Check if there is a matching date in database

Rasmus

As the title says. I have a table wich stores some information with a date and a time per post.

This table is fetched in an array and besides the fetch, I have an array with 12 banks with values that i loops thru with a foor loop. I need to check every post with criteria date (there is a $cDate which stores the choosed date).

The array stores:
1 = 00:00
2 = 02:00
3 = 04:00
4 = 06:00
5 = 08:00
6 = 10:00
7 = 12:00
8 = 14:00
9 = 16:00
10 = 18:00
11 = 20:00
12 = 22:00

So, for every row from the table, it needs to check with the array like:
if($row['time'] != /ANY OF THE TIMESTAMPS IN THE ARRAY/)
{
echo("<option>" . $time['$i'] . "</option>");
}

I hope someone understands what I'm out for.
/Rasmus

halojoy

Maybe you can use [man]in_array[/man]

Depends on the format in $row['time']
But if it is same as in your array, '08:00'
then this should work

// if $row['time'] not in array $test_array
if( !in_array( $row['time'], $test_array )

Rasmus

I tried that. But I cant get it to work out well.

This is what i want:
First, I want to get all occupied timestamps for the date that is stored in $cDate, for an example we say that $cDate = 2010-02-11.

I fetch's the table where column date = $cDate and i get 3 matching rows, which is:
2010-02-11 12:00
2010-02-11 16:00
2010-02-11 22:00

Then I have these possible time stamps everyday:
00:00, 02:00, 04:00, 06:00, 08:00, 10:00, 12:00, 14:00, 16:00, 18:00, 20:00, 22:00

But, 3 of 12 time stamps is occupied, and I just want to print the time stamps that is not occupied which is:
00:00, 02:00, 04:00, 06:00, 08:00, 10:00, 14:00, 18:00, 20:00

Any idea?

halojoy

Well, this is more complex.
But not too difficult.

to get only the TIME part of a timestamp '2010-02-11 12:00'
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_time

SELECT TIME('cDate') AS time FROM .......
would probably return result $row['time'] = '12:00'

Then this value should be removed from your full array with times.
3 values would leave 9 times
It is a bit more programming and I am in a hurry.
I am sure someone will guide you further.
🙂

johanafm

Loop over the sql result and create an array of used times then take the diff of all times and those in use.

$used = array();
while($r = fetch_row...) [
	$used[] = $r['time'];
}
$all_times = array('00:00', '02:00', ...);

$unused = array_diff($all_times, $used);