請多用 PDO...
文章會有點長，我先貼範例：
<?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
推
05/26 22:15, , 1F
05/26 22:15, 1F
→
05/26 22:15, , 2F
05/26 22:15, 2F
討論串 (同標題文章)
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
5
22
