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


PHP Zend_Db_Statement_Pdo::fetchAll方法代码示例

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


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

示例1: 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:netixx,项目名称:Stock,代码行数:25,代码来源:Oci.php

示例2: 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

示例3: 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

示例4: 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


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