Syntax error or access violation 1305 PROCEDURE

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Syntax error or access violation 1305 PROCEDURE

Postby snake2221 » 02. June 2022 04:57

please help me i'm still a beginner

Code: Select all
<?php
include '../../../includes/koneksi.php';
$conn = new PDOConnection;
try{
$id_barang = htmlentities($_POST['id_barang']);
$nama_barang = htmlentities($_POST['nama_barang']);
$spesifikasi = htmlentities($_POST['spesifikasi']);
$lokasi = htmlentities($_POST['lokasi']);
$kondisi = htmlentities($_POST['kondisi']);
$kategori = htmlentities($_POST['kategori']);
$jml_barang = htmlentities($_POST['jml_barang']);
$sumber_dana = htmlentities($_POST['sumber_dana']);


$q_insert_data = $conn->getConn()->prepare("CALL TambahDataBarang(:val1,:val2,:val3,:val4,:val5,:val6,:val7,:val8)");

$q_insert_data->bindParam(":val1",$id_barang);
$q_insert_data->bindParam(":val2",$nama_barang);
$q_insert_data->bindParam(":val3",$spesifikasi);
$q_insert_data->bindParam(":val4",$lokasi);
$q_insert_data->bindParam(":val5",$kondisi);
$q_insert_data->bindParam(":val6",$kategori);
$q_insert_data->bindParam(":val7",$jml_barang);
$q_insert_data->bindParam(":val8",$sumber_dana);

$q_insert_data->execute();

}catch(PDOException $ex){
    die("Error : ".$ex->getMessage());
}
if ($q_insert_data){
    header("location:../../index.php?page=DataBarang&alert=InsertSuccess");
}
?>
snake2221
 
Posts: 1
Joined: 02. June 2022 04:47
XAMPP version: 3.3.0
Operating System: Windows 11

Re: Syntax error or access violation 1305 PROCEDURE

Postby Altrea » 02. June 2022 06:23

full error message?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11952
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 164 guests