use a global javascript variable in ajax php mysql

Question

I have a variable 'user_cache' stored in local storage: Now I am doing a $.getJSON call

<script>

    user_data = JSON.parse(localStorage.getItem("user_cache"));

    $.getJSON("query.php",  { productId: productId}, function(data) { /*do something*/});

</script>

Query.php does a php_mysql database query:

<? php
if( $_REQUEST["productId"] )
{
    $productid = $_REQUEST['productId'];

    /*Database connection*/
    include_once("php_includes/db_conx.php");

    $sql = "DELETE FROM USERPRODUCTCOLLECTION WHERE  Product_ID = $productid";


    if ($db_conx->query($sql) === TRUE) {
        echo "Success";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }

    $db_conx->close();

}
?>

My question is that I also want to use the object 'user_data' in the query.php file to do that database query but I dont want to pass 'user_data' in $.getJSON. Is it possible to use 'user_data' object inside 'query.php' file without having to pass it in the $.getJSON?

Mikel Bitson · Accepted Answer · 2014-11-28 21:15:11Z

1

Unfortunately that will not be possible. You must pass the data to the php file in order to utilize it. Are you leaning away from passing the user data because it is passing it as a GET variable (in the URL)? If so, consider using a jQuery.post() call instead. This way the data will be posted instead of in the URL.

See : http://api.jquery.com/jquery.post/

answered Nov 28, 2014 at 21:15

Mikel Bitson

3,6471 gold badge20 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2850305 Over a year ago

Is it possible to access 'user_data' directly (without reading it from local storage) in a JavaScript code inside query.php?

Mikel Bitson Over a year ago

No, it is not. The javascript is being run in the user's browser. This means that their browser is the only place with that information, and in order to get it back to your php you will need to send the information to the PHP script. Consider a .post() to post all of the necessary information to your query.php.

Collectives™ on Stack Overflow

use a global javascript variable in ajax php mysql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related