Advertisement
Guest User

Untitled

a guest
Apr 20th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.50 KB | None | 0 0
  1. $(document).on("click", ".uib_w_18", function(evt)
  2. {
  3. var lecturer = document.getElementById("reg_name").value;
  4. //var lecturer = $("#reg_name").val();
  5. var dept = document.getElementById("reg_dept").value;
  6. var level = document.getElementById("reg_level").value;
  7. var course = document.getElementById("reg_course").value;
  8. var start = document.getElementById("reg_time_1").value;
  9. var ade = 2;
  10. window.alert(lecturer);
  11. var dataString = '?ade=' + ade+'&lecturer='+lecturer+'&dept='+dept +'&level='+level+'&course='+course+'&start='+start;
  12.  
  13. $.ajax({
  14. type: "GET",
  15. url: 'http://localhost/my_queries.php',
  16. data: dataString,
  17. success: window.alert ("I've been to localhost.")
  18. });
  19. window.alert(dataString);
  20. });
  21.  
  22. <?php
  23. $dbhost = "localhost";
  24. $dbuser = "root";
  25. $dbname = "myDatabase";
  26. $dbpass = null;
  27. //Connect to MySQL Server
  28. echo "yo";
  29. $con = mysqli_connect($dbhost, $dbuser,$dbpass,$dbname);
  30. $level = $_GET['level'];
  31. $lecturer = $_GET['lecturer'];
  32. $sql = "INSERT INTO level1(message, department)
  33. VALUES ($level,'Jane')";
  34. $sql2 = "INSERT INTO level1(message, department)
  35. VALUES ($lecturer,'Jane')";
  36. if ($con->query($sql) === TRUE) {
  37. echo "New record created successfully";
  38. } else {
  39. echo "Error: " . $sql . "<br>" . $con->error;
  40. }
  41.  
  42. ?>
  43.  
  44. $sql = "INSERT INTO level1(message, department)
  45. VALUES ('".$level."','Jane')";
  46. $sql2 = "INSERT INTO level1(message, department)
  47. VALUES ('".$lecturer."','Jane')";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement