PHP mysql error, unable to INSERT to database

Question

I have these lines of PHP code:

$sql2 = "INSERT INTO TableName ... " //an example, line is very long
error_log($sql2);
$result2 = $this->conn->query($sql2); //line 81

I get this error in PHP error log:

PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /volume1/web/DB_Functions.php on line 81

My first idea was that my $sql2 string is not valid, but when I copied it from PHP error log and pasted it to PhpMyAdmin as SQL it works pretty well, what could be wrong?

How are you initializing your mysql connection ? maybe you didn't set it up correctly — Vishnu Nair
– Vishnu Nair, Commented May 26, 2016 at 8:33

Community · Accepted Answer · 2017-05-23 12:02:11Z

1

I think it is because when you close the database connection the first time, you forget to do:

unset($this->conn);

And then when you try connecting to the database again, it craps out because it is still set to the closed connection. Originally referenced from: Warning: mysqli_query(): Couldn't fetch mysqli

Hope it solve your problem!

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered May 26, 2016 at 8:46

Rupal Javiya

5795 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP mysql error, unable to INSERT to database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related