checkbox question

SeenGee

I have built a schedule system for a 24 hour radio station, each day there are 24 1 hour shows. I have built a system allowing all the inserts to be done, what i want to do is target specific days and choose to edit those alone afterwards(if there has been a mistake etc.). This is not a problem until the data comes to be edited, i want to allow for the client to select multiple entries to be changed(using checkboxes), these values would be passed to a page that uses these values to provide drop down forms with the appropriate content provided. The whole thing needs to be dynamic to a degree but there will always be 24 shows, i've never used checkboxes before like this, has anyone got any ideas about the best way to do this in terms of how the different checkboxes will be named and then processed in the next script. Thanks.

frizzo

yeah, i do it like this with checkboxes....

say you have a bunch of categories, or whatever, and they all have an ID in the database, you want to be able to check them and submit the form, and then have the php page do something with the ones you've checked. ...right?

suppose you have a bunch of radio stations. loop through the db to create the html form with the checkoxes, and set the html for each radio station's checkbox like this

where nn is the ID of the station from the db.

then when the form is submitted, loop through every element on the form and look for the "station" in each key. when you find it, do a string replace and remove the "station" from the key, and you end up with the ID from the db, which you can stick into an array or tack onto a sql query string, etc....

here is sample code i use to loop through the form: Change "delete_res_id" to whatever you want and set the second argument of substr() to the length of that string...

while (list($key, $val) = each($HTTP_POST_VARS)){
    if(substr($key, 0, 14) == "delete_res_id_"){
        $m_id = str_replace("delete_res_id_", "", $key);
        if(is_numeric($m_id)){
            // do something here with the ID
        }
    }
}

hope that helps.

Frizzo

SeenGee

Thanks for all the help man, what i basically want to do with the station_id's is then print an select menu with a list of dj's(i've got this sorted already), for the records that are not to be updated i still want them to be displayed but non editable. How would i incoroporate (esentially an else statement) this into your loop?

Thanks again.

frizzo

Thanks for all the help man,

You're welcome

what i basically want to do with the station_id's is then print an select menu with a list of dj's(i've got this sorted already), for the records that are not to be updated i still want them to be displayed but non editable. How would i incoroporate (esentially an else statement) this into your loop?

There's lots of ways you could approach it. I try to keep the code clean to use for next time. so what I'd do is make a list of ID's, yuou could stick them into an array. then when the code is done looping through the form, you have your array of selected ID's. then loop through your DJ list to create the select dropdown, and for each DJ, check to see if that DJ's ID is in the array. If so then add that dj to the select list...

$checked_djs = array();
while (list($key, $val) = each($HTTP_POST_VARS)){ 
    if(substr($key, 0, 6) == "dj_id_"){ 
        $m_id = str_replace("dj_id_", "", $key); 
        if(is_numeric($m_id)){ 
            // do something here with the ID
            array_push($checked_djs, $m_id); 
        } 
    } 
}


// now loop through the array of djs you have set up earlier 

$out = "<select name=djdropdown>";

foreach($djs as $d){
    //check to see if the dj is among those checked...
    $m_id=$d->get_id() // or from the database, whatever...
    if(in_array($m_id, $checked_djs){
        $out .="<option value=$m_id>Wolfman Jack</option>";
    }   

}

$out .="</select>";

frizzo