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');
}
}
?>