I am attempting to use dhtmlxGrid in order to get data from a PostegreSQL DB. Now I am able to get the data from the DB, and I am successfully converting it to XML. And I got it working happily off a test table.
However when I tried to query my main table I keep getting an error of “Incorrect XML”
Here is a sample row of my XML that is outputted by my php file that is querying the DB:
<?xml version="1.0" encoding="UTF-8"?>
Airport Direction (pictorial)
Photos\Fenton St (Small)\Fenton St-1.JPG
What am I doing wrong with this?
There is no any problem with used XML - it is correct and works fine while loading from static XML file.
Please be sure that server side script
- set correct content type - text/xml
- there is no whitespaces before xml header <?xml …
Also you can try to use attached js file instead of original dhtmlxcommon.js - it shows all fetched data, so if any problem occurs with server side script - it will be easy to detect it.
1201600539.zip (68.7 KB)
dhtmlxcommon_debug.zip (4.95 KB)
I found the problem, I needed to put a htmlspecialchars clause around some of my strings as they contained things that the loadXML didn’t like