Assign the row column values to the Zend_View
instance. The variables assigned to the Zend_View
object become the properties of the Zend_View
object.
$view->id = $_POST['id']; $view->journal = $rowset[0]["JOURNAL"]; $view->publisher = $rowset[0]["PUBLISHER"]; $view->edition = $rowset[0]["EDITION"]; $view->title = $rowset[0]["TITLE"]; $view->author = $rowset[0]["AUTHOR"];
Create a view script, resultView.php
, associated with the Zend_View
object. The view script will run in the scope of the Zend_View
object. References to $this
in the view script are references to the Zend_View
object. Create a table header and add values to the table using the Zend_View
properties assigned in the action controller. In the selectAction
function render the resultView.php
script.
echo $view->render('resultView.php');
Invoke the selectView.php
view script with the URL http://localhost/views/selectView.php
. Specify the catalog ID for the row that is to be retrieved and click select.
Selecting a database table row
The row corresponding to the specified catalog ID will be retrieved and the results displayed.
Update a Row
Next, update a catalog table row using the Zend Framework. Create an associative array, $data
, of column names and values for the row to be updated. Create a SQL expression specifying the WHERE
clause for the ID of the row to be updated.
$where[] = "ID ="."'".$_POST['id']."'";
Update the database table using the update()
method.
$n = $db->update('Catalog', $data, $where);
Invoke the updateView.php
script with URL http://localhost/views/updateView.php
. Specify the catalog ID of the row to be updated and the column values to be updated and click on update.
Updating database table
A table row may be deleted using the delete()
function.
MVC has a proven track record in simplifying the development and on-going maintenance of applications. Using Zend and the methodology I have outlined, you can now take advantage of MVC to simplify your work with PHP applications.®