? ??? ???? Zend_Db_Table? ???? ?????. ????? ??? ?? ?????.

1. ??

Zend_Db_Table? Zend Framework? ??? ?????. zend_db_adapter? ?? ??????? ???? ??????? ??? ??? ?????.

2.

? ????? ?? ?? ??? zend_db_table? ???? ???(??: ? ???? ?? ?????? ??? ? ????). ?? ??????? ? ???? ?? ??? ?? ?? ???? ??????? ?? ??? ?????? ???? ???? ?? ? ?? zend_db_table ??? ????? ?? ???? ?????.

<?php
// 建立一個(gè) adapter
require_once &#39;Zend/Db.php&#39;;
$params = array (
  &#39;host&#39;   => &#39;127.0.0.1&#39;,
  &#39;username&#39; => &#39;malory&#39;,
  &#39;password&#39; => &#39;******&#39;,
  &#39;dbname&#39;  => &#39;camelot&#39;
);
$db = Zend_Db::factory(&#39;PDO_MYSQL&#39;, $params);
// 為所有的Zend_Db_Table對(duì)象設(shè)定默認(rèn)的adapter
require_once &#39;Zend/Db/Table.php&#39;;
Zend_Db_Table::setDefaultAdapter($db);
?>

????, ??????? "round_table"??? ???? ??? ?????. ? ???? zend_db_table? ????? zend_db_table ???? ???? RoundTable??? ? ???? ???? ???. ?? ?? round_table? ??? ?? ???? ??? ? ????. ? ???? ?? ??????? ???? ???? ??? ??? ?????.

<?php
class RoundTable extends Zend_Db_Table {}
$table = new RoundTable();
?>

3. ??? ?? ? ?? ?

????? zend_db_table ???? ??? ??? ??? ???? ?????. ?? ??, SomeTableName??? zend_db_table ???? ??????? ??? ??? ???? ??? ??? ??????? "some_table_name"? ?????. ? ?? ? ??? ???? $_name? ???? ? ???? ??? ? ????.

<?php
class ClassName extends Zend_Db_Table
{
  // 默認(rèn)表名為 &#39;class_name&#39;
  // 但是我們也可以對(duì)應(yīng)其它表
  protected $_name = &#39;another_table_name&#39;;
}
?>

zend_db_table ???? ?? ?? "id"? ???? ?? ????(? ??? ???? ????? ?? ?? ????). , ??? ??? ????) ???? ?? ?? "$id"? ???? ?? ??? ??? ???? ??? ? $_primary? ???? ? ????

<?php
class ClassName extends Zend_Db_Table
{
  // 默認(rèn)主鍵為&#39;id&#39;
  // 但我們也可以設(shè)定其他列名為主鍵
  protected $_primary = &#39;another_column_name&#39;;
}
?>

??? ?? ????. ??? ??? ??? ??? ???? _setup() ???? ?? ????? ?? ??? ??? parent::_setup() ???? ?? ???? ???.

<?php
class ClassName extends Zend_Db_Table
{
  protected function _setup()
  {
    $this->_name = &#39;another_table_name&#39;;
    $this->_primary = &#39;another_column_name&#39;;
    parent::_setup();
  }
}
?>

4.

???? ? ??? ?? ????? ? ??? ????? ?? ???. ???? ?? ??? ????? ???? insert() ???? ????? ?? ???.

(zend ?????)? ???? ?????. ???? ???? ??? ??? ?? id ?? ?????

(??: ????? zend_db_adapter::insert ???? ??? ??? ??? ? ?? ?????).

<?php
//
// INSERT INTO round_table
//   (noble_title, first_name, favorite_color)
//   VALUES ("King", "Arthur", "blue")
//
class RoundTable extends Zend_Db_Table {}
$table = new RoundTable();
$data = array(
  &#39;noble_title&#39; => &#39;King&#39;,
  &#39;first_name&#39; => &#39;Arthur&#39;,
  &#39;favorite_color&#39; => &#39;blue&#39;,
)
$id = $table->insert($data);
?>

5. data

???? ??? ?? ????? ? ?? ??: ???? ?? ??? ????? ???? update() ???? ???? ???? ? ?? ?????. where ???? ?? ? ???? ???? ???? ???? ??? ? ?? ?????.

(Zend ?????)? ??? ???? ???? ????? ? ???? ???? ???? ????. ??? ????? ???? zend_db_adapter ??? ???? ???.

class RoundTable extends Zend_Db_Table {}
$table = new RoundTable();
$db = $table->getAdapter();
$set = array(
  'favorite_color' => 'yellow',
)
$where = $db->quoteInto('first_name = ?', 'Robin');
$rows_affected = $table->update($set, $where);

