<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$TOC_DEPRECATED = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/mysql.inc";
$setup = array (
  'home' => 
  array (
    0 => 'index.php',
    1 => 'PHP Manual',
  ),
  'head' => 
  array (
    0 => 'UTF-8',
    1 => 'en',
  ),
  'this' => 
  array (
    0 => 'mysqlinfo.api.choosing.php',
    1 => 'Choosing an API',
  ),
  'up' => 
  array (
    0 => 'mysql.php',
    1 => 'Overview of the MySQL PHP drivers',
  ),
  'prev' => 
  array (
    0 => 'mysqlinfo.terminology.php',
    1 => 'Terminology overview',
  ),
  'next' => 
  array (
    0 => 'mysqlinfo.library.choosing.php',
    1 => 'Choosing a library',
  ),
  'alternatives' => 
  array (
  ),
  'source' => 
  array (
    'lang' => 'en',
    'path' => 'reference/mysqlinfo/set.xml',
  ),
  'history' => 
  array (
  ),
);
$setup["toc"] = $TOC;
$setup["toc_deprecated"] = $TOC_DEPRECATED;
$setup["parents"] = $PARENTS;
manual_setup($setup);

contributors($setup);

?>
<div id="mysqlinfo.api.choosing" class="chapter">
   <h1 class="title">Choosing an API</h1>

   <p class="para">
    PHP offers different APIs to connect to MySQL. Below we show
    the APIs provided by the mysqli and PDO extensions. Each code snippet
    creates a connection to a MySQL server running on &quot;example.com&quot; using
    the username &quot;user&quot; and the password &quot;password&quot;. And a query is run to
    greet the user.
   </p>
   <p class="para">
    <div class="example" id="example-1460">
     <p><strong>Example #1 Comparing the MySQL APIs</strong></p>
     <div class="example-contents">
<div class="phpcode"><code><span style="color: #000000"><span style="color: #0000BB">&lt;?php<br /></span><span style="color: #FF8000">// mysqli<br /></span><span style="color: #0000BB">$mysqli </span><span style="color: #007700">= new </span><span style="color: #0000BB">mysqli</span><span style="color: #007700">(</span><span style="color: #DD0000">"example.com"</span><span style="color: #007700">, </span><span style="color: #DD0000">"user"</span><span style="color: #007700">, </span><span style="color: #DD0000">"password"</span><span style="color: #007700">, </span><span style="color: #DD0000">"database"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">$mysqli</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">$result</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">fetch_assoc</span><span style="color: #007700">();<br />echo </span><span style="color: #0000BB">htmlentities</span><span style="color: #007700">(</span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #DD0000">'_message'</span><span style="color: #007700">]);<br /><br /></span><span style="color: #FF8000">// PDO<br /></span><span style="color: #0000BB">$pdo </span><span style="color: #007700">= new </span><span style="color: #0000BB">PDO</span><span style="color: #007700">(</span><span style="color: #DD0000">'mysql:host=example.com;dbname=database'</span><span style="color: #007700">, </span><span style="color: #DD0000">'user'</span><span style="color: #007700">, </span><span style="color: #DD0000">'password'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$statement </span><span style="color: #007700">= </span><span style="color: #0000BB">$pdo</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">$statement</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">fetch</span><span style="color: #007700">(</span><span style="color: #0000BB">PDO</span><span style="color: #007700">::</span><span style="color: #0000BB">FETCH_ASSOC</span><span style="color: #007700">);<br />echo </span><span style="color: #0000BB">htmlentities</span><span style="color: #007700">(</span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #DD0000">'_message'</span><span style="color: #007700">]);</span></span></code></div>
     </div>

    </div>
   </p>
   <p class="para">
    <div class="example" id="example-1461">
     <p><strong>Example #2 Comparing prepared statements</strong></p>
     <div class="example-contents">
