PHP? MySQL? ??
PHP? MySQL? ??
PHP 5 ????? ?? ??? ???? MySQL? ???? ?? ????.
· MySQLi ??("i"? ???? ??) )
· PDO(PHP ??? ??)
PHP ?? ????? MySQL ??? ?????. ??? ? ??? 2012?? ? ?? ???? ????.
PDO? ??????
? ??????? ???? ????,
pdo? ??????? ???? ??? pdo ???? ????? ? ???? ?? ??? ???? ???.
PDO? mysqli? ???:
MySQLi? ???? ???, PDO? ???? ????
?? ??? ??? ?? "?? ??? ?????."
MySQLi? PDO?? ??? ??? ????.
PDO? 12?? ?? ?? ???????? ???? MySQLi? MySQL ??????? ???? ???.
??? ????? ?? ?????? ??? ???? ?? ?? ?? ???? ?? ???? ???? ??? PDO? ???? ?? ????. MySQLi? ???? ?? ??????? ???? ?? ??? ??? ?? ??? ?? ???? ???.
? ? ?? ????? MySQLi? API ?????? ?????.
? ? ??? ??? ?????. ??? ???? SQL ??? ??? ? ??? ? ???? ??? ?? ?????.
MySQLi ? PDO? MySQL ????? ??
? ?? ?? ???? ?? ? ?? ??? ???? MySQL? ???? PHP? ?????.
· MySQLi(?? ??)
$mysqli = new mysqli('localhost','username','password','database');
· MySQLi(???? ??) )
$mysqli = mysqli_connect('localhost','??? ??','????','??????');
· PDO
$pdo = ? PDO(" mysql :host=localhost;dbname=database", '??? ??', '????');
MySQLi ??
Linux ? Windows: php5 mysql ???? ???? ???? ?? MySQLi ??? ???? ?????.
?? ?? ??? http://php.net/manual/en/mysqli.installation.php? ?????.
phpinfo()? ?? ?? ?? ??? ??? ? ????.
PDO ??
?? ?? ??? http://http:/ /php .net/manual/en/pdo.installation.php
phpinfo()? ?? ?? ?? ??? ??? ? ????:
MySQL? ??
MySQL ??????? ????? ?? ???? ???. ?????? ??:
????(MySQLi - ?? ??)
$link = mysqli_connect('localhost', 'mysql_user', 'mysql_password');
? ????? ??? ????.
· ?? ??(??? ??, IP)
· ?????? ??? ??(??)
· ?????? ????(?? ??)
??? ???? ?????? ??? ???? ??? ??? false? ?????(?? ?? ??? ????? ?? ??? ??? ? ??)
<?php
$servername = "localhost";
$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? ?? ???? ?? ?????? ??? ???? ???. ???? ??? ??? ?????.
?????? ??
$db_selected = mysqli_select_db($link, 'db_name');
? ?? ????
? mysql_connect?? ??? ?????? ??
? ?????? ??
???? true? ???? ???? false? ?????
??? ?? ???? ??????? ??? ? ??:
$link = mysqli_connect('localhost', 'mysql_user', 'mysql_password', 'db_name');
??? ????
???? ?? ? ???? ??? ?????. ?? ??? ???? ??? ?? ?? ????.
????(MySQLi - ?? ??)
$conn->close();
????(MySQLi - ???? ??)
mysqli_close($conn);
????(PDO)
$conn = null;
??:
????? ??? ? ???? ???? ?? ?? ???? ??? ??? ?? ? ?? ?????. ??? ??? ??? ?? ??? ?? ??? ?? ??? ?? ? ? ?? ??? ??? ? ????. ???? ??? ??? ??? ??? ???? ??, ????? ???? ??? ?? ??? ???? ??? ?? ? ????.
