Zend Framework Database: Inserting Expressions to a table

Zend Framework Database Step By Step Tutorial - Part 4: At previous post, we use ordinary query for input data. Zend framework have simple way for insert query. It is good alternative because simple and more neat.

You can use like this:

	$data = array('first_name' => $request->getParam('first_name'),
	              'last_name' => $request->getParam('last_name'),
				  'user_name' => $request->getParam('user_name'),
				  'password' => md5($request->getParam('password'))
	              );
   $DB->insert('user', $data);

old query like this:

	$sql = "INSERT INTO `user` 
			(`first_name` , `last_name` ,`user_name` ,`password`)
			VALUES 
			('".$request->getParam('first_name')."', '".$request->getParam('last_name')."', '".$request->getParam('user_name')."', MD5('".$request->getParam('password')."'))";
	$DB->query($sql);

Ok, replace our processAction become like this:

  public function processAction()
  {
  
    $params = array('host'		=>'localhost',
	                'username'	=>'root',
					'password'  =>'admin',
					'dbname'	=>'zend'
	               );
	$DB = new Zend_Db_Adapter_Pdo_Mysql($params);
	
    $request = $this->getRequest();
	$data = array('first_name' => $request->getParam('first_name'),
	              'last_name' => $request->getParam('last_name'),
				  'user_name' => $request->getParam('user_name'),
				  'password' => md5($request->getParam('password'))
	              );
    $DB->insert('user', $data);
	
    $this->view->assign('title','Registration Process');
	$this->view->assign('description','Registration succes');  	
	
  }