mysql php jquery hide show select

Question

I know a little bit of PHP programming, but none of JQuery. I have build a <select> dropdown menu with data from MySql db. But now I want a button or something next to the <select> option, like a + sign or something that will give me a extra <select> option. And that this can come as many time as you want.

Ps. I'm sorry for my English.

Here is a picture of how I want this to be.

and then next you will get this. And here is the code what I already have made.

<?php

    $conn = new mysqli('localhost', 'username', 'password', 'database') 
    or die ('Cannot connect to db');

    $result = $conn->query("select id, name from table");

    echo "<html>";
    echo "<body>";
    echo "<select name='id'>";

    while ($row = $result->fetch_assoc()) {
        unset($id, $name);
        $id = $row['id'];
        $name = $row['name']; 
        echo '<option value="'.$id.'">'.$name.'</option>';         
    }

    echo "</select>";
    echo "</body>";
    echo "</html>";
?>

The easiest way would be to use something like Bootstrap multiselect — Artur Filipiak
– Artur Filipiak, Commented May 22, 2016 at 10:46

Mujahidh · Accepted Answer · 2016-05-22 12:57:53Z

1

You can use check box instead of dropdown for multiple selection

while ($row = $result->fetch_assoc()) {
    unset($id, $name);//use if you want
    $id = $row['id'];
    $name = $row['name']; 

    echo '<input name="city[]" type="checkbox" value="'.$name.'" />'.$name;
}

edited May 22, 2016 at 12:57

answered May 22, 2016 at 10:26

Mujahidh

4704 silver badges21 bronze badges

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

10 Comments

Artur Filipiak Over a year ago

Yes, for a couple of cities... Imagine how it would looks like with hundreds of cities :-)

Mujahidh Over a year ago

yes you made me thinking @artur filipak.Any idea to help to implement this?

Mujahidh Over a year ago

Please check this answer for jquery stackoverflow.com/questions/18421988/…

Mujahidh Over a year ago

To which php file you want to send this value

Mujahidh Over a year ago

Let us continue this discussion in chat.

|

Collectives™ on Stack Overflow

mysql php jquery hide show select

1 Answer 1

10 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related