mysqli::use_result
(mysqli_use_result) Start result set search
Start searching the result set from the last executed query:
<span class="token php language-php"><span class="token delimiter important"><?php</span> <span class="token variable">$mysqli</span> <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">mysqli</span> <span class="token punctuation">(</span> <span class="token string double-quoted-string">"localhost"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_user"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_password"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_db"</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token variable">$mysqli</span> <span class="token operator">-></span> <span class="token property">connect_errno</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">echo</span> <span class="token string double-quoted-string">"Failed to connect to MySQL: "</span> <span class="token operator">.</span> <span class="token variable">$mysqli</span> <span class="token operator">-></span> <span class="token property">connect_error</span> <span class="token punctuation">;</span> <span class="token keyword">exit</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token variable">$sql</span> <span class="token operator">=</span> <span class="token string double-quoted-string">"SELECT Lastname FROM Persons ORDER BY LastName;"</span> <span class="token punctuation">;</span> <span class="token variable">$sql</span> <span class="token operator">.=</span> <span class="token string double-quoted-string">"SELECT Country FROM Customers"</span> <span class="token punctuation">;</span> <span class="token comment">// Perform multiple queries</span> <span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token variable">$mysqli</span> <span class="token operator">-></span> <span class="token function">multi_query</span> <span class="token punctuation">(</span> <span class="token variable">$sql</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">do</span> <span class="token punctuation">{</span> <span class="token comment">//Storing the first result set</span> <span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token variable">$result</span> <span class="token operator">=</span> <span class="token variable">$mysqli</span> <span class="token operator">-></span> <span class="token function">use_result</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">while</span> <span class="token punctuation">(</span> <span class="token variable">$row</span> <span class="token operator">=</span> <span class="token variable">$result</span> <span class="token operator">-></span> <span class="token function">fetch_row</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token function">printf</span> <span class="token punctuation">(</span> <span class="token string double-quoted-string">"%s\n"</span> <span class="token punctuation">,</span> <span class="token variable">$row</span> <span class="token punctuation">[</span> <span class="token number">0</span> <span class="token punctuation">]</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token variable">$result</span> <span class="token operator">-></span> <span class="token function">close</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token comment">// If there are more result sets, print the separator</span> <span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token variable">$mysqli</span> <span class="token operator">-></span> <span class="token function">more_results</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token function">printf</span> <span class="token punctuation">(</span> <span class="token string double-quoted-string">"--------------\n"</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token comment">// Prepare the next result set</span> <span class="token punctuation">}</span> <span class="token keyword">while</span> <span class="token punctuation">(</span> <span class="token variable">$mysqli</span> <span class="token operator">-></span> <span class="token function">next_result</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token variable">$mysqli</span> <span class="token operator">-></span> <span class="token function">close</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token delimiter important">?></span></span>
Start searching the result set from the last executed query:
<span class="token php language-php"><span class="token delimiter important"><?php</span> <span class="token variable">$con</span> <span class="token operator">=</span> <span class="token function">mysqli_connect</span> <span class="token punctuation">(</span> <span class="token string double-quoted-string">"localhost"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_user"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_password"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_db"</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token function">mysqli_connect_errno</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">echo</span> <span class="token string double-quoted-string">"Failed to connect to MySQL: "</span> <span class="token operator">.</span> <span class="token function">mysqli_connect_error</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token keyword">exit</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token variable">$sql</span> <span class="token operator">=</span> <span class="token string double-quoted-string">"SELECT Lastname FROM Persons ORDER BY LastName;"</span> <span class="token punctuation">;</span> <span class="token variable">$sql</span> <span class="token operator">.=</span> <span class="token string double-quoted-string">"SELECT Country FROM Customers"</span> <span class="token punctuation">;</span> <span class="token comment">// Perform multiple queries</span> <span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token function">mysqli_multi_query</span> <span class="token punctuation">(</span> <span class="token variable">$con</span> <span class="token punctuation">,</span> <span class="token variable">$sql</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">do</span> <span class="token punctuation">{</span> <span class="token comment">//Storing the first result set</span> <span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token variable">$result</span> <span class="token operator">=</span> <span class="token function">mysqli_use_result</span> <span class="token punctuation">(</span> <span class="token variable">$con</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">while</span> <span class="token punctuation">(</span> <span class="token variable">$row</span> <span class="token operator">=</span> <span class="token function">mysqli_fetch_row</span> <span class="token punctuation">(</span> <span class="token variable">$result</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token function">printf</span> <span class="token punctuation">(</span> <span class="token string double-quoted-string">"%s\n"</span> <span class="token punctuation">,</span> <span class="token variable">$row</span> <span class="token punctuation">[</span> <span class="token number">0</span> <span class="token punctuation">]</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token function">mysqli_free_result</span> <span class="token punctuation">(</span> <span class="token variable">$result</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token comment">// If there are more result sets, print the separator</span> <span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token function">mysqli_more_results</span> <span class="token punctuation">(</span> <span class="token variable">$con</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token function">printf</span> <span class="token punctuation">(</span> <span class="token string double-quoted-string">"--------------\n"</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token comment">// Prepare the next result set</span> <span class="token punctuation">}</span> <span class="token keyword">while</span> <span class="token punctuation">(</span> <span class="token function">mysqli_next_result</span> <span class="token punctuation">(</span> <span class="token variable">$con</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token function">mysqli_close</span> <span class="token punctuation">(</span> <span class="token variable">$con</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token delimiter important">?></span></span>