作者DarkKiller (System hacked)
看板PHP
标题请多用 PDO...
时间Sun May 26 08:41:55 2013
文章会有点长，我先贴范例：
<?php
# Connect to database.
$db = new PDO('mysql:dbname=mydb;host=mydbhost.example.com', 'user', 'pass');
# Use prepare() to generate PDOStatement object.
$p = $db->prepare('SELECT * FROM `user` WHERE `id` = ?;');
# Use execute() to run it.
$p->execute(array(1));
# Then fetch it, return object.
$obj = $p->fetch(PDO::FETCH_OBJ);
# Use property to access.
printf("ID: %d\n", $obj->id);
printf("Username: %s\n", $obj->username);
# Execute again, with id = 2.
$p->execute(array(2));
# We want array this time.
$a = $p->fetch(PDO::FETCH_ASSOC);
# Use array to access.
printf("ID: %d\n", $a['id']);
printf("Username: %s\n", $a['username']);
# Generate another PDOStatement object.
$p2 = $db->prepare('INSERT INTO `user` SET `id` = ?, `username` = ?;');
# Insert it.
$p2->execute(array(1, 'gslin'));
# Again.
$p2->execute(array(2, 'in2'));
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 112.121.80.241
1F：推 gpmm:欢迎 DK 大前来本板（鞠躬） 05/26 22:15
2F：→ gpmm:最近是季节到了吗？神人一个接一个 XD 05/26 22:15