我无法使用此代码更改mysql数据库中名为oturum的列。 哪里出错了？

Question

ı cant change the column named oturum with this code however. the id is true but not changing the database.

<?php 
include 'islemmerkezi/baglan.php';

ob_start();
session_start();
$id=$_GET['durum'];
echo "your id"; echo "<br>";
echo $id ; echo "<br>";
    $kullaniciguncelle=$db->prepare("UPDATE kullanici SET   
        oturum=:oturum
        WHERE id=@id
        ");
    $update=$kullaniciguncelle->execute(array(
        'oturum' => 0
    ));
session_destroy();
/*header("Location:login.php?durum=exit");*/
ob_end_flush();
?>

Answer 1

You need to bind the id as well. It is a variable data so you should use placeholder in SQL and then pass data in execute():

$kullaniciguncelle = $db->prepare("UPDATE kullanici SET oturum=:oturum WHERE id=:id");
$kullaniciguncelle->execute([
    'oturum' => 0,
    'id' => $_GET['durum']
]);