dongyi5570 2016-04-07 13:14
浏览 35
已采纳

如何将特定数据库记录发送到其他文件

My question is regarding the ability to update a certain record by choosing a single record from a table and going to that selected record in another page with the full data. I know I would have to create another file with all of the input fields I need, but my question is how do I get there and send over the data info that I selected, then how do I echo out that information and allow the record to be updated?

Let's say I have a table called "Products" that looks like this:

ID Name Amount

1 Shoes $10 Edit

2 Hats $5 Edit

If I click the "Edit" Button next to "Shoes" I want to go to a different page which allows me to edit all of the information for that record selected.

  <form method="POST">
   <input name="first" placeholder="First Name">
   <input name="last" placeholder="Last Name">
   <input name="product" placeholder="Product">
   <button name="add" type="submit">Add</button>
</form>
</div>
<hr>
<table>
<thead>
   <tr>
      <th>ID</th>
      <th>Name</th>
      <th>Amount</th>
      <th></th>
   </tr>
</thead>
<tbody>
   <?php
      $stmt = $dbc->query("SELECT * FROM users");
      $stmt->setFetchMode(PDO::FETCH_ASSOC);

      while($row = $stmt->fetch()) {
      ?>
   <form method="POST">
      <tr>
         <td><?php echo $row['id'];?></td>
         <td><?php echo $row['name'];?></td>
         <td><?php echo $row['amount'];?></td>
         <td><button name="edit" type="submit">Edit</button></td>
      </tr>
   </form>
   <?php } ?>
</tbody>
  • 写回答

2条回答 默认 最新

  • dongyinglan8707 2016-04-07 13:23
    关注

    You can send your form data to next page using hidden field as

    <form method="POST" action="edit_page.php">// add action here
            <tr>
                <td><?php echo $row['id'];?></td>
                <td><?php echo $row['name'];?></td>
                <td><?php echo $row['amount'];?></td>
                <input name="name" type="hidden" value="<?php echo $row['name'];?>">
                <input name="id" type="hidden" value="<?php echo $row['id'];?>">
                <input name="amount" type="hidden" value="<?php echo $row['amount'];?>">
                <td><button name="edit" type="submit">Edit</button></td>
            </tr>
        </form> 
    

    And in edit_page.php use

    $name=$_POST['name'];
    $id=$_POST['id'];
    $amount=$_POST['amount'];
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误