PHP Zend_Db_Statement_Pdo类代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中Zend_Db_Statement_Pdo类的典型用法代码示例。如果您正苦于以下问题：PHP Zend_Db_Statement_Pdo类的具体用法？PHP Zend_Db_Statement_Pdo怎么用？PHP Zend_Db_Statement_Pdo使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

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

示例1: testStatementConstructWithSelectObject

 public function testStatementConstructWithSelectObject()
 {
     $select = $this->_db->select()->from('zfproducts');
     $stmt = new Zend_Db_Statement_Pdo($this->_db, $select);
     $this->assertTrue($stmt instanceof Zend_Db_Statement_Interface);
     $stmt->closeCursor();
 }

开发者ID:jsnshrmn，项目名称:Suma，代码行数:7，代码来源:TestCommon.php

示例2: getStats

 /**
  * Get formatted statistics message
  *
  * @param string $type Type of query
  * @param string $sql
  * @param array $bind
  * @param \Zend_Db_Statement_Pdo|null $result
  * @return string
  * @throws \Zend_Db_Statement_Exception
  */
 public function getStats($type, $sql, $bind = [], $result = null)
 {
     $message = '## ' . getmypid() . ' ## ';
     $nl = "\n";
     $time = sprintf('%.4f', microtime(true) - $this->timer);
     if (!$this->logAllQueries && $time < $this->logQueryTime) {
         return '';
     }
     switch ($type) {
         case self::TYPE_CONNECT:
             $message .= 'CONNECT' . $nl;
             break;
         case self::TYPE_TRANSACTION:
             $message .= 'TRANSACTION ' . $sql . $nl;
             break;
         case self::TYPE_QUERY:
             $message .= 'QUERY' . $nl;
             $message .= 'SQL: ' . $sql . $nl;
             if ($bind) {
                 $message .= 'BIND: ' . var_export($bind, true) . $nl;
             }
             if ($result instanceof \Zend_Db_Statement_Pdo) {
                 $message .= 'AFF: ' . $result->rowCount() . $nl;
             }
             break;
     }
     $message .= 'TIME: ' . $time . $nl;
     if ($this->logCallStack) {
         $message .= 'TRACE: ' . Debug::backtrace(true, false) . $nl;
     }
     $message .= $nl;
     return $message;
 }

开发者ID:IlyaGluschenko，项目名称:test001，代码行数:43，代码来源:LoggerAbstract.php

示例3: editAction

 public function editAction()
 {
     //$this->_helper->viewRenderer->setNoRender(true);
     $referer = $this->getRequest()->getHeader('Referer');
     $id = $this->getParam('id');
     $userForm = new Form_Auth_Add();
     try {
         #using named parameters
         /*
         $sql = 'SELECT * FROM users WHERE id = :id';
         $stmt = new Zend_Db_Statement_Pdo($this->db, $sql);
         $stmt->execute(array(':id' => $this->getParam('id')));
         */
         #using positional parameters
         $sql = 'SELECT * FROM users WHERE id = ?';
         $stmt = new Zend_Db_Statement_Pdo($this->db, $sql);
         $stmt->execute(array($id));
         $userData = $stmt->fetchAll();
         if ($this->getRequest()->isPost()) {
             print_r($usersData);
             exit;
             // clearing previous values
             $usersData = array();
             $userData = $this->getRequest()->getPost();
             if ($userForm->isValid($userData)) {
                 $this->db->update($userData, 'id = ' . (int) $id);
                 $this->_redirect($referer);
             }
         }
         $userForm->populate($userData);
         print_r($userData[0]);
         //exit;
         //$this->view->users = $usersData; // oneliner // $this->view->users = $this->db->fetchAll($sql);
         $this->view->userForm = $userForm;
         // oneliner // $this->view->users = $this->db->fetchAll($sql);
     } catch (Exception $e) {
         $this->_helper->flashMessenger('An error_log');
     }
 }

开发者ID:ajaysarw，项目名称:zf1，代码行数:39，代码来源:UserController.php

示例4: getFirstOrLastLogForUser

    public function getFirstOrLastLogForUser($idUser, $first = true)
    {
        $db = $this->getDbTable()->getAdapter();
        $sql = '	SELECT *
					FROM pic 
					WHERE user_id = :idUser
					';
        if ($first) {
            $sql .= ' ORDER BY date_shot DESC LIMIT 1';
        } else {
            $sql .= ' ORDER BY date_shot ASC LIMIT 1';
        }
        $stmt = new Zend_Db_Statement_Pdo($db, $sql);
        $stmt->bindParam(':idUser', $idUser);
        $stmt->execute();
        $resultSet = $stmt->fetchAll();
        $arrPics = $this->createObjektArr($resultSet);
        if (empty($arrPics)) {
            return 0;
        } else {
            return $arrPics[0];
        }
    }

开发者ID:naegeles，项目名称:Logit，代码行数:23，代码来源:PictureMapper.php

示例5: insertAllSessionData

 function insertAllSessionData($session_date, $records)
 {
     $db = Zend_Registry::get('db');
     $i = 0;
     $max_inserts = 100;
     for ($rows = 0; $rows < count($records); $rows += $max_inserts) {
         $values = array();
         $sql = 'INSERT INTO t_exercise_data
                    (session_date,
                     time,
                     distance,
                     heartrate,
                     speed,
                     latitude,
                     longitude,
                     altitude,
                     cadence,
                     temperature,
                     power,
                     gradient,
                     userid)
                 VALUES ';
         /* Do a multi insert */
         for ($i = 0; $i < $max_inserts && $i + $rows < count($records); $i++) {
             if ($i != 0) {
                 $sql .= ', ';
             }
             $sql .= '(:session_date,
                       :time' . $i . ',
                       :distance' . $i . ',
                       :heartrate' . $i . ',
                       :speed' . $i . ',
                       :latitude' . $i . ',
                       :longitude' . $i . ',
                       :altitude' . $i . ',
                       :cadence' . $i . ',
                       :temperature' . $i . ',
                       :power' . $i . ',
                       :gradient' . $i . ',
                       :userid) ';
             $values[':time' . $i] = $records[$i + $rows]->interval;
             $values[':distance' . $i] = $records[$i + $rows]->distance;
             $values[':heartrate' . $i] = $records[$i + $rows]->heart_rate;
             $values[':speed' . $i] = $records[$i + $rows]->speed;
             $values[':latitude' . $i] = $records[$i + $rows]->position_lat;
             $values[':longitude' . $i] = $records[$i + $rows]->position_long;
             $values[':altitude' . $i] = $records[$i + $rows]->altitude;
             $values[':cadence' . $i] = $records[$i + $rows]->cadence;
             $values[':temperature' . $i] = $records[$i + $rows]->temperature;
             $values[':power' . $i] = $records[$i + $rows]->power;
             $values[':gradient' . $i] = $records[$i + $rows]->gradient;
         }
         //$stmt = new Zend_Db_Statement($db, $sql);
         $stmt = new Zend_Db_Statement_Pdo($db, $sql);
         /* Add the constant values for all rows */
         $values[':session_date'] = $session_date;
         $values[':userid'] = Core_Common::getCurrentUserLogin();
         $stmt->execute($values);
     }
 }

开发者ID:ptarcher，项目名称:exercise_mvc，代码行数:60，代码来源:API.php

示例6: prepare

 /**
  * Prepares an SQL statement.
  *
  * @param string $sql The SQL statement with placeholders.
  * @param array $bind An array of data to bind to the placeholders.
  * @return PDOStatement
  */
 public function prepare($sql)
 {
     $this->_connect();
     $stmt = new Zend_Db_Statement_Pdo($this, $sql);
     $stmt->setFetchMode($this->_fetchMode);
     return $stmt;
 }

开发者ID:jorgenils，项目名称:zend-framework，代码行数:14，代码来源:Abstract.php

示例7: _debugStat

 /**
  * Logging debug information
  *
  * @param int $type
  * @param string $sql
  * @param array $bind
  * @param Zend_Db_Statement_Pdo $result
  * @return Varien_Db_Adapter_Pdo_Mysql
  */
 protected function _debugStat($type, $sql, $bind = array(), $result = null)
 {
     if (!$this->_debug) {
         return $this;
     }
     $code = '## ' . getmypid() . ' ## ';
     $nl = "\n";
     $time = sprintf('%.4f', microtime(true) - $this->_debugTimer);
     if (!$this->_logAllQueries && $time < $this->_logQueryTime) {
         return $this;
     }
     switch ($type) {
         case self::DEBUG_CONNECT:
             $code .= 'CONNECT' . $nl;
             break;
         case self::DEBUG_TRANSACTION:
             $code .= 'TRANSACTION ' . $sql . $nl;
             break;
         case self::DEBUG_QUERY:
             $code .= 'QUERY' . $nl;
             $code .= 'SQL: ' . $sql . $nl;
             if ($bind) {
                 $code .= 'BIND: ' . var_export($bind, true) . $nl;
             }
             if ($result instanceof Zend_Db_Statement_Pdo) {
                 $code .= 'AFF: ' . $result->rowCount() . $nl;
             }
             break;
     }
     $code .= 'TIME: ' . $time . $nl;
     if ($this->_logCallStack) {
         $code .= 'TRACE: ' . Varien_Debug::backtrace(true, false) . $nl;
     }
     $code .= $nl;
     $this->_debugWriteToFile($code);
     return $this;
 }

