Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <access origin="*" />
- <access origin="http://ec2-54-229-109-138.eu-west-1.compute.amazonaws.com/chrisTest.php" subdomains="true" />
- $("#upload").live('click', function(){
- alert("Upload");
- db.transaction(uploadQuery, errorCB);
- })
- function uploadQuery(tx){
- tx.executeSql('SELECT * FROM DEMO',[], posting, errorCB);
- }
- function posting(tx, results){
- var len = results.rows.length;
- alert("Posting");
- for (var i = 0; i < len; i++){
- var trackID =results.rows.item(i).trackID;
- var longitude= results.rows.item(i).longitude;
- var latitude=results.rows.item(i).latitude;
- var data = {
- "trackID": trackID,
- "longitude": longitude,
- "latitude": latitude
- };
- data = $.param(data);
- $.ajax({
- type: "POST",
- dataType: "json",
- url: "http://ec2-54-229-109-138.eu-west-1.compute.amazonaws.com/chrisTest.php", //Relative or absolute path to handle.request.ajax file
- data: data,
- success: function(data) {
- alert("Form submitted successfully.");
- }
- });
- }
- }
- <?php
- $username="mxxxxx";
- $password="xxxx";
- $database="xxxxx";
- $url = "xxxx";
- $trackID = $_POST['trackID'];
- $longitude =$_POST['longitude'];
- $latitude = $_POST['latitude'];
- mysql_connect($url,$username,$password);
- @mysql_select_db($database) or die( "Unable to select database");
- $query = "INSERT INTO test(trackID,longitude,latitude) VALUES ('$trackID','$longitude','$latitude')";
- mysql_query($query);
- mysql_close();
- echo "You successfully added your Coupon";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement