php form -> mysql problem (please help!)

SilverX

No matter what I try I can't seem to get the data from my form into my db. This is a slightly simplified version of what I'm doing:

 
<?php 

print_r($HTTP_POST_VARS); 

$dbh = mysql_connect ("localhost", "ascendan_cat", "paws") or die ( 'I cannot connect to the database because: ' . mysql_error()); 

mysql_select_db ("ascendan_pets") or die (mysql_error()); 

$result = mysql_query ("INSERT INTO pets (Name, Fav food) values ('$petname','$ffood')", $dbh); 

?> 

<form method="post" action="<?php echo $PHP_SELF?>"> 
Pet Name: <input type="text" name="petname"><br> 
Favourite Food: <input type="text" name="ffood"><br> 
<input type="submit" name="submit" value="Enter information"> 
</form>

print_r($HTTP_POST_VARS); (when it's on) shows the data is THERE. It's just not getting into the db.

Please help? I've tried everything in the similar thread and in tutorials. I have plans for a neat script but I'm stuck on this basic thing.

Many thanks in advance.

acesabotage

I am having the exact same issue, and looking at your code, I believe you and I my be sharing the same webhost. Please email me at acesabotage@hotmail.com, maybe we could help each other.

dv6cougar

Originally posted by SilverX
No matter what I try I can't seem to get the data from my form into my db. This is a slightly simplified version of what I'm doing:
 
<?php 

print_r($HTTP_POST_VARS); 

$dbh = mysql_connect ("localhost", "ascendan_cat", "paws") or die ( 'I cannot connect to the database because: ' . mysql_error()); 

mysql_select_db ("ascendan_pets") or die (mysql_error()); 

$result = mysql_query ("INSERT INTO pets (Name, Fav food) values ('$petname','$ffood')", $dbh); 

?> 

<form method="post" action="<?php echo $PHP_SELF?>"> 
Pet Name: <input type="text" name="petname"><br> 
Favourite Food: <input type="text" name="ffood"><br> 
<input type="submit" name="submit" value="Enter information"> 
</form> 
print_r($HTTP_POST_VARS); (when it's on) shows the data is THERE. It's just not getting into the db.

Please help? I've tried everything in the similar thread and in tutorials. I have plans for a neat script but I'm stuck on this basic thing.

Many thanks in advance. [/B]

hmm well it should be <? echo $PHP_SELF ?>
with a space between the F and the ?> doubt that's your problem
......

/****** THIS IS HOW DO INSERT INTO********/
$query = "INSERT INTO pets (Name, 
                                               Fav food) "// here's your problem.... I think,you cannot have a space in a database field  

$query .= "VALUES('$petname',
                                '$ffood')"; 


mysql_query($query);

hope i could help 🙂 sort of a noob myself 🙂

cgraz

You may not be able to have a space in the field name (although I'm not positive). But using mysql_error() should let you know. Also printing the query string will tell you if the variables are being passed. I'd also suggest using $POST to access your variables. Try this:

$query = "INSERT INTO pets (Name, Fav food) values ('" . $_POST["petname"] . "','" . $_POST["ffood"] . "')"; 
print $query . "<br>";

$result = mysql_query($result) or die(mysql_error());

Cgraz

SilverX

Originally posted by cgraz
You may not be able to have a space in the field name (although I'm not positive). But using mysql_error() should let you know. Also printing the query string will tell you if the variables are being passed. I'd also suggest using $POST to access your variables. Try this:
$query = "INSERT INTO pets (Name, Fav food) values ('" . $_POST["petname"] . "','" . $_POST["ffood"] . "')"; 
print $query . "<br>";

$result = mysql_query($result) or die(mysql_error());
Cgraz [/B]

Thanks for your help... Okay this is interesting because I can see a bit more of what's happening, but it hasn't worked. (I changed the fields to test if the space was causing the problem, but no luck.) It now returns this:

Array ( ) INSERT INTO pets (Name, Weight) values ('','')
Query was empty

SilverX

Originally posted by dv6cougar
hope i could help 🙂 sort of a noob myself 🙂

Doesn't appear to be that... but thanks anyway. 🙂

SilverX

IT WORKS! 😃

I tinkered and this is what finally worked:

<?php

print_r($HTTP_POST_VARS)  . "<br>";

$dbh = mysql_connect ("localhost", "ascendan_cat", "paws") or die ( 'I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("ascendan_pets") or die (mysql_error());


$result = mysql_query ("INSERT INTO pets (Name, Weight) values ('" . $HTTP_POST_VARS[Name] . "','" . $HTTP_POST_VARS[Weight] . "')", $dbh);

?>

Thanks you guys, you gave me the clues and I couldn't have done it without you. (Okay, I have the Oscars in my head still.) 😉

SilverX

Oh, and one more thing in case anyone else has this problem; it did NOT like having a space in the db field name either (after all).

dv6cougar

Originally posted by SilverX
Oh, and one more thing in case anyone else has this problem; it did NOT like having a space in the db field name either (after all).

yeap, mine dont' either... i use _ instead 🙂

glad you got it working