Using variables in mysqli bind_param

Question

I have a number of similar ( but not identical ) sql statements. The parameter types vary for each call and so I want to pass these as variables. Something like this:

$stmt->bind_param( $typeString, $parameter1, $parameter1 );

Where $typeString can be set to 'ss' or 'is' or 'ds'.

I get the error Number of elements in type definition string doesn't match number of bind variables.

I have tried (for instance)

$typeString = "is";
$typeString = "\'".$typeString."\'";
$stmt->bind_param( $typeString, $parameter1, $parameter1 );

And

$typeString = "is";
$stmt->bind_param( $typeString, $parameter1, $parameter1 );

But still get an error.

Is it possible to set this with a variable?

Where is the sql statment? And never bind a variable twice, you use $parameter1 twice. — JustOnUnderMillions
– JustOnUnderMillions, Commented Mar 6, 2017 at 13:14
And you just only once bind: stackoverflow.com/questions/15748254/… then refill the parameter variables and execute again. And if possible use always s for param typ. — JustOnUnderMillions
– JustOnUnderMillions, Commented Mar 6, 2017 at 13:16
number of similar ( but not identical ) sql statements so if you have 2 sql statements then you have also 2 mysqli stmt objects (for each stmt one). So nothing should mixed up here. — JustOnUnderMillions
– JustOnUnderMillions, Commented Mar 6, 2017 at 13:19
Not sure I get it. Do you want to reuse a prepared statement for different queries? — Álvaro González
– Álvaro González, Commented Mar 6, 2017 at 13:19
Nope here: reuse of bounded varaibles for different execution of the query. And stmts are for multi execution made! Send it once to the sql server (query with placeholder), but execute it with diff parameter (only varialbes send to mysql). — JustOnUnderMillions
– JustOnUnderMillions, Commented Mar 6, 2017 at 13:21

Your Common Sense · Accepted Answer · 2017-03-06 13:16:07Z

1

First variant makes no sense as quotes shouldn't be sent into type definition list.
Second variant actually works.
There is little use in setting specific parameters. Just use 's' for everything.

answered Mar 6, 2017 at 13:16

Your Common Sense

158k42 gold badges226 silver badges372 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using variables in mysqli bind_param

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related