开发者ID:z4kko，项目名称:smartdevs-indexer，代码行数:46，代码来源:Mysql.php

示例8: createTimeslots

 /**
  * Create default timeslot values based on days/session duration
  *
  * @param	array	$post	Post request
  */
 public function createTimeslots($post)
 {
     $db = $this->getAdapter();
     $dt = new Zend_Date($post['start'], 'dd/MM/YYYY hh:mm');
     $sql = 'insert into timeslots (tstart, tend, number, type, conference_id)' . 'values (:tstart, :tend, :number, :type, ' . (int) $post['id'] . ')';
     $stmt = new Zend_Db_Statement_Pdo($db, $sql);
     $n = 0;
     // for every day add slot/break/lunch/slot/break/slot
     for ($i = 1; $i <= $post['days']; $i++) {
         $stmt->execute(array(':tstart' => $dt->get(Zend_Date::ISO_8601), ':tend' => $dt->add('90', 'mm')->get(Zend_Date::ISO_8601), ':number' => $n + 1, ':type' => 1));
         $stmt->execute(array(':tstart' => $dt->get(Zend_Date::ISO_8601), ':tend' => $dt->add('30', 'mm')->get(Zend_Date::ISO_8601), ':number' => 0, ':type' => 2));
         $stmt->execute(array(':tstart' => $dt->get(Zend_Date::ISO_8601), ':tend' => $dt->add('90', 'mm')->get(Zend_Date::ISO_8601), ':number' => $n + 2, ':type' => 1));
         $stmt->execute(array(':tstart' => $dt->get(Zend_Date::ISO_8601), ':tend' => $dt->add('90', 'mm')->get(Zend_Date::ISO_8601), ':number' => 0, ':type' => 3));
         $stmt->execute(array(':tstart' => $dt->get(Zend_Date::ISO_8601), ':tend' => $dt->add('90', 'mm')->get(Zend_Date::ISO_8601), ':number' => $n + 3, ':type' => 1));
         $stmt->execute(array(':tstart' => $dt->get(Zend_Date::ISO_8601), ':tend' => $dt->add('30', 'mm')->get(Zend_Date::ISO_8601), ':number' => 0, ':type' => 2));
         $stmt->execute(array(':tstart' => $dt->get(Zend_Date::ISO_8601), ':tend' => $dt->add('90', 'mm')->get(Zend_Date::ISO_8601), ':number' => $n = $n + 4, ':type' => 1));
         // reset date and add a day
         $dt = new Zend_Date($post['start'], 'dd/MM/YYYY hh:mm');
         $dt->add($i, Zend_Date::DAY_SHORT);
     }
     return true;
 }

开发者ID:GEANT，项目名称:CORE，代码行数:27，代码来源:Conferences.php

示例9: searchFriendsByName

    public function searchFriendsByName($idUser, $username)
    {
        $db = $this->getDbTable()->getAdapter();
        $sql = '	SELECT 	f.*
					FROM 	user f, 
							user_friends u 
					WHERE 	u.id_user = :idUser
					AND 	f.id = u.id_friend	
					AND		f.username LIKE :name ';
        $username = '%' . $username . '%';
        $stmt = new Zend_Db_Statement_Pdo($db, $sql);
        $stmt->bindParam(':idUser', $idUser);
        $stmt->bindParam(':name', $username);
        $stmt->execute();
        $resultSet = $stmt->fetchAll();
        $arrRestaurants = $this->createObjektArr($resultSet);
        return $arrRestaurants;
    }

开发者ID:naegeles，项目名称:Logit，代码行数:18，代码来源:UserMapper.php

示例10: testFetchItem

 /**
  * Run test fetchItem method
  *
  * @return void
  */
 public function testFetchItem()
 {
     $adapterMock = $this->getMock('Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql', ['query'], [], '', false);
     $this->selectMock->expects($this->once())->method('getConnection')->will($this->returnValue($adapterMock));
     $adapterMock->expects($this->once())->method('query')->will($this->returnValue($this->fetchStmtMock));
     $this->fetchStmtMock->expects($this->once())->method('fetch')->will($this->returnValue(null));
     $this->assertEquals([], $this->query->fetchItem());
 }

开发者ID:tingyeeh，项目名称:magento2，代码行数:13，代码来源:QueryTest.php

示例11: fetch

 /**
  * Fetches a row from the result set.
  *
  * @param int $style  OPTIONAL Fetch mode for this fetch operation.
  * @param int $cursor OPTIONAL Absolute, relative, or other.
  * @param int $offset OPTIONAL Number for absolute or relative cursors.
  * @return mixed Array, object, or scalar depending on fetch mode.
  * @throws Zend_Db_Statement_Exception
  */
 public function fetch($style = null, $cursor = null, $offset = null)
 {
     $row = parent::fetch($style, $cursor, $offset);
     $remove = $this->_adapter->foldCase('zend_db_rownum');
     if (is_array($row) && array_key_exists($remove, $row)) {
         unset($row[$remove]);
     }
     return $row;
 }

开发者ID:netixx，项目名称:Stock，代码行数:18，代码来源:Oci.php

示例12: fetchItem

 /**
  * Fetch statement
  *
  * @return mixed
  */
 public function fetchItem()
 {
     if (null === $this->fetchStmt) {
         $this->fetchStmt = $this->getConnection()->query($this->getSelect(), $this->bindParams);
     }
     $data = $this->fetchStmt->fetch();
     if (!$data) {
         $data = [];
     }
     return $data;
 }

开发者ID:shabbirvividads，项目名称:magento2，代码行数:16，代码来源:Query.php

示例13: fetchAll

 /**
  * Returns an array containing all of the result set rows.
  *
  * Behaves like parent, but if limit()
  * is used, the final result removes the extra column
  * 'zend_db_rownum'
  *
  * @param int $style OPTIONAL Fetch mode.
  * @param int $col   OPTIONAL Column number, if fetch mode is by column.
  * @return array Collection of rows, each in a format by the fetch mode.
  * @throws Zend_Db_Statement_Exception
  */
 public function fetchAll($style = null, $col = null)
 {
     $data = parent::fetchAll($style, $col);
     $results = array();
     $remove = $this->_adapter->foldCase('ZEND_DB_ROWNUM');
     foreach ($data as $row) {
         if (is_array($row) && array_key_exists($remove, $row)) {
             unset($row[$remove]);
         }
         $results[] = $row;
     }
     return $results;
 }

开发者ID:webino，项目名称:zf1，代码行数:25，代码来源:Ibm.php

示例14: fetchItem

 /**
  * Returns a collection item that corresponds to the fetched row
  * and moves the internal data pointer ahead
  *
  * @return  Varien_Object|bool
  */
 public function fetchItem()
 {
     if (null === $this->_fetchStmt) {
         $this->_fetchStmt = $this->getConnection()->query($this->getSelect());
     }
     $data = $this->_fetchStmt->fetch();
     if (!empty($data) && is_array($data)) {
         $item = $this->getNewEmptyItem();
         if ($this->getIdFieldName()) {
             $item->setIdFieldName($this->getIdFieldName());
         }
         $item->setData($data);
         return $item;
     }
     return false;
 }

开发者ID:natxetee，项目名称:magento2，代码行数:22，代码来源:Db.php

示例15: _execute

 /**
  * Executes a prepared statement.
  *
  * @param array $params OPTIONAL Values to bind to parameter placeholders.
  * @return bool
  * @throws Zend_Db_Statement_Exception
  */
 public function _execute(array $params = null)
 {
     $this->_adapter->incrementExecCounter($this->caller);
     return parent::_execute($params);
 }

开发者ID:adamfranco，项目名称:harmoni，代码行数:12，代码来源:Pdo.php

