FUDforum: comp.lang.php » mysqli_stmt_bind_param with multiple parameters in an array

Home » Imported messages » comp.lang.php » mysqli_stmt_bind_param with multiple parameters in an array

Show: Today's Messages :: Polls :: Message Navigator

mysqli_stmt_bind_param with multiple parameters in an array [message #180739]

Sat, 16 March 2013 00:47

burrowingowl
Messages: 3
Registered: March 2013

Karma:

Junior Member

Goal: Insert a row into a mysql table using mysqli and bound parameters.

$stmt = mysqli_prepare($dbhandle, "INSERT INTO work (".$SQL_fields.") VALUES
($SQL_params_text)");

This results in the following query, for example:
INSERT INTO work (abstract,announcement,apparatus_description,author_1_first_name,author_1_f ollowing,author_1_last_name,author_1_middle,author_1_preceding,author_1_rol e,author_2_first_name) VALUES(?,?,?,?,?,?,?,?,?,?)

This list has been truncated for testing purposes. In practice it will be over 100 fields, heavy on text.

$SQL_params_text is ?,?,?, with the number ? matching the number of fields.
$sqltypes is a string like 'ssssssssss'
The array $SQL_values holds the data.

I have tried
mysqli_stmt_bind_param($stmt,$sqltypes,$SQL_values);

and
$msbp = array( $stmt, $sqltypes, $SQL_values);
call_user_func_array( 'mysqli_stmt_bind_param', $msbp);

I have also tried the above while wrapping $SQL_values in
function fn_refValues($arr){
$refs = array();
foreach($arr as $key => $value){
$refs[$key] = &$arr[$key];
}
return $refs;
}

Without the wrapper I get:
> PHP Warning: mysqli_stmt_bind_param(): Number of elements in type definition string doesn't match number of bind variables in ...

This is not true. I've checked it several ways. It just doesn't like $SQL_values as a plain old array. Maybe it's counting the whole array as 1, vs. 10 items in the type definition string.

And with the wrapper to make the values into references I get:
> PHP Warning: Parameter 3 to mysqli_stmt_bind_param() expected to be a reference, value given in ...

Parameter three is fn_refValues($SQL_values) in this case.

Simple fix, or am I just going about this the wrong way?

Thanks.

Report message to a moderator

[Message index]

		mysqli_stmt_bind_param with multiple parameters in an array By: burrowingowl on Sat, 16 March 2013 00:47
		Re: mysqli_stmt_bind_param with multiple parameters in an array By: Jerry Stuckle on Sat, 16 March 2013 02:45
		Re: mysqli_stmt_bind_param with multiple parameters in an array By: M. Strobel on Sat, 16 March 2013 11:39
		Re: mysqli_stmt_bind_param with multiple parameters in an array By: burrowingowl on Sat, 16 March 2013 15:46
		Re: mysqli_stmt_bind_param with multiple parameters in an array By: Jerry Stuckle on Sat, 16 March 2013 15:58
		Re: mysqli_stmt_bind_param with multiple parameters in an array By: Peter H. Coffin on Sat, 16 March 2013 16:51
		Re: mysqli_stmt_bind_param with multiple parameters in an array By: M. Strobel on Sat, 16 March 2013 17:04
		Re: mysqli_stmt_bind_param with multiple parameters in an array By: burrowingowl on Sat, 16 March 2013 18:42

Previous Topic:	question about class getters
Next Topic:	script works fine now

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 21:35:51 GMT 2024

Total time taken to generate the page: 0.04191 seconds