All pastes #487849 Raw Edit

Miscellany

public php v1 · immutable
·published 2007-05-14 18:11 UTC
rendered paste body
	function available_times($requested_date) {			$datetime = date('Y-m-d',$requested_date);			//Parent Array            $requested_times = array();            $query = "SELECT date_time FROM kvmrequests WHERE status='1' OR status='2' AND date_time LIKE '".$datetime." %'";            $result = mysql_query($query) or die(mysql_error());                        while ($row = mysql_fetch_array($result)) {					$rowtime = strtotime($row['date_time']);                    $requested_times[] = $rowtime;            }		return $requested_times;	}            function get_times($requested_date)    {            //test date			//$requested_date = '1177884000';			$requested_times = available_times($requested_date);            			//Paremt Array            $standard_timeslots = array();			$timeslots = array();            $t = '0';            while ($t < '23') {                    if ($t % 2 == '0') {                            $standard_timeslots[] = mktime(0 + $t, 0, 0, date("m", $requested_date), date("d", $requested_date), date("y", $requested_date));					}                    $t++;            }			$timeslots = array_diff($standard_timeslots, $requested_times);            return $timeslots;    }