adding days to date

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Da_Elf
Forum Commoner
Posts: 81
Joined: Mon Dec 29, 2008 12:31 pm

adding days to date

Post by Da_Elf »

ive got a date stored in a database as 3 different field. YYYY, MM and DD

i did this just as a test hopeing to see it add 2,3,4 days onto the day stored in the database

Code: Select all

$querz = "SELECT * FROM event WHERE event_ID = '00000000000000000001' " ;
$resulz = mysql_query($querz, $dbConn) or die ( "Error in query: $query. " . mysql_error() );
$rolt=mysql_fetch_array($resulz);
$compedate = $rolt['event_dateey'].$rolt['event_dateem'].$rolt['event_dateed'];
$NewDate1=Date('Ymd', strtotime("+2 days",$compedate));
$NewDate2=Date('Ymd', strtotime("+3 days",$compedate));
$NewDate3=Date('Ymd', strtotime("+4 days",$compedate));
echo $compedate."<br>";
echo $NewDate1."<br>";
echo $NewDate2."<br>";
echo $NewDate3."<br>";
what i get echoed back
20100326 <---date compiled from whats in the database
19700823 <---no idea
19700824 <---more clueless
19700825 <----- utterly lost
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: adding days to date

Post by John Cartwright »

Try

Code: Select all

 
echo date("M-d-Y", mktime(0, 0, 0, $rolt['event_dateem'], $rolt['event_dateed'], $rolt['event_dateey']) + 172800);
echo date("M-d-Y", mktime(0, 0, 0, $rolt['event_dateem'], $rolt['event_dateed'], $rolt['event_dateey']) + 259200);
echo date("M-d-Y", mktime(0, 0, 0, $rolt['event_dateem'], $rolt['event_dateed'], $rolt['event_dateey']) + 345600);
 
User avatar
flying_circus
Forum Regular
Posts: 732
Joined: Wed Mar 05, 2008 10:23 pm
Location: Sunriver, OR

Re: adding days to date

Post by flying_circus »

Try something like this.

Code: Select all

$querz = "SELECT * FROM event WHERE event_ID = '00000000000000000001' " ;
$resulz = mysql_query($querz, $dbConn) or die ( "Error in query: $query. " . mysql_error() );
$rolt=mysql_fetch_array($resulz);
$compedate = mktime(0,0,0,(int) $rolt['event_dateem'],(int) $rolt['event_dateed'],(int) $rolt['event_dateey']);
$NewDate1=Date('Ymd', strtotime("+2 days",$compedate));
$NewDate2=Date('Ymd', strtotime("+3 days",$compedate));
$NewDate3=Date('Ymd', strtotime("+4 days",$compedate));
echo $compedate."<br>";
echo $NewDate1."<br>";
echo $NewDate2."<br>";
echo $NewDate3."<br>";
Edit: You're on it tonight, John :mrgreen:
Post Reply