Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax

Viewed 8

i cant edit data , please help me I tried to change the data but it couldn't be caused by an error Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'condition='new', berat='20kg', sum='1', tgl_p='2022-09-21', tgl_k='2022-09...' at line 1 in C:xampphtdocsExperimentfunbrg.php:19 Stack trace: #0 C:xampphtdocsExperimentfunbrg.php(19): mysqli_query(Object(mysqli), 'UPDATE brg SET ...') #1 {main}

<?php

include 'koneksi.php';

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

$id_b = $_POST['id_b'];
$nama_barang = $_POST['nama_barang'];
$jenis_barang = $_POST['jenis_barang'];
$condition = $_POST['condition'];
$berat = $_POST['berat'];
$jumlah = $_POST['jumlah'];
$tgl_p = $_POST['tgl_p'];
$tgl_k = $_POST['tgl_k'];
$stat = $_POST['stat'];


$sql = "UPDATE brg SET nama_barang='$nama_barang', jenis_barang='$jenis_barang', condition='$condition', berat='$berat', jumlah='$jumlah', tgl_p='$tgl_p', tgl_k='$tgl_k' WHERE id_b='$id_b'";
$query = mysqli_query($connect,$sql);



if($query){
  header('Location: displaybrg1.php');

}else{
  header('Location: funceddit.php?status=gagal');
}

}

?>

0 Answers
Related