PHP - Bind results from mySQL to datagrid and show to user.

darenceang
darenceang used Ask the Experts™
on
Hi!
I have a number of rows returned to the users from the database.

Is there anyway i can use something like .net datagrid.databind?

I have achieved outputting the results using table but it just doesent look nice.

Any advice?

I found form the internet that i need to buy something like this:
http://www.phpgrid.com/grid/

Any advice?
d.JPG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
I've used www.datatables.net, which is a jQuery plugin, and have been pretty happy with it. It takes a little tweaking, but has a lot of examples. It essentially runs off of JSON data, which is easily created from MySQL recordsets, and you can script updates so that they save back to the server. It's a really flexible and extensible script.

Commented:
I thoroughly reccomend www.datatables.net i have implemented it successfully on php, and .net based sites.

As pointed out it uses jQuery, and so is a tool that you can deploy on any site regardless of it's undelying architecture.

I also assist with it's development from time-to-time too when I can spare the time with it's creator.

Commented:
@BrrianMM - you assist with its development? Nice. Now I have another contact to pester if I have questions about the guts of it. :)

Author

Commented:
Hi All,

Thanks for the reply.

Sorry but i am out of coutry at the moment, can give me another 1 week before getting back to Singapore to test it out? So sorry. Will award the points accordingly then.

Thanks for the advice!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial