作者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
推 gpmm:歡迎 DK 大前來本板(鞠躬) 05/26 22:15
→ gpmm:最近是季節到了嗎?神人一個接一個 XD 05/26 22:15