數(shù)據(jù)庫(kù)讀寫沒問題,response body部分空
求助~!文章操作這部分,_handleArticleList(),使用 return時(shí),response 的 body 部分為空,用print_r()能顯示,代碼照著視頻中的敲的。User部分的注冊(cè)就沒問題,得到的response 的 body中有注冊(cè)用戶信息。謝謝!
getList
```php
public function getList($user_id,$page=1,$size=10){
????????if($size > 100) {
????????????throw new Exception('Page limited 100', ErrorCode::PAGE_LIMIT_EXCEED);
????????}
????????$sql = 'SELECT * FROM `article` WHERE `user_id`=:user_id LIMIT :limit, :offset';
????????$limit = ($page-1)*$size;
????????$limit = $limit < 0 ? 0 : $limit;
????????$stmt = $this->_db->prepare($sql);
????????$stmt->bindValue(':user_id', $user_id);
????????$stmt->bindValue(':limit', $limit);
????????$stmt->bindValue(':offset', $size);
????????$stmt->execute();
????????$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
??????? //print_r($data);
????????return $data;
????
????}
```
_handleArticleList()
```php
????private function _handleArticleList(){
????????$user = $this->_userLogin($_SERVER['PHP_AUTH_USER'],$_SERVER['PHP_AUTH_PW']);
????????$page = isset($_GET['page']) ? $_GET['page'] : 1;
????????$size = isset($_GET['size']) ? $_GET['size'] : 10;
????????if($size > 100){
????????????throw new Exception("Page is too large", 400);
????????}
????????return $this->_article->getList($user['user_id'], $page, $size);
????}
????private function _handleArticleView(){
????????
????}
????private function _userLogin($PHP_AUTH_USER, $PHP_AUTH_PW){
????????try{
????????????return $this->_user->login($PHP_AUTH_USER, $PHP_AUTH_PW);
????????}catch(Exception $e){
????????????if(in_array($e->getCode(),
????????????????[
????????????????????ErrorCode::USERNAME_CANNOT_EMPTY,
????????????????????ErrorCode::PASSWORD_CANNOT_EMPTY,
????????????????????ErrorCode::USERNAME_OR_PASSWORD_INVALID
????????????????])) {
????????????????????throw new Exception($e->getMessage(), 400);
????????????}
????????????throw new Exception($e->getMessage(), 500);
????????}
????}
```
2019-01-28
對(duì)不起!我提問在錯(cuò)誤的章節(jié)了,本想提問在3-11的,回來(lái)查看文章邏輯章節(jié)后,就提問了。希望看到3-11的小伙伴能回來(lái)幫看看拿出問題了。。。謝謝!!