All pastes #487850 Raw Edit

Something

public php v1 · immutable
·published 2007-05-14 18:12 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;    }