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