PDO??mysql???????????
???????????? ???????[ 2014/1/27 11:41:27 ] ????????mysql ????? PDO
??????????:
$url = "mysql:host=???????;dbname=????";
$user = "?????";
$pwd = "????";
$conn = new PDO($url??$user??$pwd);
$conn->query("set names utf8");
$st = $conn->prepare("select???");//???
$st->execute();//???
$rs = $st->fetchAll();
foreach($rs as $value)
{
echo $value["?????|?????"];
}
unset($rs);
unset($st);
unset($conn);
????mysql??????????????insert|update|delete???
?????????:
$url = "mysql:host=???????;dbname=????";
$user = "?????";
$pwd = "????";
$conn = new PDO($url??$user??$pwd);
$conn->query("set names utf8");
$row = $conn->exec("insert|update|delete???");
unset($conn);
??????????:
$url = "mysql:host=???????;dbname=????";
$user = "?????";
$pwd = "????";
$conn = new PDO($url??$user??$pwd);
$conn->query("set names utf8");
$st = $conn->prepare("insert|update|delete???"); //??????е?sql??? ???where Id=:a ????????:a
$st->bindParam(":??"??$????); //bind?? paramter???????sql????е?:a ??????$id
$result = $st->execute(); //???prepare???????sql???
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