Zend - Database Style

$db = new Zend_Db_Adapter_Pdo_Mysql($params)

To update data, do like

$data = array(

    'name' => 'Lady Gaga',

    'city' => 'New York',

);

$db->update('user_table', $data, 'id = 1');

For insert data, do like

$data = array(

    'name' => 'Lady Gaga',

    'city' => 'New York',

    'age' => 24

);

$db->insert('user_table', $data);

For deleting data, use

$db->delete('user', 'id = '.$id);

For querying table, use:

$result = $db->fetchRow('SELECT * FROM user_table WHERE id=1');

echo $result['first_name'];

echo $result['last_name'];

$result = $db->fetchAssoc('SELECT * FROM user_table');

for($i=0; $i<count($result); $i++){

     echo $result[$i]['first_name'];

     echo $result[$i]['last_name'];

}

Zend - Database Style