有人帮助我，当我进行编辑以选择时，我无法从数据库中获得价值 [英] some one help me, i cant get value from database when edit filed to select

问题描述

我已经创建了一个选择选项表单，但是在编辑时我可以从数据库中获取当前值.

I have create a select option form but when edit i can get current value from database.

 <select name="t_proyek_kd_proyek" id="t_proyek_kd_proyek" class="select-search"  />
        <option value=""></option>
        <?php 
        $t_cost=$this->db->query("select * from t_proyek ");

        foreach($t_cost->result() as $value){
          $selected= '';
          if($nm_proyek == $value->nm_proyek){
            $selected = 'selected';

          }
        ?>
          <option value="<?php echo $value->kd_proyek; ?>" <?php echo $selected;?>>
            <?php echo $value->nm_proyek; ?>
          </option>
       <?php }?>

      </select>

推荐答案

<?php 
$conn = new mysqli('SERVER NAME', 'DB USER NAEM', 'DB USER PASSWORD', 'DB NAME');
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
//set the value of which option you want to selected
$nm_proyek = '';
?>
<!-- for combobox  you should use 'multiple' -->
<select name="t_proyek_kd_proyek" id="t_proyek_kd_proyek" class="select-search" placeholder="Pilih..." multiple />
    <option value=""></option>
    <?php
    $query = $conn->query("SELECT * FROM `t_proyek`");
    while($value = $query->fetch_object()) {?>
        <option value="<?php echo $value->kd_proyek; ?>" <?php $nm_proyek == $value->kd_proyek ? "selected='selected'" : "" ?> ><?php echo $kd_proyek=$value->nm_proyek; ?></option>
    <?php }?>
</select>

这篇关于有人帮助我，当我进行编辑以选择时，我无法从数据库中获得价值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！