i have an query in mysql zend framwork is there any other way of writing this
$select = $this->select ()
->where ( "phone = '" . $post ['phone'] . "'")
->where(!( "member_id != '" .$post['member_id'] . "'"));
what am trying to do is update phone no of member and see if the phone no already exist in datbase any other way of doing this can someone answer
First off, your code has a security issue. Always use safe quoting:
->where("phone = ?",$post["phone"])
As for the question, you can use the Zend_Validate_Db_NoRecordExists validator on your form. Here are some useful links:
The idea of using this validator is precisely checking whether a given value doesn't already exist in the database, without any additional work on your queries.
To do this I suggest you use a validator on the form!
Example Form:
//phone
$this->addElement('text', 'phone',
array('label' => 'Phone', 'required' => true));
$params = array(
'table' => 'User',
'field' => 'phone',
);
$this->phone->addValidator('Db_NoRecordExistPhone', false, array($params));
validator write in the query that will return the control should be true or false.
