combining variables and inserting into mySQL

[riley6902]

Having some difficulty combining values into one variable from an HTML form. I have three fields for a date the user selects on the form, that are inserted in mySQL as one variable $Date. Here's what I have:

$DateInjured = $InjuredMonth.$InjuredDay.$InjuredYear;

/* Insert  values from page */
$query = "INSERT INTO detail (CityInjured, StateInjured, $DateInjured)
				VALUES('$CityInjured', '$StateInjured', '$DateInjured')";

Any help would be appreciated!

[jmarco]

dates in MySQL should take on the YYYY-MM-DD structure by default.

//if you need to format the variables first then do

$yearinjured = date("Y", strtotime("$yearinjured"));
$monthinjured = date("m", strtotime("$monthinjured"));
$dayinjured = date("d", strtotime("$dayinjured"));

$dateinjured = $yearinjured."-".$monthinjured."-".$dayinjured;

//or as a string:

$dateinjured = "$yearinjured-$monthinjured-$dayinjured";

//or

$dateinjured = date("Y-m-d", strtotime("$yearinjured-$monthinjured-$dayinjured"));

I think both ways should work, I use the 2nd way out of habit.

Then you can use the date() function in php to get the YYYY-MM-DD structure into any format you wish.

date("F jS Y", strototime("$dateinjured"));

Would output:

May 1st, 2003

There are a few ways to do this, I suggest finding a prefered way and sticking to it.

[run_GMoney]

You might wanna take out that "$" in the INSERT line. Unless the field name is $DateInjured. I'm thinking like this:

$query = "INSERT INTO detail (CityInjured, StateInjured, DateInjured)
                    VALUES('$CityInjured', '$StateInjured', '$DateInjured')";

[riley6902]

Sorry to post the whole file but maybe that's the root of the problem. Thanks for the input.

<?php
while (list($name, $value) = each($HTTP_POST_VARS)) {
  echo "$name = $value<br>\n";
}

"$InjuredYear-$InjuredMonth-$InjuredDay" = $DateInjured;


/* Connecting, selecting DB */
$link = mysql_connect("localhost", "user", "pwd") or die("Could not connect: " . mysql_error());
print "Connected successfully<br>";
mysql_select_db("esa_db")or die("Could not select database: " . mysql_error());

/* Insert  values from page */
$query = "INSERT INTO contact (LastName, FirstName, StreetAddress, City, State, Zip, Phone, WorkPhone, Email, InjuredRelation, InjuredName, InjuredAge, Attorney, AccidentDESC, FoundSite, Questions)
				VALUES('$LastName', '$FirstName', '$StreetAddress', '$City', '$State', '$Zip', '$Phone', '$WorkPhone', '$Email', '$InjuredRelation', '$InjuredName', '$InjuredAge', '$Attorney', '$AccidentDESC', '$FoundSite', '$Questions')";

/* Insert  values from page */
$query = "INSERT INTO detail (CityInjured, StateInjured, DateInjured)
				VALUES('$CityInjured', '$StateInjured', '$DateInjured')";


/* Closing connection */
mysql_close($link);

?>

[jmarco]

A few things I would do:

// #1:

$DateInjured = "$InjuredYear-$InjuredMonth-$InjuredDay";

// switch that around, I'm not sure if it makes a difference, but it might, maybe someone knows exactly

And

// #2

// add $link to mysql_select_db() as the second parameter

mysql_select_db("esa_db", $link)or die("Could not select database: " . mysql_error());

After each $query = "INSERT..." statement you need to call mysql_query()

// #3

// for insertions, simply:

mysql_query($query) or die("Query Failed ".mysql_error());