从mysql过渡到PDO

本文介绍了从mysql过渡到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.

自从将数据库连接更改为PDO以来，是否需要将我的所有mysql_query更改为PDO?

我能否请您提供一些参考，以获取在过渡阶段帮助我的好教程? 谢谢

Do I need to change all my mysql_query to PDO since I changed the database connection to PDO?

Can I please ask you some reference for a good tutorial to help me during this transition phase? thanks

推荐答案

是的.

这是一个很好的 PDO教程和这一个