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
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?