<div class="phpcode"><code><span style="color: #000000"><span style="color: #0000BB">&lt;?php<br /></span><span style="color: #FF8000">// mysqli<br /></span><span style="color: #0000BB">$mysqli </span><span style="color: #007700">= new </span><span style="color: #0000BB">mysqli</span><span style="color: #007700">(</span><span style="color: #DD0000">"example.com"</span><span style="color: #007700">, </span><span style="color: #DD0000">"user"</span><span style="color: #007700">, </span><span style="color: #DD0000">"password"</span><span style="color: #007700">, </span><span style="color: #DD0000">"database"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$statement </span><span style="color: #007700">= </span><span style="color: #0000BB">$mysqli</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">prepare</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT District FROM City WHERE Name=?"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$statement</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">execute</span><span style="color: #007700">([</span><span style="color: #DD0000">"Amersfoort"</span><span style="color: #007700">]);<br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">$statement</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">get_result</span><span style="color: #007700">();<br /></span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">$result</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">fetch_assoc</span><span style="color: #007700">();<br />echo </span><span style="color: #0000BB">htmlentities</span><span style="color: #007700">(</span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #DD0000">'District'</span><span style="color: #007700">]);<br /><br /></span><span style="color: #FF8000">// PDO<br /></span><span style="color: #0000BB">$pdo </span><span style="color: #007700">= new </span><span style="color: #0000BB">PDO</span><span style="color: #007700">(</span><span style="color: #DD0000">'mysql:host=example.com;dbname=database'</span><span style="color: #007700">, </span><span style="color: #DD0000">'user'</span><span style="color: #007700">, </span><span style="color: #DD0000">'password'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$statement </span><span style="color: #007700">= </span><span style="color: #0000BB">$pdo</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">prepare</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT District FROM City WHERE Name=?"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$statement</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">execute</span><span style="color: #007700">([</span><span style="color: #DD0000">"Amersfoort"</span><span style="color: #007700">]);<br /></span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">$statement</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">fetch</span><span style="color: #007700">(</span><span style="color: #0000BB">PDO</span><span style="color: #007700">::</span><span style="color: #0000BB">FETCH_ASSOC</span><span style="color: #007700">);<br />echo </span><span style="color: #0000BB">htmlentities</span><span style="color: #007700">(</span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #DD0000">'District'</span><span style="color: #007700">]);</span></span></code></div>
     </div>

    </div>
   </p>
   <p class="para">
    <strong>Feature comparison</strong>
   </p>
   <p class="para">
    The overall performance of both extensions is considered to be about
    the same. Although the performance of the extension contributes only a
    fraction of the total run time of a PHP web request.  Often, the impact is
    as low as 0.1%.
   </p>
   <table id="mysqlinfo.api.choosing.changelog" class="doctable informaltable">
    
     <thead>
      <tr>
       <th class="empty">&nbsp;</th>
       <th>ext/mysqli</th>
       <th>PDO_MySQL</th>
      </tr>

     </thead>

     <tbody class="tbody">
      <tr>
       <td>PHP version introduced</td>
       <td>5.0</td>
       <td>5.1</td>
      </tr>

      <tr>
       <td>Included with PHP 7.x and 8.x</td>
       <td>Yes</td>
       <td>Yes</td>
      </tr>

      <tr>
       <td>Development status</td>
       <td>Active</td>
       <td>Active</td>
      </tr>

      <tr>
       <td>Lifecycle</td>
       <td>Active</td>
       <td>Active</td>
      </tr>

      <tr>
       <td>Recommended for new projects</td>
       <td>Yes</td>
       <td>Yes</td>
      </tr>

      <tr>
       <td>OOP Interface</td>
       <td>Yes</td>
       <td>Yes</td>
      </tr>

      <tr>
       <td>Procedural Interface</td>
       <td>Yes</td>
       <td>No</td>
      </tr>

      <tr>
       <td>API supports non-blocking, asynchronous queries with mysqlnd</td>
       <td>Yes</td>
       <td>No</td>
      </tr>

      <tr>
       <td>Persistent Connections</td>
       <td>Yes</td>
       <td>Yes</td>
      </tr>

      <tr>
       <td>API supports Charsets</td>
       <td>Yes</td>
       <td>Yes</td>
      </tr>

      <tr>
       <td>API supports server-side Prepared Statements</td>
       <td>Yes</td>
       <td>Yes</td>
      </tr>

      <tr>
       <td>API supports client-side Prepared Statements</td>
       <td>No</td>
       <td>Yes</td>
      </tr>

      <tr>
       <td>API supports Stored Procedures</td>
       <td>Yes</td>
       <td>Yes</td>
      </tr>

      <tr>
       <td>API supports Multiple Statements</td>
       <td>Yes</td>
       <td>Most</td>
      </tr>

      <tr>
       <td>API supports Transactions</td>
       <td>Yes</td>
       <td>Yes</td>
      </tr>

      <tr>
       <td>Transactions can be controlled with SQL</td>
       <td>Yes</td>
       <td>Yes</td>
      </tr>

      <tr>
       <td>Supports all MySQL 5.1+ functionality</td>
       <td>Yes</td>
       <td>Most</td>
      </tr>

     </tbody>
    
   </table>

  </div>
<?php manual_footer($setup); ?>