Cant insert "FormID" into database

#1

Hi
I have a problem with inserting into one tabel. I have one other “Insert” before in the code, that works just fine. I can’t figure out what is wrong. Could anyone help?

$aId3 = $_POST[‘formID’];

$stmt = $con->prepare(“INSERT INTO OrdreDetalierT (OrdreID, UVmaterialeID )
VALUES (?, ?)”);

for($i=0; $i < $N; $i++)

{
$stmt->bind_param(‘isi’, $Ordre_id, $aId3[$i] );
$stmt->execute();
}
$stmt->close();

#2

First are you using PDO or mysqli? It will make a difference, but what jumps out at me the most, if you are using mysqli:

You are attempting to bind a integer, a string, and an integer, but only passing two arguments.

#3

It is mysql. Actually I had changed it, so it now is:
$stmt->bind_param(‘is’, $Ordre_id, $aId3[$i] );

#4

mysql or mysqli?

Turn error reporting on and see what the specific error it is reporting.

#5

It´s mysqli - sorry:-)

This is an error I get: Undefined index: searchFag in /customers/8/f/a/ellebaekskolen2.dk/httpd.www/Indkoeb/order.php on line 73

I think the website has got a new version, so maybe that is the problem, since it all worked before. I´ll check it out.

#6

Well that error has nothing to do with the code you posted, so I can’t help without more information.

#7

Actually you helped me by giving me the tip to turn error reporting on. I found the error, and you were right, it had nothing to do with the code, but with the database.

1 Like