[ create a new paste ] login | about

Link: http://codepad.org/xoos3r6A    [ raw code | output | fork ]

PHP, pasted on Dec 27:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<?php

$timestamp = mktime();
$today = date('l', $timestamp);
$yesterday = date('l', strtotime('-1 day'));
$time = date('g:i:s', $timestamp);

echo "
SELECT COUNT(*)
FROM Shifts
WHERE (start_day = LOWER('$today')
       AND start_time < '$time'
       AND end_time > '$time')
   OR (start_day = LOWER('$yesterday')
       AND start_time < ADDTIME('24:00:00', '$time')
       AND end_time > ADDTIME('24:00:00', '$time'))
";

?>


Output:
1
2
3
4
5
6
7
8
9

SELECT COUNT(*)
FROM Shifts
WHERE (start_day = LOWER('Thursday')
       AND start_time < '12:01:37'
       AND end_time > '12:01:37')
   OR (start_day = LOWER('Wednesday')
       AND start_time < ADDTIME('24:00:00', '12:01:37')
       AND end_time > ADDTIME('24:00:00', '12:01:37'))


Create a new paste based on this one


Comments: