' . "\n" . '' . $GLOBALS['strDocu'] . '' . "\n"; exit; } // 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); 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); } function PMA_DBI_free_result($result) { if (!is_bool($result)) { return mysqli_free_result($result); } else { return 0; } } /** * 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_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)); } ?>