3 * This is the MySQL database abstraction layer.
5 * This program is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
15 * You should have received a copy of the GNU General Public License along
16 * with this program; if not, write to the Free Software Foundation, Inc.,
17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 * http://www.gnu.org/copyleft/gpl.html
25 * Database abstraction object for PHP extension mysql.
30 class DatabaseMysql
extends DatabaseMysqlBase
{
35 protected function doQuery( $sql ) {
36 if ( $this->bufferResults() ) {
37 $ret = mysql_query( $sql, $this->mConn
);
39 $ret = mysql_unbuffered_query( $sql, $this->mConn
);
45 protected function mysqlConnect( $realServer ) {
47 # Otherwise we get a suppressed fatal error, which is very hard to track down
48 if ( !extension_loaded( 'mysql' ) ) {
49 throw new DBConnectionError(
51 "MySQL functions missing, have you compiled PHP with the --with-mysql option?\n"
56 if ( $this->mFlags
& DBO_SSL
) {
57 $connFlags |
= MYSQL_CLIENT_SSL
;
59 if ( $this->mFlags
& DBO_COMPRESS
) {
60 $connFlags |
= MYSQL_CLIENT_COMPRESS
;
63 if ( ini_get( 'mysql.connect_timeout' ) <= 3 ) {
71 for ( $i = 0; $i < $numAttempts && !$conn; $i++
) {
75 if ( $this->mFlags
& DBO_PERSISTENT
) {
76 $conn = mysql_pconnect( $realServer, $this->mUser
, $this->mPassword
, $connFlags );
78 # Create a new connection...
79 $conn = mysql_connect( $realServer, $this->mUser
, $this->mPassword
, true, $connFlags );
89 protected function mysqlSetCharset( $charset ) {
90 if ( function_exists( 'mysql_set_charset' ) ) {
91 return mysql_set_charset( $charset, $this->mConn
);
93 return $this->query( 'SET NAMES ' . $charset, __METHOD__
);
100 protected function closeConnection() {
101 return mysql_close( $this->mConn
);
107 function insertId() {
108 return mysql_insert_id( $this->mConn
);
114 function lastErrno() {
115 if ( $this->mConn
) {
116 return mysql_errno( $this->mConn
);
118 return mysql_errno();
125 function affectedRows() {
126 return mysql_affected_rows( $this->mConn
);
133 function selectDB( $db ) {
134 $this->mDBname
= $db;
136 return mysql_select_db( $db, $this->mConn
);
142 function getServerVersion() {
143 return mysql_get_server_info( $this->mConn
);
146 protected function mysqlFreeResult( $res ) {
147 return mysql_free_result( $res );
150 protected function mysqlFetchObject( $res ) {
151 return mysql_fetch_object( $res );
154 protected function mysqlFetchArray( $res ) {
155 return mysql_fetch_array( $res );
158 protected function mysqlNumRows( $res ) {
159 return mysql_num_rows( $res );
162 protected function mysqlNumFields( $res ) {
163 return mysql_num_fields( $res );
166 protected function mysqlFetchField( $res, $n ) {
167 return mysql_fetch_field( $res, $n );
170 protected function mysqlFieldName( $res, $n ) {
171 return mysql_field_name( $res, $n );
174 protected function mysqlDataSeek( $res, $row ) {
175 return mysql_data_seek( $res, $row );
178 protected function mysqlError( $conn = null ) {
179 return ( $conn !== null ) ?
mysql_error( $conn ) : mysql_error(); // avoid warning
182 protected function mysqlRealEscapeString( $s ) {
183 return mysql_real_escape_string( $s, $this->mConn
);
186 protected function mysqlPing() {
187 return mysql_ping( $this->mConn
);