我是PHP的新手,想知道為什么我的like查詢只返回一個值。這是我的模特//For searchpublic function getSearchResults($username){ $stmt = $this->_connection->prepare("SELECT * FROM users WHERE username LIKE :username"); $stmt->execute(['username' => '%'.$username.'%']); $stmt->setFetchMode(PDO::FETCH_CLASS, "User"); return $stmt->fetch();}然后在我的控制器中function search($name){ //Get search results $searchResults = $this->model('User'); $searchResults = $searchResults->getSearchResults($name); $data = (array) $searchResults; $this->view('User/search', $data);}但是,它僅返回1個結果,而不是3個結果。(我有4個用戶名,其中帶有“ hi”,但僅返回一個)
PDO查詢僅返回1行
幕布斯6054654
2021-05-11 17:22:27