我已经看到了至少几个关于这个重复的问题，但由于某种原因，我无法获得数据显示在菜单中。下拉菜单是空白的。
表是"Colleges2"。我试图获取的数据在一个名为"名称"的列中。因此，它基本上从Colleges2表中获取并显示一个名称列表。
mysql_connect('localhost', '', '') or die(mysqli_error()) ;
mysql_select_db('Colleges2');
$sql = "SELECT Name FROM Colleges2";
$result = mysql_query($sql);
?>
<select name="Name" id="">
<?php
while ($row = mysql_fetch_array($result)) {
$Name = $row['Name'];
echo "<option value='" .$row['Name']. "'>" .$row['Name']. "</option>";
} ?>
</select>
我可能没有使用最新的mysql代码....请原谅我。我一直看到使用mysql或mysqli的帖子和教程。
更新:
<?php
$sql = "SELECT Name FROM Colleges2";
$conn = new mysqli("localhost", "", "") or die("Failure!") ;
$stmt=$conn->query($sql);
?>
<select name="Name" id="">
<?php
while ($row = $stmt->fetch_assoc() ) {
$Name = $row['Name'];
echo "<option value='" .$Name. "'>" .$Name. "</option>";
} ?>
</select>
第二次更新(这个有效):
<?php
//$host = "localhost:3306";
//$db_name="univers1_test";
//$user = "univers1_admin";
//$pass = "B@ctad89";
//$conn = new mysqli($host, $user, $pass, $db_name) or die("DB Connection failed!!");
mysql_connect("localhost:3306", "", "") or die(mysql_error()) ;
mysql_select_db("univers1_test") or die(mysql_error()) ;
$sql = "SELECT Name FROM Colleges2";
$result = mysql_query($sql) or die(mysqli_error()) ;
//$stmt=$conn->query($sql);
?>
<select name="Name" id="">
<?php
while ($row = mysql_fetch_array($result)) {
?>
<option value="<?php $row['Name']; ?>"><?php echo $row['Name']; ?> </option>
<?php
} ?>
</select>
如何使用PDO或MySQLi
PDO
<?php
$host = "localhost";
$db_name="Colleges2";
$user = "";
$pass = "";
$sql = "SELECT Name FROM Colleges2";
$conn = new PDO("mysql:host=$host;dbname=$db_name",$user,$pass) or die("DB Connection failed!!");
$stmt = $conn->prepare($sql);
$stmt->execute();
?>
<select name="Name" id="">
<?php
while ( $row = $stmt->fetch(PDO::FETCH_ASSOC) ) {
$Name = $row['Name'];
echo "<option value='" .$Name. "'>" .$Name. "</option>";
} ?>
</select>
MySQLi
<?php
$host = "localhost";
$db_name="Colleges2";
$user = "";
$pass = "";
$sql = "SELECT Name FROM Colleges2";
$conn = new mysqli($host, $user, $pass, $db_name) or die("DB Connection failed!!");
$stmt=$conn->query($sql);
?>
<select name="Name" id="">
<?php
while ( $row = $stmt->fetch_assoc() ) {
$Name = $row['Name'];
echo "<option value='" .$Name. "'>" .$Name. "</option>";
} ?>
</select>
<?php
mysql_connect('localhost', '', '') or die(mysqli_error()) ;
mysql_select_db('Colleges2');
$sql = "SELECT Name FROM Colleges2";
$result = mysql_query($sql) or die(mysqli_error()) ;
?>
<select name="Name" id="">
<?php
while ($row = mysql_fetch_array($result)) {
?>
<option value="<?php echo $row['Name']; ?>"> <?php echo $row['Name']; ?> </option>
<?php
} ?>
</select>