Comments on snippet: 'Prepared Statements: Read'

Nettuts said on 25/Jun/2010

Fri, 25 Jun 2010 07:47:54 UTC

1) Create mysqli connection, and pass the host, username, password, and desired database. 2) Prepare your SQL query. Replace mine with whatever you need to select. 3) Execute the statement 4) Bind the results to variables. Make sure that you pass the same number of arguments to bind_result as you selected in your SQL query -- in this case, three. 7) Cycle through the rows, and echo out the title and content.

aelien said on 26/Jun/2010

Sat, 26 Jun 2010 03:05:38 UTC

Cool, and what if we need parameters in the statement? Can you give an example or a link to one? Thanks.

Nettuts said on 26/Jun/2010

Sat, 26 Jun 2010 08:36:02 UTC

@aelien - Sure, you use ? and then bind the parameters, accordingly. I'm heading out for the evening, but I'll add a new snippet tomorrow.