单击按钮时更新信息表

时间:2023-03-05
本文介绍了单击按钮时更新信息表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

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

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.

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

上一篇:为什么当我将多个查询发送到 mysqli_query 时会发生错误? 下一篇:MYSQLI - 数组中的位置

相关文章