Answer the question
In order to leave comments, you need to log in
Why can't I retrieve data from the database?
What am I doing wrong?
Fatal error: Call to a member function fetch() on boolean in /customers/b/c/d/bashlam.com/httpd.www/models/News.php on line 38
public static function getNewsList()
{
// Запрос к БД
$host = 'xxx';
$dbname = 'xxxxx';
$user = 'xxxx';
$password = 'xxxx';
$db = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);
$newsList = array();
$result = $db->query('SELECT id, title, date, short_content '
. 'FROM news'
. 'ORDER BY date DESC '
. 'LIMIT 10');
$i = 0;
while($row = $result->fetch()){
$newsList[$i]['id'] = $row['id'];
$newsList[$i]['title'] = $row['title'];
$newsList[$i]['date'] = $row['date'];
$newsList[$i]['short_content'] = $row['short_content'];
$i++;
}
return $newsList;
}
Answer the question
In order to leave comments, you need to log in
in Google
"Call to a member function fetch() on boolean"
the first ten of the issue is full
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question