php 下拉菜单选择后读取数据库,php – 将下拉菜单中的多个值保存到数据库中

我有一个包含下拉列表的表单.我希望该用户应该能够从该下拉列表中选择多个值

Name

Address

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "db";

// Create connection

$con = mysqli_connect($servername, $username, $password, $dbname);

// Check connection

if (!$con) {

die("Connection failed: " . mysqli_connect_error());

}

echo "Student";

echo "

";

$sql = "SELECT student FROM student";

$result = $con->query($sql);

echo "";

while($row = $result->fetch_assoc()) {

echo "" . $row['student'] . "";

}

echo "";

echo"

";

?>

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "db";

// Create connection

$con = mysqli_connect($servername, $username, $password, $dbname);

// Check connection

if (!$con) {

die("Connection failed: " . mysqli_connect_error());

}

echo "Subject";

echo "

";

$sql = "SELECT subject FROM subject";

$result = $con->query($sql);

echo "";

while($row = $result->fetch_assoc()) {

echo "" . $row['subject'] . "";

}

echo "";

echo"

";

?>

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "db";

// Create connection

$con = mysqli_connect($servername, $username, $password, $dbname);

// Check connection

if (!$con) {

die("Connection failed: " . mysqli_connect_error());

}

echo "Hobby";

echo "

";

$sql = "SELECT hobby FROM hobby";

$result = $con->query($sql);

echo "";

while($row = $result->fetch_assoc()) {

echo "" . $row['hobby'] . "";

}

echo "";

echo"

";

?>

add.php

include('admin_session.php');

$con=mysqli_connect("localhost","root","","db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$name = mysqli_real_escape_string($con, $_POST['name']);

$address = mysqli_real_escape_string($con, $_POST['address']);

$student = mysqli_real_escape_string($con, $_POST['student']);

$subject = mysqli_real_escape_string($con, $_POST['subject']);

$hobby = mysqli_real_escape_string($con, $_POST['hobby']);

$sql="INSERT INTO class (name,address,student,subject,hobby) VALUES ('$name','$address','$student','$subject''$hobby')";

if (!mysqli_query($con,$sql)) {

die('Error: ' . mysqli_error($con));

}

header("Location: list.php");

mysqli_close($con);

exit;

?>

我希望在从下拉列表中选择多个值后,它们应该保存在具有名为class的表的数据库中.表名为class的视图是

id name address student subject hobby

1 a s t y j

2 b d i g d

问题是,虽然我能够选择多个值,但只有单个值存储在数据库中

P.S我想我应该以更好的方式解释我的问题,所以我更新了我的帖子