I am trying to bind the Grid to a MySQL datasource using the GridConnector on a server-side PHP file. When I open the HTML file which contains the grid I get this popup:
Error type: LoadXML
Description: Incorrect XML
If I call the URL of the server-side php script directly I receive this error message:
This page contains the following errors:
error on line 1 at column 1: Document is empty
Below is a rendering of the page up to the first error.
Here is my server side php script which has been taken out of one of your samples:
<?php require_once("dhtml/codebase/grid_connector.php"); $res=mysql_connect("localhost","root",""); mysql_select_db("test"); $grid = new GridConnector($res); $grid->enable_log("temp.log",true); $grid->render_table("groups","id","name"); ?>Here is my “temp.log” file:
Log started, 25/10/2010 09:10:51
SELECT id,name FROM groups
Done in 0.0009310245513916s
As a side note, my /var/log/httpd/error_log is clean.
My environment is:
Linux CentOS 5.5 2.6.35.4 x86_64
Apache/2.2.3
MySQL 5.0.77
PHP Version 5.1.6
Can you point me into the right direction? Is this an apache/mysql/php configuration issue?
Thank you!