FN-FORUM: PHP version of ASP datagrid?

date posted 21st May 2007 11:07

Good Morning all!

Right, all of the admin features I build to edit properties, products,
courses, etc.. always are based on paginated listings which can be
filtered by a number of parameters, which then affects which rows are
returned by the MySQL query.

What I have always wondered, is how can you implement something
similar to most email clients, where you can tick ant number of rows
and then select an action from a drop-down and that action is applied
to all the rows?

I know ASP has something called datagrid, and someone has brought out
phpdatagrid, but it costs, and to be honest I would rather learn how
to build it myself.

An example of why this could be so useful. If you have a list of
pupils whose progress in a course you wish to update in bulk, then you
could select how wever many have passed by ticking the box on their
row, and then selecting "Passed" from the drop down, which would then
update all of their MySQL entries to passed.

I look forward to hearing from you with hints, tips, and ideally a
couple of links to tutorials I can work my way through.

Many thanks,

Duncan