PHP load as XML in JQuery

I am trying to load in XML to populate a search box. The code I have works fine with a static xml file, but I need to load in a PHP file to generate a dynamic XML file based on data from a database.

I knwo the PHP file generates the XML as it loads in a browser and the page source shows the correct nodes etc, however when I reference the .php file in my JavaScript it fails to load, or show an error… Using the .xml file (which is a replica of the php output source) it loads fine.

I would like someone to check to see if I am encoding the XML correctly or missing something in my JavaScript… and advice will be greatly appreciated.

JS

var myArr = [];
$.ajax({            
     url: \"people.php\", // change to full path of file on server
     type: \"GET\",
     dataType: \"xml\",
     success: parseXml,
     complete: setupAC,
     failure: function(data) {
       alert(\"XML File could not be found\");
     }
});

function parseXml(xml){
     $(xml).find(\"person\").each(function(){     
        var thisItem = $(this).find(\'name\').text();
        myArr.push(thisItem);
        alert(thisItem);
     });    
}

PHP

<?php

    include \'../../inc_global/connect.php\';

    $query = \'SELECT * FROM candidates\';  

    $result = mysql_query($query, $link);

    $xmlOutput = \"<?xml version=\\\"1.0\\\" encoding=\\\"UTF-8\\\"?>\\n\";
    $xmlOutput .= \"<people>\\n\";

    while ($line = mysql_fetch_assoc($result)) {

   $xmlOutput .= \"<person>\\n\"; 
   $xmlOutput .= \"<name>\" . $line[\'name\'] . \"</name>\\n\"; 
   $xmlOutput .= \"</person>\\n\";

}

$xmlOutput .= \"</people>\\n\";

echo $xmlOutput;

mysql_close($link);

?>

Rating: 3 out of 5 based on 3 ratings

Posts Related to PHP load as XML in JQuery

• Aug 16th, 2012 Loading file with javascript/jquery Thursday AM 10:33:32


• Aug 01st, 2012 jquery - Running Javascript after CSS is fully loaded Wednesday AM 02:16:17


• Jul 19th, 2012 ajax - Load xml file in a directory using javascript Thursday AM 11:55:52


• Aug 16th, 2012 monitoring - Monitor certain webpage load times (including all images, css, etc..) using PHP Thursday AM 03:23:12


• Aug 11th, 2012 Using jquery .load to add rows to an html table Saturday PM 14:13:02


• Jul 10th, 2012 javascript - set cursor in login form field on page load Tuesday AM 10:53:35


• Jul 23rd, 2012 javascript - .ready to load in html Monday PM 14:00:47


• Aug 01st, 2012 jquery - How to call ajax only once Wednesday AM 04:36:46


• Aug 15th, 2012 javascript - call a function after complete page load Wednesday AM 06:01:51


• Jul 24th, 2012 javascript - How to get a specific jquery toggle show / hide div to load visible? Tuesday AM 03:24:32

The post PHP load as XML in JQuery appeared first on Javascript ASK.

via Javascript ASK http://javascriptask.phpfogapp.com/php-load-as-xml-in-jquery.html