mysql，mysqli和PDO的区别

PHP-MySQL PHP 操作 MySQL 资料库原始 Extension PHP-MySQLi i 代表 Improvement 提更相进阶功能 Extension 言本身增加安全性 PDO (PHP Data Object) 则提供 Abstraction Layer 操作资料库用讲其实看麽差别所直接看程式吧…
首先先看段用 PHP-MySQL 写程式码类范例用世界各：

复制代码代码:

mysql_connect($db_host, $db_user, $db_password);
mysql_select_db($dn_name);
$result = mysql_query("SELECT `name` FROM `users` WHERE `location` = '$location'");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo $row['name'];
}
mysql_free_result($result);
?>

乍看没麽问题其实背些问…
种式能 Bind Column 前例 SQL 叙述说$location 容易 SQL Injection于发展 mysql_escape_string() (备注：5.3.0弃用) 及 mysql_real_escape_string() 解决问题麽搞整叙述变复杂且丑陋且栏位想见情形…

复制代码代码:

$query = sprintf("SELECT * FROM users WHERE user='%s' AND password='%s'",
mysql_real_escape_string($user),
mysql_real_escape_string($password));
mysql_query($query);
?>

PHP-MySQLi 少进步除透 Bind Column 解决述问题且援 Transaction, Multi Query 并且同提供 Object oriented style (面段 PHP-MySQLi 范例写) Procedural style (面 PHP-MySQL 范例写)两种写…等等
复制代码代码:

简单来说：
PHP-MySQL 是 PHP 操作 MySQL 资料库最原始的 Extension
PHP-MySQLi 的 i 代表 Improvement ，提更了相对进阶的功能，就 Extension 而言，本身也增加了安全性。
PDO (PHP Data Object) 则是提供了一个 Abstraction Layer 来操作数据库。
PHP-MySQLi操作db举例：
$mysqli = new mysqli($db_host, $db_user, $db_password, $db_name);
$sql = "INSERT INTO `users` (id, name, gender, location) VALUES (?, ?, ?, ?)"; //构建插入的sql语句
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('dsss', $source_id, $source_name, $source_gender, $source_location); //此处设置插入参数
$stmt->execute(); //执行sql语句
$stmt->bind_result($id, $name, $gender, $location); //获取结果并处理
while ($stmt->fetch())
{
echo $id . $name . $gender . $location;
}
$stmt->close();
$mysqli->close();
?>
PDO操作db举例：
oga@carlisten-lx:~$ pecl search pdo //打开pdo
=======================================
Package Stable/(Latest) Local
PDO 1.0.3 (stable) PHP Data Objects Interface.
PDO_4D 0.3 (beta) PDO driver for 4D-SQL database
PDO_DBLIB 1.0 (stable) FreeTDS/Sybase/MSSQL driver for PDO
PDO_FIREBIRD 0.2 (beta) Firebird/InterBase 6 driver for PDO
PDO_IBM 1.3.2 (stable) PDO driver for IBM databases
PDO_INFORMIX 1.2.6 (stable) PDO driver for IBM Informix INFORMIX databases
PDO_MYSQL 1.0.2 (stable) MySQL driver for PDO //加载驱动
PDO_OCI 1.0 (stable) Oracle Call Interface driver for PDO
PDO_ODBC 1.0.1 (stable) ODBC v3 Interface driver for PDO
PDO_PGSQL 1.0.2 (stable) PostgreSQL driver for PDO
PDO_SQLITE 1.0.1 (stable) SQLite v3 Interface driver for PDO
pdo_user 0.3.0 (beta) Userspace driver for PDO