update multiple

twitch

Hello again my friends. Got something I've been working on all day and I finally gave in and decided to post. I have the row below that is a repeating row grabbing the values from an employee table. The company wants to add the ability to change the projectAccess of multiple employees from this page that used to just show all the info and then you could click the edit button to change the info. I have added a radio button that reflects the proper access yes or no being selected depending on the employee's access status, but I'm stuck as to how to update them all at once. I assume I just put a <form action="update-access.php" method="post"></form> tag around the whole table with a update button.

echo "<tr $color><td>$idnum</td><td>$prid</td>"
            ."<td>$lname</td><td>$fname</td><td>$type</td>"
            ."<td>$salary</td><td>$location</td><td>$supervisor_fullname</td><td>";
			if ($projectAccess == 'Yes')  {
			print "<INPUT type=\"radio\" name=\"projectAccess".$idnum."\" value=\"Yes\" CHECKED > Yes <INPUT type=\"radio\" name=\"projectAccess".$idnum."\" value=\"No\" > No";
			}else{
			print "<INPUT type=\"radio\" name=\"projectAccess".$idnum."\" value=\"Yes\" > Yes <INPUT type=\"radio\" name=\"projectAccess".$idnum."\" value=\"No\" CHECKED > No";
			}
print "</td>";
            print "<td><a href=edit-user/?id=$idnum><img src=note.gif alt=edit ";
            print "border=0></a></td></tr>\n";

} 
}
print "</table>\n";

In the update-access.php script I have the following just to test my connection. How do I get the value of each employee to this script and update each records? I'm sure it has something to do with arrays but to put it bluntly I suck at arrays...haha

// Connect to MySQL

$result = mysql_query("UPDATE employees SET projectAccess='value of radio button' WHERE idnum='id number of employee'") 
or die(mysql_error());

Any help would be much appreciated. Thanks in advance,
Eric

twitch

Forgot to mention, to test the update-access.php I simply put static values for projectAccess and idnum and navigated to the page to trigger it. Didn't know how to get the values from the form.

bradgrafelman

I would recommend using names like projectAccess[id] where id is the employee id number. That way, when you get to your processing script, $_POST['projectAccess'] will be an array that you can easily process like so:

foreach($_POST['projectAccess'] as $idnum => $value) {
    // run sql query here
}

twitch

Thanks for the reply Brad. You helped me out tremendously the last time I posted here.
Sorry for the delay in replying, I had a gig last night.

I'm not sure I follow what you mean on using names like projectAccess[id] On the radio buttons I added ".$idnum." cause without it, the radio buttons didn't reflect the access status from the database.

Does the part of code you posted go in the update-access.php script like so:

foreach($_POST['projectAccess'] as $idnum => $value) {
$result = mysql_query("UPDATE employees SET projectAccess='value of radio button' WHERE idnum='id number of employee'")
or die(mysql_error()); 
}

I imagine $value would go in the projectAccess='$value' but how do I extract the idnum?

Thanks again for the quick reply my friend.

halojoy

I think your inputs would look like this:

"<INPUT type=\"radio\" name=\"projectAccess[".$idnum."]\" value=\"Yes\" CHECKED > Yes 
<INPUT type=\"radio\" name=\"projectAccess[".$idnum."]\" value=\"No\" > No";
            }else{

Then the code you show in last would be correct to read those post values.

twitch

Ah ok I see, the brackets separate the name of the radio button from the idnum. When I changed the code to that and did a test and echo'd $value, I got all the projectAccess statuses of YesNoNoYes etc.

Now we're cooking. Thanks guys this site rocks! I'll let you know how it turns out and mark it resolved when/if I get it working.

twitch

Yes Yes Yes....you guys are awesome. The code below works like a champ for anyone else needing something like this:

// Connect to MySQL

foreach($_POST['projectAccess'] as $idnum => $value) {

$result = mysql_query("UPDATE employees SET projectAccess='$value' WHERE idnum='$idnum'") 
or die(mysql_error());  

}

halojoy

Good to hear 🙂
We will see when you have some other question in some new topic.
Later.

bradgrafelman

Glad we could help!

Don't forget to mark this thread resolved (if it is) using the link on the Thread Tools menu above.