PHP/MySQL form not posting data to database

Question

New to learning PHP form validation on same page. Please advise as to why my data might not be posting to the database. After filling out the form, it redirects to thank you page without sending data. Thanks!

http://pastebin.com/3T1W9Krx

Edit: Now that I know where my problem was, I have updated the Pastebin file to show the working code, which validates in the same page and checks the database for duplicate email addresses.

I was able to use Rick Kuipers suggestion below to find this error. I was trying to include a column for the primary key under VALUES, however I only needed the values for the INSERT keys, not ID or timestamp, as ID is set to auto-increment.

$sql = "INSERT INTO table (last_name, first_name, age) 

VALUES (". 
                        PrepSQL($last_name) . ", " .
                        PrepSQL($first_name) . ", " .
                        PrepSQL($age) . ")";

        mysql_query($sql);
        header("Location: volthankyou.php");
        exit();
    }
}

I've worked really hard on this and just need some advice. Thanks though. — Commandrea
– Commandrea, Commented Feb 28, 2012 at 19:56
You are welcome to ask for the advise, not just throwing the code to fix — Your Common Sense
– Your Common Sense, Commented Feb 28, 2012 at 19:58
before echoing 'Thank you', add var_dump($_POST) and send the result. After that, you should check why data is not being inserted. — Mohammad Naji
– Mohammad Naji, Commented Feb 28, 2012 at 20:01

Rick Kuipers · Accepted Answer · 2012-02-28 19:56:15Z

2

This could be because of a problem with your query.

Try doing the following:

echo mysql_error($db);
//header("Location: volthankyou.php");

This should display the error if there is any.

answered Feb 28, 2012 at 19:56

Rick Kuipers

6,5972 gold badges19 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Commandrea Over a year ago

AH! Got it- Column count doesn't equal...the problem is that the first column is the primary key, however I'm not sure how to set this under VALUES using the PrepSQL prefix and $value... trying a few things- thank you!

Rick Kuipers Over a year ago

If the first column "id" is set to auto_increment you can just leave it out, it will fill itself in.

Commandrea Over a year ago

Thank you Rick- you helped me find the solution.

Alfabravo · Accepted Answer · 2012-02-28 19:54:57Z

0

Check if mysql_query is true or false for your insert. Otherwise, it will ALWAYS try and then, redirect to thankyou. And as spencercw points out, mysql_select_db could also be failing. Always check the result of such methods.

P.S.: always check server logs

answered Feb 28, 2012 at 19:54

Alfabravo

7,5786 gold badges49 silver badges83 bronze badges

1 Comment

spencercw Over a year ago

mysql_select_db could also be failing.

Collectives™ on Stack Overflow

PHP/MySQL form not posting data to database

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related