Details |
Last modification |
View Log
| RSS feed
| Rev |
Author |
Line No. |
Line |
| 14 |
liveuser |
1 |
<?php
|
|
|
2 |
|
|
|
3 |
try {
|
|
|
4 |
$db = new PDO("mysql:host=localhost;dbname=ch30", "root", "");
|
|
|
5 |
// 資料庫使用 UTF8 編碼
|
|
|
6 |
$db->exec("SET CHARACTER SET utf8");
|
|
|
7 |
}
|
|
|
8 |
catch (PDOException $e) {
|
|
|
9 |
echo 'Error!: ' . $e->getMessage() . '<br />';
|
|
|
10 |
}
|
|
|
11 |
/*$cmd = $pdo->prepare("select ProductID, ProductName, UnitPrice from products where productid = :pid lock in share mode");
|
|
|
12 |
$cmd->bindValue(":pid", $id);
|
|
|
13 |
|
|
|
14 |
$cmd->execute();
|
|
|
15 |
$row = $cmd->fetch();
|
|
|
16 |
echo "$id => {$row['ProductName']}"; */
|
|
|
17 |
|
|
|
18 |
?>
|