Advertisement
Guest User

Untitled

a guest
Jul 29th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. ===Register====
  2. <?php
  3. require "conn.php";
  4.  
  5. $password = $_POST["password"];
  6. $username = $_POST["username"];
  7.  
  8. //$password = "password";
  9. //$username = "username";
  10.  
  11. $mysql_qry = "INSERT INTO UserData (username,password) VALUES ('$username','$password')";
  12. if($conn->query($mysql_qry) === TRUE){
  13.  
  14. echo "Insert Successful";
  15.  
  16. }else{
  17.  
  18. echo "Error:" .$mysql_qry. "<br>" .$conn->error;
  19. }
  20. $conn->close();
  21.  
  22. ?>
  23.  
  24. ===Connect===
  25. <?php
  26. $db_name = "xxxxx";
  27. $mysql_username = "xxxxx";
  28. $mysql_password = "xxxxx";
  29. $server_name = "xxxxx";
  30. $conn = mysqli_connect($server_name, $mysql_username, $mysql_password,$db_name);
  31. if ($conn) {
  32. echo "Connected successfully";
  33. }
  34. if (!$conn) {
  35. echo "no";
  36. }
  37. ?>
  38.  
  39. ===Login===
  40.  
  41. <?php
  42. require "conn.php";
  43. $user_name = $_POST["user_name"];
  44. $user_pass = $_POST["password"];
  45. //$user_name = "jimbo";
  46. //$user_pass = "jimbo123";
  47. $mysql_qry = "SELECT * FROM UserData WHERE username = '$user_name' AND password = '$user_pass';";
  48. $result = mysqli_query($conn ,$mysql_qry);
  49. if(mysqli_num_rows($result) > 0) {
  50. echo "login success !!!!! Welcome user";
  51. }
  52. else {
  53. echo "login not success";
  54. }
  55.  
  56. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement