我正在从MySQL数据库创建一个表。目前,我可以手动输入课程ID,然后单击"选择"以显示基于输入的课程ID的名册。
然而,我想通过每行后面表格右侧的按钮来简化这一点。最好的方法是什么?我可以提供一张截图,但我仍然需要更多的声誉。
因此,生成该表的代码如下。
<?php
// Connection information to database has been removed.
// $Row[1] - first name of faculty
// $Row[2] - last name of faculty
// $fieldRow[0] - course ID
// $fieldRow[1] - course name
// $fieldRow[2] - course year
// $fieldRow[3] - number of units
echo "<table>
<caption>....for " . $Row[1] . " " . $Row[2] . "</caption>
<tr>
<th>Course ID</th>
<th>Course Name</th>
<th>Course Year</th>
<th>Units</th>
</tr>";
while ($fieldRow = mysqli_fetch_row($result2))
{
echo "<tr><td>" . $fieldRow[0] . "</td>
<td>" . $fieldRow[1] . "</td>
<td>" . $fieldRow[2] . "</td>
<td>" . $fieldRow[3] . "</td>
<td><button name='" . $fieldRow[0] . "'>Select</button></td>
</tr>";
}
echo "</table>";
?>
<form method="get" action="class.php">
<p>Enter Course ID
<input autofocus="autofocus" tabindex="1" type="text" maxlength="5" name="classSelect" title="Enter Class Number" />
</p>
<p>
<button tabindex="2" type="submit">Select</button>
</p>
</form>
谢谢你看这个!
你可以有类似的东西
if(isset($_GET['id'])
{
$course_id = intval($_GET['id']);
// Do your query against the course id.
}
while ($fieldRow = mysqli_fetch_row($result2))
{
echo "<tr><td>" . $fieldRow[0] . "</td>
<td>" . $fieldRow[1] . "</td>
<td>" . $fieldRow[2] . "</td>
<td>" . $fieldRow[3] . "</td>
<td><a href='" . ?id=$fieldRow[0] . "'>Select</a></td>
</tr>";
}
echo "</table>";
?>
您可以使用JQuery来完成
在您的代码中
echo "<tr><td>" . $fieldRow[0] . "</td>
<td>" . $fieldRow[1] . "</td>
<td>" . $fieldRow[2] . "</td>
<td>" . $fieldRow[3] . "</td>
<td><button name='" . $fieldRow[0] . "' class='selecter'>Select</button></td>
</tr>";
并添加一个类似的头
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<script>
$(document).ready(function(){
$(".selecter").click(function(){
$("input").val($(this).attr("name"));
});
});
</script>
</head>
完整代码
<html>
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<script>
$(document).ready(function(){
$(".selecter").click(function(){
$("input").val($(this).attr("name"));
});
});
</script>
</head>
<body>
<?php
// Connection information to database has been removed.
// $Row[1] - first name of faculty
// $Row[2] - last name of faculty
// $fieldRow[0] - course ID
// $fieldRow[1] - course name
// $fieldRow[2] - course year
// $fieldRow[3] - number of units
echo "<table>
<caption>....for " . $Row[1] . " " . $Row[2] . "
</caption>
<tr>
<th>Course ID</th>
<th>Course Name</th>
<th>Course Year</th>
<th>Units</th>
</tr>";
while ($fieldRow = mysqli_fetch_row($result2))
{
echo "<tr><td>" . $fieldRow[0] . "</td>
<td>" . $fieldRow[1] . "</td>
<td>" . $fieldRow[2] . "</td>
<td>" . $fieldRow[3] . "</td>
<td><button name='" . $fieldRow[0] . "' class='selecter'>Select</button></td>
</tr>";
}
echo "</table>";
?>
<form method="get" action="class.php">
<p>Enter Course ID
<input autofocus="autofocus" tabindex="1" type="text" maxlength="5" name="classSelect" title="Enter Class Number" />
</p>
<p>
<button tabindex="2" type="submit">Select</button>
</p>
</form>
</body>
</html>