mysql迁移到pdo_如何将mysqli迁移到pdo

您好，我想知道如何迁移一个mysqli php文件来使用PDO。任何人都可以看看我的代码，看看我是否在正确的轨道上？

这是我的原始(mysqli)代码：

// connecting to database

$conn = new mysqli('xxxxxx', 'xxxxxx', 'password', 'xxxxxx');

$match_email = 'email';

$match_passhash = 'passhash';

if (isset($_POST['email'])) {

$clean_email = mysqli_real_escape_string($conn, $_POST['email']);

$match_email = $clean_email;

}

if (isset($_POST['passhash'])) {

$clean_passhash = mysqli_real_escape_string($conn, $_POST['passhash']);

$match_passhash = sha1($clean_passhash);

}

$userquery = "SELECT email, passhash, userlevel, confirmed, blocked FROM useraccounts

WHERE email = '$match_email' AND passhash = '$match_passhash'

AND userlevel='user' AND confirmed='true' AND blocked='false';";

$userresult = $conn->query($userquery);

if ($userresult->num_rows == 1) {

$_SESSION['authorisation'] = 'knownuser';

header("Location: userhome.php");

exit;

} else {

$_SESSION['authorisation'] = 'unknownuser';

header("Location: userlogin.php");

exit;

}

?>这是我尝试将其移植到PDO：

// connecting to database

$dbh = new PDO("mysql:host=xxxxxx; dbname=xxxxxx", "xxxxxx", "password");

$match_email = 'email';

$match_passhash = 'passhash';

if (isset($_POST['email'])) {

$clean_email = mysqli_real_escape_string($conn, $_POST['email']);

$match_email = $clean_email;

}

if (isset($_POST['passhash'])) {

$clean_passhash = mysqli_real_escape_string($conn, $_POST['passhash']);

$match_passhash = sha1($clean_passhash);

}

$userquery = "SELECT email, passhash, userlevel, confirmed, blocked FROM useraccounts

WHERE email = ':match_email' AND passhash = ':match_passhash' AND

userlevel='user' AND confirmed='true' AND blocked='false';";

$stmt = $dbh->prepare($query);

$stmt->bindParam(":match_email", $match_email);

$stmt->bindParam(":match_passhash", $match_passhash);

$stmt->execute();

$userresult = $conn->query($userquery);

if ($userresult->num_rows == 1) {

$_SESSION['authorisation'] = 'knownuser';

header("Location: userhome.php");

exit;

} else {

$_SESSION['authorisation'] = 'unknownuser';

header("Location: userlogin.php");

exit;

}

?>我也不确定如何计算在PDO中返回的行数。

如果任何人能够帮助我，那将是非常伟大的。

万事先感谢！