Advertisement
Guest User

Create New Data

a guest
Feb 17th, 2016
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. <?php
  2.  
  3. $firstname= $_GET['firstname'];
  4. $lastname= $_GET['lastname'];
  5.  
  6. $dbhost = 'localhost';
  7. $dbuser = 'username';
  8. $dbpass = 'your-pwd';
  9. $dbname = 'mydbname';
  10.  
  11. mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
  12. mysql_select_db($dbname);
  13.  
  14. //array for JSON response
  15. $response = array();
  16.  
  17. //add users details to database
  18.  
  19. $result = mysql_query("INSERT INTO payen83_melaka.xdkdemo(firstname,lastname) VALUES('$firstname','$lastname')") or die(mysql_error());
  20. if ($result){
  21. $response["success"] = 1;
  22. $response["message"] = "User details saved";
  23.  
  24. } else {
  25. $response["success"] = 1;
  26. $response["message"] = "User details failed";
  27. }
  28. //echoing JSON response
  29. echo json_encode($response);
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement