[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-doc-cvs
Subject:    [DOC-CVS] [doc-en] master: Drop "Quick comparison of prepared and non-prepared statements" table
From:       Kamil Tekiela <noreply () php ! net>
Date:       2023-04-16 20:57:42
Message-ID: luwNQQmVVvcTgrrejwACiF8A3sCPDuU0sn4TvcuJnuc () main ! php ! net
[Download RAW message or body]

Author: Kamil Tekiela (kamil-tekiela)
Date: 2023-04-16T21:44:07+01:00

Commit: https://github.com/php/doc-en/commit/60a292997b3c6341cf52099d901aa0b5f8673d87
Raw diff: https://github.com/php/doc-en/commit/60a292997b3c6341cf52099d901aa0b5f8673d87.diff

Drop "Quick comparison of prepared and non-prepared statements" table

Changed paths:
  M  reference/mysqli/quickstart.xml


Diff:

diff --git a/reference/mysqli/quickstart.xml b/reference/mysqli/quickstart.xml
index a365366765b..3c7ec66ebd1 100644
--- a/reference/mysqli/quickstart.xml
+++ b/reference/mysqli/quickstart.xml
@@ -952,92 +952,6 @@ array(2) {
   <para>
    The API does not include emulation for client-side prepared statement emulation.
   </para>
-  <para>
-   <emphasis role="bold">Quick comparison of prepared and non-prepared statements</emphasis>
-  </para>
-  <para>
-   The table below compares server-side prepared and non-prepared statements.
-  </para>
-  <table xml:id="mysqli.quickstart.prepared.comparison">
-   <title>Comparison of prepared and non-prepared statements</title>
-   <tgroup cols="3">
-    <thead>
-     <row>
-      <entry></entry>
-      <entry>Prepared Statement</entry>
-      <entry>Non-prepared statement</entry>
-    </row>
-    </thead>
-    <tbody>
-     <row>
-      <entry>Client-server round trips, SELECT, single execution</entry>
-      <entry>2</entry>
-      <entry>1</entry>
-     </row>
-     <row>
-      <entry>Statement string transferred from client to server</entry>
-      <entry>1</entry>
-      <entry>1</entry>
-     </row>
-     <row>
-      <entry>Client-server round trips, SELECT, repeated (n) execution</entry>
-      <entry>1 + n</entry>
-      <entry>n</entry>
-     </row>
-     <row>
-      <entry>Statement string transferred from client to server</entry>
-      <entry>1 template, n times bound parameter, if any</entry>
-      <entry>n times and parsed every time</entry>
-     </row>
-     <row>
-      <entry>Input parameter binding API</entry>
-      <entry>Yes</entry>
-      <entry>No, manual input escaping</entry>
-     </row>
-     <row>
-      <entry>Output variable binding API</entry>
-      <entry>Yes</entry>
-      <entry>No</entry>
-     </row>
-     <row>
-      <entry>Supports use of mysqli_result API</entry>
-      <entry>Yes, use <methodname>mysqli_stmt::get_result</methodname></entry>
-      <entry>Yes</entry>
-     </row>
-     <row>
-      <entry>Buffered result sets</entry>
-      <entry>
-       Yes, use <methodname>mysqli_stmt::get_result</methodname> or
-       binding with <methodname>mysqli_stmt::store_result</methodname>
-      </entry>
-      <entry>Yes, default of <methodname>mysqli::query</methodname></entry>
-     </row>
-     <row>
-      <entry>Unbuffered result sets</entry>
-      <entry>Yes, use output binding API</entry>
-      <entry>
-       Yes, use <methodname>mysqli::real_query</methodname> with
-       <methodname>mysqli::use_result</methodname>
-      </entry>
-     </row>
-     <row>
-      <entry>MySQL Client Server protocol data transfer flavor</entry>
-      <entry>Binary protocol</entry>
-      <entry>Text protocol</entry>
-     </row>
-     <row>
-      <entry>Result set values SQL data types</entry>
-      <entry>Preserved when fetching</entry>
-      <entry>Converted to string or preserved when fetching</entry>
-     </row>
-     <row>
-      <entry>Supports all SQL statements</entry>
-      <entry>Recent MySQL versions support most but not all</entry>
-      <entry>Yes</entry>
-     </row>
-    </tbody>
-   </tgroup>
-  </table>
   <para>
    <emphasis role="bold">See also</emphasis>
   </para>

-- 
PHP Documentation Commits Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]