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

Файловый менеджер - Редактировать - /home/digilove/public_html/110/installation/framework/database/driver/mysql.php

Назад
<?php /** * ANGIE - The site restoration script for backup archives created by Akeeba Backup and Akeeba Solo * * @package angie * @copyright Copyright (c)2009-2023 Nicholas K. Dionysopoulos / Akeeba Ltd * @license GNU General Public License version 3, or later / defined('_AKEEBA') or die(); /* * This file may contain code from the Joomla! Platform, Copyright (c) 2005 - * 2012 Open Source Matters, Inc. This file is NOT part of the Joomla! Platform. * It is derivative work and clearly marked as such as per the provisions of the * GNU General Public License. / /* * MySQL database driver * * @see http://dev.mysql.com/doc/ / class ADatabaseDriverMysql extends ADatabaseDriverMysqli { /* * @var string The database technology family supported, e.g. mysql, mssql / public static $dbtech = 'mysql'; /* * The name of the database driver. * * @var string / public $name = 'mysql'; private $isReconnecting = false; /* * Test to see if the MySQL connector is available. * * @return boolean True on success, false otherwise. * / public static function isSupported() { return (function_exists('mysql_connect')); } /* * Destructor. * / public function __destruct() { if (is_resource($this->connection)) { mysql_close($this->connection); } } /* * Connects to the database if needed. * * @return void Returns void if the database connected successfully. * * @throws RuntimeException / public function connect() { if ($this->connection) { return; } // Make sure the MySQL extension for PHP is installed and enabled. if (!function_exists('mysql_connect')) { throw new RuntimeException('Could not connect to MySQL.'); } // Attempt to connect to the server. if (!($this->connection = @ mysql_connect($this->options['host'], $this->options['user'], $this->options['password'], true))) { throw new RuntimeException('Could not connect to MySQL.'); } // Set sql_mode to non_strict mode mysql_query("SET @@SESSION.sql_mode = '';", $this->connection); // If auto-select is enabled select the given database. if ($this->options['select'] && !empty($this->options['database'])) { $this->select($this->options['database']); } // Set charactersets (needed for MySQL 4.1.2+). $this->setUTF(); } /* * Determines if the connection to the server is active. * * @return boolean True if connected to the database engine. * / public function connected() { if (is_resource($this->connection)) { return @mysql_ping($this->connection); } return false; } /* * Disconnects the database. * * @return void * / public function disconnect() { // Close the connection. mysql_close($this->connection); $this->connection = null; } /* * Method to escape a string for usage in an SQL statement. * * @param string $text The string to be escaped. * @param boolean $extra Optional parameter to provide extra escaping. * * @return string The escaped string. * / public function escape($text, $extra = false) { $this->connect(); if (is_null($text)) { return 'NULL'; } $result = mysql_real_escape_string($text, $this->getConnection()); if ($extra) { $result = addcslashes($result, '%_'); } return $result; } /* * Execute the SQL statement. * * @return mixed A database cursor resource on success, boolean false on failure. * * @throws RuntimeException / public function execute() { $this->connect(); if (!is_resource($this->connection)) { throw new RuntimeException($this->errorMsg, $this->errorNum); } // Take a local copy so that we don't modify the original query and cause issues later $sql = $this->replacePrefix((string) $this->sql); if ($this->limit > 0 \|\| $this->offset > 0) { $sql .= ' LIMIT ' . $this->offset . ', ' . $this->limit; } // Increment the query counter. $this->count++; // If debugging is enabled then let's log the query. if ($this->debug) { // Add the query to the object queue. $this->log[] = $sql; } // Reset the error values. $this->errorNum = 0; $this->errorMsg = ''; // Execute the query. Error suppression is used here to prevent warnings/notices that the connection has been lost. $this->cursor = @mysql_query($sql, $this->connection); // If an error occurred handle it. if (!$this->cursor) { $this->errorNum = (int) mysql_errno($this->connection); $this->errorMsg = (string) mysql_error($this->connection) . "\nSQL=" . $sql; // Check if the server was disconnected. if (!$this->connected() && !$this->isReconnecting) { $this->isReconnecting = true; try { // Attempt to reconnect. $this->connection = null; $this->connect(); } // If connect fails, ignore that exception and throw the normal exception. catch (RuntimeException $e) { // Get the error number and message. $this->errorNum = (int) mysql_errno($this->connection); $this->errorMsg = (string) mysql_error($this->connection) . ' SQL=' . $sql; unset($sql); // Throw the normal query exception. throw new RuntimeException($this->errorMsg, $this->errorNum); } unset($sql); // Since we were able to reconnect, run the query again. $result = $this->execute(); $this->isReconnecting = false; return $result; } // The server was not disconnected. else { // Get the error number and message. unset($sql); // Throw the normal query exception. throw new RuntimeException($this->errorMsg, $this->errorNum); } } unset($sql); return $this->cursor; } /* * Get the number of affected rows for the previous executed SQL statement. * * @return integer The number of affected rows. * / public function getAffectedRows() { $this->connect(); return mysql_affected_rows($this->connection); } /* * Get the number of returned rows for the previous executed SQL statement. * * @param resource $cursor An optional database cursor resource to extract the row count from. * * @return integer The number of returned rows. * / public function getNumRows($cursor = null) { $this->connect(); return mysql_num_rows($cursor ? $cursor : $this->cursor); } /* * Get the version of the database connector. * * @return string The database connector version. * / public function getVersion() { $this->connect(); return mysql_get_server_info($this->connection); } /* * Method to get the auto-incremented value from the last INSERT statement. * * @return integer The value of the auto-increment field from the last inserted row. * / public function insertid() { $this->connect(); return mysql_insert_id($this->connection); } /* * Select a database for use. * * @param string $database The name of the database to select for use. * * @return boolean True if the database was successfully selected. * * @throws RuntimeException / public function select($database) { $this->connect(); if (!$database) { return false; } if (!mysql_select_db($database, $this->connection)) { throw new RuntimeException('Could not connect to database'); } return true; } /* * Set the connection to use UTF-8 character encoding. * * @return boolean True on success. * / public function setUTF() { $this->connect(); $charset = $this->supportsUtf8mb4() ? 'utf8mb4' : 'utf8'; $result = @mysql_set_charset($charset, $this->connection); if (!$result) { $this->supportsUTF8MB4 = false; $result = @mysql_set_charset('utf8', $this->connection); } return $result; } /* * Does this database server support UTF-8 four byte (utf8mb4) collation? * * libmysql supports utf8mb4 since 5.5.3 (same version as the MySQL server). mysqlnd supports utf8mb4 since 5.0.9. * * This method's code is based on WordPress' wpdb::has_cap() method * * @return bool / public function supportsUtf8mb4() { if (is_null($this->supportsUTF8MB4)) { // Get the client driver (mysql, mysqlnd) version $client_version = mysql_get_client_info(); // Get the MySQL server version $server_version = $this->getVersion(); // We need MySQL server 5.5.3 or later for UTF8MB4 support $this->supportsUTF8MB4 = version_compare($server_version, '5.5.3', '>='); // Now we must make sure the client driver also supports UTF8MB4. Minimum acceptable version is 5.5.3 (the // same version as MySQL, that's when the UTF8MB4 support was added in the first place). $minVersion = '5.5.3'; // However, if we have mysqlnd a different version scheme was followed. We need mysqlnd version 5.0.9 or // later for UTF8MB4 support. if (strpos($client_version, 'mysqlnd') !== false) { $client_version = preg_replace('/^\D+([\d.]+)./', '$1', $client_version); $minVersion = '5.0.9'; } // UTF8MB4 support equals server version match AND client version match (BOTH conditions must be fulfilled) $this->supportsUTF8MB4 = $this->supportsUTF8MB4 && version_compare($client_version, $minVersion, '>='); } return $this->supportsUTF8MB4; } /** * Method to fetch a row from the result set cursor as an array. * * @param mixed $cursor The optional result set cursor from which to fetch the row. * * @return mixed Either the next row from the result set or false if there are no more rows. * / protected function fetchArray($cursor = null) { return mysql_fetch_row($cursor ? $cursor : $this->cursor); } /* * Method to fetch a row from the result set cursor as an associative array. * * @param mixed $cursor The optional result set cursor from which to fetch the row. * * @return mixed Either the next row from the result set or false if there are no more rows. * / protected function fetchAssoc($cursor = null) { return mysql_fetch_assoc($cursor ? $cursor : $this->cursor); } /* * Method to fetch a row from the result set cursor as an object. * * @param mixed $cursor The optional result set cursor from which to fetch the row. * @param string $class The class name to use for the returned row object. * * @return mixed Either the next row from the result set or false if there are no more rows. * / protected function fetchObject($cursor = null, $class = 'stdClass') { return mysql_fetch_object($cursor ? $cursor : $this->cursor, $class); } /* * Method to free up the memory used for the result set. * * @param mixed $cursor The optional result set cursor from which to fetch the row. * * @return void * */ protected function freeResult($cursor = null) { mysql_free_result($cursor ? $cursor : $this->cursor); } }

| ver. 1.4 | Github | . | PHP 7.4.33 | Генерация страницы: 0 | proxy | phpinfo | Настройка