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

date posted 21st May 2007 12:05

This is very simple, just have a selection of checkboxs all named example
"uid" with the value of each row id as the value.
When submitted only the checked ids will be passed as a comma delimited
string "1,5,56,300,459,etc" and you can split the data and create a SQL
string to alter your database based on the id's passed.

For example in ASP you can simply do

for i=1 to Request.form("uid").count
theSQL = theSQL & "id=" & clng(Request.form("images")(i)) & " OR "
next

in PHP you can probably do something very similar.


Regards
Sam Morgan
WiredEyes Media / ServWise Advanced Hosting
tel (Uk): +44 (0)20 7100 2178
tel (Italy): +39 070 773 6543
web : www.wiredeyes.com / www.servwise.com
----
umop ap!sdn w,! aw dlaH


> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
> Duncan Glendinning
> Sent: Monday, May 21, 2007 12:14 PM
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: PHP version of ASP datagrid?
>
>
> 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
>
> --
> 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
>
>