Advertisement
Guest User

Untitled

a guest
Aug 9th, 2016
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. include("dbconnect.php"); //database connection
  2.  
  3. session_start();
  4.  
  5. $error = ""; //error msg variable.
  6. if(isset($_POST["submit"])){
  7. if(empty($_POST["username"]) || empty($_POST["password"]))
  8. {
  9. $error = "username/password can't be empty.";
  10. }else
  11. {
  12. $username=$_POST['username'];
  13. $password=$_POST['password'];
  14. $username = stripslashes($username); //SQL Injection denial
  15. $password = stripslashes($password);
  16. $username = mysqli_real_escape_string($username, $koneksi);
  17. $password = mysqli_real_escape_string($password, $koneksi);
  18. $sql = "SELECT * FROM operator WHERE username='$username' and password='$password'";//username and password checking
  19. $result =mysqli_query($sql, $koneksi);
  20. $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
  21. if(mysqli_num_rows($result) == 1){
  22. $_SESSION['username'] = $login_user; // create session
  23. header("location: home.php"); // redirection
  24. }else{
  25. $error = "wrong username or password.";
  26. }
  27. }
  28. }
  29.  
  30. Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, string given in /opt/lampp/htdocs/libraryman/login.php on line 15
  31.  
  32. Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, string given in /opt/lampp/htdocs/libraryman/login.php on line 16
  33.  
  34. Warning: mysqli_query() expects parameter 1 to be mysqli, string given in /opt/lampp/htdocs/libraryman/login.php on line 18
  35.  
  36. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /opt/lampp/htdocs/libraryman/login.php on line 19
  37.  
  38. Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /opt/lampp/htdocs/libraryman/login.php on line 20
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement