downloads | documentation | faq | getting help | mailing lists | licenses | wiki | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

Our source is open

The syntax highlighted source is automatically generated by PHP from the plaintext script. If you're interested in what's behind the several functions we used, you can always take a look at the source of the following files:

Of course, if you want to see the source of this page, we have it available. You can also browse the SVN repository for this website on svn.php.net.

Source of: /manual/en/function.sqlite-num-rows.php

<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/ref.sqlite.inc";
$setup = array (
  'home' =>
  array (
    0 => 'index.php',
    1 => 'PHP Manual',
  ),
  'head' =>
  array (
    0 => 'UTF-8',
    1 => 'en',
  ),
  'this' =>
  array (
    0 => 'function.sqlite-num-rows.php',
    1 => 'sqlite_num_rows',
  ),
  'up' =>
  array (
    0 => 'ref.sqlite.php',
    1 => 'SQLite Functions',
  ),
  'prev' =>
  array (
    0 => 'function.sqlite-num-fields.php',
    1 => 'sqlite_num_fields',
  ),
  'next' =>
  array (
    0 => 'function.sqlite-open.php',
    1 => 'sqlite_open',
  ),
);
$setup["toc"] = $TOC;
$setup["parents"] = $PARENTS;
manual_setup($setup);

manual_header();
?>
<div id="function.sqlite-num-rows" class="refentry">
 <div class="refnamediv">
  <h1 class="refname">sqlite_num_rows</h1>
  <h1 class="refname">SQLiteResult-&gt;numRows</h1>
  <p class="verinfo">(PHP 5, PECL sqlite &gt;= 1.0.0)</p><p class="refpurpose"><span class="refname">sqlite_num_rows</span> -- <span class="refname">SQLiteResult-&gt;numRows</span> &mdash; <span class="dc-title">Returns the number of rows in a buffered result set</span></p>

 </div>

 <a name="function.sqlite-num-rows.description"></a><div class="refsect1 description">
  <h3 class="title">Description</h3>
  <div class="methodsynopsis dc-description">
   <span class="type">int</span> <span class="methodname"><b>sqlite_num_rows</b></span>
    ( <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$result</tt></span>
   )</div>

  <p class="para rdfs-comment">Object oriented style (method):</p>
  <div class="classsynopsis">
   <div class="ooclass"><b class="classname">SQLiteResult</b></div>
   <div class="methodsynopsis dc-description">
    <span class="type">int</span> <span class="methodname"><b>numRows</b></span>
     ( <span class="methodparam">void</span>
    )</div>

  </div>
  <p class="para">
   Returns the number of rows in the buffered <i><tt class="parameter">result</tt></i>

   set.
  </p>
 </div>


 <a name="function.sqlite-num-rows.parameters"></a><div class="refsect1 parameters">
  <h3 class="title">Parameters</h3>
  <p class="para">
   </p><dl>

    <dt class="varlistentry">

     <span class="term"><i><tt class="parameter">result</tt></i>
</span>

     </dt><dd class="listitem">

      <p class="para">
       The SQLite result resource.  This parameter is not required when using
       the object-oriented method.
      </p>
      <blockquote><p><b class="note">Note</b>: This function cannot be used with
unbuffered result handles.<br /></p></blockquote>
     </dd>

   
   </dl>
<p>
  </p>
 </div>


 <a name="function.sqlite-num-rows.returnvalues"></a><div class="refsect1 returnvalues">
  <h3 class="title">Return Values</h3>
  <p class="para">
   Returns the number of rows, as an integer.
  </p>
 </div>


 <a name="function.sqlite-num-rows.examples"></a><div class="refsect1 examples">
  <h3 class="title">Examples</h3>
  <p class="para">
   </p><div class="example">
    <p><b>Example #1 Procedural example</b></p>
    <div class="example-contents programlisting">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php<br />$db&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">sqlite_open</span><span style="color: #007700">(</span><span style="color: #DD0000">'mysqlitedb'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">sqlite_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$db</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"SELECT&nbsp;*&nbsp;FROM&nbsp;mytable&nbsp;WHERE&nbsp;name='John&nbsp;Doe'"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$rows&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">sqlite_num_rows</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);<br /><br />echo&nbsp;</span><span style="color: #DD0000">"Number&nbsp;of&nbsp;rows:&nbsp;</span><span style="color: #0000BB">$rows</span><span style="color: #DD0000">"</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">?&gt;</span>
</span>
</code></div>
    </div>

   </div><p>
  </p>
  <p class="para">
   </p><div class="example">
    <p><b>Example #2 Object-oriented example</b></p>
    <div class="example-contents programlisting">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php<br />$db&nbsp;</span><span style="color: #007700">=&nbsp;new&nbsp;</span><span style="color: #0000BB">SQLiteDatabase</span><span style="color: #007700">(</span><span style="color: #DD0000">'mysqlitedb'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$db</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT&nbsp;*&nbsp;FROM&nbsp;mytable&nbsp;WHERE&nbsp;name='John&nbsp;Doe'"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$rows&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$result</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">numRows</span><span style="color: #007700">();<br /><br />echo&nbsp;</span><span style="color: #DD0000">"Number&nbsp;of&nbsp;rows:&nbsp;</span><span style="color: #0000BB">$rows</span><span style="color: #DD0000">"</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">?&gt;</span>
</span>
</code></div>
    </div>

   </div><p>
  </p>
 </div>


 <a name="function.sqlite-num-rows.seealso"></a><div class="refsect1 seealso">
  <h3 class="title">See Also</h3>
  <p class="para">
   </p><ul class="simplelist">
    <li class="member"><a href="function.sqlite-changes.php" class="function" rel="rdfs-seeAlso">sqlite_changes()</a> - Returns the number of rows that were changed by the most
   recent SQL statement</li>
    <li class="member"><a href="function.sqlite-query.php" class="function" rel="rdfs-seeAlso">sqlite_query()</a> - Executes a query against a given database and returns a result handle</li>
    <li class="member"><a href="function.sqlite-num-fields.php" class="function" rel="rdfs-seeAlso">sqlite_num_fields()</a> - Returns the number of fields in a result set</li>
   </ul><p>
  </p>
 </div>

</div><?php manual_footer(); ?>
 
show source | credits | sitemap | contact | advertising | mirror sites