Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. [{"firstname":"Student","lastname":"1"},{"firstname":"Student","lastname":"2"},{"firstname":"Student","lastname":"3"}]
  2.  
  3. ["85.00000","50.00000","90.00000"]
  4.  
  5. {"firstname":"Student","lastname":"1","grade":"85.00000"}
  6.  
  7. //Provisional Array Setup for Grades
  8. $grade = array();
  9. $userid = array();
  10. $sqldata = array();
  11.  
  12. foreach($json_d->assignments[0]->grades as $gradeInfo) {
  13. $grade[] = $gradeInfo->grade;
  14. $userid[] = $gradeInfo->userid;
  15. }
  16.  
  17. //Server Details
  18. $servername = "localhost";
  19. $username = "root";
  20. $password = "";
  21. $dbname = "moodle";
  22.  
  23. // Create connection
  24. $conn = mysqli_connect($servername, $username, $password, $dbname);
  25.  
  26. // Check connection
  27. if (!$conn) {
  28. die("Connection failed: " . mysqli_connect_error());
  29. }
  30.  
  31. foreach($userid as $id) {
  32. $sql = "SELECT firstname, lastname FROM mdl_user WHERE id='$id'";
  33. $result = mysqli_query($conn, $sql);
  34.  
  35. if (mysqli_num_rows($result) > 0) {
  36. // output data of each row
  37.  
  38. while($row = mysqli_fetch_array($result, MYSQL_ASSOC)) {
  39. $sqldata[] = $row;
  40. }
  41.  
  42. } else {
  43. echo "ERROR!";
  44. }
  45.  
  46. }
  47.  
  48. $sqlr = json_encode($sqldata);
  49. $grd = json_encode($grade);
  50.  
  51. echo $sqlr;
  52. echo $grd;
  53.  
  54.  
  55.  
  56. mysqli_close($conn);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement