单击按钮时更新信息表

问题描述

我有一个表格，可以从数据库中选择信息并显示它，我想知道是否有人可以提供代码让我通过单击按钮来更新列?

I have a table which will select information from a database and display it, I'm wondering if anyone can provide a code for me to update a column on the click of a button?

示例表:(Access=Boolean)

Example Table: (Access=Boolean)

ID   -   Name   -   Access
---------------------------
1   -   John    -    1
---------------------------
2   -   Ben     -    1
---------------------------
3   -   Terry   -    0
---------------------------

我现有的按钮基于引导程序，

My exisiting button is based on bootstrap,

    <button type="button" id="passed" class="btn btn-success btn-flat"><i class="fa fa-check"></i></button>
    <button type="button" id="insufficient" class="btn btn-danger btn-flat"><i class="fa fa-times"></i></button>

我希望有这样的事情，ONCLICK button1 Run $Allowed SQLONCLICK button2 运行 $NotAllowed SQL

I was hoping for something like this, ONCLICK button1 Run $Allowed SQL ONCLICK button2 Run $NotAllowed SQL

$allowed = mysqli_query($conn," UPDATE users SET Access = "1" WHERE id = '27' ");     
$notallowed = mysqli_query($conn," UPDATE users SET Access = "0" WHERE id = '453' ");

推荐答案

您可以使用带有 post 方法的表单和带有命名属性的提交类型的按钮，并在条件语句中使用这些按钮.

You can use a form with a post method and a submit type of buttons with named attributes and use those in a conditional statement.

即:

旁注:我删除了转义引号，因为我不确定这些引号是否已经设置在 echo 中.

Sidenote: I removed the escaped quotes, as I was not sure if those were already set inside an echo.

HTML 表单:

<form method="post" action="handler.php">

    <button type="submit" name="passed" id="passed" class="btn btn-success btn-flat"><i class="fa fa-check"></i></button>
    <button type="submit" name="insufficient" id="insufficient" class="btn btn-danger btn-flat"><i class="fa fa-times"></i></button>

</form>

PHP:

<?php 

// db connection

if(isset($_POST['passed'])){

    $allowed = mysqli_query($conn," UPDATE users SET Access = "1" WHERE id = '27' ");

}

if(isset($_POST['insufficient'])){

    $notallowed = mysqli_query($conn," UPDATE users SET Access = "0" WHERE id = '453' ");

}

• 如果这在任何给定点有任何用户交互，请务必小心.

  • Be careful if this has any user interaction at any given point.

    使用准备好的语句，或 带有准备好的语句的 PDO，它们更安全.

    脚注:

    运行 UPDATE 查询时，最好使用 mysqli_affected_rows() 以获得绝对真实性.

    When running an UPDATE query, it's best to use mysqli_affected_rows() for absolute truthness.

    • http://php.net/manual/en/mysqli.affected-行.php

    否则，您可能会得到误报.

    Otherwise, you may get a false positive.

    这篇关于单击按钮时更新信息表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！