No errors, but DATA doesn't appear in database!?

Timsoft

This is a pretty simple script for a basic survey to collect data on political issues.

I was able to get rid of all the errors, but when I test it and look in the table, there is no data?

Here is the code, any help would be appreciated....

$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
if (!$dbh)
{
die('Could not connect: ' . mysql_error());
}

else echo ("Looks good!");

mysql_select_db("Tpowell03", $dbh);;

$religionlevel = $POST["radiogroup1"];
$left_right = $POST["radiogroup2"];
$abortion = $POST["radiogroup3"];
$vote = $POST["radiogroup4"];
$rich = $POST["radiogroup5"];
$salary = $POST["radiogroup6"];
$mother = $POST["radiogroup7"];
$father = $POST["radiogroup8"];
$email = $_POST["Email"];

mysql_query ("INSERT INTO survey (Religionlevel,left_right,abortion,vote,rich,salary,mother,father,email)
VALUES('$religionlevel','$left_right','$abortion','$vote','$rich','$salary','$mother','$father','$email')");

laserlight

Are you sure that data is being sent from the form via the post method?

Sxooter

Ok, a few very quick points.

mysql_select_db("Tpowell03", $dbh);;

you got two ;s there.

Use the [ php ] (minus the spaces) tags to enclose your code. makes it more readable.

Take a look at the php manual on mysql functions, and you'll see lots of examples of checking the error return code of a mysql_query call. Do that.

Sxooter

Oh, and another thing, you should really be escaping all user input data with mysql_real_escape_string (or whatever the function is called in mysql)

Timsoft

I verified that it is using "POST" in the form...

I know the code isn't easy to read, but that shouldn't have anything to do with the functionality, right?

I removed the double semi-colon, yet still no posting of data to the database.

Any other ideas?

NogDog

To expand upon one of Sxooter's comments, try using this sort of pattern to help you trap any SQL errors:

$query = "INSERT INTO survey (Religionlevel,left_right,abortion,vote,rich,salary,mother,father,email)
VALUES('$religionlevel','$left_right','$abortion','$vote','$rich','$salary','$mother','$father','$email')"
$result = mysql_query($query);
if(!$result)
{
   user_error(mysql_error() . "<br />\n$query");
}

Depending on your display_errors setting, you may need to check the error log for any error output (or turn on display_errors via ini_set()).

Timsoft

Thanks for that snippet. I plugged it in to see if I could get some errors, but when I ran it I got a parse error listed below. I double checked it against a page on php.net and the syntax appears to be correct?!

Parse error: parse error, unexpected T_VARIABLE in /home/content/t/i/m/timothy1982/html/insert.php on line 33

Line 33 is as follows:

$result = mysql_query($query);

NogDog

Missing ";" at the end of the preceding line.

Timsoft

Damn, I can usually find the simple ones! Something interesting happened when I fixed that.

It gave me this: "Parse error: parse error, unexpected $ in /home/content/t/i/m/timothy1982/html/insert.php on line 42"

The weird thing is, the code ends on line 41, line 42 is completely blank....?? I punched in a couple queries into google, but didn't get anything that matched...

Looks like I'm almost there! Thank you all so much for your help.

NogDog

Make sure all opening braces have corresponding closing braces, and the same for quotes and parentheses. If it's not obvious, you can post the code here within [noparse]

...

[/noparse] bbcode tags for us to take a look at.

Timsoft

You were right on, missing brace...

Well, I learned a lot today. Thanks for your help, again!

NogDog

Great. Don't forget to mark this thread resolved, if it is ("Thread Tools" link at the top of the thread).