INSERT script really won't INSERT!

Deaner3D

hello, I am really trying to create a database for an online journal and I don't know wtf is wrong with my insert script, cause it's inserting no data into the database. The id(AUTO-INCREMENT PRIMARY KEY) works fine but the rest of the data won't insert. here's my code bastardized from various books/online guides.

mysql_connect($host,$username,$password) or die("Unable connect to $host");
@mysql_select_db($database) or die( "Unable to select database");


$insert="INSERT INTO journal VALUES (NULL,'$year','$day','$day_of_week','$month','$mood','$entry')";
mysql_query($insert);
mysql_close();

See anything wrong?
-Dean

Deaner3D

this is what the table looks like, notice the lower rows...empty except for those zeroes, which are the default values.

http://www.deancripps.com/journal_list.php

here, even try adding a "journal" entry yourself...it doesn't work and I don't know what the problem is...
http://www.deancripps.com/journal_insert.html
has anyone ever had this happen? If so, what are some common troubleshooting steps that fixed it?

-Dean

Deaner3D

I think that my host (godaddy.com) has some problems with the PHP and carrying over variables from a form to the PHP scripted page. I tried some simple forms, even making the form and parsing on the same page...no luck. There isn't something I'm blatantly doing wrong here, is there?
-Dean

joelvb

Hi deaner,

i think your host (Goda**) PHP setting on register_globals is off. If it is off, then you're PHP script dont have automatic access to form variables. You need to get them by using this:

$year = $HTTP_POST_VARS["year"];

this assigns the value of the "year" form variable to your local $year variable.

Hope this helps 🙂

helz

right, use $POST['field_name'] to get info from the db, or alternativly use extract($POST) works similar to the register_globals

mysql_connect($host,$username,$password) or die("Unable connect to $host"); 
@mysql_select_db($database) or die( "Unable to select database"); 
extract($_POST);// this converts the field names of the form into a variable of the same name with the value of the form info

$insert="INSERT INTO journal (year, day, day_of_week, month, mood, entry) VALUES ('$year','$day','$day_of_week','$month','$moo
d','$entry')"; 
mysql_query($insert); 
if (!$insert) {
  die("Info could not be inserted into the db");
} else {
  echo "Woohoo journal updated!";
}
mysql_close();

Deaner3D

you guys/gals are amazing. Both of those suggestiongs worked! Thank you soooooo much. There is no emoticon for my thanks...
/me huggles helz and joelbv!
-Dean

superwormy

To clarify further...

$GET is used to access variables provided in the URL
$COOKIE through cookies
$POST for POSTed data
$SERVER for various server variables
$_SESSION for session data

The $HTTP*VARS arrays are deprecated and shouldn't be used anymore. Use the super-global $POST, $GET, $COOKIE, $SERVER, $_SESSION arrays insated.

ANd make sure you read the PHP manual section ( www.php.net/ ) on Predefined Variables.