Guest User

Untitled

a guest
Oct 7th, 2018
216
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. <?php
  2. $con = mysqli_connect("localhost:3306","id7390457_user","abcd1234","id7390457_data");
  3.  
  4. $username = $_POST["username"];
  5. $password = $_POST["password"];
  6.  
  7. $statement = mysqli_prepare($con, "SELECT * FROM user WHERE username = ? AND password = ?");
  8. mysqli_stmt_bind_param($statement, "ssis", $username, $password);
  9. mysqli_stmt_execute($statement);
  10.  
  11. mysqli_stmt_store_result($statement);
  12. mysqli_stmt_bind_result($statement, $user_id, $name, $age, $username, $password);
  13.  
  14. $response = array();
  15. $response["success"] = false;
  16.  
  17. while(mysqli_stmt_fetch($statement)){
  18. $response["success"] = true;
  19. $response["name"] = $name;
  20. $response["age"] = $age;
  21. $response["username"] = $username;
  22. $response["password"] = $password;
  23. }
  24.  
  25. echo json_encode($response);
  26.  
  27. <?php
  28. $con = mysqli_connect("localhost", "id7390457_user", "abcd1234", "id7390457_data");
  29.  
  30. $name = $_POST["name"];
  31. $age = $_POST["age"];
  32. $username = $_POST["username"];
  33. $password = $_POST["password"];
  34. $statement = mysqli_prepare($con, "INSERT INTO user (name, age, username, password) VALUES (?, ?, ?, ?)");
  35. mysqli_stmt_bind_param($statement, "ssis", $name, $age, $username, $password);
  36. mysqli_stmt_execute($statement);
  37.  
  38. $response = array();
  39. $response["success"] = true;
  40.  
  41. echo json_encode($response);
  42.  
  43. $con = mysqli_connect("localhost", "id7390457_user", "abcd1234", "id7390457_data");
Add Comment
Please, Sign In to add comment