CODEWITHSUNDEEP
phpmysqlcodeigniter
SoftwareDev
SoftwareDev

Reputation: 356

save selected value in database as id

i have two tables as shown, when employee edits its details department_id save as 0 in database 

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

and this view part 

<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>

after edit 0 value get store in database

Upvotes: 3

Views: 895

Answers (3)

Manoj Sharma
Manoj Sharma

Reputation: 616

you have forgot to echo department_id in option value attribute and second you are comparing name to id which never match if id is int and name not.

try this updated code:

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

Upvotes: 1

Rana Soyab
Rana Soyab

Reputation: 896

forget 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>

Upvotes: 4

Ajit Singh
Ajit Singh

Reputation: 1150

updated line is in as below

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






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

Upvotes: 1

Related Questions