mysql数据的下拉菜单 - Dropdown menu from mysql data

Dropdown menu from mysql data

本文关键字：下拉菜单数据 mysql | 更新日期: 2023-09-27

我有这个代码：

<?php
session_start();
include_once 'include/dbconnect.php';
if(!isset($_SESSION['user']))
{
header("Location: ../index.php");
}
$dropdown = mysql_query("SELECT * FROM carros_real WHERE real_dono='".$_SESSION['user']."'");
while ($drop_row = mysql_fetch_array($dropdown)){
echo "<select>";
echo "<option value='".$drop_row['real_id']."'>" . $drop_row['real_marca'] .     "</option>";
echo "</select>";
}
?>

结果如下：http://prntscr.com/9d1vpg

好吧，我打算做的是opsite。。。我需要一个所有汽车的列表，我想把$drop_row['ral_id']发送到$var。我在这里缺少什么？感谢

<?php
session_start();
include_once 'include/dbconnect.php';
if(!isset($_SESSION['user']))
{
 header("Location: ../index.php");
}
$dropdown = mysql_query("SELECT * FROM carros_real WHERE real_dono='".$_SESSION['user']."'");
  echo "<select>";
while ($drop_row = mysql_fetch_array($dropdown)){
echo "<option value='".$drop_row['real_id']."'>" . $drop_row['real_marca'] .     "</option>";
 }
 echo "</select>";
 ?>