Menu
Community /Pin to ProfileBookmark
@NogDogNov 17.2021 — #Which line is failing? (The rest of the error message should tell you, likely after the colon with the file name, e.g.
In any case, based on what you've posted, I see no reason to use
But that would not appear to have anything to do with that error message, as far as I can see.
Prepared Statement Loop Insert issue
Good morning again,
This piece of code has stumped for me the last 4 hours. The first issue I solved on this post and was user error.
The second bit seems more technical which I’m not sure how to fix. As per my other thread. I’m passing in an array to my object and now within a method I want to foreach loop through that array and insert each one into a database.
There may be better ways of achieving this and I’m open to those. I’ve been writing PHP for only a few months so please excuse me.
Here is my code
[code]
$students= $this->studentList;
foreach ($students as $key => $value) {
$stmt3 = $con->stmt_init();
$stmt3->prepare(“INSERT INTO `studentList` (`objectVal0`, `objectVal`, `objectVal2`) VALUES (?, ?, ?)”);
$student = $students[$key];
$stmt3->bind_param(‘iii’, $var1, $var2, $student);
$stmt3->execute();
}
When I dump my original object I get this
“`
‘studentList’ =>
array (
0 => ’10’,
1 => ’65’,
),
**My error is :
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogNov 17.2021 — #Which line is failing? (The rest of the error message should tell you, likely after the colon with the file name, e.g. /path/to/some/file.php:123123$var2bind_param()In any case, based on what you've posted, I see no reason to use
$key$students[code=php]
foreach($this->studentList as $student) {
$stmt3 = $con->stmt_init();
$stmt3->prepare("INSERT INTO studentList (objectVal0, objectVal, objectVal2) VALUES (?, ?, ?)");
$stmt3->bind_param('iii', $var1, $var2, $student);
$stmt3->execute();
}
[/code]But that would not appear to have anything to do with that error message, as far as I can see.