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

Question

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 ?

Answer 1

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
}