Advertisement
Guest User

Untitled

a guest
Dec 7th, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. $sql = "SELECT Id, UserID, TimeAction, Command FROM users_checked WHERE UserId = 4 AND date(TimeAction) = '2016-12-05 '";
  2.  
  3. $q=$conn->query($sql);
  4.  
  5. $data = array();
  6.  
  7. while($r=$q->fetchAll((PDO::FETCH_ASSOC))){
  8. $data[]=$r;
  9. }
  10.  
  11. $data = array(
  12. array(
  13. "Id" => "1",
  14. "UserID" => "1",
  15. "TimeAction" => "2016-11-29 08:00:00",
  16. "Command" => "Prijava"
  17. ),
  18. array(
  19. "ID" => "1",
  20. "USERID" => "1",
  21. "TimeAction" => "2016-11-29 10:05:14",
  22. "Command" => "Odjava"
  23. ),
  24. array(
  25. "Id" => "1",
  26. "UserID" => "1",
  27. "TimeAction" => "2016-11-29 12:22:14",
  28. "Command" => "PoslovniIzlazak"
  29. ),
  30. array(
  31. "ID" => "1",
  32. "USERID" => "1",
  33. "TimeAction" => "2016-11-29 13:32:14",
  34. "Command" => "Prijava"
  35. ),
  36. array(
  37. "ID" => "1",
  38. "USERID" => "1",
  39. "TimeAction" => "2016-11-29 16:00:00",
  40. "Command" => "Odjava"
  41. ),
  42. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement