In Zend Framework, It’s very easy to run select, insert, update and delete query.
Select Query in ZF:
<?php
$sql = $this->select() ->from('tablename',array('*')) ->where('userID=?',1); $data = $this->fetchAll($sql); // This query will return a multidimensional Array.This work as a mysql_fetch_array()
$data = $this->fetchRow($sql); // Get Row
?>
|
Insert query in Zend Framework :
<?php $userTable = new users(); ?> $userProfileData = array(
'first_name'=>'David', 'add_line1'=>'UK', 'description'=>'something'
);
$userTable->insert($userProfileData);
|
Update query in Zend Framework :
<?php
$userProfileData = array(
'first_name'=>'David', 'add_line1'=>'UK', 'description'=>'something'
);
$userId =2;
$userTable->update($userProfileData,'userID='.$userId); |
Delete Query In zend Framework :
$userTable->delete('user_id='.$userId);
|
Run Raw SQL Query
Zend_Db_Table_Abstract::getDefaultAdapter()->query($sql);
Zend_Db_Table_Abstract::getDefaultAdapter()->query($sql)->fetch();
Zend_Db_Table_Abstract::getDefaultAdapter()->query($sql)->fetchAll();