Current Location: Home> Function Categories> mysqli::use_result

mysqli::use_result

(mysqli_use_result) Start result set search
Name:mysqli::use_result
Category:MySQLi
Programming Language:php
One-line Description:Starts to retrieve the result set from the last executed query.

Example

Example 1 - Object-Oriented Style

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>

Example 2 - Procedural Style

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>
Similar Functions
Popular Articles