Refresh Query in Zend Framework
what is wrong with this request ??? I need this request.
UPDATE user_preferences SET user_preferences_value = '2'
WHERE user_preferences_name = 'is_user_package_active'
AND user_id = '$user_id'
AND phone_service_id='$phone_service_id';
above request equals request ZF below
function Deactivate_Service($user_id,$phone_service_id){
$DB = Zend_Db_Table_Abstract::getDefaultAdapter();
$data = array('user_preferences_value' => 2);
$where = "user_preferences_name = 'is_user_package_active' AND user_id = " . (int)$user_id ." AND phone_service_id = ".(int)$phone_service_id;
$DB->update('user_preferences',$data, $where);
}
I get 0 with my ZF request
Editorial staff:
public function deactivateserviceAction(){
$this->_helper->viewRenderer->setNeverRender();
$user = new Zend_Session_Namespace('user');
$user_id =$user->user_id;
$phone_service_id = $this->_getParam('phone_service_id');
//$Deactive = new Account();
$DB = Zend_Db_Table_Abstract::getDefaultAdapter();
$DB->query("UPDATE user_preferences SET user_preferences_value = '2'
WHERE user_preferences_name = 'is_user_package_active' AND user_id = '$user_id' AND phone_service_id='$phone_service_id'");
// $a = $Deactive->Deactivate_Service($user_id,$phone_service_id);
// var_dump($a);
}
+3
source to share
1 answer
Your call to "update" seems fine, although in your case it is better to use the following syntax to construct the WHERE clause (but this is a stylistic thing):
$data = array('user_preference_value' => 2);
$where = array(
'user_preferences_name = ?' => 'is_user_package_active',
'user_id = ?' => $user_id,
'phone_service_id = ?' => $phone_service_id
);
$DB->update('user_preferences', $data, $where);
So my guess is that the problem is with your default adapter. Are you sure you have configured your connection? Can you run SELECT successfully with the same $ DB object? Try running a normal SQL update with your object, i.e. $ DB-> query ("Your raw UPDATE query is here") to see if it works.
Also Zend_Db_Table is the default way to get the DB, but this is also stylistic.
+5
source to share