dates

[anthony-needs-you]

hi i have a date picker, here is my form field:

 

<input name="departureDate" type="text" class="fields" id="departureDateField" value="dd/mm/yy" onfocus="this.select();lcs(this)" onclick="event.cancelBubble=true;this.select();lcs(this)">

 

I pass this to:

 

<?php

 

if(isset($_POST['save']))

{

$departureDate  = $_POST['departureDate'];

$expireDate = $_POST['expireDate'];

$airport  = $_POST['airport'];

$resort = $_POST['resort'];

$hotel  = $_POST['hotel'];

$duration = $_POST['duration'];

$board  = $_POST['board'];

$price = $_POST['price'];

$specialoffer  = $_POST['specialoffer'];

$description = $_POST['description'];

$customerRef  = $_POST['customerRef'];

$mystiqueRef = $_POST['mystiqueRef'];

$stars  = $_POST['stars'];

 

 

 

if(!get_magic_quotes_gpc())

{

$departureDate  = addslashes($departureDate);

$expireDate = addslashes($expireDate);

$airport  = addslashes($airport);

        $resort  = addslashes($resort);

$hotel  = addslashes($hotel);

$duration = addslashes($duration);

$board  = addslashes($board);

        $price  = addslashes($price);

$specialoffer  = addslashes($specialoffer);

$description  = addslashes($description);

$customerRef = addslashes($customerRef);

$mystiqueRef  = addslashes($mystiqueRef);

        $stars  = addslashes($stars);

}

include 'library/config.php';

include 'library/opendb.php';                 

 

 

$query = "INSERT INTO test (departureDate, expireDate, airport, destination, resort, hotel, duration, board, price, specialoffer, description, customerRef, mystiqueRef, stars) VALUES ('$departureDate', '$expireDate', '$airport', '$destination', '$resort', '$hotel', '$duration', '$board', '$price', '$specialoffer', '$description', '$customerRef', '$mystiqueRef', '$stars')";

mysql_query($query) or die('Error, query failed : ' . mysql_error());

include 'library/closedb.php';

 

echo "<div class=\"alert\">Holiday '$mystiqueRef' added</div>";

}

?>

 

 

my sql is:

 

`departureDate` DATE NULL,

 

but all i get is:

 

0000-00-00

 

whatever date i put in

 

can someone please tell me what i've done  wrong, thanks

[Mark Baker]

What datatype are you using for the dates in your test table?

[anthony-needs-you]

i've got it set as date

[Maq]

Can you echo out the query to ensure they contain correct values:

 

$query = "INSERT INTO test (departureDate, expireDate, airport, destination, resort, hotel, duration, board, price, specialoffer, description, customerRef, mystiqueRef, stars) VALUES ('$departureDate', '$expireDate', '$airport', '$destination', '$resort', '$hotel', '$duration', '$board', '$price', '$specialoffer', '$description', '$customerRef', '$mystiqueRef', '$stars')";
echo $query;

[twm]

looks like you are asking users to enter the date in dd/mm/yy format, then you are trying to insert it into the DB in the same format.

 

in you database the date field is in yyyy-mm-dd  format.

 

maybe you should format the date to mysql format before trying to insert it

 

 

[anthony-needs-you]

i've echo the date and it shows as 17/12/2008

 

How do i change this to a mysql format would i change the value in the form?

 

<input name="departureDate" type="text" class="fields" id="departureDateField" value="yy/dd/mm" onfocus="this.select();lcs(this)" onclick="event.cancelBubble=true;this.select();lcs(this)">

[anthony-needs-you]

would this work

 

function format_date_mysql($departureDate){

 

  $output = '';

 

  $temp = explode("-",$departureDate);

 

  if($departureDate) {

 

        $output  = $temp[2]."-".$temp[0]."-".$temp[1];

 

  }

 

return $output;

 

}

[twm]

this could work:

 

<?PHP

$date = explode("/",$departureDate);

