CODEWITHSUNDEEP
php
Arun Kumar
Arun Kumar

Reputation: 11

How to display selected Multiple dropdown values in edit page php

i'm getting one problme.i'm unable to display selected dropdon values in edit form.while adding i'm storing dropdon values with , seperated in database field.

code:
 <select name='weekoff[]' id='weekoff' multiple>
                          <option value="Monday">Monday</option>
                          <option value="Tuesday">Tuesday</option>
                          <option value="Wednesday">Wednesday</option>
                          <option value="Thursday">Thursday</option>
                           <option value="Friday">Friday</option>
                            <option value="Saturday">Saturday</option>
                             <option value="Sunday">Sunday</option>
                        </select>

if(isset($_REQUEST['weekoff'])){
  $dbCheckbox = implode(',',$_REQUEST['weekoff']);
}

database Storing Format:Monday,Sunday

how to display selected values in edit form:
edit.php:
<?php 
                                       // $dbCheckbox = explode(',',$row['UNIT_WEEKOFF']);
                                       $weekendArr = array();
                                       $weekendArr[] =$row['UNIT_WEEKOFF'];

                    //print_r($weekendArr);
                    $weekendArr = explode(",",$weekendArr) ;
                    //echo $weekendArr;
                                      ?>
                                  <select name='weekoff[]' id='weekoff' multiple>
    <option value="Monday" <?php echo (isset($weekendArr) && in_array('Monday', $weekendArr) ) ? "selected" : "" ?>>Monday</option>
    <option value="Tuesday" <?php echo (isset($weekendArr) && in_array('Tuesday', $weekendArr) ) ? "selected" : "" ?>>Tuesday</option>
    <option value="Wednesday" <?php echo (isset($weekendArr) && in_array('Wednesday', $weekendArr) ) ? "selected" : "" ?>>Wednesday</option>
    <option value="Thursday">Thursday</option>
    <option value="Friday">Friday</option>
    <option value="Saturday">Saturday</option>
    <option value="Sunday">Sunday</option>

Upvotes: 0

Views: 8092

Answers (1)

Sunil Pachlangia
Sunil Pachlangia

Reputation: 2071

Hope this will help you

Suppose you are retrieving data from DB like

$weekendArr = array(); //First define blank array so you will fill it with your DB values
while($row = mysql_fetch_assoc($query)){
   $weekendArr[] = $row['weekoff']; 
}
$weekendArr = explode(",",$weekendArr) ;

Then use this array like 

<select name='weekoff[]' id='weekoff' multiple>
        <option value="Monday" <?php echo (isset($weekendArr) && in_array('Monday, $weekendArr) ) ? 'selected="selected"' : "" ?>>Monday</option>
        <option value="Tuesday" <?php echo (isset($weekendArr) && in_array('Tuesday, $weekendArr) ) ? 'selected="selected"' : "" ?>>Tuesday</option>
        <option value="Wednesday" <?php echo (isset($weekendArr) && in_array('Wednesday, $weekendArr) ) ? 'selected="selected"' : "" ?>>Wednesday</option>
        <option value="Thursday">Thursday</option>
        <option value="Friday">Friday</option>
        <option value="Saturday">Saturday</option>
        <option value="Sunday">Sunday</option>
</select>

Apply this to every option.

Upvotes: 1

Related Questions