Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › Update not functioning & MySQLi

Update not functioning & MySQLi

Thread began 3/02/2016 10:35 am by Andrew Dodd - ADDIGITAL | Last modified 3/03/2016 9:42 am by Ray Borduin | 687 views | 2 replies |

3/02/2016 10:35 am | #1 Andrew Dodd - ADDIGITAL

Update not functioning & MySQLi

I have a legacy site built with Design Extender & Data Bridge at nktheatre.co.uk.

It's going to be a hassle to convert the whole site to MySQLi right now, tho I will do at some point.

My question is, I've used DW's update record behaviour, along with a record selection page to select the record, and this seems to work fine apart from the update itself - nothing happens when the update is submitted & it's got me stumped for the last day or so..

Files attached!

Can anybody see anything obvious that I've missed on the update page?

Also, can I mix MySQLi behaviours with the existing DataBridge/PowerCMS behaviours until they're updated?

I tried to use DataAssist, but it just crashes Dreamweaver!

TIA
Andrew

3/02/2016 2:21 pm | #2 Ray BorduinWebAssist

Yes you can mix mysql with mysqli without issues.

Does the update work? It looks like you have several blank lines in your php code... those will cause issues with the redirects after insert or update. You should definitely remove them from lines 3,67,68,70,75

Did this help? Tips are appreciated...

3/03/2016 4:10 am | #3 Andrew Dodd - ADDIGITAL

Thanks for that Ray!

Another pair of eyes spotted a hidden field in the update form which was basically causing the record id to be lost, during update.

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.