Advertisement
Guest User

Untitled

a guest
Aug 16th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. $result='';
  2. if(isset($_POST['username']) && isset($_POST['password']))
  3. {
  4.  
  5. $username = $_POST['username'];
  6. $password = $_POST['password'];
  7.  
  8. $_SESSION['username'] = $_POST['username'];
  9.  
  10. $sql = 'SELECT * FROM login WHERE username = :username AND password = :password';
  11. $stmt = $conn->prepare($sql);
  12. $stmt->bindParam(':username', $username, PDO::PARAM_STR);
  13. $stmt->bindParam(':password', $password, PDO::PARAM_STR);
  14. $stmt->execute();
  15.  
  16. if($stmt->rowCount())
  17. {
  18. $result="true";
  19.  
  20. }
  21. elseif(!$stmt->rowCount())
  22. {
  23. $result="false";
  24. }
  25.  
  26. echo $result;
  27. }
  28. ?>
  29.  
  30. <?php
  31. include 'DatabaseConfig_Apk.php';
  32.  
  33. session_start();
  34. $professor = $_SESSION['username'];
  35.  
  36. // Create connection
  37. $conn = new mysqli($HostName, $HostUser, $HostPass, $DatabaseName);
  38.  
  39. if ($conn->connect_error) {
  40.  
  41. die("Connection failed: " . $conn->connect_error);
  42. }
  43.  
  44. $sql = "SELECT NomComplet FROM Info WHERE UserProfessor = '$professor' ";
  45.  
  46. $result = $conn->query($sql);
  47.  
  48. if ($result->num_rows >0) {
  49. while($row[] = $result->fetch_assoc()) {
  50.  
  51. $tem = $row;
  52.  
  53. $json = json_encode($tem);
  54. }
  55.  
  56. } else {
  57. echo "No Results Found.";
  58. }
  59.  
  60. echo $json;
  61. $conn->close();
  62. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement