Guest User

Untitled

a guest
Sep 29th, 2016
25
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. <?phpdefine('DB_HOST','localhost');
  2. define('DB_NAME','vehicle');
  3. define('DB_USER','root');
  4. define('DB_PASSWORD','');
  5. $con=mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME) or die("Failed to connect to MySQL: " . mysqli_connect_error());
  6.  
  7. public function login()
  8. {
  9. $username=$_POST['username'];
  10. $password=md5($_POST['password']);
  11. log_valid($username,$password);
  12. }
  13.  
  14. public function log_valid($username,$password)
  15. {
  16. if(verify_user($username,$password))
  17. {
  18. $row=fetch_user($username,$password);
  19. $data = array('username' => $row['username'],
  20. 'is_admin'=>$row['is_admin'],
  21. );
  22. // Start the session
  23. session_start();
  24. $_SESSION['user']=$data;
  25. }
  26.  
  27. public function signup()
  28. {
  29. if($_SERVER["REQUEST_METHOD"] == "POST")
  30. {
  31. $username=$_POST['username'];
  32. $password=$_POST['password'];
  33. $username=$_POST['username'];
  34. $username=$_POST['username'];
  35. $username=$_POST['username'];
  36. }
  37. }
  38. public function chkusrname($username)
  39. {
  40. $query="SELECT * from users where username=$username";
  41. $rowcount=mysqli_num_rows(mysqli_query($con,$query));
  42. if($rowcount>0)
  43. return false;
  44. else
  45. return true;
  46. }
  47.  
  48. public function verify_user($username,$password)
  49. {
  50. $query="SELECT * from users where username=$username and password=$password";
  51. $result=mysqli_query($con,$query);
  52. $rowcount=mysqli_num_rows($result);
  53. if($rowcount==1)
  54. return true;
  55. else
  56. return false;
  57. }
  58.  
  59.  
  60. public function fetch_user($username,$password)
  61. {
  62. $query="SELECT * from users where username=$username and password=$password";
  63. $result=mysqli_query($con,$query);
  64. return $result;
  65. }
  66.  
  67.  
  68. ?>
Add Comment
Please, Sign In to add comment