The example in this article describes the usage of Zend_Db_Table_Row in the Zend Framework tutorial. Share it with everyone for your reference, as follows:

1. Introduction

Zend_Db_Table_Row is the row data gateway of Zend Framework. Generally speaking, you cannot instantiate Zend_Db_Table_Row yourself, but call The Zend_Db_Table::find() method or Zend_Db_Table::fetchRow() method returns Zend_Db_Table_Row as the result data. Once you get a Zend_Db_Table_Row object, you can modify the record value (reflected as a class attribute) and then call the save() method. Save the changes to the original table.

2. Retrieve a record

First, you need to instantiate a Zend_Db_Table class.

<?php
// 設(shè)置一個 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對象設(shè)置默認(rèn)adapter
require_once &#39;Zend/Db/Table.php&#39;;
Zend_Db_Table::setDefaultAdapter($db);
// 連接到數(shù)據(jù)庫中的某一個表
class RoundTable extends Zend_Db_Table {}
$table = new RoundTable();
?>

Next, use Zend_Db_Table::find () method and primary key to query, or use the Zend_Db_Table::fetchRow() method to query.
The returned result is a Zend_Db_Table_Row object, and the attribute name of the object is in the form of camelCaps corresponding to the underlined table name in the database.
For example, if the table name is first_name, then the modified attribute in the class is firstName.

<?php
// 從表中取回的結(jié)果數(shù)據(jù)是一個Zend_Db_Table_Row對象
$row = $table->fetchRow(&#39;first_name = "Robin"&#39;);
//
// $row現(xiàn)在是一個帶有多種公有屬性的Zend_Db_Table_Row對象
// that map to table columns:
//
// $row->id = &#39;3&#39;
// $row->nobleTitle = &#39;Sir&#39;
// $row->firstName = &#39;Robin&#39;
// $row->favoriteColor = &#39;yellow&#39;
//
?>

3. Modify data

Modifying row data is a very easy thing: just need Modify the class attributes according to the conventional method. Then call the save() method to save the changed results to the data table.

<?php
// 連接到數(shù)據(jù)庫中的表
class RoundTable extends Zend_Db_Table {}
$table = new RoundTable();
// 從表中取回的結(jié)果數(shù)據(jù)是一個Zend_Db_Table_Row對象
$row = $table->fetchRow(&#39;first_name = "Robin"&#39;);
//
// $row現(xiàn)在是一個帶有多種公有屬性的Zend_Db_Table_Row對象
// that map to table columns:
//
// $row->id = &#39;3&#39;
// $row->nobleTitle = &#39;Sir&#39;
// $row->firstName = &#39;Robin&#39;
// $row->favoriteColor = &#39;yellow&#39;
//
// 改變favorite color字段,并且將變動存儲到數(shù)據(jù)表中.
$row->favoriteColor = &#39;blue&#39;;
$row->save();
?>

However, you cannot modify the value of the primary key. If you try to perform a modification operation, Zend_Db_Table_Row An exception will be thrown.

<?php
// 連接到數(shù)據(jù)庫中的表
class RoundTable extends Zend_Db_Table {}
$table = new RoundTable();
// fetch a record from the table as a Zend_Db_Table_Row object
$row = $table->fetchRow(&#39;first_name = "Robin"&#39;);
// 我們嘗試修改主鍵值
try {
  $row->id = 5;
  echo "We should not see this message, as an exception was thrown.";
} catch (Zend_Db_Table_RowException $e) {
  echo $e->getMessage();
}
?>

I hope this article will be helpful to everyone’s PHP programming based on the Zend Framework framework.

For more Zend Framework tutorial Zend_Db_Table_Row usage example analysis and related articles, please pay attention to the PHP Chinese website!