Still not working with or without redirect line commented out
You commented out the redirect... I'd start by removing the comment on line 21 and then updating line 19 to add a url parameter to the redirect. Then you can tell if the redirect happens or not. If the redirect happens then it is trying to insert and it may be failing because of a required field. 
The redirect is not the issue. I commented out the redirect to allow the page to show the results. I tried the code without my debug code and with the insert EXCATLY as normal at it still WILL NOT insert.
I see you have a form element named date... that might be causing issues since it is a reserved word in mySQL. It is also skipped in the insert, so if it is required in your database that would cause the insert to fail. 
That is skipped because it is a time stamp auto entered by the database that's why it is skipped. After renaming it and using line 21 as uncommented; no insert; then I commented it out and again no insert but the values I posted are all accurate.
Separate note:
All along I have been trying to find the code to show the response from MySQL and no one can tell me and my searches are in vain. There has to be a way to force this php code to tell me the MySQL response.... but I fail to find anything.


