MySQLi

Hi There
Working with the extension I got a PHP error message: "Notice: Undefined property: mysqli_stmt::$close in /Applications/MAMP/htdocs/test/webassist/mysqli/queryobj.php on line 393

Warning: Cannot modify header information - headers already sent by (output started at /Applications/MAMP/htdocs/test/webassist/mysqli/queryobj.php:393) in /Applications/MAMP/htdocs/test/webassist/mysqli/queryobj.php on line 472"

The queryobj.php file seems to be corrupted, When I changed the file for an 'older' file, the problem was gone. Reinstalling the extension did not help, the problem is still there

Please Advice
Greetings: Anton

Can I get FTP access and a url to reproduce the problem? I'd love to take a look at it to determine what is causing it.

Hi Ray,
I am very sorry....
Updated MAMP (I use to check PHP sites) I did not realize that the PHP version in the installed version was PHP 7. I think that was the problem because installing PHP 5.6 there was no problem, everything worked as it should.

Again sorry for bothering you
Any change you update the extension for PHP 7?
Greetings from Holland
Anton

That wouldn't have been the issue. I'd have to debug to find it though, so if you can't reproduce it at the moment there isn't much I can do.

HI Ray, I am getting the same error over lots of pages from line 393 testing on localhost.

if ($query && $query->close) $query->close();

This looks as though it is not properly formatted as there is no opening { after the if statement

If I change the line to

$query->close();

the error is not reported.

You don't need a { in a one line IF statement.

What about if you change it to:

if ($query && method_exists($query,'close')) $query->close();

Does that eliminate the error? I think that is probably the right syntax.

Hi Ray,

Yes that seems to work, can you update the MySQLi extension please.

Yes I will make sure it gets updated.