help with dates

[dadamssg]

im trying to do is find out if the event im querying is happening today. i had this

 $now = time()
	 if(strtotime($row['start']) > $now and strtotime($row['end'] < $now))
	 {
	 echo "Its today!!!!!";
	 }

but its wrong, not only because of the syntax but that deals with time...the event can start a month ago if it ends today or later..or it can start today and end today or end in a month....i just want to find out if any part of it is happening the current date...thanks

 

[Ken2k7]

if(strtotime($row['start']) > $now and strtotime($row['end'] < $now))

 

Should be:

if(strtotime($row['start']) > $now and strtotime($row['end']) < $now)

 

Right?

[thebadbad]

Ken fixed the syntax error, but your logic should be the other way around. Currently you say; if the start happens after now and the end happens before now, do this. It should be:

 

if(strtotime($row['start']) < $now and strtotime($row['end']) > $now)

"It has started and hasn't ended".

[Ken2k7]

That's more like it had started and has not ended.

 

if(strtotime($row['start']) <= $now and strtotime($row['end']) > $now)

 

Much more like it.

[thebadbad]

Sure, but I'm assuming $row['start'] and $row['end'] are datetime values (YYYY-MM-DD HH:MM:SS), so I figured that one second wouldn't matter much

[Ken2k7]

They better not be. $now = time(), so $row['start'] and $row['end'] should be in seconds.

 

Which reminds me. Syntax error on that line $now = time(). You need a semi-colon after it.

[thebadbad]

They better not be. $now = time(), so $row['start'] and $row['end'] should be in seconds.

 

No, they are run through strtotime() that expects the datetime format, and returns a timestamp. But I'm sure you just overlooked that.

 

Edit: In either case, while your comparison operator <= is logically correct, it will still only make a difference if the script is run at the same second the event is set to start

[dadamssg]

hey guys, thanks for the advice...but i don't think thats gonna gonna do what i want it to do...cause say its 3:20pm right now, but if i have an event that starts at 4:00pm today and ends at 5:30pm today it won't work....thanks for lookin at it again

$now = time();
	 if(strtotime($row['start']) <= $now and strtotime($row['end']) > $now)
	 {
	 echo "Its today!!!!!";
	 }

 

 

[Ken2k7]

Why not use MySQL? (Not tested.)

 

SELECT * FROM tablename
WHERE DATE_FORMAT(start, '%Y-%m-%d') <= CURDATE()
     AND DATE_FORMAT(end, '%Y-%m-%d') >= CURDATE()

[dadamssg]

cause im pulling up and displaying all the events...so i want to put a symbol or something next to the events that are occurring today

[roopurt18]

You can still use SQL:

select *, now() between start_tm and end_tm as `is_today`
from `thetable` where ...

 

Then your $row variable should have an index is_today:

if( $row['is_today'] ) {
  echo 'it happens today';
}

[dadamssg]

could you explain that? i don't understand the start_tm and end_tm part and how would output the variables?

[Ken2k7]

I believe roopurt18 just used tm to represent time. So start_tm = start_time or whatever the start column name is. It was just an example. Similar situation for end_tm.