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