Time / Date

NZ_Kiwis

hey...

i'm kind of new to PHP.... what i'm wanting to do it have a user enter a date from three drop down menus..
like this http://www.rugbyleaguenz.com/test.php

what i want to do is store this date in a my mysql database which will allow me to get a time stamp and then my code can see both of these in time stamp format.....

kburger

I think I'd store it in a MySQL date field, where the format is YYYY-MM-DD.

You'd need to modify your form to look something like:

<form method="POST" action="">
	<p><select size="1" name="D1">
	<option value="01">1</option>
	<option value="02">2</option>
	<option value="03">3</option>
	</select>
        <select size="1" name="D2">
	<option value="01">Jan</option>
	<option value="02">Feb</option>
	</select>
        <select size="1" name="D3">
	<option value="2005">2005</option>
	<option value="2006">2006</option>
	</select></p>
</form>

then concatenate the values with something like:

$date = "$D3-$D2-$D1";

NZ_Kiwis

Cool... it works well....
Is there a way I can display the date such 16 April??

bradgrafelman

Use [man]strtotime/man to get a Unix timestamp of the date, then [man]date/man to format the date properly.

Like so:

$date = '2005-04-16'; // $date is your YYYY-MM-DD variable
$newdate = date('d F', strtotime($date));
echo $newdate; // 16 April

NOTE: The 'd' flag in date() is a 2 digit formatted number for the day (prepends a 0 to single-digit days). The 'j' flag will get you the day of the month without prepending a 0. Change the date format to suit your needs! (Full explanation of the flags found in the manual entry for date(), linked above)

NZ_Kiwis

Wow works well!! thanks very much...

Now.... I want a edit funtion??? is there a way of splitting this up??? to have three values or something???

that way I can do a

if $d1 == 1 ( echo "selected" }

bradgrafelman

Once you've queried the MySQL DB, and got the current values of D1, D2, D3 loaded into variables, try this:

Well first of all, if you want to dynamically create the page, you can do this:

<form method="POST" action="">
	<p><select size="1" name="D1">
<?PHP
for($i = 01; $i <= 31; $i = sprintf('%02s', $i+1)) echo '	<option value="'.$i.'">'.intval($i)."</option>\n";
?>
	</select>
        <select size="1" name="D2">
<?PHP
for($i = 01; $i <= 12; $i = sprintf('%02s', $i+1)) echo '	<option value="'.$i.'">'.date('M', mktime(0, 0, 0, $i))."</option>\n";
?>
	</select>
        <select size="1" name="D3">
<?PHP
for($i = date("Y"); $i < date("Y")+2; $i++) echo '	<option value="'.$i.'">'.$i."</option>\n";
?>
	</select></p>
</form>

To edit a date, retrieve the 3 values from MySQL and store them in $d1, $d2, and $d3. Then, you can do something like:

<form method="POST" action="">
	<p><select size="1" name="D1">
<?PHP
for($i = 01; $i <= 31; $i = sprintf('%02s', $i+1)) echo '	<option value="'.$i.'"'.(($i == $d1) ? ' selected' : '').'>'.intval($i)."</option>\n";
?>
	</select>
        <select size="1" name="D2">
<?PHP
for($i = 01; $i <= 12; $i = sprintf('%02s', $i+1)) echo '	<option value="'.$i.'"'.(($i == $d2) ? ' selected' : '').'>'.date('M', mktime(0, 0, 0, $i))."</option>\n";
?>
	</select>
        <select size="1" name="D3">
<?PHP
for($i = date("Y"); $i < date("Y")+2; $i++) echo '	<option value="'.$i.'"'.(($i == $d3) ? ' selected' : '').'>'.$i."</option>\n";
?>
	</select></p>
</form>

NOTE: You should make sure dates that people submit when adding/editing are valid. Do so by adding code like this:

if(checkdate($d2, $d1, $d3) === FALSE) {
    echo 'Invalid date!';
    // what to do if date is invalid (reprint form, etc)
    exit;
}

NZ_Kiwis

Originally posted by bradgrafelman
Once you've queried the MySQL DB, and got the current values of D1, D2, D3 loaded into variables, try this:

Well first of all, if you want to dynamically create the page, you can do this:

<form method="POST" action="">
	<p><select size="1" name="D1">
<?PHP
for($i = 01; $i <= 31; $i = sprintf('%02s', $i+1)) echo '	<option value="'.$i.'">'.intval($i)."</option>\n";
?>
	</select>
        <select size="1" name="D2">
<?PHP
for($i = 01; $i <= 12; $i = sprintf('%02s', $i+1)) echo '	<option value="'.$i.'">'.date('M', mktime(0, 0, 0, $i))."</option>\n";
?>
	</select>
        <select size="1" name="D3">
