从mysql过渡到PDO [英] Transition from mysql to PDO

问题描述

我正在学习PDO.我从此开始更改数据库连接:

I'm in the process to learn PDO. I started changing my database connection from this:

$dbname = "database1";


mysql_connect(
  ':/Applications/MAMP/tmp/mysql/mysql.sock',
 'root',
 'root'
) or die( mysql_error());
mysql_select_db($dbname) or die("MySQL Error: " . mysql_error());

到PDO连接:

$username = "root";
$password = "root";


try {
$conn = new PDO('mysql:host=localhost;dbname=database1', $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
}

连接似乎正常，但是当我尝试登录网站(本地主机)时，找不到我的用户名和密码.

the connection seems to be working but when I try to login on the website (localhost) it doesn't find my username and password.

1. 自从将数据库连接更改为PDO以来，是否需要将我的所有mysql_query更改为PDO?
2. 我能否请您提供一些参考，以获取在过渡阶段帮助我的好教程? 谢谢

1. Do I need to change all my mysql_query to PDO since I changed the database connection to PDO?
2. Can I please ask you some reference for a good tutorial to help me during this transition phase? thanks

推荐答案

1. 是的.
2. 这是一个很好的 PDO教程和 查看全文