<div id="content"> <h1 align="center">Source for file Mysqli.php</h1> <p>Documentation is available at <a href="../Doctrine/Doctrine_Adapter/_Doctrine---Adapter---Mysqli.php.html">Mysqli.php</a></p> <div class="src-code"><span class="php"> <ol><li><div class="src-line"><a name="a1"></a><span class="src-php"><?php</span></div></li> <li><div class="src-line"><a name="a2"></a><span class="src-comm">/*</span></div></li> <li><div class="src-line"><a name="a3"></a><span class="src-comm"> * $Id: Mock.php 1080 2007-02-10 18:17:08Z romanb $</span></div></li> <li><div class="src-line"><a name="a4"></a><span class="src-comm"> *</span></div></li> <li><div class="src-line"><a name="a5"></a><span class="src-comm"> * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS</span></div></li> <li><div class="src-line"><a name="a6"></a><span class="src-comm"> * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT</span></div></li> <li><div class="src-line"><a name="a7"></a><span class="src-comm"> * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR</span></div></li> <li><div class="src-line"><a name="a8"></a><span class="src-comm"> * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT</span></div></li> <li><div class="src-line"><a name="a9"></a><span class="src-comm"> * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,</span></div></li> <li><div class="src-line"><a name="a10"></a><span class="src-comm"> * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT</span></div></li> <li><div class="src-line"><a name="a11"></a><span class="src-comm"> * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,</span></div></li> <li><div class="src-line"><a name="a12"></a><span class="src-comm"> * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY</span></div></li> <li><div class="src-line"><a name="a13"></a><span class="src-comm"> * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT</span></div></li> <li><div class="src-line"><a name="a14"></a><span class="src-comm"> * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE</span></div></li> <li><div class="src-line"><a name="a15"></a><span class="src-comm"> * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.</span></div></li> <li><div class="src-line"><a name="a16"></a><span class="src-comm"> *</span></div></li> <li><div class="src-line"><a name="a17"></a><span class="src-comm"> * This software consists of voluntary contributions made by many individuals</span></div></li> <li><div class="src-line"><a name="a18"></a><span class="src-comm"> * and is licensed under the LGPL. For more information, see</span></div></li> <li><div class="src-line"><a name="a19"></a><span class="src-comm"> * <http://www.phpdoctrine.com>.</span></div></li> <li><div class="src-line"><a name="a20"></a><span class="src-comm"> */</span></div></li> <li><div class="src-line"><a name="a21"></a><span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a22"></a><span class="src-doc"> * Doctrine_Adapter_Mysqli</span></div></li> <li><div class="src-line"><a name="a23"></a><span class="src-doc"> * This class is used for special testing purposes.</span></div></li> <li><div class="src-line"><a name="a24"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Doctrine</span></div></li> <li><div class="src-line"><a name="a26"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> Doctrine_Adapter</span></div></li> <li><div class="src-line"><a name="a27"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Konsta Vesterinen <kvesteri@cc.hut.fi></span></div></li> <li><div class="src-line"><a name="a28"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://www.opensource.org/licenses/lgpl-license.php LGPL</span></div></li> <li><div class="src-line"><a name="a29"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc"> Object Relational Mapping</span></div></li> <li><div class="src-line"><a name="a30"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@link</span><span class="src-doc"> www.phpdoctrine.com</span></div></li> <li><div class="src-line"><a name="a31"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@since</span><span class="src-doc"> 1.0</span></div></li> <li><div class="src-line"><a name="a32"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Revision: 1080 $</span></div></li> <li><div class="src-line"><a name="a33"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a34"></a><span class="src-key">class </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html">Doctrine_Adapter_Mysqli</a> <span class="src-key">extends </span><a href="../Doctrine/Doctrine_Adapter.html">Doctrine_Adapter</a></div></li> <li><div class="src-line"><a name="a35"></a><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a36"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a37"></a><span class="src-doc"> * Creates a connection to the database.</span></div></li> <li><div class="src-line"><a name="a38"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a39"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a40"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@throws</span><span class="src-doc"> Doctrine_Adapter_Mysqli_Exception</span></div></li> <li><div class="src-line"><a name="a41"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a42"></a> <span class="src-key">protected </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#method_connect">_connect</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a43"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a44"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a45"></a> <span class="src-key">return</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a46"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a47"></a> <span class="src-comm">// Suppress connection warnings here.</span></div></li> <li><div class="src-line"><a name="a48"></a> <span class="src-comm">// Throw an exception instead.</span></div></li> <li><div class="src-line"><a name="a49"></a> <span class="src-sym">@</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection </span>= <span class="src-key">new </span><span class="src-id">mysqli</span><span class="src-sym">(</span></div></li> <li><div class="src-line"><a name="a50"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_config</span><span class="src-sym">[</span><span class="src-str">'host'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a51"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_config</span><span class="src-sym">[</span><span class="src-str">'username'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a52"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_config</span><span class="src-sym">[</span><span class="src-str">'password'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a53"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_config</span><span class="src-sym">[</span><span class="src-str">'dbname'</span><span class="src-sym">]</span></div></li> <li><div class="src-line"><a name="a54"></a> <span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a55"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection </span>=== <span class="src-id">false </span>|| <a href="http://www.php.net/mysqli_connect_errno">mysqli_connect_errno</a><span class="src-sym">(</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a56"></a> throw <span class="src-key">new </span><span class="src-id">Doctrine_Adapter_Mysqli_Exception</span><span class="src-sym">(</span><a href="http://www.php.net/mysqli_connect_error">mysqli_connect_error</a><span class="src-sym">(</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a57"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a58"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a59"></a> </div></li> <li><div class="src-line"><a name="a60"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a61"></a><span class="src-doc"> * Force the connection to close.</span></div></li> <li><div class="src-line"><a name="a62"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a63"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a64"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a65"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#methodcloseConnection">closeConnection</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a66"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a67"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection</span><span class="src-sym">-></span><span class="src-id">close</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a68"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection </span>= <span class="src-id">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a69"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a70"></a> </div></li> <li><div class="src-line"><a name="a71"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a72"></a><span class="src-doc"> * Prepare a statement and return a PDOStatement-like object.</span></div></li> <li><div class="src-line"><a name="a73"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a74"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc"> </span><span class="src-doc-type">string </span><span class="src-doc"> </span><span class="src-doc-var">$sql </span><span class="src-doc"> SQL query</span></div></li> <li><div class="src-line"><a name="a75"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">Doctrine_Statement_Mysqli </span></div></li> <li><div class="src-line"><a name="a76"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a77"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#methodprepare">prepare</a><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a78"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a79"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#method_connect">_connect</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a80"></a> <span class="src-var">$stmt </span>= <span class="src-key">new </span><span class="src-id">Doctrine_Statement_Mysqli</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">, </span><span class="src-var">$sql</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a81"></a> <span class="src-var">$stmt</span><span class="src-sym">-></span><span class="src-id">setFetchMode</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_fetchMode</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a82"></a> <span class="src-key">return </span><span class="src-var">$stmt</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a83"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a84"></a> </div></li> <li><div class="src-line"><a name="a85"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a86"></a><span class="src-doc"> * Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.</span></div></li> <li><div class="src-line"><a name="a87"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a88"></a><span class="src-doc"> * As a convention, on RDBMS brands that support sequences</span></div></li> <li><div class="src-line"><a name="a89"></a><span class="src-doc"> * (e.g. Oracle, PostgreSQL, DB2), this method forms the name of a sequence</span></div></li> <li><div class="src-line"><a name="a90"></a><span class="src-doc"> * from the arguments and returns the last id generated by that sequence.</span></div></li> <li><div class="src-line"><a name="a91"></a><span class="src-doc"> * On RDBMS brands that support IDENTITY/AUTOINCREMENT columns, this method</span></div></li> <li><div class="src-line"><a name="a92"></a><span class="src-doc"> * returns the last value generated for such a column, and the table name</span></div></li> <li><div class="src-line"><a name="a93"></a><span class="src-doc"> * argument is disregarded.</span></div></li> <li><div class="src-line"><a name="a94"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a95"></a><span class="src-doc"> * MySQL does not support sequences, so $tableName and $primaryKey are ignored.</span></div></li> <li><div class="src-line"><a name="a96"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a97"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$tableName </span><span class="src-doc"> OPTIONAL Name of table.</span></div></li> <li><div class="src-line"><a name="a98"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$primaryKey </span><span class="src-doc"> OPTIONAL Name of primary key column.</span></div></li> <li><div class="src-line"><a name="a99"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">integer </span></div></li> <li><div class="src-line"><a name="a100"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a101"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#methodlastInsertId">lastInsertId</a><span class="src-sym">(</span><span class="src-var">$tableName </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$primaryKey </span>= <span class="src-id">null</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a102"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a103"></a> <span class="src-var">$mysqli </span>= <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a104"></a> <span class="src-key">return </span><span class="src-var">$mysqli</span><span class="src-sym">-></span><span class="src-id">insert_id</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a105"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a106"></a> </div></li> <li><div class="src-line"><a name="a107"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a108"></a><span class="src-doc"> * Begin a transaction.</span></div></li> <li><div class="src-line"><a name="a109"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a110"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a111"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a112"></a> <span class="src-key">protected </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#method_beginTransaction">_beginTransaction</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a113"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a114"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#method_connect">_connect</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a115"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection</span><span class="src-sym">-></span><span class="src-id">autocommit</span><span class="src-sym">(</span><span class="src-id">false</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a116"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a117"></a> </div></li> <li><div class="src-line"><a name="a118"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a119"></a><span class="src-doc"> * Commit a transaction.</span></div></li> <li><div class="src-line"><a name="a120"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a121"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a122"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a123"></a> <span class="src-key">protected </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#method_commit">_commit</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a124"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a125"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#method_connect">_connect</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a126"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection</span><span class="src-sym">-></span><span class="src-id">commit</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a127"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection</span><span class="src-sym">-></span><span class="src-id">autocommit</span><span class="src-sym">(</span><span class="src-id">true</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a128"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a129"></a> </div></li> <li><div class="src-line"><a name="a130"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a131"></a><span class="src-doc"> * Roll-back a transaction.</span></div></li> <li><div class="src-line"><a name="a132"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a133"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a134"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a135"></a> <span class="src-key">protected </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#method_rollBack">_rollBack</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a136"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a137"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Mysqli.html#method_connect">_connect</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a138"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection</span><span class="src-sym">-></span><span class="src-id">rollback</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a139"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">_connection</span><span class="src-sym">-></span><span class="src-id">autocommit</span><span class="src-sym">(</span><span class="src-id">true</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a140"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a141"></a><span class="src-sym">}</span></div></li> </ol> </span></div> </div>