// re-assign to var in mysql format
$departureDate = sprintf("%04d-%02d-%02d", $date[2], $date[1], $date[0]);

?>

[jeff5656]

Here's how I handle the date.

 

$newdate = date("Y-m-d", strtotime($_POST['departureDate']));

 

Then I add $newdate into the database:

"INSERT INTO test (departureDate, expireDate, ....) VALUES ('$newdate', '$expireDate', '$airport', '$destination', '$resort', '$hotel', '$duration', '$board', '$price', '$specialoffer', '$description', '$customerRef', '$mystiqueRef', '$stars')";
   

 

[anthony-needs-you]

cool cheers guys thanks for all your help, its really appreciated

[Maq]

There are multiple ways of handling dates but logically one would use the date function to handle them.  It's the safest/easiest way to handle them.

[anthony-needs-you]

ok this is what i've got:

 

if(isset($_POST['save']))
{

$departureDate = date("Y-m-d", strtotime($_POST['departureDate']));
$expireDate = date("Y-m-d", strtotime($_POST['expireDate']));
$airport  = $_POST['airport'];
$resort = $_POST['resort'];
$hotel  = $_POST['hotel'];
$duration = $_POST['duration'];
$board  = $_POST['board'];
$price = $_POST['price'];
$specialoffer  = $_POST['specialoffer'];
$description = $_POST['description'];
$customerRef  = $_POST['customerRef'];
$mystiqueRef = $_POST['mystiqueRef'];
$stars  = $_POST['stars'];



if(!get_magic_quotes_gpc())
{
	$airport   = addslashes($airport);
        $resort  = addslashes($resort);
	$hotel   = addslashes($hotel);
	$duration = addslashes($duration);
	$board   = addslashes($board);
        $price  = addslashes($price);
	$specialoffer  = addslashes($specialoffer);
	$description   = addslashes($description);
	$customerRef = addslashes($customerRef);
	$mystiqueRef   = addslashes($mystiqueRef);
        $stars  = addslashes($stars);
}
include 'library/config.php';
include 'library/opendb.php';                   


$query = "INSERT INTO test (departureDate, expireDate, airport, destination, resort, hotel, duration, board, price, specialoffer, description, customerRef, mystiqueRef, stars) VALUES ('$departureDate', '$expireDate', '$airport', '$destination', '$resort', '$hotel', '$duration', '$board', '$price', '$specialoffer', '$description', '$customerRef', '$mystiqueRef', '$stars')";
echo $query;
mysql_query($query) or die('Error, query failed : ' . mysql_error()); 
include 'library/closedb.php';

echo "<div class=\"alert\">Holiday '$mystiqueRef' added</div>";
}   

 

--------------------------------------------------------------------------------------

 

and this is my form field:

 

<input name="departureDate" type="text" class="fields" id="departureDateField" value="dd/mm/yy" onfocus="this.select();lcs(this)" onclick="event.cancelBubble=true;this.select();lcs(this)">

 

For some reason it return the wrong date selected, has anyone have a clue whats wrong?

[anthony-needs-you]

and also this, it got chopped from the above:

 

$query = "INSERT INTO test (departureDate, expireDate, airport, destination, resort, hotel, duration, board, price, specialoffer, description, customerRef, mystiqueRef, stars) VALUES ('$departureDate', '$expireDate', '$airport', '$destination', '$resort', '$hotel', '$duration', '$board', '$price', '$specialoffer', '$description', '$customerRef', '$mystiqueRef', '$stars')";

echo $query;

mysql_query($query) or die('Error, query failed : ' . mysql_error());

include 'library/closedb.php';

 

echo "<div class=\"alert\">Holiday '$mystiqueRef' added</div>";

}

[anthony-needs-you]

Ignore that last comment, late one.

 

I'm getting a lot of 2009-01-12?

 

When picking 2008-12-25

[twm]

the way you are using strtotime it works fine if your date is in a format mm/dd/yyyy