]>
src.bluestatic.org Git - isso.git/blob - db_mysqli.php
2 /*=====================================================================*\
3 || ###################################################################
4 || # Iris Studios Shared Object Framework [#]version[#]
5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
23 * MySQLi Database Abstraction Layer
29 $this->load('db', null);
32 * MySQLi Database Abstraction Layer
34 * This framework is a function wrapper for MySQLi functions so we can have
35 * better error reporting and query reporting.
37 * @author Iris Studios, Inc.
38 * @copyright Copyright ©2002 - [#]year[#], Iris Studios, Inc.
43 class DB_MySQLi
extends DB_Abstract
46 * Command mapping list
50 var $commands = array(
51 'pconnect' => '$this->command_mysqli_connect',
52 'connect' => '$this->command_mysqli_connect',
53 'query' => 'mysqli_query',
54 'error_num' => 'mysqli_errno',
55 'error_str' => 'mysqli_error',
56 'escape_string' => 'mysqli_real_escape_string',
57 'escape_binary' => 'mysqli_real_escape_string',
58 'unescape_binary' => '$this->command_unescape_binary',
59 'fetch_assoc' => 'mysqli_fetch_assoc',
60 'fetch_row' => 'mysqli_fetch_row',
61 'fetch_object' => 'mysqli_fetch_object',
62 'free_result' => 'mysqli_free_result',
63 'insert_id' => 'mysqli_insert_id',
64 'num_rows' => 'mysqli_num_rows',
65 'affected_rows' => 'mysqli_affected_rows'
68 // ###################################################################
72 function __construct(&$registry)
74 parent
::__construct($registry);
77 // ###################################################################
81 function DB_MySQLi(&$registry)
83 $this->__construct($registry);
86 // ###################################################################
88 * Wrapper: mysqli_connect
92 * @param string Server name
93 * @param string User name
94 * @param string Password
95 * @param string Database
97 * @return integer DB-Link
99 function command_mysqli_connect($server, $user, $password, $database)
101 return mysqli_connect($server, $user, $password, $database);
104 // ###################################################################
106 * Not supported: unescape binary string
110 * @param string Escaped data
112 * @return string Same data
114 function command_unescape_binary($string)
119 // ###################################################################
121 * Starts a database transaction
125 function transaction_start()
127 $this->query("START TRANSACTION");
130 // ###################################################################
132 * Saves current transaction steps as a savepoint
136 * @param string Named savepoint
138 function transaction_savepoint($name)
140 $this->query("SAVEPOINT $name");
143 // ###################################################################
145 * Reverts a transaction back to a given savepoint
149 * @param string Named savepoint
151 function transaction_rollback($name = null)
153 $this->query("ROLLBACK
" . ($name != null ? " TO SAVEPOINT
$name" : ""));
156 // ###################################################################
158 * Commits a database transaction
162 function transaction_commit()
164 $this->query("COMMIT");
168 /*=====================================================================*\
169 || ###################################################################
172 || ###################################################################
173 \*=====================================================================*/