Editing multiple records

[Anon]

I'm writing a script that allows mass-editing of records (this table only has 3 fields, so it's tedious doing them one at a time).

I'm just after some opinions on the best way to do this. The only way I can thin of is to prefix all the form variables with the id, so I'd have

<INPUT TYPE=TEXT NAME=123_title VALUE=ddd><INPUT TYPE=TEXT NAME=123_path VALUE=ddd><BR><BR>

<INPUT TYPE=TEXT NAME=124_title VALUE=eee><INPUT TYPE=TEXT NAME=124_path VALUE=eee>

etc., but this would be a little messy on the other side. Any suggestions? I'd also like to add a few blank rows on the end, so records can be added if needed (tho since this will only be about 5, I can just call these new_1 new_2 etc., it's the hundreds out the db i'm worred about!)

Thanks,

Danny

[[deleted]]

First, if this is really just for maintenance, you may want to get yourself a decent frontend, such as phpmyadmin or mysqlfront for MySQL. There are frontends for nearly every database type.

Second, you can simply use arrays:

<input type=text name="title[]" value="ddd">

Add one hidden field per row, to store the record_id of the record:

<input type=hidden name="recordid[]" value="2">

If you do that for every row, you will end up with several arrays. You can find the record id in the 'recordid' array, and rest of the data is scattered accross the other arrays, but at the same index:

third record from the form:
recordid = $recordid[2];
title = $title[2];
path = $path[2];

etc.

[Anon]

I have phpMyAdmin (couldn't live without it!), but this is for the administration of part of a site.

Would something like this work?

while ($id = array_shift($recordid)) {
$title = array_shift($title);
$path = array_shift($path);

// update database bit here

}

I haven't got php working properly on my laptop yet, so I can't test it.

Whenever I post here, I always seem to get helpful replies from you Vincent, so if I haven't already said thanks, Thank You. You've been a lot of help!!

[[deleted]]

You can just look through it, no need to use array_shift or any of that. A simple FOR loop will do.

you're welcome.

[Anon]

heh! of course I can! Duh!

Cheers!