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-fetch-column-types.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-fetch-column-types.php',
    1 => 'sqlite_fetch_column_types',
  ),
  'up' =>
  array (
    0 => 'ref.sqlite.php',
    1 => 'SQLite Functions',
  ),
  'prev' =>
  array (
    0 => 'function.sqlite-fetch-array.php',
    1 => 'sqlite_fetch_array',
  ),
  'next' =>
  array (
    0 => 'function.sqlite-fetch-object.php',
    1 => 'sqlite_fetch_object',
  ),
);
$setup["toc"] = $TOC;
$setup["parents"] = $PARENTS;
manual_setup($setup);

manual_header();
?>
<div id="function.sqlite-fetch-column-types" class="refentry">
 <div class="refnamediv">
  <h1 class="refname">sqlite_fetch_column_types</h1>
  <h1 class="refname">SQLiteDatabase-&gt;fetchColumnTypes</h1>
  <p class="verinfo">(PHP 5)</p><p class="refpurpose"><span class="refname">sqlite_fetch_column_types</span> -- <span class="refname">SQLiteDatabase-&gt;fetchColumnTypes</span> &mdash; <span class="dc-title">
   Return an array of column types from a particular table
  </span></p>

 </div>

 <a name="function.sqlite-fetch-column-types.description"></a><div class="refsect1 description">
  <h3 class="title">Description</h3>
  <div class="methodsynopsis dc-description">
   <span class="type">array</span> <span class="methodname"><b>sqlite_fetch_column_types</b></span>
    ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$table_name</tt></span>
   , <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$dbhandle</tt></span>
   [, <span class="methodparam"><span class="type">int</span> <tt class="parameter">$result_type</tt></span>
  ] )</div>

  <p class="para rdfs-comment">Object oriented style (method):</p>
  <div class="classsynopsis">
   <div class="ooclass"><b class="classname">SQLiteDatabase</b></div>
   <div class="methodsynopsis dc-description">
    <span class="type">array</span> <span class="methodname"><b>fetchColumnTypes</b></span>
     ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$table_name</tt></span>
    [, <span class="methodparam"><span class="type">int</span> <tt class="parameter">$result_type</tt></span>
   ] )</div>

  </div>
  <p class="para">
   <b>sqlite_fetch_column_types()</b> returns an array of column
   data types from the specified <i><tt class="parameter">table_name</tt></i>
 table.
  </p>
 </div>


 <a name="function.sqlite-fetch-column-types.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">table_name</tt></i>
</span>

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

      <p class="para">
       The table name to query.
      </p>
     </dd>

   
    <dt class="varlistentry">

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

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

      <p class="para">
       The SQLite Database resource; returned from <a href="function.sqlite-open.php" class="function">sqlite_open()</a>
       when used procedurally.  This parameter is not required
       when using the object-oriented method.
      </p>
     </dd>

   
    <dt class="varlistentry">

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

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

      <p class="para">
       The optional <i><tt class="parameter">result_type</tt></i>
 parameter accepts a
       constant and determines how the returned array will be indexed. Using
       <b><tt class="constant">SQLITE_ASSOC</tt></b> will return only associative indices
       (named fields) while <b><tt class="constant">SQLITE_NUM</tt></b> will return only
       numerical indices (ordinal field numbers).
       <b><tt class="constant">SQLITE_BOTH</tt></b> will return both associative and
       numerical indices. <b><tt class="constant">SQLITE_ASSOC</tt></b> is the default for
       this function.
      </p>
     </dd>

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


 <a name="function.sqlite-fetch-column-types.returnvalues"></a><div class="refsect1 returnvalues">
  <h3 class="title">Return Values</h3>
  <p class="para">
   Returns an array of column data types; <b><tt class="constant">FALSE</tt></b> on error.
  </p>
  <p class="para">The column names returned by
<b><tt class="constant">SQLITE_ASSOC</tt></b> and <b><tt class="constant">SQLITE_BOTH</tt></b> will be
case-folded according to the value of the
<a href="sqlite.configuration.php#ini.sqlite.assoc-case" class="link">sqlite.assoc_case</a> configuration
option.</p>
 </div>


 <a name="function.sqlite-fetch-column-types.changelog"></a><div class="refsect1 changelog">
  <h3 class="title">Changelog</h3>
  <p class="para">
   </p><table class="doctable informaltable">
   
     <thead valign="middle">
      <tr valign="middle">
       <th>Version</th>
       <th>Description</th>
      </tr>

     </thead>

     <tbody valign="middle" class="tbody">
      <tr valign="middle">
       <td align="left">5.1.0</td>
       <td align="left">Added <i><tt class="parameter">result_type</tt></i>
</td>
      </tr>

     </tbody>
   
   </table>
<p>
  </p>
 </div>

 
 <a name="function.sqlite-fetch-column-types.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">sqlite_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$db</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'CREATE&nbsp;TABLE&nbsp;foo&nbsp;(bar&nbsp;varchar(10),&nbsp;arf&nbsp;text)'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$cols&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">sqlite_fetch_column_types</span><span style="color: #007700">(</span><span style="color: #DD0000">'foo'</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$db</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">SQLITE_ASSOC</span><span style="color: #007700">);<br /><br />foreach&nbsp;(</span><span style="color: #0000BB">$cols&nbsp;</span><span style="color: #007700">as&nbsp;</span><span style="color: #0000BB">$column&nbsp;</span><span style="color: #007700">=&gt;&nbsp;</span><span style="color: #0000BB">$type</span><span style="color: #007700">)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;</span><span style="color: #DD0000">"Column:&nbsp;</span><span style="color: #0000BB">$column</span><span style="color: #DD0000">&nbsp;&nbsp;Type:&nbsp;</span><span style="color: #0000BB">$type</span><span style="color: #DD0000">"</span><span style="color: #007700">;<br />}<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">$db</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">'CREATE&nbsp;TABLE&nbsp;foo&nbsp;(bar&nbsp;varchar(10),&nbsp;arf&nbsp;text)'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$cols&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$db</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">fetchColumnTypes</span><span style="color: #007700">(</span><span style="color: #DD0000">'foo'</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">SQLITE_ASSOC</span><span style="color: #007700">);<br /><br />foreach&nbsp;(</span><span style="color: #0000BB">$cols&nbsp;</span><span style="color: #007700">as&nbsp;</span><span style="color: #0000BB">$column&nbsp;</span><span style="color: #007700">=&gt;&nbsp;</span><span style="color: #0000BB">$type</span><span style="color: #007700">)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;</span><span style="color: #DD0000">"Column:&nbsp;</span><span style="color: #0000BB">$column</span><span style="color: #DD0000">&nbsp;&nbsp;Type:&nbsp;</span><span style="color: #0000BB">$type</span><span style="color: #DD0000">"</span><span style="color: #007700">;<br />}<br /></span><span style="color: #0000BB">?&gt;</span>
</span>
</code></div>
    </div>

    <div class="example-contents para"><p>The above example will output:</p></div>
    <div class="example-contents screen">
<div class="cdata"><pre>
Column: bar  Type: VARCHAR
Column: arf  Type: TEXT
</pre></div>
    </div>
   </div><p>
  </p>
 </div>

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