March 18th, 2004, 05:53 PM
|
|
Registered User
|
|
Join Date: Jul 2002
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Answer
Here's the answer I came up with. Now, I'm just gonna post the whole code, but I needed two checkboxes per row. One for whether the user wanted the data public, and one for whether that data should also be considered "featured". I used checkboxes for both data to create a sql statement for each option. This required me to create 4 sql statements, however, which sucked.. but hey, it got the job done.
I needed to know 1) the id of the row's data, 2) whether 'public' was checked, and 3) whether 'featured' was checked. If 'featured' was checked and 'public' was not, I made sure to throw in a little extra snippit so that both 'featured' and 'public' were set to 'f'. (there can't be a featured piece of data unless it's public was my logic).
So, here it all is.
--------- the form page -------------
Code:
<?
$total_rows = 0;
foreach($items as $key => $val)
{
.............
.............
<td class="field-cell"><input name="public[<?=$val["listingID"]?>]" type="checkbox" id="public"<? if ($val["show"]=='t') { echo " checked"; } ?>></td>
<td class="field-cell"><input name="featured[<?=$val["listingID"]?>]" type="checkbox" id="featured"<? if ($val["featured"]=='t') { echo " checked"; } ?>></td>
<? $allIDs = $allIDs.'|'.$val["listingID"] ?>
</tr>
<?
$total_rows++;
}
............
............
<input type="hidden" name="allIDs" value="<?=$allIDs?>">
<input type="hidden" name="total_rows" value="<?=$total_rows?>">
<input class="buttons" name="save" type="submit" id="save" value="Save Changes">
--------- The processing page ---------------
PHP Code:
// create the sql string dynamically here
$allIDs = substr($_POST["allIDs"],1); // Trim off first pipe (|)
$allIDs = explode("|",$allIDs); // Put all the id numbers on the page into an array
// First do the public checkboxes
foreach ($allIDs as $key => $val) { // iterate through all the ids
if (isset($_POST['public']) && array_key_exists($val,$_POST['public'])) {
// this id is checkmarked
$sql.=" or `listingID`=$val";
} else {
// an ID is missing from the post, so include it in the sql changing it to false
$sql2.=" or `listingID`=$val";
}
}
// Now do it for the featured
foreach ($allIDs as $key => $val) { // iterate through all the ids
if (isset($_POST['featured']) && array_key_exists($val,$_POST['featured'])) {
// this id is checkmarked, but we need to set featured='f' if public=='f'
if (!isset($_POST['public']) || !array_key_exists($val,$_POST['public'])) {
$sql4.=" or `listingID`=$val";
} else {
$sql3.=" or `listingID`=$val";
}
} else {
// an ID is missing from the post, so include it in the sql changing it to false
$sql4.=" or `listingID`=$val";
}
}
// Now finish and run the statements
if ($sql) { // finish the sql string to set public='t'
$sql = substr($sql,4);
$sql = "UPDATE `table` SET `public`='t' WHERE (".$sql.");
// run it through the db
$affected1 = $db->update($sql);
//echo "<br />".$sql;
}
if ($sql2) { // finish the sql string to set public='f'
$sql2 = substr($sql2,4);
$sql2 = "UPDATE `table` SET `public`='f' WHERE (".$sql2.");
// run it through the db
$affected2 = $db->update($sql2);
//echo "<br />".$sql2;
}
if ($sql3) { // finish the sql string to set featured='t'
$sql3 = substr($sql3,4);
$sql3 = "UPDATE `table` SET `featured`='t' WHERE (".$sql3.");
// run it through the db
$affected3 = $db->update($sql3);
//echo "<br />".$sql3;
}
if ($sql4) { // finish the sql string to set featured='f'
$sql4 = substr($sql4,4);
$sql4 = "UPDATE `table` SET `featured`='f' WHERE (".$sql4.");
// run it through the db
$affected4 = $db->update($sql4);
//echo "<br />".$sql4;
}
BTW, if you're wondering about the $db->update($sql); stuff, that's an object I created to make things a bit easier for myself. Just execute the $sql and it will work for you fine.
Enjoy.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
