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 #180740 is a reply to message #180739]

Sat, 16 March 2013 02:45

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 3/15/2013 8:47 PM, burrowingowl(at)gmail(dot)com wrote:
> 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.
>

You can't pass the values as an array. You need to pass them as
individual items.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

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: Thu Nov 28 14:27:52 GMT 2024

Total time taken to generate the page: 0.04018 seconds