About the author: Daniel “Satyam” Barreiro is a specialist in YUI’s DataTable Control (and a capable generalist in most YUI-related issues). Satyam was a recipient of the inaugural 2008 YUI Community Award, recognizing his substantial contributions to the YUI project.
YUI is designed to be flexible so it can work in all sorts of environments. Sometimes we start from scratch, both on the client side and the server side, and we might get a little disoriented with so many possibilities. PHP or Rails? JSON or XML? In previous articles, I’ve shown how to use the DataTable Component and I’ve made some suggestions about how to manage the choices you have on the client.
A recent article at my web site offers techniques and sample code for the server side if it runs PHP scripts, which is a pretty common server-side choice for YUI deployments. It shows the code for several handy functions that make the server code easy to write. I begin by discussing a dispatcher function,
ajaxReq which branches off to your individual responders, but not before setting the environment for a proper JSON reply. I also provide an
ajaxReply function which makes it easy to produce the reply — for example, by simply passing it an SQL statement. I’ve recently updated
ajaxReply to be able to produce replies suitable for the new YUI Get Utility. Finally, the function
BuildSql is like a
sprintf command designed for SQL, which makes it easy to build SQL statements with variables and can be used in any environment, AJAX or not.
If you’re using PHP with YUI, take a look — and feel free to leave feedback in the comments here.