close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

MySQLi

Thread began 2/25/2018 11:12 am by antonstaartjes358461 | Last modified 4/01/2018 2:08 pm by Ray Borduin | 195 views | 7 replies |

antonstaartjes358461

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

antonstaartjes358461

MySQLi

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

markdoyle87077

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

markdoyle87077

Hi Ray,

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

Sign in to reply to this post

Ray BorduinWebAssist

Yes I will make sure it gets updated.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...