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();
}

avatar oceanli
@oceanli

63 Kontribusi 2 Poin

Diperbarui 5 tahun yang lalu

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

avatar bosque
@bosque

187 Kontribusi 104 Poin

Dipost 5 tahun yang lalu

Login untuk ikut Jawaban