mysqli函数bind_result，store_result和fetch之间有什么区别? [英] What's the difference between the mysqli functions bind_result, store_result and fetch?
问题描述
在mysqli_stmt_execute
之后知道什么时候打电话给我遇到了麻烦
你怎么知道什么时候打电话
I'm running into problems knowing when and what to call after mysqli_stmt_execute
How do you know when to call
- mysqli_stmt_bind_result
- mysqli_stmt_store_result
- mysqli_stmt_fetch
推荐答案
mysqli_stmt_bind_result()告诉mysqli在获取行时要填充哪个变量，但还没有fetch()任何东西.在调用提取之前，必须先调用一次.
mysqli_stmt_bind_result() tells mysqli which variable you want to be populate when you fetch a row, but it doesn't fetch() anything yet. This is necessary to call once, before you call fetch.
mysqli_stmt_store_result()设置了一个可选行为，以便客户端在您fetch()第一行时下载所有行，并将整个结果集缓存在客户端(即PHP)中.随后的fetch()调用将简单地对此客户端缓存的结果集进行迭代.但是设置此选项本身也不会导致fetch().此功能是完全可选的.
mysqli_stmt_store_result() sets an optional behavior so that the client downloads all rows when you fetch() the first row, and caches the whole result set in the client (i.e. PHP). Subsequent fetch() calls will simply iterate over this client-cached result set. But setting this option itself does not cause a fetch() yet either. This function is totally optional.
mysqli_stmt_fetch()返回结果集中的下一行，并将其存储在绑定变量中.您必须为结果集的每一行循环调用此函数.也就是说，直到提取返回false为止.
mysqli_stmt_fetch() returns the next row in the result set, and causes it to be stored in a bound variable. You must call this function in a loop, for each row of the result set. That is, until the fetch returns false.
这篇关于mysqli函数bind_result，store_result和fetch之间有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
