Zend_Db_Table Simple Demo PRO

Using the Zend_Db_Table class, which is part of the Zend Framework, we can easily access a specific table in our database. The following code sample shows how simple it is to add a new row using this class.

The following code includes our definition for the users controller.

<?php

require_once ROOT_DIR.'/models/Users.php';

class UsersController extends Zend_Controller_Action
{	   
    public function addusersAction()
    {
	$table = new Users();
	$row = $table->createRow();
	$row->id=98989898;
	$row->username='moshmosh';
	$row->save();
	$this->view->msg = "new user were added";
    }
}

The following code includes our definition for the Users class.

<?php
class Users extends Zend_Db_Table
{
    protected $_name = 'members';
}
?>

The following code is the view of the ‘addusers’ action.

<?php
echo $this->msg;
?>

The following video clip overviews this code sample and shows its execution.