????PDO?????"????????????"????????????????????????????mysql??mysqli????????????PDO??????????????????????:??ADODB??MDB2????PDO????Ч.
??????????????"?????????"?????????????PDO??????"????????????"?????????????.
?????.PDO??????????
????PDO->beginTransaction() ????????????
????PDO->commit ??????????????????SQL
????PDO->__construct ???????PDO?????????????
????PDO->errorCode ?????????
????PDO->errorInfo ???????????
????PDO->exec ???????SQL????????????????????
????PDO->getAttribute ??????“????????????”??????
????PDO->getAvailableDrivers ?????Ч??PDO??????????
????PDO->lastInsertId ???д?????????????????
????PDO->prepare ???????“???????”
????PDO->query ???????SQL????????????“PDOStatement”
????PDO->quote ????SQL?е?????????????
????PDO->rollBack ??л??
????PDO->setAttribute ????“????????????”?趨????
??????.PDO??mysql???????????
???????php.ini???????
????1???????pdo???????????
????2?????pdo???????з??
????3??????apache????
?????????????select??????
?????????:
$url = "mysql:host=???????;dbname=????"; //?????????????
$user = "?????";
$pwd = "????";
$conn = new PDO($url??$user??$pwd); //?????????
$conn->query("set names utf8"); //???????
$st = $conn->query("select??????"); //???select?????????????????????statement
$rs = $st->fetchAll(); //??y???????????????????????
//??????м??
foreach($rs as $value)
{
echo $value["?????|?????"];
}
//????????
unset($rs);
unset($st);
unset($conn);