php - Not sure why drop down box is not populating the data or selection ← (PHP, CodeIgniter)

one text

Solution:

I'm not very experienced with CodeIgniter but the code you have provided looks very similar to PHP procedural programming methods

I'm not sure why you have the following code in there. Not sure if it is needed to be honest?

$Scheduled_Area=$e->Scheduled_Area; 

I think where your issue lies is your named array. It currently is $db, I would change it from $db as $db is often already defined within MVC software packages for database purposes and it could be causing a conflict. Try renaming it to see if that helps at all.

Also, nowhere within your code is $department defined so, that may be another issue why things aren't working.

I hope you don't mind but I have tidied your code a little for you, its good practice to concatenate php variables and strings. I have also greatly reduced the amount of php tags you were using for readibility purposes :)

<div class="form-group">
    <label class="col-sm-7 control-label">Scheduled Area</label><br>
    <?php
        $Scheduled_Area = $e->Scheduled_Area; 
        $options = array("Outbound","Inbound","Claims");
    ?>
    <div class="col-md-5">
        <select name="Scheduled_Area" class="form-control">
        <?php
            // Define $department here or the 'selected' attribute will not work
            foreach($options as $option){ 
                if($department == $option){
                    echo "<option value='".$option."' selected='selected'>".$option."</option>";
                }
                else{
                    echo "<option value='".$option."'>".$option."</option>";
                }
            }
        ?>
        </select>
    </div>
</div>