PDO??mysql???????????
???????????? ???????[ 2014/1/27 11:41:27 ] ????????mysql ????? PDO
????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);
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11