??????????:
$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);