我正在尝试使用HTML,PHP和MYSQL从数据库中提取数据并以形式显示(稍后进行编辑(。此时,我只是尝试提取该数据并以表单显示它。(我稍后会担心更新(。我提取数据,但文本框中没有显示任何内容:
<?php
$con = mysqli_connect("XXXXX"); //removed for privacy
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$query="select * from VOLUNTEER";
echo '$query';
$result = mysqli_query($con, $query);
echo "<table>";
if ($result)
{
while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
{
echo '<form method = "post" action="insertvolunteer.php">';
echo '<tr>';
echo '<td>First Name:</td>';
echo '<td>' . '<input type=text name=FirstName' . $row["FirstName"] . '</td>';
echo '<td>' . '<input type=hidden name=VolunteerId' . $row["VolunteerId"] . '</td>';
echo '</tr>';
}
}
echo "</form>";
echo "</table>";
mysqli_close($con);
?>
文本框
数据需要在value
上显示为
echo '<td><input type="text" name="FirstName" value="'.$row["FirstName"].'"></td>';
连接.php
<?php
$server = "server";
$user = "user";
$password = "password";
$bd = "yourbd";
$connect = mysql_connect($server, $user, $password);
$connect = mysql_select_db("$bd", $connect);
if (!$connect){
echo mysql_error(); exit;
}
?>
名称文件.php
<?php
include('connect.php');
$select = mysql_query("select * from VOLUNTEER");
while ($show = mysql_fetch_assoc($select)):
echo "<table>";
echo "<form method = 'post' action='insertvolunteer.php'>";
echo '<tr>';
echo '<td>First Name:</td>';
echo '<td><input type="text" name="FirstName" value="'.$show["FirstName"].'"></td>';
echo '<td><input type="text" name="FirstName" value="'.$show["VolunteerId"].'"></td>';
echo '</tr>';
echo "</form";
echo "</table>";
endwhile;
?>
创建 MySQL 查询时,需要声明这一点。如何?
$var ="从某处选择 *";错
$var = mysql_query("从某处选择 *"(;右
'n 在 echo '<td>' . '<input type=text name=FirstName' . $row["FirstName"] . '</td>';
中,您需要关闭标签。也不需要单独的<td>
<input>
.
尝试类似:)
@update 我意识到你得到了所希望的。干杯。