Advertisement
Guest User

Untitled

a guest
Oct 19th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. $host = 'db.soic.indiana.edu';
  2. $user = 'caps16_team40';
  3. $pass = 'my+sql=caps16_team40';
  4. $db = 'caps16_team40';
  5.  
  6. $con = mysqli_connect($host, $user, $pass, $db);
  7.  
  8. if (!$con) {
  9. printf("Connection failed: %sn", mysqli_connect_error());
  10. exit();
  11. }
  12.  
  13. $query ="UPDATE user_info VALUES (?, ?, ?, ?, ?, ?)"; // make this query into "update query"
  14. $statement = mysqli_prepare($con, $query);
  15.  
  16. if($statement === FALSE){ die(mysqli_error($link)); }
  17.  
  18. mysqli_stmt_bind_param($statement, "isssss" ,$UserID, $LastName, $FirstName, $Username, $EmailAddress, $Password);
  19.  
  20. $LastName = $_POST["LastName"];
  21. $FirstName = $_POST["FirstName"];
  22. $Username = $_POST["Username"];
  23. $EmailAddress = $_POST["EmailAddress"];
  24. $Password = $_POST["Password"];
  25.  
  26. mysqli_stmt_execute($statement);
  27.  
  28. $response = array();
  29. $response["success"] = true;
  30.  
  31. echo json_encode($response);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement