当前位置: 首页>>代码示例>>PHP>>正文


PHP Zend_Db_Adapter_Abstract::prepare方法代码示例

本文整理汇总了PHP中Zend_Db_Adapter_Abstract::prepare方法的典型用法代码示例。如果您正苦于以下问题:PHP Zend_Db_Adapter_Abstract::prepare方法的具体用法?PHP Zend_Db_Adapter_Abstract::prepare怎么用?PHP Zend_Db_Adapter_Abstract::prepare使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Zend_Db_Adapter_Abstract的用法示例。


在下文中一共展示了Zend_Db_Adapter_Abstract::prepare方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: update

 /**
  * Update table rows with the given data, optionally limited by using a filter
  *
  * Pass an array with a column name (the same as in $bind) and a PDO::PARAM_* constant as value
  * as fourth parameter $types to define a different type than string for a particular column.
  *
  * @param   string  $table
  * @param   array   $bind
  * @param   Filter  $filter
  * @param   array   $types
  *
  * @return  int             The number of affected rows
  */
 public function update($table, array $bind, Filter $filter = null, array $types = array())
 {
     $set = array();
     foreach ($bind as $column => $_) {
         $set[] = $column . ' = :' . $column;
     }
     $sql = 'UPDATE ' . $table . ' SET ' . join(', ', $set) . ($filter ? ' WHERE ' . $this->renderFilter($filter) : '');
     $statement = $this->dbAdapter->prepare($sql);
     foreach ($bind as $column => $value) {
         $type = isset($types[$column]) ? $types[$column] : PDO::PARAM_STR;
         $statement->bindValue(':' . $column, $value, $type);
     }
     $statement->execute();
     return $statement->rowCount();
 }
开发者ID:scibi,项目名称:icingaweb2,代码行数:28,代码来源:DbConnection.php

示例2: _updateLastEnd

 /**
  * Updates the lastEnd values of all entries
  *
  * @return void
  */
 private function _updateLastEnd()
 {
     if ($this->_debug) {
         Phprojekt::getInstance()->getLog()->debug('_updateLastEnd');
     }
     $this->_db->query('UPDATE calendar2 SET last_end = end WHERE rrule = ""');
     $entries = $this->_db->select()->from('calendar2', array('id', 'start', 'end', 'rrule'))->where('rrule != ""')->query()->fetchAll();
     $update = $this->_db->prepare('UPDATE calendar2 SET last_end = :last_end WHERE id = :id');
     $x = 0;
     foreach ($entries as $key => $e) {
         if ($this->_debug && ++$x % 100 == 0) {
             Phprojekt::getInstance()->getLog()->debug($x);
         }
         $start = new Datetime($e['start']);
         $end = new Datetime($e['end']);
         $duration = $start->diff($end);
         $helper = new Calendar2_Helper_Rrule($start, $duration, $e['rrule']);
         $update->execute(array(':last_end' => $helper->getUpperTimeBoundary()->format('Y-m-d H:i:s'), ':id' => $e['id']));
     }
 }
开发者ID:RainyBlueSky,项目名称:PHProjekt,代码行数:25,代码来源:Migration.php

示例3: prepare

 /**
  * Prepare a statement and return a PDOStatement-like object.
  *
  * @param string|Zend_Db_Select $sql SQL query
  * @return Zend_Db_Statement|PDOStatement
  */
 public function prepare($sql)
 {
     return $this->_adapter->prepare($sql);
 }
开发者ID:cwcw,项目名称:cms,代码行数:10,代码来源:Abstract.php

示例4: printQuery

 public static function printQuery(Zend_Db_Adapter_Abstract $database, $query)
 {
     try {
         $s = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">';
         $s .= '<html>';
         $s .= '<head>';
         $s .= '<meta http-equiv="content-type" content="text/html; charset=utf-8" />';
         $s .= '</head>';
         $s .= '<body>';
         $statement = $database->prepare($query);
         $statement->execute();
         $result = $statement->fetchAll(Zend_Db::FETCH_ASSOC);
         $s .= "<table width=600 border=1>";
         $s .= "<tr><th colspan=\"2\" align=\"left\" bgcolor=\"#eeeeee\"><h2>Database - Select Query</h2></td></tr>";
         $s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Database Class</nobr></nobr></td><td>" . get_class($database) . "&nbsp;</td></tr>";
         $s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Statement Class</nobr></td><td>" . get_class($statement) . "&nbsp;</td></tr>";
         $s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Rows</nobr></td><td>" . sizeof($result) . "&nbsp;</td></tr>";
         #$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Columns</nobr></td><td>".$numCols."&nbsp;</td></tr>";
         $s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Query</nobr></td><td>" . htmlentities($query) . "&nbsp;</td></tr>";
         $s .= "</table><br />";
         $count = 0;
         if (sizeof($result) > 0) {
             $s .= "<table border=1>";
             foreach ($result as $row) {
                 if ($count == 0) {
                     # column index
                     $colCount = 0;
                     $s .= "<tr>";
                     foreach ($row as $k => $v) {
                         $s .= '<th align="left" bgcolor="#eeeeee">' . $colCount++ . '</th>';
                     }
                     $s .= "</tr>";
                     # column names
                     $s .= "<tr>";
                     foreach ($row as $k => $v) {
                         $s .= '<th align="left" bgcolor="#eeeeee">' . htmlentities($k) . '</th>';
                     }
                     $s .= "</tr>";
                 }
                 $s .= "<tr>";
                 foreach ($row as $k => $v) {
                     $v = mb_substr($v, 0, 100);
                     $s .= '<td>' . htmlentities($v) . '&nbsp;</td>';
                 }
                 $s .= "</tr>";
                 $count++;
             }
             $s .= "</table><br />";
         }
         # EXPLAIN
         $statement = $database->prepare('EXPLAIN ' . $query);
         $statement->execute();
         $result = $statement->fetchAll(Zend_Db::FETCH_ASSOC);
         $count = 0;
         if (sizeof($result) > 0) {
             $s .= "<table border=1>";
             foreach ($result as $row) {
                 if ($count == 0) {
                     # column names
                     $s .= "<tr>";
                     foreach ($row as $k => $v) {
                         $s .= '<th align="left" bgcolor="#eeeeee">' . htmlentities($k) . '</th>';
                     }
                     $s .= "</tr>";
                 }
                 $s .= "<tr>";
                 foreach ($row as $k => $v) {
                     $v = mb_substr($v, 0, 100);
                     $s .= '<td>' . htmlentities($v) . '&nbsp;</td>';
                 }
                 $s .= "</tr>";
                 $count++;
             }
             $s .= "</table><br />";
         }
         $s .= '</body>';
         $s .= '</html>';
         print $s;
     } catch (Exception $exception) {
         $s = "<table width=600 border=1>";
         $s .= "<tr><th colspan=\"2\" align=\"left\" bgcolor=\"#eeeeee\"><h2>Database - Select Query</h2></td></tr>";
         $s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Database Class</nobr></td><td>" . get_class($database) . "&nbsp;</td></tr>";
         #$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Statement Class</nobr></td><td>".get_class($result)."&nbsp;</td></tr>";
         $s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Code</nobr></td><td>" . $exception->getCode() . "&nbsp;</td></tr>";
         $s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Error</nobr></td><td>" . $exception->getMessage() . "&nbsp;</td></tr>";
         #$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Native Code</nobr></td><td>".$this->getNativeErrorCode()."&nbsp;</td></tr>";
         #$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Native Error</nobr></td><td>".htmlentities($this->getNativeError())."&nbsp;</td></tr>";
         $s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Query</nobr></td><td>" . htmlentities($query) . "&nbsp;</td></tr>";
         $s .= "</table><br />";
         print $s;
     }
 }
开发者ID:sirprize,项目名称:xzend,代码行数:92,代码来源:Debug.php

示例5: _printDocuments

 /**
  * 
  * @param Zend_Db_Adapter_Abstract $db
  * @param string $printerName
  * @param string $ipServer
  * @return boolean
  * @throws ZendT_Exception_Error
  */
 private function _printDocuments($db, $printerName, $ipServer)
 {
     $sql = "declare\n                      message varchar2(500);\n                   begin\n                      wsapi.ws_printserver_pkg.print(pprintername => :printername,\n                                                     pipserver => :ipserver);\n                      :erro      := 0;\n                      :message   := NULL;\n                   exception when others then\n                      :erro      := 1;\n                      :message   := sqlerrm;\n                   end;";
     $stmt = $db->prepare($sql);
     $stmt->bindParam('printername', $printerName);
     $stmt->bindParam('ipserver', $ipServer);
     $stmt->bindValue('erro', $erro);
     $stmt->bindValue('message', $message);
     $stmt->execute();
     if ($erro) {
         throw new ZendT_Exception_Error($message);
     }
     return true;
 }
开发者ID:rtsantos,项目名称:mais,代码行数:22,代码来源:Printer.php


注:本文中的Zend_Db_Adapter_Abstract::prepare方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。