how to get multiple values of drop down from a loop?

Question

<?php
    // this is where selecting of number of rooms in database
    $sql = mysqli_query($con, 'SELECT * FROM roomtype');
    $get_room1 = mysqli_query ($con, "SELECT * from room where status='Activated' and type_id=2");
    $get_room2 = mysqli_query ($con, "SELECT * from room where status='Activated' and type_id=3");
    $get_room3 = mysqli_query ($con, "SELECT * from room where status='Activated' and type_id=4");
    $get_room4 = mysqli_query ($con, "SELECT * from room where status='Activated' and type_id=5");
    $standard = mysqli_num_rows($get_room1);
    $deluxe = mysqli_num_rows($get_room2);
    $family = mysqli_num_rows($get_room3);
    $regular = mysqli_num_rows($get_room4);
    // this is the loop for the drop down and it will display the number of rooms available

    while($row = mysqli_fetch_array($sql))
    {
    $a=$row['type_id'];
    $b = $row['rmtype'];
    $_SESSION['room_type'] = $row['rmtype'];
    echo '<div style="height: 300px;">';
    echo '<div style="float: left; width: 100px; margin-top: 15px; margin-left: 60px;">';
    echo "<img width=250 height=200 alt='Unable to View' src='" . $row["image"] . "'>";
    echo '</div>';
    echo '<div class="well" style="float: right; width: 780px; margin-top: 5px;">';
                echo '<div style="float: right;">';
                echo '</div>';

    echo '<br />';
    echo "<label style='margin-left: px;'>Number of rooms:";
    echo "<select name='select_no_rooms[]' value='" .$row['rmtype']." ' />";
    echo "<option> </option>";
    if ($row['rmtype']=="Standard Room")
    {
        for ($x = 1; $x<=$standard; $x++){
            echo "<option name='standard'>$x</option>";}

    }
    if ($row['rmtype']=="Deluxe Room")
    {
        for ($x = 1; $x<=$deluxe; $x++){
            echo "<option name='deluxe'>$x</option>";}

    }
    if ($row['rmtype']=="Family Room")
    {
        for ($x = 1; $x<=$family; $x++){
            echo "<option name='family'>$x</option>";}

    }
    if ($row['rmtype']=="Regular Room")
    {
        for ($x = 1; $x<=$regular; $x++){
            echo "<option name='regular'>$x</option>";} 
    }
    echo "</select>";

    }
?>

This is the design of drop down,

Denny Sutedja · Accepted Answer · 2016-10-10 01:16:15Z

1

add [ ] tag to name tag, so you will get your value in array.

<option name='deluxe[]'>$x</option>

answered Oct 10, 2016 at 1:16

Denny Sutedja

5384 silver badges17 bronze badges

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

Comments

Amol · Accepted Answer · 2016-10-10 01:39:21Z

0

First thing that I notice is that in you select statement, you cannot have value as an attribute. Please check the documentation select tag

And the option tag does not include name attribute. Please check the documentation option tag

If you want to get multiple values from a drop down list. Please check this article

answered Oct 10, 2016 at 1:39

Amol

1453 silver badges9 bronze badges

Collectives™ on Stack Overflow

how to get multiple values of drop down from a loop?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related