Return SQL query errors in PHP file

Question

UPD: CLOSED. Duplicate found and typos in my original question

I am using this code and I want to get a message if there is an error with my SQL query :

$Db = mysqli_init();
$Db->options(MYSQLI_OPT_LOCAL_INFILE, true);
$Db->real_connect($servername, $username, $password, $dbname, 3306);

// Creation of first SQL query
$sql = ('select sum('.$metric1.') as t1metric from '.$table1.' WHERE '.$date1.' between "'.$start_date.'" AND "'.$end_date.'"');
$query = $Db->query($sql);

if ($Db->error) 
{
    printf("Errormessage: %s\n", $Db->error);
}

and I receive this error when I run the php file :

Call to a member function query() on a non-object

You should use `$Db` instead `$mysqli`, as above you define `$Db = mysqli_init();` — Armen, Dec 15 '15 at 11:33

score 2 · Answer 1 · edited Dec 15 '15 at 11:38

2

use the following

$Db->query($sql);

instead of

$mysqli->query($query);

edited Dec 15 '15 at 11:38

Syed mohamed aladeen

6,507
4
32
59

answered Dec 15 '15 at 11:37

Drop Shadow

845
3
12
28

score 1 · Accepted Answer · answered Dec 15 '15 at 11:34

1

$mysqli->query($query);

Replace with:

 $Db->query($query);

answered Dec 15 '15 at 11:34

Shailesh Katarmal

2,757
1
12
15

Return SQL query errors in PHP file

2 Answers2