主页

索引

模块索引

搜索页面

5.1.2. 简单的数据库实例

from: http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers * db_test.php(PDO):

<?php
include('db_login.php');

$db = new PDO('mysql:host=localhost;dbname=testdb;charset=utf8', 'username', 'password');

// 请求得到全部数据
try {
  $stmt = $db->query("SELECT * FROM table");
  return $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch(PDOException $ex) {
  //handle me.
}

// 一条条进行操作
foreach($db->query('SELECT * FROM table') as $row) {
   echo $row['field1'].' '.$row['field2']; //etc...
}

// 得到请求条数
$stmt = $db->query('SELECT * FROM table');
$row_count = $stmt->rowCount();

// Getting the Last Insert Id
$result = $db->exec("INSERT INTO table(firstname, lastname) VAULES('John', 'Doe')");
$insertId = $db->lastInsertId();

// Running Simple INSERT, UPDATE, or DELETE statements
$affected_rows = $db->exec("UPDATE table SET field='value'");
echo $affected_rows.' were affected'

// Running Statements With Parameters
$stmt = $db->prepare("SELECT * FROM table WHERE id=? AND name=?");
$stmt->execute(array($id, $name));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

...

主页

索引

模块索引

搜索页面