Zend Framework Database Step By Step Tutorial - Part 7: In this post, we will see action for updating data. Open your "UserController.php" within application/controller. Enter following new action:
public function processeditAction()
{
$params = array('host' =>'localhost',
'username' =>'root',
'password' =>'admin',
'dbname' =>'zend'
);
$DB = new Zend_Db_Adapter_Pdo_Mysql($params);
$request = $this->getRequest();
$sql = "UPDATE `user` SET `first_name` = '".$request->getParam('first_name')."',
`last_name` = '".$request->getParam('last_name')."',
`user_name` = '".$request->getParam('user_name')."'
WHERE id = '".$request->getParam('id')."'";
$DB->query($sql);
$this->view->assign('title','Editing Process');
$this->view->assign('description','Editing succes');
}
Then, create a file named "processedit.phtml" within views/scripts/user. Enter following code:
<? include "header.phtml"; ?>
<h1><?=$this->escape($this->title);?></h1>
<h2><?=$this->escape($this->description);?></h2>
<a href="list">Member List</a>
<? include "footer.phtml"; ?>
Ok, try to update data from edit form.
