欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

select-php如何读取下拉菜单选中数据

程序员文章站 2024-02-07 19:21:40
...
selectphp下拉菜单

$con = mysqli_connect($db_hostname,$db_username,$db_password,$db_database);if (!$con) die("Unable to connect to MySQL: ".mysqli_connect_error());$query = "select * from tutorials";$result = mysqli_query($con,$query);$result || die("Database access failed: ".mysqli_error($con));$rows = mysqli_num_rows($result);while ($row = mysqli_fetch_assoc($result)) {    echo "Day: ", $row["day"],"
\n"; echo "Time: ", $row["time1"],"
\n"; echo "Available: ", $row["available2"],"
\n"; echo "Time: ", $row["time2"],"
\n"; echo "Available: ",$row["available"],"

\n";}

?>

Please choose a day from above timetable:


Select a day
$query = "select day from tutorials";
$result = mysqli_query($con,$query);
$result || die("Database access failed: ".mysqli_error($con));
while ($rows = mysqli_fetch_assoc($result)) {
?>

Please choose one time:


Select a time
if(isset($_POST['submit']))
$day = $_POST['selectDay'];
echo "The day is $day";
$query = "select time1 from tutorials where day='$day'";
$result = mysqli_query($con,$query);
$result || die("Database access failed: ".mysqli_error($con));
?>