Forums

I'm really new to all of this...so I apologize for stupid questions in advance.

What I'm able to do:
I have a mysql database and a php file that has a function that generates a results.json file. Anotherwords I can query the database and output results.

I don't know how to send the results to a datatable in yui 3. I tried looking at the datasource help and the base datatable examples but so far have not had any luck in understanding this. I'm really new to this so if someone could provide some guidance I'd really appreciate it.

Thanks!

Hi Gennady,

Have you looked over the YUI 3 user guide, specifically the YQL example at http://yuiblog.com/sandbox/yui/3.3.0pr3/examples/datatable/datatable_dsget.html ?
This example uses a URL (which could be replaced with your php url) and a JSON schema response object (which could be replaced with your response results object and column names).

If you need more help, please ask

Todd

Todd,
I get an error that the function db_lookup is undefined. Also when I do "require_once 'JSON.php';" it pastes the contents of JSON.php in the browser when I run it. Is this normal?

Thanks,

-Gennady

Hi Gennady,

I can tell by some of your questions that you may be a little confused about using PHP. The example link I provided earlier was meant to show my example implementation. You appear to have understood that "db_lookup" is a library function I wrote that simply returns an associative array from MySQL. Sorry, I should have been more clear about that.

From the server snippet you provided it looks like you may have an extraneous "echo $returnValue" statement which will mess things up. You only need to have the "echo json_encode($returnValue)" statement.

Also, from the example of the output you show it looks like you are only returning a single row with mysql_fetch_assoc, but the 'Results' object of the JSON that is returned is expected to be an array. So I recommend your server call be replaced with the following
where the $row[] assignment appends to the $row array.

I recommend again that you review some of Satyam's examples for writing YUI 2 DataTable with php servers, they are very helpful.
1. Essential reading http://www.satyam.com.ar/yui/
2. Also his YUILibrary articles http://yuiblog.com/blog/2008/10/15/datatable-260-part-one/
3. and http://yuiblog.com/blog/2008/10/27/datatable-260-part-two/

You haven't shown any of your YUI3 DataTable code so I can't really tell if there are issues there. Once you get your php server worked out if you have problems you may want to use a pastie service to post your code and we can review it.

Regards,
Todd

It worked Todd. My table now has data from the database! Thank you VERY much!