Advertisement
Transformator

php014

Oct 17th, 2014
333
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.64 KB | None | 0 0
  1. <?php
  2.  
  3. mysql_connect(deleted);
  4. mysql_select_db("DB1367141")
  5.  
  6. $day = date("d");
  7. $month = date("m");
  8. $year = date("Y");
  9.  
  10. $result = mysql_query("SELECT * FROM entries WHERE day = '$day' AND month = '$month' AND year = '$year' ORDER BY hour DESC, minute");
  11.  
  12. $array = {};
  13.  
  14. while($obj = mysql_fetch_object($result))
  15. {
  16.     if($obj->hour != "--")
  17.         $hour = splitf("%02d", $obj->hour);
  18.     else
  19.         $hour = $obj->hour;
  20.    
  21.     if($obj->minute != "--")
  22.         $minute = splitf("%02d", $obj->minute)
  23.     else
  24.         $minute = $obj->minute;
  25.  
  26.     array_push($array, {"hour":$hour, "minute":$minute, "text":$obj->tex});
  27. }
  28.  
  29. var_dump($array);
  30. echo json_encode($array);
  31.  
  32. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement