I am currently developing an app using PhoneGap which involves a script to read a ticket code. The script performs two queries: one to update the ticket status in the database if it exists, and another to write a log in a separate table. This functionality is working perfectly.
Now, I need to implement a feature where the script will return different responses (Valid or Invalid) in JSON format. However, I am facing challenges in reading the data and displaying the appropriate responses based on the result.
Below is the code snippet from index.html:
$(function() {
$("#savedata").click(function() {
var fcode = $("#code").val();
var fuuid = $("#uuid").val();
$("#code").val(" ");
$("#uuid").val(" ");
$.ajax({type: "POST",
url: "http://phonegap.localhost/test/www/db/update.php",
data: ({code: fcode, uuid: fuuid}),
cache: false,
dataType: "text",
success: Send
});
});
function Send(data){
document.getElementById('entrada').innerHTML = ("Done!");
}
});
And here is the code for update.php:
<?php
require_once('conndb.php');
$code= $_POST['code'];
$uuid = $_POST['uuid'];
$data=array();
$sql = "SELECT code FROM ticket WHERE code='$code'";
$result = mysql_query($sql);
if(mysql_num_rows($result) >0){
$sql="UPDATE ticket SET redeem_status= 1 WHERE code = '$code'";
$resultado=mysql_query($sql);
$sql2="INSERT INTO log(id, codigo, hora, uuid, valido) VALUES(NULL, '$code', CURRENT_TIMESTAMP, '$uuid', 1)";
$resultado2=mysql_query($sql2);
$val['status'] = 1;
echo json_encode($val);
}else{
$sql2="INSERT INTO log (id, codigo, hora, uuid, valido) VALUES (NULL, '$code', CURRENT_TIMESTAMP, '$uuid', 0)";
$resultado2=mysql_query($sql2);
$val['status'] = 0;
echo json_encode($val);
}
?>