Fabio

Hi, I tried with fetchAll() and it works. Now, I am going to change the code about password cryptography Thank you

Yes is encript with MD5 function, I controlled the variable $password and it was correct with that in the database

Hi to everyone, I am preparing the log-In page and when I am going to controll if the user is present in the user-list with two fields: matricola and password, MySQL return zero record. I do not understand where is the error because I am novice in programming with PHP. The code is: function controlUser($matricola, $password) { include $_SERVER['DOCUMENT_ROOT'] . '../db.conn.php'; try { $sql = 'SELECT COUNT(*) FROM personale WHERE Matricola = :matricola AND password = :password'; $s = $pdo -> prepare($sql); $s -> bindValue(':matricola', $matricola); $s -> bindValue(':password', $password); $s -> execute(); } catch (PDOException $e) { $error = 'Errore durante la ricerca!'; include $_SERVER['DOCUMENT_ROOT'] . '../error.html.php'; exit(); } $row = $s -> fetch(); if ($row[0] > 0) { return TRUE; } else { return FALSE; } }