7 replies to this topic

[datalogi]

Hi, could someone help me how to pass following variables back to jQuery from PHP-file,
which I was called from jQuery.

$sql = $dbh->prepare("SELECT merkki, vuosimalli FROM autot");
$sql->execute();
$row = $sql->fetch();
$merkki = $row['merkki'];
$vuosimalli = $row['vuosimalli'];

[Vaielab]

We'll need to see how you cann this page with jquery

[datalogi]

Ok, let me explain.

This is jQuery code:
function search () {
$.get("search.php?ID=", function(data){
// return data from PHP file
});
}

And this is PHP-file search.php
<?php
$sql = $dbh->prepare("SELECT merkki, vuosimalli FROM autot");
$sql->execute();
$row = $sql->fetch();
$merkki = $row['merkki'];
$vuosimalli = $row['vuosimalli'];
?>

[Vaielab]

In this case, simply do a echo of your variable, and it will be in the variable data

[datalogi]

But i need to echo to variables: $merkki and $vuosimalli

I think it's possible to echo only one variable....?

[Vaielab]

echo($merkki);

echo($vuosimalli);

To split them back in your jquery you could separate them with a comma, or any other char...

If you'd like a more elegant method, you chould do something like this

echo(json_encode(array('merkki' => $merkki, 'vuosimalli' => $vuosimalli)));

and in your jquery you read it with jQuery.parseJSON(data);

[datalogi]

So now I have:
$character = " | ";

echo($merkki);
echo($character);
echo($vuosimalli);


jQuery output is: "Toyota | 2008"

So how can I parse Toyota to one jQuery variable and 2008 to another jQuery variable?

[Orjan]

Do it the JSON way described above and fix the rest in the javascript, i'd say.