php - prepared statements. Is it correct to bind after execution?

user_5958695 0
Viewed 132

Regarding "prepared statements" in php,
I have found here in the official documentation of php this piece of code that I don´t understand.

/* execute statement */
$stmt->execute();

/* bind result variables */
$stmt->bind_result($name, $code);

I had always seen the "binding" first and then, the "execution".

Could anybody tell me why in this case, is the other way around?

Thanks.

prepared-statement sql php
1 Answers

Binding "parameters" and binding "results" are two different things.

You have to bind parameters before execution because parameters are going to be used during execution.

Yet, you have the result in $stmt object after execution, and if you want to use columns from the result, you bind results to variables.

So here are the steps:

  1. bind parameters to $stmt object

    $stmt->bind_param(...)

  2. execute prepared statement

    $stmt->execute()

  3. bind columns from the result to variables

    $stmt->bind_result(...)

user_97465700
Related