ShawnKEPPMOVING 2015-03-19 23:56
浏览 3708

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

<?php

$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"],"<br />\n";
    echo "Time: ", $row["time1"],"<br />\n";
    echo "Available: ", $row["available2"],"<br />\n";
    echo "Time: ", $row["time2"],"<br />\n";
    echo "Available: ",$row["available"],"<br /><br />\n";
}

?>

Please choose a day from above timetable:


Select a day
<?php
$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
<?php
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));
?>

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 多电路系统共用电源的串扰问题
    • ¥15 shape_predictor_68_face_landmarks.dat
    • ¥15 slam rangenet++配置
    • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
    • ¥15 对于相关问题的求解与代码
    • ¥15 ubuntu子系统密码忘记
    • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
    • ¥15 保护模式-系统加载-段寄存器
    • ¥15 电脑桌面设定一个区域禁止鼠标操作
    • ¥15 求NPF226060磁芯的详细资料