1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| function verification($nom,$motdepasse){
$dbhote = 'localhost'; //Mysql Hostname
$dbuser = 'root'; //Mysql UserName
$dbpass = 'root'; //Mysql Password
$dbbase = 'site1'; //Mysql Database Name
$dsn = "mysql:dbname=$dbbase;host=$dbhote";
$dbh = new PDO($dsn, $dbuser, $dbpass);
$mdp = md5($motdepasse);
$nom_sql = $dbh->quote($nom);
$pass_sql = $dbh->quote($mdp);
//verification de la presence de l'utilisateur dans la table usr
$sql = sprintf("SELECT count(*) AS nbres FROM users WHERE login=$nom_sql AND password=$pass_sql");
$result = $dbh->query($sql);
$row = $result->fetch();
$result = null;
if($row['nbres'] == 1){
return TRUE;
}else{
return FALSE;
}
} |