問題描述
我在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() 任何東西.在調用 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() 返回結果集中的下一行，并將其存儲在綁定變量中.您必須在循環中為結果集的每一行調用此函數.也就是說，直到 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 之間有什么區別?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！