Guest User

Untitled

a guest
Nov 28th, 2018
376
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. <?php
  2.  
  3. $host = 'example.com';
  4. $user = 'username';
  5. $pass = 'password';
  6. $db = 'database';
  7.  
  8. $con = mysqli_connect($host, $user, $pass, $db);
  9.  
  10. if (!$con) {
  11. printf("Connection failed: %sn", mysqli_connect_error());
  12. exit();
  13. }
  14.  
  15. $query ="UPDATE user_info VALUES (?, ?, ?, ?, ?, ?)"; // make this query into "update query"
  16. $statement = mysqli_prepare($con, $query);
  17.  
  18. if($statement === FALSE){ die(mysqli_error($link)); }
  19.  
  20. mysqli_stmt_bind_param($statement, "isssss" ,$UserID, $LastName, $FirstName, $Username, $EmailAddress, $Password);
  21.  
  22. $LastName = $_POST["LastName"];
  23. $FirstName = $_POST["FirstName"];
  24. $Username = $_POST["Username"];
  25. $EmailAddress = $_POST["EmailAddress"];
  26. $Password = $_POST["Password"];
  27.  
  28. mysqli_stmt_execute($statement);
  29.  
  30. $response = array();
  31. $response["success"] = true;
  32.  
  33. echo json_encode($response);
  34. ?>
  35.  
  36. <?php
  37. //I remove your credentials
  38. $con = mysqli_connect($host, $user, $pass, $db);
  39.  
  40. if (!$con) {
  41. printf("Connection failed: %sn", mysqli_connect_error());
  42. exit();
  43. }
  44.  
  45. $query ="UPDATE user_info SET lastname = ? AND firstname = ? AND username = ? AND emailaddress = ? AND password = ? WHERE userid = ?"; // make this query into "update query"
  46. $statement = mysqli_prepare($con, $query);
  47.  
  48. if($statement === FALSE){ die(mysqli_error($link)); }
  49.  
  50. $LastName = $_POST["LastName"];
  51. $FirstName = $_POST["FirstName"];
  52. $Username = $_POST["Username"];
  53. $EmailAddress = $_POST["EmailAddress"];
  54. $Password = $_POST["Password"];
  55.  
  56. mysqli_stmt_bind_param($statement, $LastName, $FirstName, $Username, $EmailAddress, $Password, $UserID);
  57.  
  58. mysqli_stmt_execute($statement);
  59.  
  60. $response = array();
  61. $response["success"] = true;
  62.  
  63. echo json_encode($response);
Add Comment
Please, Sign In to add comment