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

Insert Not Working

Thread began 5/11/2018 10:39 am by vernon webb | Last modified 5/14/2018 2:30 pm by Ray Borduin | 38 views | 3 replies |

vernon webb

Insert Not Working

I deleted everything on the page and setup a new insert using the new mysqli insert and nothing happens. The page refreshes but doesn't insert nor does it redirect to the proper page.

Sign in to reply to this post

Ray BorduinWebAssist

It looks like it isn't adding the hidden form identifier it uses as the trigger. You can either add this to your form:

<input type="hidden" name="MM_insert" value="form1">

or update the server behavior and change the trigger to use your submit button. I'll get it fixed to automatically add the hidden form element in the next build.

You could also use the MySQLi insert record server behavior, which has you set the trigger on application and wouldn't have this issue.

Sign in to reply to this post

vernon webb

OK so I deleted it and said to submit with any form and now it is submitting but the values are blank. I did select the correct form field, so am a bit perplexed.

Sign in to reply to this post

Ray BorduinWebAssist

This seems related to the previous issue you were having with your host where Prepared Statements aren't working. I'm not sure why.

I updated the queryobj.php file and added a parameter for turning off Prepared Statements. That is on line 26. And then I updated yours so that Prepared statements are turned off and the insert works now.

I also created a page debug.php that has the simplest Prepared Statement that should do an insert, but it is blank. You can show that page to your hosting provider if you want and maybe they can help debug why it isn't working.

Please download the updated queryobj.php file so you have a copy where it allows you to turn off Prepared Statements since your local version is now old.

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...