PHP 5 ????? ?? ??? ???? MySQL? ???? ?? ????.

MySQLi ??("i"? ???? ??)

PDO(PHP Data Objects)

PHP ?? ????? MySQL ??? ??????. ??? ? ??? 2012?? ? ?? ???? ????.

MySQLi? ???? ???, ??? PDO? ???? ????

?? ??? ????? "??? ?? ?????" .

MySQLi? PDO?? ??? ??? ????.

PDO? 12?? ?? ?? ???????? ???? MySQLi? MySQL ??????? ???? ???.

??? ????? ?? ?????? ??? ???? ?? ?? ?? ???? ?? ???? ???? ??? PDO? ???? ?? ????. MySQLi? ???? ?? ??????? ???? ?? ??? ??? ?? ??? ?? ???? ???.

? ? ?? ????? MySQLi? API ?????? ?????.

? ? ??? ??? ?????. ??? ???? SQL ??? ??? ? ??? ? ???? ??? ?? ?????.

MySQLi ? PDO? MySQL ????? ??

? ?? ?? ???? ?? ? ?? ??? ???? PHP ??? ?????. MySQL:

MySQLi(?? ??)

MySQLi(???? ??)

PDO

MySQLi ??

Linux ? Windows: ???? ?? php5 mysql ???? ??? ? MySQLi ??? ???? ?????.

?? ?? ??? http://php.net/manual/en/mysqli.installation.php? ?????.

phpinfo()? ?? ?? ?? ??? ??? ? ????.

PDO ??

?? ?? ??? http://php.net/manual/en/pdo.installation.php? ?????.

phpinfo()? ?? ?? ?? ??? ??? ? ????.

MySQL? ??

MySQL? ????? ?? ??????? ????? ?? ?????? ??? ???? ???.

??(MySQLi - ?? ??)

<?php
$servername = "localhost";  //服務(wù)器
$username = "username";    //用戶名
$password = "password";    //密碼

// 創(chuàng)建連接
$conn = new mysqli($servername, $username, $password);

// 檢測連接
if ($conn->connect_error) {
    die("連接失敗: " . $conn->connect_error);
} 
echo "連接成功";
?>

???? ?? ?? ???? $connect_error? PHP 5.2.9 ? 5.3.0? ???????. ?? ???? ???? ??? ?? ?? ?? ??? ??????.
// ?? ??
if (mysqli_connect_error()) {
die("Database ?? ??: " . mysqli_connect_error());
}

????(MySQLi - ???? ??)

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// 創(chuàng)建連接
$conn = mysqli_connect($servername, $username, $password);

// 檢測連接
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "連接成功";
?>

????(PDO)

<?php
$servername = "localhost";
$username = "username";
$password = "password";

try {
    $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
    echo "連接成功"; 
}
catch(PDOException $e)
{
    echo $e->getMessage();
}
?>

?? PDO ?????? ??????( myDB). PDO? ?? ???? ?? ?????? ??? ???? ???. ???? ??? ??? ?????.

?? ??

????? ??? ? ??? ???? ????. ?? ??? ???? ??? ?? ?? ????.

????(MySQLi - ?? ??)

$conn->close();

????(MySQLi - ???? ??)

mysqli_close($conn);

????(PDO)

$conn = null;