duanfu4446 2015-03-06 06:00
浏览 55
已采纳

如何使用SQL查询生成的按钮获取id / name onclick?

I am creating a table from a MySQL database. Currently, I can manually enter the Course ID, then click 'select' to display a roster based on the Course ID entered.

However, I would like to streamline this with buttons on the right side of the table after each row. What is the best way to do this? I can provide a screenshot, but I still need more reputation.

So the code for generating this table is as follows.

<?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>

Thanks for looking at this!

  • 写回答

2条回答 默认 最新

  • dongyong8098 2015-03-06 06:10
    关注

    You could have something like

    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>";
        ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