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.
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.
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.
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.
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.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.