Advertisement
Guest User

Untitled

a guest
Jan 19th, 2016
279
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.64 KB | None | 0 0
  1. <access origin="*" />
  2. <access origin="http://ec2-54-229-109-138.eu-west-1.compute.amazonaws.com/chrisTest.php" subdomains="true" />
  3.  
  4. $("#upload").live('click', function(){
  5. alert("Upload");
  6. db.transaction(uploadQuery, errorCB);
  7. })
  8.  
  9.  
  10. function uploadQuery(tx){
  11. tx.executeSql('SELECT * FROM DEMO',[], posting, errorCB);
  12. }
  13.  
  14.  
  15. function posting(tx, results){
  16. var len = results.rows.length;
  17. alert("Posting");
  18. for (var i = 0; i < len; i++){
  19. var trackID =results.rows.item(i).trackID;
  20. var longitude= results.rows.item(i).longitude;
  21. var latitude=results.rows.item(i).latitude;
  22.  
  23. var data = {
  24. "trackID": trackID,
  25. "longitude": longitude,
  26. "latitude": latitude
  27. };
  28. data = $.param(data);
  29. $.ajax({
  30. type: "POST",
  31. dataType: "json",
  32. url: "http://ec2-54-229-109-138.eu-west-1.compute.amazonaws.com/chrisTest.php", //Relative or absolute path to handle.request.ajax file
  33. data: data,
  34. success: function(data) {
  35. alert("Form submitted successfully.");
  36. }
  37. });
  38. }
  39. }
  40.  
  41. <?php
  42.  
  43. $username="mxxxxx";
  44. $password="xxxx";
  45. $database="xxxxx";
  46. $url = "xxxx";
  47.  
  48. $trackID = $_POST['trackID'];
  49. $longitude =$_POST['longitude'];
  50. $latitude = $_POST['latitude'];
  51.  
  52.  
  53. mysql_connect($url,$username,$password);
  54.  
  55. @mysql_select_db($database) or die( "Unable to select database");
  56.  
  57. $query = "INSERT INTO test(trackID,longitude,latitude) VALUES ('$trackID','$longitude','$latitude')";
  58.  
  59. mysql_query($query);
  60.  
  61. mysql_close();
  62. echo "You successfully added your Coupon";
  63.  
  64. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement