Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. $sql = "SELECT id, firstName, middleName, lastName FROM users_info";
  2. $result = $pdo->query($sql);
  3.  
  4. $rows = array();
  5.  
  6. while($row = $result->fetch()){
  7. $time = $pdo->query(
  8. "SELECT CAST(SUM(timediff(dateTimeOut, dateTimeIn))
  9. as time) as totalHoursWorked
  10. FROM users_time WHERE user_id = {$row['id']}"
  11. )->fetch();
  12.  
  13. $row['totalHoursWorked'] = $time['totalHoursWorked'];
  14. $rows[] = $row;
  15.  
  16. }
  17.  
  18. echo json_encode($rows);
  19.  
  20. "SELECT CAST(SUM(timediff(dateTimeOut, dateTimeIn))
  21. as time) as totalHoursWorked
  22. FROM users_time WHERE user_id = {$row['id']}"
  23.  
  24. SELECT
  25. id
  26. , firstName
  27. , middleName
  28. , lastName
  29. , CAST(SUM(timediff(dateTimeOut, dateTimeIn))
  30. as time) as totalHoursWorked
  31. FROM users_info
  32. INNER JOIN users_time ON user_id = id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement