| 0,0 → 1,467 |
|---|
| <?php |
| /* $Id: mysqli.dbi.lib.php,v 2.43.2.1 2006/02/22 15:30:38 cybot_tm Exp $ */ |
| // vim: expandtab sw=4 ts=4 sts=4: |
| |
| /** |
| * Interface to the improved MySQL extension (MySQLi) |
| */ |
| |
| // MySQL client API |
| if (!defined('PMA_MYSQL_CLIENT_API')) { |
| $client_api = explode('.', mysqli_get_client_info()); |
| define('PMA_MYSQL_CLIENT_API', (int)sprintf('%d%02d%02d', $client_api[0], $client_api[1], intval($client_api[2]))); |
| unset($client_api); |
| } |
| |
| // Constants from mysql_com.h of MySQL 4.1.3 |
| |
| define('NOT_NULL_FLAG', 1); |
| define('PRI_KEY_FLAG', 2); |
| define('UNIQUE_KEY_FLAG', 4); |
| define('MULTIPLE_KEY_FLAG', 8); |
| define('BLOB_FLAG', 16); |
| define('UNSIGNED_FLAG', 32); |
| define('ZEROFILL_FLAG', 64); |
| define('BINARY_FLAG', 128); |
| define('ENUM_FLAG', 256); |
| define('AUTO_INCREMENT_FLAG', 512); |
| define('TIMESTAMP_FLAG', 1024); |
| define('SET_FLAG', 2048); |
| define('NUM_FLAG', 32768); |
| define('PART_KEY_FLAG', 16384); |
| define('UNIQUE_FLAG', 65536); |
| |
| /** |
| * @see http://bugs.php.net/36007 |
| */ |
| if (! defined('MYSQLI_TYPE_NEWDECIMAL')) { |
| define('MYSQLI_TYPE_NEWDECIMAL', 246); |
| } |
| if (! defined('MYSQLI_TYPE_BIT')) { |
| define('MYSQLI_TYPE_BIT', 16); |
| } |
| |
| function PMA_DBI_connect($user, $password, $is_controluser = FALSE) |
| { |
| global $cfg, $php_errormsg; |
| |
| $server_port = (empty($cfg['Server']['port'])) |
| ? FALSE |
| : (int) $cfg['Server']['port']; |
| |
| if (strtolower($cfg['Server']['connect_type']) == 'tcp') { |
| $cfg['Server']['socket'] = ''; |
| } |
| |
| // NULL enables connection to the default socket |
| $server_socket = (empty($cfg['Server']['socket'])) |
| ? null |
| : $cfg['Server']['socket']; |
| |
| $link = mysqli_init(); |
| |
| mysqli_options($link, MYSQLI_OPT_LOCAL_INFILE, TRUE); |
| |
| $client_flags = $cfg['Server']['compress'] && defined('MYSQLI_CLIENT_COMPRESS') ? MYSQLI_CLIENT_COMPRESS : 0; |
| |
| $return_value = @mysqli_real_connect($link, $cfg['Server']['host'], $user, $password, FALSE, $server_port, $server_socket, $client_flags); |
| |
| if ($return_value == FALSE) { |
| PMA_auth_fails(); |
| } // end if |
| |
| PMA_DBI_postConnect($link, $is_controluser); |
| |
| return $link; |
| } |
| |
| function PMA_DBI_select_db($dbname, $link = null) |
| { |
| if (empty($link)) { |
| if (isset($GLOBALS['userlink'])) { |
| $link = $GLOBALS['userlink']; |
| } else { |
| return FALSE; |
| } |
| } |
| if (PMA_MYSQL_INT_VERSION < 40100) { |
| $dbname = PMA_convert_charset($dbname); |
| } |
| return mysqli_select_db($link, $dbname); |
| } |
| |
| function PMA_DBI_try_query($query, $link = null, $options = 0) |
| { |
| if ($options == ($options | PMA_DBI_QUERY_STORE)) { |
| $method = MYSQLI_STORE_RESULT; |
| } elseif ($options == ($options | PMA_DBI_QUERY_UNBUFFERED)) { |
| $method = MYSQLI_USE_RESULT; |
| } else { |
| $method = MYSQLI_USE_RESULT; |
| } |
| |
| if (empty($link)) { |
| if (isset($GLOBALS['userlink'])) { |
| $link = $GLOBALS['userlink']; |
| } else { |
| return FALSE; |
| } |
| } |
| if (defined('PMA_MYSQL_INT_VERSION') && PMA_MYSQL_INT_VERSION < 40100) { |
| $query = PMA_convert_charset($query); |
| } |
| return mysqli_query($link, $query, $method); |
| // From the PHP manual: |
| // "note: returns TRUE on success or FALSE on failure. For SELECT, |
| // SHOW, DESCRIBE or EXPLAIN, mysqli_query() will return a result object" |
| // so, do not use the return value to feed mysqli_num_rows() if it's |
| // a boolean |
| } |
| |
| // The following function is meant for internal use only. |
| // Do not call it from outside this library! |
| function PMA_mysqli_fetch_array($result, $type = FALSE) |
| { |
| global $cfg, $allow_recoding, $charset, $convcharset; |
| |
| if ($type != FALSE) { |
| $data = @mysqli_fetch_array($result, $type); |
| } else { |
| $data = @mysqli_fetch_array($result); |
| } |
| |
| /* No data returned => do not touch it */ |
| if (! $data) { |
| return $data; |
| } |
| |
| if (!defined('PMA_MYSQL_INT_VERSION') || PMA_MYSQL_INT_VERSION >= 40100 |
| || !(isset($cfg['AllowAnywhereRecoding']) && $cfg['AllowAnywhereRecoding'] && $allow_recoding)) { |
| /* No recoding -> return data as we got them */ |
| return $data; |
| } else { |
| $ret = array(); |
| $num = mysqli_num_fields($result); |
| if ($num > 0) { |
| $fields = PMA_DBI_get_fields_meta($result); |
| } |
| // sometimes, mysqli_fetch_fields() does not return results |
| // (as seen in PHP 5.1.0-dev), so for now, return $data unchanged |
| if (!$fields) { |
| return $data; |
| } |
| $i = 0; |
| for ($i = 0; $i < $num; $i++) { |
| if (!isset($fields[$i]->type)) { |
| /* No meta information available -> we guess that it should be converted */ |
| if (isset($data[$i])) { |
| $ret[$i] = PMA_convert_display_charset($data[$i]); |
| } |
| if (isset($fields[$i]->name) && isset($data[$fields[$i]->name])) { |
| $ret[PMA_convert_display_charset($fields[$i]->name)] = PMA_convert_display_charset($data[$fields[$i]->name]); |
| } |
| } else { |
| /* Meta information available -> check type of field and convert it according to the type */ |
| if (stristr($fields[$i]->type, 'BLOB') || stristr($fields[$i]->type, 'BINARY')) { |
| if (isset($data[$i])) { |
| $ret[$i] = $data[$i]; |
| } |
| if (isset($data[$fields[$i]->name])) { |
| $ret[PMA_convert_display_charset($fields[$i]->name)] = $data[$fields[$i]->name]; |
| } |
| } else { |
| if (isset($data[$i])) { |
| $ret[$i] = PMA_convert_display_charset($data[$i]); |
| } |
| if (isset($data[$fields[$i]->name])) { |
| $ret[PMA_convert_display_charset($fields[$i]->name)] = PMA_convert_display_charset($data[$fields[$i]->name]); |
| } |
| } |
| } |
| } |
| return $ret; |
| } |
| } |
| |
| function PMA_DBI_fetch_array($result) |
| { |
| return PMA_mysqli_fetch_array($result, MYSQLI_BOTH); |
| } |
| |
| function PMA_DBI_fetch_assoc($result) |
| { |
| return PMA_mysqli_fetch_array($result, MYSQLI_ASSOC); |
| } |
| |
| function PMA_DBI_fetch_row($result) |
| { |
| return PMA_mysqli_fetch_array($result, MYSQLI_NUM); |
| } |
| |
| /** |
| * Frees the memory associated with the results |
| * |
| * @param result $result,... one or more mysql result resources |
| */ |
| function PMA_DBI_free_result() |
| { |
| foreach (func_get_args() as $result) { |
| if (is_object($result) |
| && is_a($result, 'mysqli_result')) { |
| mysqli_free_result($result); |
| } |
| } |
| } |
| |
| /** |
| * Returns a string representing the type of connection used |
| * @uses mysqli_get_host_info() |
| * @uses $GLOBALS['userlink'] as default for $link |
| * @param resource $link mysql link |
| * @return string type of connection used |
| */ |
| function PMA_DBI_get_host_info($link = null) |
| { |
| if (null === $link) { |
| if (isset($GLOBALS['userlink'])) { |
| $link = $GLOBALS['userlink']; |
| } else { |
| return false; |
| } |
| } |
| return mysqli_get_host_info($link); |
| } |
| |
| /** |
| * Returns the version of the MySQL protocol used |
| * @uses mysqli_get_proto_info() |
| * @uses $GLOBALS['userlink'] as default for $link |
| * @param resource $link mysql link |
| * @return integer version of the MySQL protocol used |
| */ |
| function PMA_DBI_get_proto_info( $link = null ) |
| { |
| if (null === $link) { |
| if (isset($GLOBALS['userlink'])) { |
| $link = $GLOBALS['userlink']; |
| } else { |
| return false; |
| } |
| } |
| return mysqli_get_proto_info($link); |
| } |
| |
| /** |
| * returns a string that represents the client library version |
| * @uses mysqli_get_client_info() |
| * @return string MySQL client library version |
| */ |
| function PMA_DBI_get_client_info() { |
| return mysqli_get_client_info(); |
| } |
| |
| /** |
| * returns last error message or false if no errors occured |
| * |
| * @uses PMA_MYSQL_INT_VERSION |
| * @uses PMA_convert_display_charset() |
| * @uses PMA_DBI_convert_message() |
| * @uses $GLOBALS['errno'] |
| * @uses $GLOBALS['userlink'] |
| * @uses $GLOBALS['strServerNotResponding'] |
| * @uses $GLOBALS['strSocketProblem'] |
| * @uses mysqli_errno() |
| * @uses mysqli_error() |
| * @uses mysqli_connect_errno() |
| * @uses mysqli_connect_error() |
| * @uses defined() |
| * @param resource $link mysql link |
| * @return string|boolean $error or false |
| */ |
| function PMA_DBI_getError($link = null) |
| { |
| unset($GLOBALS['errno']); |
| |
| if (null === $link && isset($GLOBALS['userlink'])) { |
| $link =& $GLOBALS['userlink']; |
| // Do not stop now. We still can get the error code |
| // with mysqli_connect_errno() |
| // } else { |
| // return false; |
| } |
| |
| if (null !== $link) { |
| $error_number = mysqli_errno($link); |
| $error_message = mysqli_error($link); |
| } else { |
| $error_number = mysqli_connect_errno(); |
| $error_message = mysqli_connect_error(); |
| } |
| if (0 == $error_number) { |
| return false; |
| } |
| |
| // keep the error number for further check after the call to PMA_DBI_getError() |
| $GLOBALS['errno'] = $error_number; |
| |
| if (! empty($error_message)) { |
| $error_message = PMA_DBI_convert_message($error_message); |
| } |
| |
| if ($error_number == 2002) { |
| $error = '#' . ((string) $error_number) . ' - ' . $GLOBALS['strServerNotResponding'] . ' ' . $GLOBALS['strSocketProblem']; |
| } elseif (defined('PMA_MYSQL_INT_VERSION') && PMA_MYSQL_INT_VERSION >= 40100) { |
| $error = '#' . ((string) $error_number) . ' - ' . $error_message; |
| } else { |
| $error = '#' . ((string) $error_number) . ' - ' . PMA_convert_display_charset($error_message); |
| } |
| return $error; |
| } |
| |
| function PMA_DBI_close($link = null) |
| { |
| if (empty($link)) { |
| if (isset($GLOBALS['userlink'])) { |
| $link = $GLOBALS['userlink']; |
| } else { |
| return FALSE; |
| } |
| } |
| return @mysqli_close($link); |
| } |
| |
| function PMA_DBI_num_rows($result) |
| { |
| // see the note for PMA_DBI_try_query(); |
| if (!is_bool($result)) { |
| return @mysqli_num_rows($result); |
| } else { |
| return 0; |
| } |
| } |
| |
| function PMA_DBI_insert_id($link = '') |
| { |
| if (empty($link)) { |
| if (isset($GLOBALS['userlink'])) { |
| $link = $GLOBALS['userlink']; |
| } else { |
| return FALSE; |
| } |
| } |
| return mysqli_insert_id($link); |
| } |
| |
| function PMA_DBI_affected_rows($link = null) |
| { |
| if (empty($link)) { |
| if (isset($GLOBALS['userlink'])) { |
| $link = $GLOBALS['userlink']; |
| } else { |
| return FALSE; |
| } |
| } |
| return mysqli_affected_rows($link); |
| } |
| |
| function PMA_DBI_get_fields_meta($result) |
| { |
| // Build an associative array for a type look up |
| $typeAr = Array(); |
| $typeAr[MYSQLI_TYPE_DECIMAL] = 'real'; |
| $typeAr[MYSQLI_TYPE_NEWDECIMAL] = 'real'; |
| $typeAr[MYSQLI_TYPE_BIT] = 'bool'; |
| $typeAr[MYSQLI_TYPE_TINY] = 'int'; |
| $typeAr[MYSQLI_TYPE_SHORT] = 'int'; |
| $typeAr[MYSQLI_TYPE_LONG] = 'int'; |
| $typeAr[MYSQLI_TYPE_FLOAT] = 'real'; |
| $typeAr[MYSQLI_TYPE_DOUBLE] = 'real'; |
| $typeAr[MYSQLI_TYPE_NULL] = 'null'; |
| $typeAr[MYSQLI_TYPE_TIMESTAMP] = 'timestamp'; |
| $typeAr[MYSQLI_TYPE_LONGLONG] = 'int'; |
| $typeAr[MYSQLI_TYPE_INT24] = 'int'; |
| $typeAr[MYSQLI_TYPE_DATE] = 'date'; |
| $typeAr[MYSQLI_TYPE_TIME] = 'time'; |
| $typeAr[MYSQLI_TYPE_DATETIME] = 'datetime'; |
| $typeAr[MYSQLI_TYPE_YEAR] = 'year'; |
| $typeAr[MYSQLI_TYPE_NEWDATE] = 'date'; |
| $typeAr[MYSQLI_TYPE_ENUM] = 'unknown'; |
| $typeAr[MYSQLI_TYPE_SET] = 'unknown'; |
| $typeAr[MYSQLI_TYPE_TINY_BLOB] = 'blob'; |
| $typeAr[MYSQLI_TYPE_MEDIUM_BLOB] = 'blob'; |
| $typeAr[MYSQLI_TYPE_LONG_BLOB] = 'blob'; |
| $typeAr[MYSQLI_TYPE_BLOB] = 'blob'; |
| $typeAr[MYSQLI_TYPE_VAR_STRING] = 'string'; |
| $typeAr[MYSQLI_TYPE_STRING] = 'string'; |
| $typeAr[MYSQLI_TYPE_CHAR] = 'string'; |
| $typeAr[MYSQLI_TYPE_GEOMETRY] = 'unknown'; |
| |
| $fields = mysqli_fetch_fields($result); |
| |
| // this happens sometimes (seen under MySQL 4.0.25) |
| if (!is_array($fields)) { |
| return FALSE; |
| } |
| |
| foreach ($fields as $k => $field) { |
| $fields[$k]->type = $typeAr[$fields[$k]->type]; |
| $fields[$k]->flags = PMA_DBI_field_flags($result, $k); |
| |
| // Enhance the field objects for mysql-extension compatibilty |
| $flags = explode(' ', $fields[$k]->flags); |
| array_unshift($flags, 'dummy'); |
| $fields[$k]->multiple_key = (int)(array_search('multiple_key', $flags, true) > 0); |
| $fields[$k]->primary_key = (int)(array_search('primary_key', $flags, true) > 0); |
| $fields[$k]->unique_key = (int)(array_search('unique_key', $flags, true) > 0); |
| $fields[$k]->not_null = (int)(array_search('not_null', $flags, true) > 0); |
| $fields[$k]->unsigned = (int)(array_search('unsigned', $flags, true) > 0); |
| $fields[$k]->zerofill = (int)(array_search('zerofill', $flags, true) > 0); |
| $fields[$k]->numeric = (int)(array_search('num', $flags, true) > 0); |
| $fields[$k]->blob = (int)(array_search('blob', $flags, true) > 0); |
| } |
| return $fields; |
| } |
| |
| function PMA_DBI_num_fields($result) |
| { |
| return mysqli_num_fields($result); |
| } |
| |
| function PMA_DBI_field_len($result, $i) |
| { |
| $info = mysqli_fetch_field_direct($result, $i); |
| // stdClass::$length will be integrated in |
| // mysqli-ext when mysql4.1 has been released. |
| return @$info->length; |
| } |
| |
| function PMA_DBI_field_name($result, $i) |
| { |
| $info = mysqli_fetch_field_direct($result, $i); |
| return $info->name; |
| } |
| |
| function PMA_DBI_field_flags($result, $i) |
| { |
| $f = mysqli_fetch_field_direct($result, $i); |
| $f = $f->flags; |
| $flags = ''; |
| if ($f & UNIQUE_FLAG) { $flags .= 'unique ';} |
| if ($f & NUM_FLAG) { $flags .= 'num ';} |
| if ($f & PART_KEY_FLAG) { $flags .= 'part_key ';} |
| if ($f & SET_FLAG) { $flags .= 'set ';} |
| if ($f & TIMESTAMP_FLAG) { $flags .= 'timestamp ';} |
| if ($f & AUTO_INCREMENT_FLAG) { $flags .= 'auto_increment ';} |
| if ($f & ENUM_FLAG) { $flags .= 'enum ';} |
| if ($f & BINARY_FLAG) { $flags .= 'binary ';} |
| if ($f & ZEROFILL_FLAG) { $flags .= 'zerofill ';} |
| if ($f & UNSIGNED_FLAG) { $flags .= 'unsigned ';} |
| if ($f & BLOB_FLAG) { $flags .= 'blob ';} |
| if ($f & MULTIPLE_KEY_FLAG) { $flags .= 'multiple_key ';} |
| if ($f & UNIQUE_KEY_FLAG) { $flags .= 'unique_key ';} |
| if ($f & PRI_KEY_FLAG) { $flags .= 'primary_key ';} |
| if ($f & NOT_NULL_FLAG) { $flags .= 'not_null ';} |
| return PMA_convert_display_charset(trim($flags)); |
| } |
| |
| ?> |