Select value inside a dropdown using ternary operator inside a foreach php loop

Question

How do you select a dropdown value inside a foreach loop. The code below generate time with 30 minutes gap. I cannot able to select the value from mysql database.

$sql = "SELECT * FROM batches WHERE batch_id = '$id'";
$result = mysqli_query($con, $sql);

while ($row = mysqli_fetch_array($result)) {

    // Name
    echo "<label>Batch name</label> ";
    echo "<input type=text name=name value='".$row['name']."' required> <br />";

    // Start time
    echo "<label>Start time</label> ";
    echo "<select name=starttime value=''> Start time </option>";
        $range = range( strtotime("05:00"), strtotime("21:00"), 30 * 60);
        foreach($range as $time){
            $foo = date("H:i", $time) . "</br>";
            $selected = ($foo == $row['start_time']) ? 'selected="selected"' : '';
            echo "<option value='$foo'" . $selected . ">" . $foo . "</option>";
        } // foreach
    echo "</select>";

} // while

Please help!!

'select a dropdown value inside a foreach loop' - what do you mean ? — Istiaque Ahmed
– Istiaque Ahmed, Commented Feb 25, 2018 at 16:20

ishegg · Accepted Answer · 2018-02-25 16:44:09Z

1

You are concatenating a break line (<br>) to your $foo variable, which is why the comparison fails. You don't need this break line inside a option tag either, so just get rid of it:

foreach($range as $time){
    $foo = date("H:i", $time);
    $selected = ($foo == $row['start_time']) ? 'selected="selected"' : '';
    echo "<option value='$foo'" . $selected . ">" . $foo . "</option>";
} // foreach

Also, by your comments, the start_time coming from the database contains seconds as well, so you need to format your timestamps accordingly:

$foo = date("H:i:s", $time);

edited Feb 25, 2018 at 16:44

answered Feb 25, 2018 at 16:26

ishegg

9,9973 gold badges20 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Dexter Over a year ago

It's still not selecting.

ishegg Over a year ago

What's in $row['start_time'];? It works correctly here

Dexter Over a year ago

Its a db col_name.

ishegg Over a year ago

I know, I'm asking what's in it. What's the result of var_dump($row['start_time']);?

Dexter Over a year ago

string(8) "10:00:00"

|

Collectives™ on Stack Overflow

Select value inside a dropdown using ternary operator inside a foreach php loop

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related