6. ? ??

???? ???? ????? delete( ) ???? ???? where ???? ?? ???? ?? ?? ?????. ? ???? ??? ? ?? ?????.

(zend Framework)? ???? ???? ???? ?? ???? ???. ??? ???? ?? ???? zend_db_adapter ??

<?php
//
// DELETE FROM round_table
//   WHERE first_name = "Patsy"
//
class RoundTable extends Zend_Db_Table {}
$table = new RoundTable();
$db = $table->getAdapter();
$where = $db->quoteInto(&#39;first_name = ?&#39;, &#39;Patsy&#39;);
$rows_affected = $table->delete($where);
?>

7. ?? ? ?? ???? ??

find() ???? ???? ???? ???? ?? ??? ? ????. ?? ???? ????? ?? ? ???? zend_db_table_row ??? ????, ?? ???? ????? ?? zend_db_table_rowset ??? ?????.

<?php
class RoundTable extends Zend_Db_Table {}
$table = new RoundTable();
// SELECT * FROM round_table WHERE id = "1"
$row = $table->find(1);
// SELECT * FROM round_table WHERE id IN("1", "2", 3")
$rowset = $table->find(array(1, 2, 3));
?>

8. ??? ??

?? ?? ?? ?? ??? ?? ?? ?? ?? ?????, ?? ?? ?? ?? ??? ?? ??? ?? ?? ??? ????. () ???? ???? where ???(? ??? order ?)? ??? ? ????. fetchRow() ???? ???? zend_db_tabel? ??? ???? ? ?? ??? ?? zend_db_table_row ??? ?????. >

(zend ?????)? where ?? ???? ???? ??? ??? ???? zend_db_adapter? ???? ???

9. ?? ??? ??

<?php
//
// SELECT * FROM round_table
//   WHERE noble_title = "Sir"
//   AND first_name = "Robin"
//   ORDER BY favorite_color
//
class RoundTable extends Zend_Db_Table {}
$table = new RoundTable();
$db = $table->getAdapter();
$where = $db->quoteInto(&#39;noble_title = ?&#39;, &#39;Sir&#39;)
    . $db->quoteInto(&#39;AND first_name = ?&#39;, &#39;Robin&#39;);
$order = &#39;favorite_color&#39;;
$row = $table->fetchRow($where, $order);
?>

??? ?? ? ?? ?? ???? ????? fetchRow() ???? ???? fetchAll() ???? ??? ? ????. ? ???? where ? order ?? ??? ? ?? ?? ??? ?? ?? ? ?? ??? ?? ??? ? ????. ???? ??? ?? ?????. ? ???? ???? ??? ??? Zend_Db_Table_Rowset ??? ?????.

??(zend ?????)??? where ?? ???? ???? zend_db_adapter? ?? ??? ??? ???? ???.

10. ??? ??

<?php
class RoundTable extends Zend_Db_Table {}
$table = new RoundTable();
$db = $table->getAdapter();
// SELECT * FROM round_table
//   WHERE noble_title = "Sir"
//   ORDER BY first_name
//   LIMIT 10 OFFSET 20
$where = $db->quoteInto(&#39;noble_title = ?&#39;, &#39;Sir&#39;);
$order = &#39;first_name&#39;;
$count = 10;
$offset = 20;
$rowset = $table->fetchAll($where, $order, $count, $offset);
?>

? Zend Framework ??? ??? ???? Zend_Db_Table? ????? ??? ??? ???? ??????. ??? ?? ??? ???? ?? ?? ? ??? ?????.

????? ?? ? ?? ?? ??? ?? ???? ????? ???? find() ???? ??? ?? ????.

<?php
class RoundTable extends Zend_Db_Table
{
  public function insert($data)
  {
    // 添加一個(gè)時(shí)間戳
    if (empty($data[&#39;created_on&#39;])) {
      $data[&#39;created_on&#39;] = time();
    }
    return parent::insert($data);
  }
  public function update($data)
  {
    // 添加一個(gè)時(shí)間戳
    if (empty($data[&#39;updated_on&#39;])) {
      $data[&#39;updated_on&#39;] = time();
    }
    return parent::update($data);
  }
}
?>

? ??? Zend Framework ????? ??? PHP ????? ???? ?? ???? ??? ??? ????.

<?php
class RoundTable extends Zend_Db_Table
{
  public function findAllWithName($name)
  {
    $db = $this->getAdapter();
    $where = $db->quoteInto("name = ?", $name);
    $order = "first_name";
    return $this->fetchAll($where, $order);
  }
}
?>

? ?? Zend Framework ????? Zend_Db_Table ???? ?? ??? ??? ??? PHP ??? ????? ?????!