So I have a website that will upload a volunteer html form to our php database, I have most of the PHP working but a few main parts.
Part1: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in /home/petrzilk/public_html/Database/update.php on line 192 I know this means that I have too many tokens because some of the inputs are empty, how do I fix something like this. Solved
Part2: I have sanitized inputs but my arrays of check boxes would no work unless I user $_POST, is that still secure? Everything else is Sanitized and my dates are read in the format YYYY-MM-DD so from my understanding if I sanitize ints it will only keep numbers and addition and subtraction symbols so it should work.
And lastly I just want to make sure that everything I am doing is secure and correct. I am a beginner at this but I want to avoid every volubility I can.
PHP CODE: http://pastebin.com/W3Pvc6xw <--- Not up to date but nothing changed on input
HTML CODE: http://pastebin.com/EMjnibtD
Part1: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in /home/petrzilk/public_html/Database/update.php on line 192 I know this means that I have too many tokens because some of the inputs are empty, how do I fix something like this. Solved
Part2: I have sanitized inputs but my arrays of check boxes would no work unless I user $_POST, is that still secure? Everything else is Sanitized and my dates are read in the format YYYY-MM-DD so from my understanding if I sanitize ints it will only keep numbers and addition and subtraction symbols so it should work.
And lastly I just want to make sure that everything I am doing is secure and correct. I am a beginner at this but I want to avoid every volubility I can.
PHP CODE: http://pastebin.com/W3Pvc6xw <--- Not up to date but nothing changed on input
HTML CODE: http://pastebin.com/EMjnibtD
Last edited: