Adding to data base

Discussion in 'Scripts, 3rd Party Apps, and Programming' started by andylpsx, Jul 28, 2014.

  1. andylpsx

    andylpsx New Member

    Messages:
    29
    Likes Received:
    1
    Trophy Points:
    3
    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
     
    Last edited: Jul 29, 2014

Share This Page