Sending a PHP variable through ajax

Question

I want to send the result of an SQL query which is a PHP variable to the index file. Here's from the PHP I want to send from:

$result = mysqli_query($conn, $sql);
$remaining = array();
while($row = mysqli_fetch_array($result)){
array_push($remaining, $row['_id']);
}
echo json_encode($remaining);

?>
<script>
      $.ajax({
        url: "index.php", 
        data: {result: result}, 
        dataType: "json",
        success: function(result){
}});
</script>

Here is where I want to use the code:

$var_value = $_GET['remaining'];
$values = implode(", ", $var_value);

$sql = "SELECT *
        FROM `species` 
        WHERE `_id` IN (".$valus.") ";

$results = mysqli_query($conn, $sql);

I have tried many methods, running a second ajax call within one already running since the $remaining variable is sent back to a javascript using ajax. $_cookies doesn't work for my webserver. So this seems the best solution. Can anyone see what is going wrong?

Is there a reason you need to to use two transactions to the database? Could you refactor by making the SELECT * FROM art WHERE _id IN ( [$sql from first example] )? — ash
– ash, Commented May 3, 2015 at 9:00
@doublesidedstickytape I still have to send it to another document, since I use the PHP document only for the first query. — Øyvind
– Øyvind, Commented May 3, 2015 at 9:08
ok, bottomline: on the server, you get values from the database, renderthat in to a javascript and send that to the client. The client then sends back tha just generated values to the server to another page, where they are picked up as query parameters by php again? Sorry, that's like printing an email and sending it by fax to the next recipient. Consider to store the values in the session and skip that AJAX stuff. — Axel Amthor
– Axel Amthor, Commented May 3, 2015 at 9:10
@AxelAmthor How do I store the values from the query and use it in another mySQL query on the same page? — Øyvind
– Øyvind, Commented May 3, 2015 at 9:26

Axel Amthor · Accepted Answer · 2015-05-03 09:31:28Z

1

As reply to your comment: easy:

session_start(); // important!!

if ( !isset($_SESSION['remaining']) )
{
    $result = mysqli_query($conn, $sql);
    $remaining = array();
    while($row = mysqli_fetch_array($result)){
        array_push($remaining, $row['_id']);
    }
    $_SESSION['remaining'] = $remaining;
}
else
{
    $values = implode(",", $_SESSION['remaining']);
    /// $_SESSION['remaining'] = null - depends on logic.
    $sql = "SELECT *
        FROM `species` 
        WHERE `_id` IN (".$valus.") ";

    $results = mysqli_query($conn, $sql);
}

answered May 3, 2015 at 9:31

Axel Amthor

11.1k1 gold badge28 silver badges45 bronze badges

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

5 Comments

Øyvind Over a year ago

Thanks for the reply. This seems like a great solution, but I have issues accessing the server in the session even after setting save path, I get the permission denied (13) error. Got any ideas?

Axel Amthor Over a year ago

please explain " issues accessing the server in the session"

Axel Amthor Over a year ago

got it: the user which is running your web server has no access rights on the file path to store the session in.

Øyvind Over a year ago

Yeah, it seems so. I am currently trying to fix it and sending for help :). Thanks for the help though.

Øyvind Over a year ago

Is there another way to do it by $_POST or something? @Axel Amthor

Collectives™ on Stack Overflow

Sending a PHP variable through ajax

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related