Object oriented style
Procedural style
Binds columns in the result set to variables.
When mysqli_stmt_fetch() is called to fetch data, the MySQL client/server protocol places the data for the bound columns into the specified variables var1, ...
.
Note:
Note that all columns must be bound after mysqli_stmt_execute() and prior to calling mysqli_stmt_fetch(). Depending on column types bound variables can silently change to the corresponding PHP type.
A column can be bound or rebound at any time, even after a result set has been partially retrieved. The new binding takes effect the next time mysqli_stmt_fetch() is called.
Procedural style only: A statement identifier returned by mysqli_stmt_init().
The variable to be bound.
Returns TRUE
on success or FALSE
on failure.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <?php $mysqli = new mysqli( "localhost" , "my_user" , "my_password" , "world" ); if (mysqli_connect_errno()) { printf( "Connect failed: %s\n" , mysqli_connect_error()); exit (); } /* prepare statement */ if ( $stmt = $mysqli ->prepare( "SELECT Code, Name FROM Country ORDER BY Name LIMIT 5" )) { $stmt ->execute(); /* bind variables to prepared statement */ $stmt ->bind_result( $col1 , $col2 ); /* fetch values */ while ( $stmt ->fetch()) { printf( "%s %s\n" , $col1 , $col2 ); } /* close statement */ $stmt ->close(); } /* close connection */ $mysqli ->close(); ?> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | <?php $link = mysqli_connect( "localhost" , "my_user" , "my_password" , "world" ); /* check connection */ if (! $link ) { printf( "Connect failed: %s\n" , mysqli_connect_error()); exit (); } /* prepare statement */ if ( $stmt = mysqli_prepare( $link , "SELECT Code, Name FROM Country ORDER BY Name LIMIT 5" )) { mysqli_stmt_execute( $stmt ); /* bind variables to prepared statement */ mysqli_stmt_bind_result( $stmt , $col1 , $col2 ); /* fetch values */ while (mysqli_stmt_fetch( $stmt )) { printf( "%s %s\n" , $col1 , $col2 ); } /* close statement */ mysqli_stmt_close( $stmt ); } /* close connection */ mysqli_close( $link ); ?> |
The above examples will output:
AFG Afghanistan ALB Albania DZA Algeria ASM American Samoa AND Andorra
Please login to continue.