I'm currently working on a webbased QR code scanner and i use html5QrcodeScanner for it.
The scanning progress works fine, except for this few lines:
This SQL statement works fine with $abc as the variable I get via GET from ajax:
$sql = "UPDATE `registered` SET scan = current_timestamp() WHERE `id`='$abc'";
$result = mysqli_query($conn, $sql);
Next line, my variable $abc doesn't work anymore...
$key_ar = array_search($abc, array_column($userinfo, 'id'));
This is (i would say) all in all the important part for the Problem
// on the top of the class, i put the whole table in a array
$result_rs = mysqli_query($conn, "select `id`,`pname`,`name`,`date` from `registered`");
$userinfo = array();
while ($row_user = mysqli_fetch_assoc($result_rs)) {
$userinfo[] = $row_user;
}
function onScanSuccess(decodedText, decodedResult) {
if (decodedText !== lastResult) {
++countResults;
lastResult = decodedText;
// Handle on success condition with the decoded message.
console.log(`Scan result ${decodedText}`, decodedResult);
document.getElementById("uniqueid").textContent=lastResult;
var idabc = lastResult;
var userdata = {'id':lastResult};
$.ajax({
type: "GET",
url: "index.php",
data:userdata,
success: function(data){
<?php
$abc = $_GET['id'];
// these lines working great
$sql = "UPDATE `registered` SET scan = current_timestamp() WHERE `id`='$abc'";
$result = mysqli_query($conn, $sql);
// from there, the $abc variable hasn't the same value as 2 lines above...
$key_ar = array_search($abc, array_column($userinfo, 'id'));
$search_results = array();
foreach($userinfo[$key_ar] as $key => $value) {
$search_results[$key] = $value;
}
$pname = $search_results['pname'];
$name = $search_results['name'];
$date = $search_results['date'];
echo "document.getElementById('pname').textContent='$pname';";
echo "document.getElementById('name').textContent='$name';";
echo "document.getElementById('date').textContent='$date';";
?>
}
});
}
}
I hope you can help me... If you need more code feel free to ask for it, i will add it asap
Via Active questions tagged javascript - Stack Overflow https://ift.tt/2FdjaAW
Comments
Post a Comment