Re: FN-FORUM: PHP version of ASP datagrid?

date posted 21st May 2007 11:39

On Mon, May 21, 2007 at 10:14:16AM -0000, Duncan Glendinning wrote:
>
> 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.
>

I can recommend the pager from the Pear repository:

http://pear.php.net/package/Pager/

This has a link to a .net - style datagrid, which I haven't used:

http://pear.php.net/package/Structures_DataGrid/

That should get you started. Bulk-updating students shouldn't be too tricky
from there, though probably a bit more low-level in php than .net.

Graham

> Many thanks,
>
> Duncan
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>