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

Re: mysqli_stmt_bind_param with multiple parameters in an array [message #180742 is a reply to message #180739]

Sat, 16 March 2013 11:39

M. Strobel
Messages: 386
Registered: December 2011

Karma:

Senior Member

Am 16.03.2013 01:47, schrieb burrowingowl(at)gmail(dot)com:
> 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 ...
>

Look up working examples of mysqli_stmt_bind_param() on the net. The & operator is
of limited use in modern PHP, use only if your code does not work without it.

And you should ask yourself how you came to believe you could put an array where
individual variables are needed.

/Str.

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: Wed Nov 13 11:28:47 GMT 2024

Total time taken to generate the page: 0.04592 seconds