Управление сайтом

Компаний

Пользователи

Фиксированные новости

Отзывы о фирмах

Пользователи

Банкоматы

Торговые точки

Доска объявлений

Курсы валют

организации Орла

организации области

сайты Орел

Поиск запросы

Статистика

Показы каталога организаций

Статистика клиенты

Пользователи

Управление сайтом

Каталоги >

Новости >

Организации >

Секрет фирмы >

Сервисы >

Файловый менеджер

Имя файла	mysqli.dbi.lib.php
Содержимое	<?php /* vim: set expandtab sw=4 ts=4 sts=4: / /* * Interface to the improved MySQL extension (MySQLi) * * @version $Id$ / if (! defined('PHPMYADMIN')) { 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); } /* * some older mysql client libs are missing this constants ... / if (! defined('MYSQLI_BINARY_FLAG')) { define('MYSQLI_BINARY_FLAG', 128); } /* * @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); } /* * connects to the database server * * @uses $GLOBALS['cfg']['Server'] * @uses PMA_auth_fails() * @uses PMA_DBI_postConnect() * @uses MYSQLI_CLIENT_COMPRESS * @uses MYSQLI_OPT_LOCAL_INFILE * @uses strtolower() * @uses mysqli_init() * @uses mysqli_options() * @uses mysqli_real_connect() * @uses defined() * @param string $user mysql user name * @param string $password mysql user password * @param boolean $is_controluser * @return mixed false on error or a mysqli object on success / function PMA_DBI_connect($user, $password, $is_controluser = false) { $server_port = (empty($GLOBALS['cfg']['Server']['port'])) ? false : (int) $GLOBALS['cfg']['Server']['port']; if (strtolower($GLOBALS['cfg']['Server']['connect_type']) == 'tcp') { $GLOBALS['cfg']['Server']['socket'] = ''; } // NULL enables connection to the default socket $server_socket = (empty($GLOBALS['cfg']['Server']['socket'])) ? null : $GLOBALS['cfg']['Server']['socket']; $link = mysqli_init(); mysqli_options($link, MYSQLI_OPT_LOCAL_INFILE, true); $client_flags = 0; / Optionally compress connection / if ($GLOBALS['cfg']['Server']['compress'] && defined('MYSQLI_CLIENT_COMPRESS')) { $client_flags \|= MYSQLI_CLIENT_COMPRESS; } / Optionally enable SSL / if ($GLOBALS['cfg']['Server']['ssl'] && defined('MYSQLI_CLIENT_SSL')) { $client_flags \|= MYSQLI_CLIENT_SSL; } $return_value = @mysqli_real_connect($link, $GLOBALS['cfg']['Server']['host'], $user, $password, false, $server_port, $server_socket, $client_flags); // Retry with empty password if we're allowed to if ($return_value == false && isset($cfg['Server']['nopassword']) && $cfg['Server']['nopassword'] && !$is_controluser) { $return_value = @mysqli_real_connect($link, $GLOBALS['cfg']['Server']['host'], $user, '', false, $server_port, $server_socket, $client_flags); } if ($return_value == false) { if ($is_controluser) { if (! defined('PMA_DBI_CONNECT_FAILED_CONTROLUSER')) { define('PMA_DBI_CONNECT_FAILED_CONTROLUSER', true); } return false; } PMA_auth_fails(); } // end if PMA_DBI_postConnect($link, $is_controluser); return $link; } /* * selects given database * * @uses $GLOBALS['userlink'] * @uses PMA_MYSQL_INT_VERSION * @uses PMA_convert_charset() * @uses mysqli_select_db() * @param string $dbname database name to select * @param object mysqli $link the mysli object * @return boolean treu or false / 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); } /* * runs a query and returns the result * * @uses PMA_DBI_QUERY_STORE * @uses PMA_DBI_QUERY_UNBUFFERED * @uses PMA_MYSQL_INT_VERSION * @uses $GLOBALS['userlink'] * @uses PMA_convert_charset() * @uses MYSQLI_STORE_RESULT * @uses MYSQLI_USE_RESULT * @uses mysqli_query() * @uses defined() * @param string $query query to execute * @param object mysqli $link mysqli object * @param integer $options * @return mixed true, false or result object / 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 = 0; } 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 } /* * returns $type array of rows from given $result * * The following function is meant for internal use only. * Do not call it from outside this library! * * @uses $GLOBALS['allow_recoding'] * @uses $GLOBALS['cfg']['AllowAnywhereRecoding'] * @uses PMA_MYSQL_INT_VERSION * @uses PMA_DBI_get_fields_meta() * @uses PMA_convert_display_charset() * @uses mysqli_fetch_array() * @uses mysqli_num_fields() * @uses stristr() * @param object mysqli result $result * @param integer $type ASSOC, BOTH, or NUMERIC array * @return array results * @access protected / function PMA_mysqli_fetch_array($result, $type = false) { 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($GLOBALS['cfg']['AllowAnywhereRecoding']) && $GLOBALS['cfg']['AllowAnywhereRecoding'] && $GLOBALS['allow_recoding'])) { / No recoding -> return data as we got them / return $data; } $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; } /* * returns array of rows with associative and numeric keys from $result * * @uses PMA_mysqli_fetch_array() * @uses MYSQLI_BOTH * @param object mysqli result $result * @return array result rows / function PMA_DBI_fetch_array($result) { return PMA_mysqli_fetch_array($result, MYSQLI_BOTH); } /* * returns array of rows with associative keys from $result * * @uses PMA_mysqli_fetch_array() * @uses MYSQLI_ASSOC * @param object mysqli result $result * @return array result rows / function PMA_DBI_fetch_assoc($result) { return PMA_mysqli_fetch_array($result, MYSQLI_ASSOC); } /* * returns array of rows with numeric keys from $result * * @uses PMA_mysqli_fetch_array() * @uses MYSQLI_NUM * @param object mysqli result $result * @return array result rows / function PMA_DBI_fetch_row($result) { return PMA_mysqli_fetch_array($result, MYSQLI_NUM); } /* * Frees the memory associated with the results * * @uses mysqli_result * @uses func_get_args() * @uses is_object() * @uses mysqli_free_result() * @param result $result,... one or more mysql result resources / function PMA_DBI_free_result() { foreach (func_get_args() as $result) { if ($result instanceof 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) { $GLOBALS['errno'] = 0; 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); } $error_message = htmlspecialchars($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; } /* * closes given database $link or $GLOBALS['userlink'] * * @uses $GLOBALS['userlink'] * @uses mysqli_close() * @param object mysqli $link the mysqli object * @return boolean treu or false / function PMA_DBI_close($link = null) { if (empty($link)) { if (isset($GLOBALS['userlink'])) { $link = $GLOBALS['userlink']; } else { return false; } } return @mysqli_close($link); } /* * * @param object mysqli result $result / 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; } } /* * returns last inserted auto_increment id for given $link or $GLOBALS['userlink'] * * @uses $GLOBALS['userlink'] * @uses mysqli_insert_id() * @param object mysqli $link the mysqli object * @return string ineteger / function PMA_DBI_insert_id($link = '') { if (empty($link)) { if (isset($GLOBALS['userlink'])) { $link = $GLOBALS['userlink']; } else { return false; } } return mysqli_insert_id($link); } /* * returns the number of rows affected by last query * * @uses $GLOBALS['userlink'] * @uses mysqli_affected_rows() * @param object mysqli $link the mysqli object * @return string integer / 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); } /* * returns metainfo for fields in $result * * @todo preserve orignal flags value * @uses PMA_DBI_field_flags() * @uses MYSQLI_TYPE_* * @uses MYSQLI_MULTIPLE_KEY_FLAG * @uses MYSQLI_PRI_KEY_FLAG * @uses MYSQLI_UNIQUE_KEY_FLAG * @uses MYSQLI_NOT_NULL_FLAG * @uses MYSQLI_UNSIGNED_FLAG * @uses MYSQLI_ZEROFILL_FLAG * @uses MYSQLI_NUM_FLAG * @uses MYSQLI_TYPE_BLOB * @uses MYSQLI_BLOB_FLAG * @uses defined() * @uses mysqli_fetch_fields() * @uses is_array() * @param object mysqli result $result * @return array meta info for fields in $result / 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] = 'int'; $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'; // MySQL returns MYSQLI_TYPE_STRING for CHAR // and MYSQLI_TYPE_CHAR === MYSQLI_TYPE_TINY // so this would override TINYINT and mark all TINYINT as string // https://sf.net/tracker/?func=detail&aid=1532111&group_id=23067&atid=377408 //$typeAr[MYSQLI_TYPE_CHAR] = 'string'; $typeAr[MYSQLI_TYPE_GEOMETRY] = 'unknown'; $typeAr[MYSQLI_TYPE_BIT] = 'bit'; $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 = $field->type; $fields[$k]->type = $typeAr[$field->type]; $fields[$k]->_flags = $field->flags; $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) (bool) ($fields[$k]->_flags & MYSQLI_MULTIPLE_KEY_FLAG); $fields[$k]->primary_key = (int) (bool) ($fields[$k]->_flags & MYSQLI_PRI_KEY_FLAG); $fields[$k]->unique_key = (int) (bool) ($fields[$k]->_flags & MYSQLI_UNIQUE_KEY_FLAG); $fields[$k]->not_null = (int) (bool) ($fields[$k]->_flags & MYSQLI_NOT_NULL_FLAG); $fields[$k]->unsigned = (int) (bool) ($fields[$k]->_flags & MYSQLI_UNSIGNED_FLAG); $fields[$k]->zerofill = (int) (bool) ($fields[$k]->_flags & MYSQLI_ZEROFILL_FLAG); $fields[$k]->numeric = (int) (bool) ($fields[$k]->_flags & MYSQLI_NUM_FLAG); $fields[$k]->blob = (int) (bool) ($fields[$k]->_flags & MYSQLI_BLOB_FLAG); } return $fields; } /* * return number of fields in given $result * * @param object mysqli result $result * @return integer field count / function PMA_DBI_num_fields($result) { return mysqli_num_fields($result); } /* * returns the length of the given field $i in $result * * @uses mysqli_fetch_field_direct() * @param object mysqli result $result * @param integer $i field * @return integer length of field / 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; } /* * returns name of $i. field in $result * * @uses mysqli_fetch_field_direct() * @param object mysqli result $result * @param integer $i field * @return string name of $i. field in $result / function PMA_DBI_field_name($result, $i) { $info = mysqli_fetch_field_direct($result, $i); return $info->name; } /* * returns concatenated string of human readable field flags * * @uses MYSQLI_UNIQUE_KEY_FLAG * @uses MYSQLI_NUM_FLAG * @uses MYSQLI_PART_KEY_FLAG * @uses MYSQLI_TYPE_SET * @uses MYSQLI_TIMESTAMP_FLAG * @uses MYSQLI_AUTO_INCREMENT_FLAG * @uses MYSQLI_TYPE_ENUM * @uses MYSQLI_ZEROFILL_FLAG * @uses MYSQLI_UNSIGNED_FLAG * @uses MYSQLI_BLOB_FLAG * @uses MYSQLI_MULTIPLE_KEY_FLAG * @uses MYSQLI_UNIQUE_KEY_FLAG * @uses MYSQLI_PRI_KEY_FLAG * @uses MYSQLI_NOT_NULL_FLAG * @uses MYSQLI_TYPE_TINY_BLOB * @uses MYSQLI_TYPE_BLOB * @uses MYSQLI_TYPE_MEDIUM_BLOB * @uses MYSQLI_TYPE_LONG_BLOB * @uses MYSQLI_TYPE_VAR_STRING * @uses MYSQLI_TYPE_STRING * @uses mysqli_fetch_field_direct() * @uses PMA_convert_display_charset() * @param object mysqli result $result * @param integer $i field * @return string field flags */ function PMA_DBI_field_flags($result, $i) { // This is missing from PHP 5.2.5, see http://bugs.php.net/bug.php?id=44846 if (! defined('MYSQLI_ENUM_FLAG')) { define('MYSQLI_ENUM_FLAG', 256); // see MySQL source include/mysql_com.h } $f = mysqli_fetch_field_direct($result, $i); $type = $f->type; $charsetnr = $f->charsetnr; $f = $f->flags; $flags = ''; if ($f & MYSQLI_UNIQUE_KEY_FLAG) { $flags .= 'unique ';} if ($f & MYSQLI_NUM_FLAG) { $flags .= 'num ';} if ($f & MYSQLI_PART_KEY_FLAG) { $flags .= 'part_key ';} if ($f & MYSQLI_SET_FLAG) { $flags .= 'set ';} if ($f & MYSQLI_TIMESTAMP_FLAG) { $flags .= 'timestamp ';} if ($f & MYSQLI_AUTO_INCREMENT_FLAG) { $flags .= 'auto_increment ';} if ($f & MYSQLI_ENUM_FLAG) { $flags .= 'enum ';} // See http://dev.mysql.com/doc/refman/6.0/en/c-api-datatypes.html: // to determine if a string is binary, we should not use MYSQLI_BINARY_FLAG // but instead the charsetnr member of the MYSQL_FIELD // structure. Watch out: some types like DATE returns 63 in charsetnr // so we have to check also the type. // Unfortunately there is no equivalent in the mysql extension. if (($type == MYSQLI_TYPE_TINY_BLOB \|\| $type == MYSQLI_TYPE_BLOB \|\| $type == MYSQLI_TYPE_MEDIUM_BLOB \|\| $type == MYSQLI_TYPE_LONG_BLOB \|\| $type == MYSQLI_TYPE_VAR_STRING \|\| $type == MYSQLI_TYPE_STRING) && 63 == $charsetnr) { $flags .= 'binary ';} if ($f & MYSQLI_ZEROFILL_FLAG) { $flags .= 'zerofill ';} if ($f & MYSQLI_UNSIGNED_FLAG) { $flags .= 'unsigned ';} if ($f & MYSQLI_BLOB_FLAG) { $flags .= 'blob ';} if ($f & MYSQLI_MULTIPLE_KEY_FLAG) { $flags .= 'multiple_key ';} if ($f & MYSQLI_UNIQUE_KEY_FLAG) { $flags .= 'unique_key ';} if ($f & MYSQLI_PRI_KEY_FLAG) { $flags .= 'primary_key ';} if ($f & MYSQLI_NOT_NULL_FLAG) { $flags .= 'not_null ';} return PMA_convert_display_charset(trim($flags)); } ?>

/admin/myadmin2/libraries/dbi/

Имя	Дата	Размер
..	2015-04-04
mysql.dbi.lib.php	2013-06-28	12 кб.
mysqli.dbi.lib.php	2013-06-28	22 кб.

/admin/myadmin2/libraries/dbi