Creation d'un site web de securite

<?php
session_start();
$_SESSION['validité']='true';

 try {
 $bdd = new PDO('mysql:host=localhost;dbname=çapasse;charset=utf8', 'root', '');}
 catch(Exception $e) {
 die('Erreur : '.$e->getMessage()); }

 $login = $_POST['login'];
 $passe = $_POST['passe'];
 if(isset($login)){
  $req = $bdd->prepare("SELECT * FROM admin WHERE NAME = :login AND PASSWORD = :pass");
  $req->execute(array(
      'login' => $login,
      'pass' => $passe));

  $resultat = $req->fetch();
  print_r($resultat);
  
 }
 ?>

<?php 
session_start();
  try {
    $bdd = new PDO('mysql:host=localhost;dbname=çapasse;charset=utf8', 'root', '');}
    catch(Exception $e) {
    die('Erreur : '.$e->getMessage()); }
  $name = $_POST['name'];
  $age =$_POST['age'];
  $sex =$_POST['sex'];
  $pass=$_POST['password'];
  $fonction=$_POST['fonction'];
  $longitute =$_POST['longitute'];
  $latitude = $_POST['latitude'];
  $req = $bdd->prepare("INSERT INTO users (NAME,AGE, PASSWORD, SEX, FONCTION,LONGITUTE,LATITUDE,site_IDSITE, admin_IDADMIN) VALUES ( :name, :age, :password, :sex, :fonction, :longitute, :latitude,1,1)");
  try {
    $res =$req->execute(array(
          "name" => $name, 
          "age" => $age,
          "password" => $pass,
          "sex" => $sex,
          "fonction" => $fonction,
          "longitute" =>$longitute,
          "latitude" => $latitude
          ));
  } catch (Exception $e) {
    echo $e.getMessage();
  }
  print_r($res);

<?php
 try {
 $bdd = new PDO('mysql:host=localhost;dbname=çapasse;charset=utf8', 'root', '');}
 catch(Exception $e) {
 die('Erreur : '.$e->getMessage()); }

 $login = $_POST['login'];
 $passe = $_POST['passe'];
 $code = $_POST['code'];
 if(isset($login)){
  $req = $bdd->prepare("SELECT * FROM users inner join site on (site.IDSITE = users.site_IDSITE) WHERE users.NAME = :login AND users.PASSWORD = :pass AND site.CODE = :code");
  try {
   $req->execute(array(
      'login' => $login,
      'pass' => $passe,
      'code'=>$code));
      $resultat = $req->fetch();


  } catch (Exception $e) {
   echo $e->getMessage();
  }
  
  $resultat = $req->fetch();
  print_r($resultat);
 }
 ?>