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](https://github.com/davidstutz/bootstrap-multiselect) — Artur Filipiak, May 22 '16 at 10:46

Mujahidh · Accepted Answer · 2016-05-22T12:57:53.227

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 '16 at 12:57

answered May 22 '16 at 10:26

Mujahidh

428
4
19

Yes, for a couple of cities... Imagine how it would looks like with hundreds of cities :-) – Artur Filipiak May 22 '16 at 10:44
yes you made me thinking @artur filipak.Any idea to help to implement this? – Mujahidh May 22 '16 at 11:15
@mujas Thank you, I will be using your answer! But how can I sent a selected checkbox along with a contact form? – Jaesen May 22 '16 at 11:15
@artur filipiak Thanks for your answer, actually your answer is the solution to my question. But it is just for a few cities. – Jaesen May 22 '16 at 11:17
please check this answer for form submit http://stackoverflow.com/questions/18421988/getting-checkbox-values-on-submit – Mujahidh May 22 '16 at 11:23
1

Please check this answer for jquery http://stackoverflow.com/questions/18421988/getting-checkbox-values-on-submit – Mujahidh May 22 '16 at 11:23
@mujas Thanks, but this is just from a HTML form. How do I sent the data that comes from a database..? – Jaesen May 22 '16 at 11:56
1

To which php file you want to send this value – Mujahidh May 22 '16 at 11:59
@mujas it will be a contact form. – Jaesen May 22 '16 at 12:20
1

Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/112610/discussion-between-mujas-and-jaesen). – Mujahidh May 22 '16 at 12:20

mysql php jquery hide show select

1 Answers1