Insert PhoneGap Data in MySQL Database

크레도스 2013. 8. 27. 11:45

Here is my track.html

<!DOCTYPE html>
<html>
<head>
<title>Device Properties Example</title>

<script type="text/javascript" charset="utf-8" src="cordova-2.7.0.js"></script>
<script type="text/javascript" charset="utf-8" src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js">
$('form').submit(function(){
    var landmarkID = $(this).parent().attr('data-landmark-id');
    var postData = $(this).serialize();

    $.ajax({
        type: 'POST',
        data: postData+'&lid='+landmarkID,
        url: 'http://192.168.254.105/webs/main/track.php',
        success: function(data){
            console.log(data);
            alert('Your comment was successfully added');
        },
        error: function(){
            console.log(data);
            alert('There was an error adding your comment');
        }
    });

    return false;
});

</script>
</head>
   <div id="landmark-1" data-landmark-id="1">
<form>
    <label for="email">
        <b>Email</b>

            <input type="email" id="email" name="email">
    </label>

    <label for="comment">
        <b>Comment</b>
        <textarea id="comment" name="comment" cols="30" rows="10"></textarea>
    </label>

    <input type="submit" value="Save">
</form>
   </div>
<body>

       </body>
    </html>

Here's my track.php

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "comments";

$con = mysql_connect($server, $username, $password) or die ("Could not connect: " .
mysql_error());
mysql_select_db($database, $con);

$locationID = $_POST["lid"];
$email = mysql_real_escape_string($_POST["email"]);
$comment = mysql_real_escape_string($_POST["comment"]);

$sql = "INSERT INTO comment (location_id, email, comment) ";
$sql .= "VALUES ($locationID, '$email', '$comment')";

   if (!mysql_query($sql, $con)) {
die('Error: ' . mysql_error());
   } else {
echo "Comment added";
    }

   mysql_close($con);
    ?>

저작자표시 비영리 변경금지