sperophp Posted January 29, 2014 Share Posted January 29, 2014 Hello All, i just finished creating my first form to database application. this form has a 136 variables but each time i testrun the form by filling some of the fields ramdomly it inserts into the database. However filling the whole 136 inputs on submission writes nothing to the data base. is there a limit of input a form can submit to a database? any idea of what i should do thanks? Quote Link to comment https://forums.phpfreaks.com/topic/285769-is-there-a-limit-to-what-a-form-can-write-to-a-database/ Share on other sites More sharing options...
sKunKbad Posted January 29, 2014 Share Posted January 29, 2014 You probably have an error before the insert. Is your error reporting showing anything? You should debug right before the insert to see if all your vars are the way you want them to be. I don't believe MySQL has a limit, but if it did 136 isn't that many. Quote Link to comment https://forums.phpfreaks.com/topic/285769-is-there-a-limit-to-what-a-form-can-write-to-a-database/#findComment-1466951 Share on other sites More sharing options...
Barand Posted January 29, 2014 Share Posted January 29, 2014 If your form method is GET you have a limit of around 2000 characters. If that is your problem change the method to POST Quote Link to comment https://forums.phpfreaks.com/topic/285769-is-there-a-limit-to-what-a-form-can-write-to-a-database/#findComment-1466952 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.