doushenken2833 2013-10-16 20:31 采纳率: 0%
浏览 18
已采纳

当同一行中的值等于变量时,如何更新某列?

I have been trying to do this for hours now, and I can't quite get my head round it. I have a table called "requests" that has the columns "deletekey" and "deleted". "deletekey" is a random unique number (data-type text), and "deleted" is by default set to 0 (data-type boolean), and when the user inputs the deletekey, it changes "deleted" to 1. But I can't get it to work. Here is the code I have, and I have no idea what I'm doing wrong:

$key = $_GET["delkey"];
$link = mysqli_connect("localhost","username","password","dbname");
$query = 'UPDATE requests SET deleted = True WHERE deletekey = "$key"';
$result = $link->query($query);
  • 写回答

6条回答 默认 最新

  • dr2898 2013-10-16 20:35
    关注

    This should help, and will also provide protection against SQL injection:

    $link = mysqli_connect("localhost","username","password","dbname");
    $key = $link->real_escape_string($_GET["delkey"]);
    $query = sprintf("UPDATE requests SET deleted = 1 WHERE deletekey = '%s'", $key);
    $result = $link->query($query);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(5条)

报告相同问题?

悬赏问题

  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果