单击并获取某个单元格的表格数据(Click and get table data of certain cell)

单击并获取某个单元格的表格数据(Click and get table data of certain cell) mysql

我有一个表，其中每一行都有一个按钮来查看记录，当我单击该按钮时，我想发送该行的记录ID并将其存储在变量中。

这是我到目前为止所拥有的

foreach($result as $row) { echo "<td> <form method='post'><input name='viewticket' type='submit' id='viewticket' value='View Ticket' class='btn btn-xs btn-danger'/></form></td>"; echo "<td>".$row['isopen']."</td>"; echo "<td>".$row['title']."</td>"; echo "<td>".$row['id']."</td> </tr>"; } if($_POST['viewticket']){ $theid= //not sure how it would work }

以下是UI的外观：

http://imgur.com/uEh37rW

I have a table where each row have a button to view a record, when I click that button I want to send the record id of that row and store it in a variable.

Here is what I have so far

foreach($result as $row) { echo "<td> <form method='post'><input name='viewticket' type='submit' id='viewticket' value='View Ticket' class='btn btn-xs btn-danger'/></form></td>"; echo "<td>".$row['isopen']."</td>"; echo "<td>".$row['title']."</td>"; echo "<td>".$row['id']."</td> </tr>"; } if($_POST['viewticket']){ $theid= //not sure how it would work }

Here is how the UI looks like:

http://imgur.com/uEh37rW

最满意答案

你可以插入一个

"<input type='hidden' name='selectedID' value='" + $row['id'] + "'/>"

进入表单，然后你有$ _POST ['selectedID']中的ID：

foreach($result as $row) { echo "<td> <form method='post'><input name='viewticket' type='submit' id='viewticket' value='View Ticket' class='btn btn-xs btn-danger'/>"; echo "<input type='hidden' name='selectedID' value='" + $row['id'] + "'/></form></td>"; echo "<td>".$row['isopen']."</td>"; echo "<td>".$row['title']."</td>"; echo "<td>".$row['id']."</td> </tr>"; } } if($_POST['viewticket']){ echo $_POST['selectedID']; }

You could insert a

"<input type='hidden' name='selectedID' value='" + $row['id'] + "'/>"

into the form, then you have the ID in $_POST['selectedID']:

foreach($result as $row) { echo "<td> <form method='post'><input name='viewticket' type='submit' id='viewticket' value='View Ticket' class='btn btn-xs btn-danger'/>"; echo "<input type='hidden' name='selectedID' value='" + $row['id'] + "'/></form></td>"; echo "<td>".$row['isopen']."</td>"; echo "<td>".$row['title']."</td>"; echo "<td>".$row['id']."</td> </tr>"; } } if($_POST['viewticket']){ echo $_POST['selectedID']; }