Postingan lainnya
Mengatasi syntax error: 7 error: cannot insert multiple commands into a prepared statement
saya mau tanya cara mengatasi error karena multiple query
$sql = "
INSERT INTO tb_trash(nama_file, tipe_file, ukuran_file, file, tanggal_upload, id_user) SELECT nama_file, tipe_file, ukuran_file, file, tanggal_upload, id_user from tb_file WHERE id_file = '$id_file' AND id_user = '$id';
DELETE FROM tb_file WHERE id_file = '$id_file';
";
try {
$stmt = $db->prepare($sql);
$stmt->execute();
}
catch (PDOException $e)
{
echo $e->getMessage();
die();
}
0
1 Jawaban:
coba kayak gini <pre> $sql = " INSERT INTO tb_trash(nama_file, tipe_file, ukuran_file, file, tanggal_upload, id_user) VALUES('nama','type','ukuran','file','tgl','id'); SELECT nama_file, tipe_file, ukuran_file, file, tanggal_upload, id_user from tb_file WHERE id_file = '$id_file' AND id_user = '$id'; DELETE FROM tb_file WHERE id_file = '$id_file'; "; </pre> semoga berhasil
0