PHP\u8bbf\u95eeMySQL\u6570\u636e\u5e93\u53ef\u4ee5\u4f7f\u7528\u4e09\u79cd\u63a5\u53e3:<\/p>\n
\u4e00.pdo_mysql(\u63a8\u8350)<\/p>\n
\u8fde\u63a5:<\/p>\n
$dsn = \"mysql:host=localhost;dbname=test\";
$username = 'root';
$password = '123456';
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
);
$pdo = new PDO($dsn, $username, $password, $options);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);<\/pre>\n\u589e:
\u65b9\u6cd51: \u7ed1\u5b9a\u5173\u8054\u6570\u7ec4<\/p>\n$str=$pdo->prepare(\"INSERT INTO `user` (`username`, `password`) VALUES (:username,:password)\");
$str->execute(array(\":username\"=>\"test\", \":password\"=>\"passwd\"));<\/pre>\n\u65b9\u6cd52: \u7ed1\u5b9a\u7d22\u5f15\u6570\u7ec4<\/p>\n
$str=$pdo->prepare(\"INSERT INTO `user` (`username`, `password`) VALUES (?,?)\");
$str->execute(array(\"test\", \"passwd\"));<\/pre>\n\u5220:<\/p>\n
$str=$pdo->prepare(\"delete from user where id > 3\");
$str->execute();<\/pre>\n\u6539:<\/p>\n
$str=$pdo->prepare(\"UPDATE `user` SET username=:username,password=:password where id=:id\");
$str->execute(array(\":username\"=>\"test\", \":password\"=>\"passwd\", \":id\"=>\"3\"));<\/pre>\n\u67e5:
\u65b9\u6cd51: \u5355\u4e2a\u53d6\u51fa,\u5faa\u73af\u904d\u5386,\u8fd4\u56de\u5230\u6570\u7ec4<\/p>\n$str=$pdo->prepare(\"select * from user where id > :id order by id\");
$str->execute(array(\":id\"=>2));
$str->setFetchMode(PDO::FETCH_ASSOC);
\/\/\u5171\u4e09\u79cd:1.PDO::FETCH_BOTH(\u9ed8\u8ba4) 2.FETCH_ASSOC 3.FTECH_NUM
while($data=$str->fetch()){
\tprint_r($data);
\techo '
';
}<\/pre>\n\u65b9\u6cd52: \u5168\u90e8\u53d6\u51fa,\u8fd4\u56de\u5230\u4e8c\u7ef4\u6570\u7ec4<\/p>\n
$str=$pdo->prepare(\"select * from user order by fid\");
$str->execute();
$data=$str->fetchAll(PDO::FETCH_NUM);
print_r($data);
<\/pre>\n\u65b9\u6cd53:\u5355\u4e2a\u53d6\u51fa,\u5faa\u73af\u904d\u5386,\u7ed1\u5b9a\u5b57\u6bb5\u540d\u5230\u53d8\u91cf<\/p>\n
$str=$pdo->prepare(\"select fid,username,password from user order by id\");
$str->execute();
$str->bindColumn(\"id\",$id);
$str->bindColumn(\"username\",$username);
$str->bindColumn(3,$password);
while($str->fetch()){
\techo \"$id | $username | $password
\";
}
echo \"\u603b\u8bb0\u5f55\u6570\uff1a\".$str->rowCount().\"
\";
echo \"\u603b\u5b57\u6bb5\u6570\uff1a\".$str->columnCount().\"
\";
<\/pre>\n\u4e8c.mysqli<\/p>\n
\t$mysqli=new mysqli(\"localhost\", \"root\", \"123456\", \"test\");
\t$sql=\"select * from user order by id\";
\t$result=$mysqli->query($sql);
\techo '
| '.$col.'<\/td>'; \t\t} \t\techo '<\/tr>'; \t} \techo '<\/table>'; \t$mysqli->close();<\/pre>\n \u4e09.mysql<\/p>\n $conn=mysql_connect(\"localhost\", \"root\", \"123456\") or die(\"\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25\");
|