Guest User

Untitled

a guest
Oct 20th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. function getCoursesDetails($course,$date)
  2. {
  3. $query = "SELECT course.courseID, course.courseName, course_room.roomID,course_room.day_date, course_room.start_time, course_room.end_time, prof.firstName, prof.lastName, prof.profID FROM course, course_room, prof
  4. WHERE course_room.courseID = course.courseID AND course.courseName = $course AND course_room.day_date = $date AND prof.profID = course.profID";
  5. $result = mysql_query($query);
  6. $arr = array();
  7. while($record = mysql_fetch_assoc($result))
  8. {
  9. $arr[] = array ('courseID' => $record['courseID'],
  10. 'courseName' => $record['courseName'],
  11. 'roomID' => $record['roomID'],
  12. 'date' => $record['day_date'],
  13. 'starting' => $record ['start_time'],
  14. 'ending' => $record['end_time'],
  15. 'firstName' => $record['firstName'],
  16. 'lastName' => $record['lastName']);
  17. }
  18. echo json_encode($arr);
  19. }
Add Comment
Please, Sign In to add comment