1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| function verification($nom,$pass){
$dbhote = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbbase = 'ATT_CLI';
$dsn = "mysql:dbname=$dbbase;host=$dbhote";
$dbh = new PDO($dsn, $dbuser, $dbpass);
$nom_sql = $dbh->quote($nom);
$pass_sql = $dbh->quote($pass);
$sql = "SELECT count(*) as nbres FROM usr WHERE LOGIN=$nom_sql AND PASSWD=$pass_sql";
$result = $dbh->query($sql);
$row = $result->fetch();
$result = null;
if($row['nbres'] == 1){
return TRUE;
}else{
return FALSE;
}
} |