如果不是，则 fetchRow(） zend - if else, fetchRow() zend

if else, fetchRow() zend

本文关键字：zend fetchRow 如果不 | 更新日期: 2023-09-27

public function updateMemberdetail(Application_Model_Memberdetail $memberdetail)
{
    $data = array(
        'memberid' => $memberdetail->getMemberid(),
        'membername' => $memberdetail->getMembername(),
        'contact' => $memberdetail->getContact(),
        'birthday' => $memberdetail->getBirthday(),
        'email' => $memberdetail->getEmail(),
        'address' => $memberdetail->getAddress(),
    );
    $auth= Zend_Auth::getInstance(); //declare zend_auth to get instance
    $user= $auth->getIdentity(); //get identity of user
    $userid = $user->userid; //get userid of user
    $this->select() //select from usertable and memberdetail 
    ->from(array('memberdetail', 'usertable')) //join memberdetail and usertable through memberid = username 
    ->where('memberdetail.memberid = usertable.?', $userid); 
    $row = $this->fetchRow($select);
    if ($row == true) //if row exist update row
    {
        $this->update($data, 'memberid = '. (int)($memberdetail->getMemberid()));
    }
    else
    {
        $this->insert($data); //if row doesnt exist, add it
    }
}

您好，我对 if else 语句有一些麻烦。如果数据库中不存在数据，我想添加一行数据，但如果存在，则更新它。但是，当我在数据库中没有该行时，它不会插入它。当我手动将一行插入数据库时，它确实会更新该行。

fetchRow 方法将返回 Zend_Db_Table_Row_Abstract 的实例，如果未找到，则返回 NULL。从 Zend 的手册中，我相信您需要在保存之前创建行。

  $select = $this->select() //select from usertable and memberdetail 
    ->from(array('memberdetail', 'usertable')) //join memberdetail and usertable through memberid = username 
    ->where('memberdetail.memberid = usertable.?', $userid); 
  $row = $this->fetchRow($select);
  if (empty($row)) //if row exist update row
  {
    $newRow = $this->createRow($data);
    $newRow->save(); //if row doesnt exist, add it
  }
  else
  {
    $this->update($data, 'memberid = '. (int)($memberdetail->getMemberid()));
  }