Skip to main content

Variable from ajax via get no longer there [duplicate]

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

Popular posts from this blog

Prop `className` did not match in next js app

I have written a sample code ( Github Link here ). this is a simple next js app, but giving me error when I refresh the page. This seems to be the common problem and I tried the fix provided in the internet but does not seem to fix my issue. The error is Warning: Prop className did not match. Server: "MuiBox-root MuiBox-root-1" Client: "MuiBox-root MuiBox-root-2". Did changes for _document.js, modified _app.js as mentioned in official website and solutions in stackoverflow. but nothing seems to work. Could someone take a look and help me whats wrong with the code? Via Active questions tagged javascript - Stack Overflow https://ift.tt/2FdjaAW

How to show number of registered users in Laravel based on usertype?

i'm trying to display data from the database in the admin dashboard i used this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count(); echo $users; ?> and i have successfully get the correct data from the database but what if i want to display a specific data for example in this user table there is "usertype" that specify if the user is normal user or admin i want to user the same code above but to display a specific usertype i tried this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count()->WHERE usertype =admin; echo $users; ?> but it didn't work, what am i doing wrong? source https://stackoverflow.com/questions/68199726/how-to-show-number-of-registered-users-in-laravel-based-on-usertype

Why is my reports service not connecting?

I am trying to pull some data from a Postgres database using Node.js and node-postures but I can't figure out why my service isn't connecting. my routes/index.js file: const express = require('express'); const router = express.Router(); const ordersCountController = require('../controllers/ordersCountController'); const ordersController = require('../controllers/ordersController'); const weeklyReportsController = require('../controllers/weeklyReportsController'); router.get('/orders_count', ordersCountController); router.get('/orders', ordersController); router.get('/weekly_reports', weeklyReportsController); module.exports = router; My controllers/weeklyReportsController.js file: const weeklyReportsService = require('../services/weeklyReportsService'); const weeklyReportsController = async (req, res) => { try { const data = await weeklyReportsService; res.json({data}) console