Date - Using If Statements

[peter_anderson]

Hi there,

 

I need to perform a check against the orders database to see if 30 days since the order has passed or not.

 

The date is stored as "11/Apr/2010" (j/M/Y), but I am unsure of how to do so.

 

Can anyone point me in the right place?

 

Thanks

[robert_gsfame]

U can use

 

mktime()

 

 

[Pikachu2000]

MySQL has some very good date and time comparison and arithmetic functions you can use right in the query string. Have a look at these.

 

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

[peter_anderson]

Thanks,

 

How do I get the results from the MySql date time function query?

 

Heres what I've got so far.

<?php
//some was stripped
	// date
	$today_date = date("Y-m-d");
	// query
	$q = "SELECT STR_TO_DATE(date, '%j/%M/%Y') FROM `orders` WHERE id='$orderid' AND customer='$email'";
	$rs = $sql->query($q);
	$r = $rs->fetch_assoc();
	$order_date = $r['date'];
	// compare dates
	function date_diff($date1, $date2){ 
		$current = $date1; 
		$datetime2 = date_create($date2); 
		$count = 0; 
		while(date_create($current) < $datetime2){ 
			$current = gmdate("Y-m-d", strtotime("+1 day", strtotime($current))); 
			$count++; 
		} 
		return $count; 
	} 
	echo(date_diff('2010-01-01', $order_date)." days <br \>"); 
	exit();
?>

 

How do I get the result of $q?

 

Thanks

[peter_anderson]

Just found it, that $order_date should be:

<?php
$order_date = $r['STR_TO_DATE(date, \'%j/%M/%Y\')'];
?>

[fred12ned]

If you changed the SQL to

SELECT STR_TO_DATE(date, '%j/%M/%Y') AS date_formatted FROM `orders` WHERE...

 

You could have nicer looking array keys

$r['date_formatted']

[peter_anderson]

Just noticed that the month is not working.

 

24/Mar/2010 is changing to 2010-01-24 using

SELECT STR_TO_DATE(date, '%j/%M/%Y')...

 

It's the same for all months. What could be the problem?

[fred12ned]

It is the line

$current = gmdate("Y-m-d", strtotime("+1 day", strtotime($current)));

 

change it to

$current = gmdate("d/m/Y", strtotime("+1 day", strtotime($current)));