Menu
Community /Pin to ProfileBookmark
@NogDogOct 31.2021 — #Yeah, it's easier in PDO as you can just pass an array of
bind param one by one
Is is possible to make this
[code]$stmt->bind_param(“sss”, $one,$two,$three);
This
[code]
$stmt->bind_param(“s”, $one);
$stmt->bind_param(“s”, $two);
$stmt->bind_param(“s”, $three);
Or can I do something like this? I’m getting errors “mysqli_stmt::bind_param(): Number of variables doesn’t match number of parameters in prepared statement in” but following another example which suggests this is possible.
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogOct 31.2021 — #Yeah, it's easier in PDO as you can just pass an array of [':place_holder' => 'value']execute()call_user_func_array()[code=php]
// Note: pass variables by reference:
$bindings = [
'dss',
&$id,
&$first_name,
&$last_name
];
if(!empty($middle_name)) {
$bindings[0] .= 's';
$bindings[] = &$middle_name
}
// where $stmt is your mysqli_stmt object:
call_user_func_array([$stmt, 'bind_param'], $bindings);
[/code]