示例16: _execute

 /**
  * Executes a prepared statement.
  *
  * @param array $params OPTIONAL Values to bind to parameter placeholders.
  * @return bool
  * @throws Zend_Db_Statement_Exception
  */
 public function _execute(array $params = null)
 {
     $specialExecute = false;
     if ($params) {
         foreach ($params as $param) {
             if ($param instanceof Varien_Db_Statement_Parameter) {
                 $specialExecute = true;
                 break;
             }
         }
     }
     if ($specialExecute) {
         return $this->_executeWithBinding($params);
     } else {
         return parent::_execute($params);
     }
 }

开发者ID:natxetee，项目名称:magento2，代码行数:24，代码来源:Mysql.php

注：本文中的Zend_Db_Statement_Pdo类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP Zend_Db_Table类代码示例发布时间：2022-05-23

PHP Zend_Db_Statement类代码示例发布时间：2022-05-23

dphi-official/Machine_Learning_Bootcamp

1 librespeed/speedtest: Self-hosted Speedt

librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam

阅读：1218|2022-08-30

2 avehtari/BDA_m_demos: Bayesian Data Anal

avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave

阅读：1133|2022-08-17

3 四维彩超怎么看性别？四维看男孩女孩诀窍

女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的

阅读：942|2022-11-06

4 medfreeman/markdown-it-toc-and-anchor: m

medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho

阅读：1339|2022-08-18

5 Matlab如何循环读取文件

循环读取图片第一种方法①List =dir(amp;#39;*.jpgamp;#39;); %如需其它图片格式支持

阅读：966|2022-07-18

6 Delphi客户端调用Webservice的TClientdatas

http://www.borland.com/namespaces/Types-IAppServerSOAP 服务器未能识别HTTP头SO

阅读：542|2022-07-18

7 CVE-2022-27807

Improper input validation vulnerability in Link of Cybozu Garoon 4.0.0 to 5.5.1

阅读：955|2022-07-08

8 sydney0zq/covid-19-detection: The implem

sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor

阅读：485|2022-08-16

9 世界上哪个国家离中国最远？

离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾

阅读：641|2022-11-06

10 shem8/MaterialLogin: Login view with mat

shem8/MaterialLogin: Login view with material design

阅读：725|2022-08-17

客服电话

电子邮件

PHP Zend_Db_Statement_Pdo类代码示例

示例1: testStatementConstructWithSelectObject

示例2: getStats

示例3: editAction

示例4: getFirstOrLastLogForUser

示例5: insertAllSessionData

示例6: prepare

示例7: _debugStat

示例8: createTimeslots

示例9: searchFriendsByName

示例10: testFetchItem

示例11: fetch

示例12: fetchItem

示例13: fetchAll

示例14: fetchItem

示例15: _execute

示例16: _execute

请发表评论

全部评论

上一篇：

下一篇：

OsbertWang/install-latex-guide-zh-cn: 一

PacktPublishing/Python-Machine-Learning-

sussillo/hfopt-matlab: A parallel, cpu-b

鲁东大学一米网:Win7系统USB驱动器RAM的操

emersion/go-ostatus: An OStatus library

dphi-official/Machine_Learning_Bootcamp

tianli/matlab_offscreen: Matlab offscree

win7系统注册表编辑器打开的操作方法

これがマストドンだ！使い方からインスタ

DelphiListView基本用法大全

matlab使用常犯的错误

关于我们

产品与服务

解决方案

139-2527-9053

客服电话

电子邮件

PHP Zend_Db_Statement_Pdo类代码示例

示例1: testStatementConstructWithSelectObject

示例2: getStats

示例3: editAction

示例4: getFirstOrLastLogForUser

示例5: insertAllSessionData

示例6: prepare

示例7: _debugStat

示例8: createTimeslots

示例9: searchFriendsByName

示例10: testFetchItem

示例11: fetch

示例12: fetchItem

示例13: fetchAll

示例14: fetchItem

示例15: _execute

示例16: _execute

请发表评论

全部评论

上一篇：

下一篇：

OsbertWang/install-latex-guide-zh-cn: 一

PacktPublishing/Python-Machine-Learning-

sussillo/hfopt-matlab: A parallel, cpu-b

鲁东大学一米网:Win7系统USB驱动器RAM的操

emersion/go-ostatus: An OStatus library

dphi-official/Machine_Learning_Bootcamp

tianli/matlab_offscreen: Matlab offscree

win7系统注册表编辑器打开的操作方法

これがマストドンだ！ 使い方からインスタ

DelphiListView基本用法大全

matlab使用常犯的错误

关于我们

产品与服务

解决方案

139-2527-9053

これがマストドンだ！使い方からインスタ