<?PHP
for($i = date("Y"); $i < date("Y")+2; $i++) echo '	<option value="'.$i.'">'.$i."</option>\n";
?>
	</select></p>
</form>

To edit a date, retrieve the 3 values from MySQL and store them in $d1, $d2, and $d3. Then, you can do something like:

<form method="POST" action="">
	<p><select size="1" name="D1">
<?PHP
for($i = 01; $i <= 31; $i = sprintf('%02s', $i+1)) echo '	<option value="'.$i.'"'.(($i == $d1) ? ' selected' : '').'>'.intval($i)."</option>\n";
?>
	</select>
        <select size="1" name="D2">
<?PHP
for($i = 01; $i <= 12; $i = sprintf('%02s', $i+1)) echo '	<option value="'.$i.'"'.(($i == $d2) ? ' selected' : '').'>'.date('M', mktime(0, 0, 0, $i))."</option>\n";
?>
	</select>
        <select size="1" name="D3">
<?PHP
for($i = date("Y"); $i < date("Y")+2; $i++) echo '	<option value="'.$i.'"'.(($i == $d3) ? ' selected' : '').'>'.$i."</option>\n";
?>
	</select></p>
</form>

NOTE: You should make sure dates that people submit when adding/editing are valid. Do so by adding code like this:

if(checkdate($d2, $d1, $d3) === FALSE) {
    echo 'Invalid date!';
    // what to do if date is invalid (reprint form, etc)
    exit;
}

[/B]

But if the date is in 0000-00-00 format how do i get back D1 D2 and D3???

bradgrafelman

list($d3, $d2, $d1) =  explode('-', $YYYY_MM_DD_date);

NZ_Kiwis

Originally posted by bradgrafelman
list($d3, $d2, $d1) =  explode('-', $YYYY_MM_DD_date);
[/B]

call me dumb but it will be

$date = $row[date];

So I have I get it to work??

NZ_Kiwis

also this only displays one record not two

$date = $row2[group_date_new]; 
$newdate = date('d F', strtotime($date)); 

$date2 = $row2[group_date_end_new]; 
$newdate2 = date('d F', strtotime($date)); 


if ($newdate = $newdate2) {
echo $newdate;
} else {
echo "$newdate - $newdate2";
}

any ideas why... the two dates are different

kburger

To answer your previously posted question...

$date = $row[date];
list($d3, $d2, $d1) =  explode('-', $date);

And your second question -- this has a few problems

$date = $row2[group_date_new]; 
$newdate = date('d F', strtotime($date)); // <-- this is the same as

$date2 = $row2[group_date_end_new]; 
$newdate2 = date('d F', strtotime($date)); // <-- this.  That's why $newdate is equal to $newdate2 

// I think you meant...
$newdate2 = date('d F', strtotime($date2));


// secondly, you're using the assignment operator in 
// the line below.  You should be using == for comparison
if ($newdate = $newdate2) {
echo $newdate;
} else {
echo "$newdate - $newdate2";
}

NZ_Kiwis

Thanks everyone so so so much... all is working well to "date"

Okay last part of my code.. I want to get the date for today... then see if the $newdate is before or after "today's" date.... how would to match the two??

bradgrafelman

Know what a Unix timestamp is? It's the number of seconds since the Unix Epoch. Comparing two lengths of time in seconds is easy. Use [man]strtotime/man to convert the two dates into a Unix timestamp, then use a simple greater/less than comparison between the two.

This solution seems simple enough that I don't need to provide an example code; see if you can work it out on your own.

Drakla

Controversially I'd say never use mysql's built in datetime format unless you need to store dates outside of the unix timestamp range. Use ints and timestamps as time comparison queries are faster on ints - I've benched it on a few systems, to I'm not just pumping words. You can use FROM_UNIXTIME in your select just as easily using date() after you've extracted it, and it takes us less space. When doing inserts use UNIX_TIMESTAMP() instead of NOW().

Weedpacket

Originally posted by Drakla
Controversially I'd say never use mysql's built in datetime format unless you need to store dates outside of the unix timestamp range. Use ints and timestamps....

For basic "before or after" comparisons, I'd agree - but when you've got to do queries involving things like "last week" or "four days" or "three months" or "same bat time, same bat channel", then things get hairier.

Drakla

Originally posted by Weedpacket
For basic "before or after" comparisons, I'd agree - but when you've got to do queries involving things like "last week" or "four days" or "three months" or "same bat time, same bat channel", then things get hairier.

Yup. I found finding things three months ago - but not at the time now, but at the start of the day can be done with '-3 months 0:00' and strtotime, even 'yesterday 0:00' works nicely.

NZ_Kiwis

i'll be doing last three days stuff so the way i have it is better?

kburger

IMHO -- yes.