/** * 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; }
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'); } }
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]; } }
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; }