Oracle 5.0, Справочное руководство

Страница: 2464 / 3232

MySQL Improved Extension (
Mysqli
)
2444
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
See Also
mysqli_stmt_bind_param
mysqli_stmt_execute
mysqli_stmt_fetch
mysqli_prepare
mysqli_stmt_prepare
mysqli_stmt_init
mysqli_stmt_errno
mysqli_stmt_error
20.7.3.10.6.
mysqli_stmt::close
,
mysqli_stmt_close
Copyright 1997-2012 the PHP Documentation Group. [2230]
•
mysqli_stmt::close
mysqli_stmt_close
Closes a prepared statement
Description
Object oriented style
bool mysqli_stmt::close();
Procedural style
bool mysqli_stmt_close(