MySQLi not selectable in recordsets

I have downloaded and installed mysqli

In Navicat I created a new connection and can see the tables and contents required.

I created a new new php file

In Dreamweaver I opened the tab for databases and can see the new connection I created in Navicat. When Test is selected, the message box states Connection was made successfully.

In bindings I tried to create a new recordset but when I click on Connection from the drop down no Connections show.

If I click on Define I can see the connection required, I highlight this and select done but once again when I select the dropdown arrow there is no connection listed.

I also tried on local host to open a previously working page but recieved another error

Warning: mysql_select_db() expects parameter 2 to be resource, object given in C:\xampp\htdocs\boatsforsalenow_mysqli\BoatAdsFree\boats_Insert.php on line 109

Warning: mysql_query() expects parameter 2 to be resource, object given in C:\xampp\htdocs\boatsforsalenow_mysqli\BoatAdsFree\boats_Insert.php on line 111

In the extension manager I can see MySQLi but cannot seeMySQL. I do need to keep my previous pages working.

Thank you
John

Can anyone assist me with this please?

I have attached two images which show the problem.
When I edit the recordset I can see a connection OK but when I try to construct a recordset no connection is available.
Any ideas how to rectify this?


Many thanks

John

Hello
After reading a few comments in this forum regarding MySqli I decided to try a completely new page set.
Search, Results and Detail.
These pages were created OK but would not function correctly.

The Results page created the errors
Warning: mysql_select_db() expects parameter 2 to be resource, object given in C:\xampp\htdocs\net100-2017\boats_results.php on line 86
Warning: mysql_query() expects parameter 2 to be resource, object given in C:\xampp\htdocs\net100-2017\boats_results.php on line 90

When I looked at the Results recordset which is created once again the is no connection created.
Same in Details.php

I am stumped on this problem can anyone help?

Thanks
John

It looks like you are creating a MySQLi connection, but then trying to create a standard Recordset. You need to create a MySQLi recordset in order to use a MySQLi connection. DataBridge doesn't work with MySQLi yet, but you can use the server behaviors directly to replicate the same functionality. You just have to use the option Webassist->MySQLi->MySQLi Recordset instead of the old Recordset option.

Thanks Ray
use the option Webassist->MySQLi->MySQLi Recordset instead of the old Recordset option
I attach an image of this. May help someone!

That error means that the username or password is incorrect for that database. I can't really debug it since I don't know the correct username and password. I wasn't able to connect to your FTP server, but I don't think it would help anyway since the issue is with the database connection information itself and not with the code on the page.

Please see PM

The issue is with your SQL statement on the page. The library file you have attached won't help me debug it.

I'm not sure if you have everything figured out at this point or not. Please reply if you still need help.

Thanks Ray,
I have attached the page which I hope is the one required