ansaurus

Question

Different AJAX XML results from same PHP file with same POST parameters using JQuery

Answer 1

A:

My guess is you should be using mysql_fetch_assoc instead of mysql_fetch_array. mysql_fetch_array will give you an array structure with numeric indexes. Where mysql_fetch_assoc will give you the $array[column_name] like you are looking for.

atodd 2009-05-08 19:31:44

Its a good point that you make, but I tried making the change and am still having the same problem..

2009-05-08 20:51:46

Answer 2

A:

I think that it's a mysql connection issue; the select is not running anyhow. To debug, add an echo "hello" to while{} , and see if it shows up at all or not :)

balint 2009-05-09 16:24:31

it looks like the select is running, because when I run the PHP file by itself it returns the correct results but when I call it through AJAX, the results are different (even though no parameters are sent through)

2009-05-11 00:44:14

try to post a some data with ajax. i had the same with a web service call on .net; I guess "getFriends" is a method, but it's not being called at all.

balint 2009-05-11 10:22:14

Answer 3

A:

In firebug, right click on the AJAX call, then select "Open in new tab." Firefox should format the XML nicely for you (if you are doing header("Content-Type: application/xml") like you should). Look at the request it is sending (in the location box). Reload it a few times. Print the data in the PHP file that you think should be set.

I'm sorry I can't help more but it sounds like some silly mistake somwhere.

Alternatively, you could just build the data up as an array, and then use JSON (my preferred method).

On more thing, you should NEVER do parameter injection into SQL. Bery very dangerous. Use something like PDO.

$userID='11';
$PDO = new PDO("mysql:dbname=mydb", "uname", "pword");

$stmt = $PDO->prepare("SELECT ID, name, pic_square FROM users WHERE ID = :userID");
$stmt->execute(array("userID" => $userID)) or die (print_r($PDO->errorInfo(), TRUE));

$output = array();
while($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) {
    $output = $row;
}

header('Content-Type: application/json; charset=ISO-8859-1');
header("Cache-Control: no-cache, must-revalidate");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");

print json_encode($output);

Paul Tarjan 2009-05-27 05:27:33

Answer 4

A:

Seems like you're not getting data from the db. What happends if you just do this

echo "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>";
echo "<Friends>";
echo "<Test>Hello</Test>";
echo "</Friends>";

instead? If it really is a cache problem, then adding a random param to the URL should force the browser to update. Ie does this should work:

$.ajax({
    url:"./lib/ajax_friends.php?random987398792374",
...

Good luck!

0scar 2009-05-30 10:53:07

ansaurus

tags:

views:

answers:

Different AJAX XML results from same PHP file with same POST parameters using JQuery

related questions