Can not print data in php from table mysql

Question

I can not display data from the table, please Help! when I run out this error: Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\test.com\index.php on line 3

<?php include ("blocks/bd.php");
$result = $db->query("SELECT title,id,meta_d,meta_k,text,page FROM 'settings'");
if (mysqli_num_rows($result) > 0)

{
$myrow = mysqli_fetch_array($result); 
}

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title><?php echo $myrow["title"]; ?></title>//so here I need to show data from table

You need to replace `'settings'` by `settings` – Ayaz Ali Shah Mar 04 '18 at 10:52 — Ayaz Ali Shah, Mar 04 '18 at 10:52
@Mr. Developer thank you very much – Билолбек Атабеков Mar 04 '18 at 10:56 — Билолбек Атабеков, Mar 04 '18 at 10:56

score 2 · Accepted Answer · answered Mar 04 '18 at 10:57

2

You don't to put single qoutes in the query. Please change following

$result = $db->query("SELECT title,id,meta_d,meta_k,text,page FROM 'settings'");

to

$result = $db->query("SELECT title,id,meta_d,meta_k,text,page FROM `settings`");

answered Mar 04 '18 at 10:57

Ayaz Ali Shah

3,453
9
36
68

Can not print data in php from table mysql

1 Answers1