PHP Zend_Db_Adapter_Pdo_Mysql::quoteInto方法代碼示例

 /**
  * add single role rights 
  *
  * @param   int $_roleId
  * @param   int $_applicationId
  * @param   string $_right
  */
 public function addSingleRight($_roleId, $_applicationId, $_right)
 {
     // check if already in
     $select = $this->_roleRightsTable->select();
     $select->where($this->_db->quoteInto($this->_db->quoteIdentifier('role_id') . ' = ?', $_roleId))->where($this->_db->quoteInto($this->_db->quoteIdentifier('right') . ' = ?', $_right))->where($this->_db->quoteInto($this->_db->quoteIdentifier('application_id') . ' = ?', $_applicationId));
     if (!($row = $this->_roleRightsTable->fetchRow($select))) {
         $data = array('role_id' => $_roleId, 'application_id' => $_applicationId, 'right' => $_right);
         $this->_roleRightsTable->insert($data);
     }
 }

 /**
  * returns all contexts of a given tag
  *
  * @param  string $_tagId
  * @return array  array of application ids
  */
 public function getContexts($_tagId)
 {
     $select = $this->_db->select()->from(array('tags_context' => SQL_TABLE_PREFIX . 'tags_context'), array('application_id' => $this->_dbCommand->getAggregate('application_id')))->where($this->_db->quoteInto($this->_db->quoteIdentifier('tag_id') . ' = ?', $_tagId))->group('tag_id');
     Tinebase_Backend_Sql_Abstract::traitGroup($select);
     $apps = $this->_db->fetchOne($select);
     if ($apps === '0') {
         $apps = 'any';
     }
     if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
         Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' got tag contexts: ' . $apps);
     }
     return explode(',', $apps);
 }

 /**
  * Quotes a value and places into a piece of text at a placeholder.
  *
  * Method revrited for handle empty arrays in value param
  *
  * @param string  $text  The text with a placeholder.
  * @param mixed   $value The value to quote.
  * @param string  $type  OPTIONAL SQL datatype
  * @param integer $count OPTIONAL count of placeholders to replace
  * @return string An SQL-safe quoted value placed into the orignal text.
  */
 public function quoteInto($text, $value, $type = null, $count = null)
 {
     if (is_array($value) && empty($value)) {
         $value = new Zend_Db_Expr('NULL');
     }
     return parent::quoteInto($text, $value, $type, $count);
 }

 /**
  * Quotes a value and places into a piece of text at a placeholder.
  *
  * Method revrited for handle empty arrays in value param
  *
  * @param string  $text  The text with a placeholder.
  * @param mixed   $value The value to quote.
  * @param string  $type  OPTIONAL SQL datatype
  * @param integer $count OPTIONAL count of placeholders to replace
  * @return string An SQL-safe quoted value placed into the orignal text.
  */
 public function quoteInto($text, $value, $type = null, $count = null)
 {
     if (is_array($value) && empty($value)) {
         $value = new \Zend_Db_Expr('NULL');
     }
     if ($value instanceof \DateTimeInterface) {
         $value = $value->format('Y-m-d H:i:s');
     }
     return parent::quoteInto($text, $value, $type, $count);
 }

 /**
  * delete note type
  *
  * @param integer $_noteTypeId
  */
 public function deleteNoteType($_noteTypeId)
 {
     $this->_noteTypesTable->delete($this->_db->quoteInto($this->_db->quoteIdentifier('id') . ' = ?', $_noteTypeId));
 }