dpt1712 2017-05-20 20:11
浏览 87
已采纳

HTML - 单击按钮时的PHP UPDATE数据库

I have html page that has several button. I want to update my database column when I click a button.

In index.html

<form action="db.php" method="post">
    <button type="submit" id="1_y" class="btn btn-success">1.Lambayı Yeşil Yak</button>
    <button type="submit" id="1_k" class="btn btn-danger">1.Lambayı Kırmızı Yak</button></form>

And it looks like that

http://prntscr.com/fa5eba

My db table Webtek

http://prntscr.com/fa5ffl

What I want is to update 'birinci_lamba' to 1 when 1_y is clicked and update 'birinci_lamba' again to 0 when 1_k is clicked.

So, what should be my db.php page ? Or any other advise to do that ?

  • 写回答

1条回答 默认 最新

  • douluo1330 2017-05-20 20:24
    关注

    You use a from-tag, so you should use <input.. instead of <button... You seem to use bootstrap and <input class="btn btn-danger" /> should also work.

    Then, you need to give your inputs a name attribute:

    <form action="db.php" method="post">
    <input type="submit" name="1_y" id="1_y" class="btn btn-success">1.Lambayı Yeşil Yak />
    <input type="submit" name="1_k" id="1_k" class="btn btn-danger">1.Lambayı Kırmızı Yak /></form>
    

    Your db.php file could look like that:

    <?php
    if(isset($_POST['1_k'])){
      mysql_query("..."); //your update-query
    } elseif(isset($_POST['1_y']){
      mysql_query("..."); //your other update-query
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 关于#c++#的问题:水果店管理系统
  • ¥30 dbLinq最新版linq sqlite
  • ¥20 对D盘进行分盘之前没有将visual studio2022卸载掉,现在该如何下载回来
  • ¥15 完成虚拟机环境配置,还有安装kettle
  • ¥15 2024年全国大学生数据分析大赛A题:直播带货与电商产品的大数据分析 问题5. 请设计一份优惠券的投放策略,需要考虑优惠券的数量、优惠券的金额、投放时间段和投放商品种类等因素。求具体的python代码
  • ¥15 有人会搭建生鲜配送自营+平台的管理系统吗
  • ¥15 用matlab写代码
  • ¥30 motoradmin系统的多对多配置
  • ¥15 求组态王串口自定义通信配置方法或代码?
  • ¥15 实验 :UML2.0 结构建模