PHP $_POST from Multiple Dropdown Box Form Submit

Question

I already use multiple dropdown box with data from MySQL database, but I face problem when I try to $_POST it. This is the code I use:

<?php try {
    $dbo = new PDO('mysql:host=' . $dbhost_name . ';dbname=' . $database, $username, $password);
} catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
}

                        $sql = "SELECT city FROM dropdown";?>
                          
                        <select name="cities" multiple="multiple">
                          
                        <?php foreach ($dbo->query($sql) as $row) {
                        echo "<option value=>$row[city]</option>";
                        }                        
                        ?>
                            
                        </select></td>

This is the code I try to call it:

$test = $_POST['cities'];
echo $test;

The data successfully imported from database but it's doesn't $_POST

Darren · Accepted Answer · 2016-01-14 00:04:23Z

3

Make sure your form method is set to POST.

<form action="..." method="post">

And also, you're best to set the select name as an array to store said selections:

<select name="cities[]" multiple="multiple">

Not to mention that your actual options within this select need values...otherwise they'd come up empty.

<option value="YOUR VALUE HERE..">...</option>

answered Jan 14, 2016 at 0:04

Darren

13.1k4 gold badges44 silver badges81 bronze badges

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

3 Comments

Samir Junaid Over a year ago

Thnx, It's work when I add value: echo "<option value=$row[city]>$row[city]</option>";

Darren Over a year ago

Did you do the other stuff I showed you? Change cities to cities[] then Loop through -> foreach($_POST['cities'] as $city) { echo $city; }

Darren Over a year ago

@SamirJunaid perfect!

Lenra · Accepted Answer · 2016-01-14 00:43:26Z

0

Use Post Method

<form action="..." method="post">

answered Jan 14, 2016 at 0:43

Lenra

11 bronze badge

Collectives™ on Stack Overflow

PHP $_POST from Multiple Dropdown Box Form Submit

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related