php - 将选定的值保存在数据库中作为 id

Question

我有两个表，如图所示，当员工编辑其详细信息 department_id 在数据库中保存为 0

employee                       department
id| name|department_id     id|department_name
1 |abc  |1                  1|HR    
2 |xyz  |4                  2|Finance   
3 |asd  |3                  3|Developer      

和这个 View 部分

<tr>
    <th> Department </th>
    <td> 
        <SELECT name="department_id" style="width:180px;" >
            <?php 
            foreach($departments as $row): ?>
            <option value="<?php $employee['department_id'] ;?>"
            <?php  if ($row['id']== $stakehholder['department_id'])
            {
            echo 'selected';
            }
            ?>>
            <?php echo $row['department_name'];?>
            </option> 
            <?php endforeach ?>
        </SELECT>
    </td>
    <td> <?php echo form_error('department_id'); ?> </td>
</tr>     

编辑 0 值后存储在数据库中

Answer 1

忘记echo <option value="<?php $employee['department_id']; ?>"

<SELECT name="department_id" style="width:180px;" >
    <?php foreach($departments as $row): ?>
            <option value="<?php echo $row['department_id']; ?>"
            <?php if ($row['department_name']== $stakehholder['department_id']) {
                echo 'selected';
            }
           ?>>
        <?php echo $row['department_name']; ?>
        </option> 
        <?php endforeach ?>
    </SELECT>