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 #180749 is a reply to message #180746]

Sat, 16 March 2013 16:51

Peter H. Coffin
Messages: 245
Registered: September 2010

Karma:

Senior Member

On Sat, 16 Mar 2013 08:46:57 -0700 (PDT), Chris Cosner wrote:
> Thanks, guys.
>
> So I definitely cannot drop an array in there.
>
> Yet I don't want to create 100+ variables for this INSERT.
>
> Not possible with bound parameters?

Cannot use an array for this. Can implode an array to a string using a
comma as a separator then use the string to construct the query you want
to bind. The usual caveats about "if this array is constructed using
data from outside your app, it can be a vector for an injection attack
on your DB" apply. Which is a common reason for people to be using bound
statements in the first place, so think carefully.

--
A: Maybe because some people are too annoyed by top-posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?

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: Fri Dec 20 05:57:17 GMT 2024

Total time taken to generate the page: 0.07126 seconds