Can't establish a dynamic link with CSS Menu Writer and MySQLi

Using Dreamweaver CC and Design Extender with Yosemite I went to put in a dynamic link using CSS Menu Writer. I bring up the edit menu content window and select the + icon and choose a dynamic link. For connection I select define and choose a Dynamic MySQLi Connection. I go through the usual process and test connection and it's working perfectly. I'm now back in the Dynamic Link window but for connection there is nothing, the Connection still says None and there is nothing in the drop down. I have been using CSS Menu Writer for many years but i have never seen this. I am presuming it is something to do with fact that I am using Dreamweaver CC.

I have not done anything different to how I would usually work. Installed Dreamweaver CC then downloaded the database behaviours panel then downloaded and installed Super Suite and that's me. I have tried removing and reinstalling extension but it still does not want to know.

Any help appreciated.

Regards,

David Fullstone.

Menu writer has not been updated to work with MySQLi yet. The best solution would probably be to generate the menu using regular MySQL and then manually update the recordset, loops, and data references on the generated menu php page.

That's cool so long as I know. I'm sure Webassist will get it to work soon enough. I was working as an Oracle contractor for a couple of years but have moved back to my web business and panicked a bit on the php support side of things. I'm currently rebuilding all my web sites to be totally HTML5 and MySQLi compliant. Hopefully other extensions will be MySQLi compliant :-)

We are working on it, but there are a lot of interfaces to get to. If you want help manually updating a page or menu in the meantime we are here to help.

Thanks Ray, it's sort of worked out well as I am combining your extensions with learning MySQLi at the same time so I'm learning a lot whilst getting those little things done for me. Finally finished and managed to use your extensions (with some code modifications) to access a partitioned table and even managed to work out how to make a call to procedures on the MySQL server and display results with minimal modifications :-)

Please let me know the modifications that were necessary and we can work them into an update. Any feedback on how we can improve the functionality is appreciated.

Hi Ray I have added my code below and you can see where I am building my new website at http://www.businessdirectorylistings.co.uk/bd2015/ as the root website is getting a bit dated.

Hi Ray,
Wondering if you can help. I am having the same problem as david73021.
I have converted all of the menu system to MySqli, and I can get the level 2 to show all of it's items, but as you can't nest two queries in MySqli I can't get the level 1 to show all of it's items. I wonder would you could offer some advice?
I have attached the menu script in a PM.

Even though you can't apply the server behavior in a nested record, you should still be able to apply it below and copy and paste it into a nested scenario and it will work.

That is what I would suggest doing... just add some text below and repeat that and manually move the repeat region back inside of the other once the code is on the page.

Hi Ray,
Thanks for your help, it's now sorted.
Compleated script attached might be useful if someone else asks the same question.