Retrieving SQL database value in dropdown with multiple select option and post the values

Question

I have retrieved the database values in dropdown list with multiple select option using PHP MySQL. My code is as follows.

$sql = "SELECT student_id, name, phone FROM student";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

    echo "<select name='num' multiple >";
    while($row = $result->fetch_assoc()) {
       echo "<option value='" . "'>" . $row['name']. " " . $row['phone_number'] ."</option>";
    }
    echo "</select>";




} else {
    echo "0 results";
}

What I need is, I want to post the multiple selected phone_number values to another page. Also, Is it possible to create a checkbox before the list values?

Now am getting the output as in this image.

That seems to have manual array values. I need to retrieve the array values from sql.. — Raja
– Raja, Commented Jun 21, 2017 at 7:32

Binary Brackets · Accepted Answer · 2017-06-21 04:50:00Z

0

Change this line to :

echo "<select name='num[]' multiple >";

name should be in array format like num[] not like num

answered Jun 21, 2017 at 4:50

Binary Brackets

5041 gold badge4 silver badges12 bronze badges

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

3 Comments

Raja Over a year ago

ok. Thanks for your reply. And how can post only the selected phone_number values to another form? Moreover, Am not getting checkbox before the name or number.

Binary Brackets Over a year ago

"And how can post only the selected phone_number values to another form? Moreover, Am not getting checkbox before the name or number." where is the code for that ? and you should post another question for this.

Raja Over a year ago

echo "<option value='" . "'>" . $row['name']. " " . $row['phone_number'] ."</option>"; In this I want to select a few names and only the selected phone_number corresponding to the names has to be passed into another form or page.

Collectives™ on Stack Overflow

Retrieving SQL database value in dropdown with multiple select option and post the values

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related