PHP resource::set_charset方法代码示例

 /**
  * Connect to a MySQL database.
  * @param array $parameters An map of parameters, which should include:
  *  - server: The server, eg, localhost
  *  - username: The username to log on with
  *  - password: The password to log on with
  *  - database: The database to connect to
  *  - timezone: (optional) The timezone offset. For example: +12:00, "Pacific/Auckland", or "SYSTEM"
  */
 public function __construct($parameters)
 {
     $this->dbConn = new MySQLi($parameters['server'], $parameters['username'], $parameters['password']);
     if ($this->dbConn->connect_error) {
         $this->databaseError("Couldn't connect to MySQL database | " . $this->dbConn->connect_error);
     }
     $this->query("SET sql_mode = 'ANSI'");
     if (self::$connection_charset) {
         $this->dbConn->set_charset(self::$connection_charset);
     }
     $this->active = $this->dbConn->select_db($parameters['database']);
     $this->database = $parameters['database'];
     if (isset($parameters['timezone'])) {
         $this->query(sprintf("SET SESSION time_zone = '%s'", $parameters['timezone']));
     }
 }

 /**
  * Connect to a MySQL database.
  * @param array $parameters An map of parameters, which should include:
  *  - server: The server, eg, localhost
  *  - username: The username to log on with
  *  - password: The password to log on with
  *  - database: The database to connect to
  *  - timezone: (optional) The timezone offset. For example: +12:00, "Pacific/Auckland", or "SYSTEM"
  */
 public function __construct($parameters)
 {
     $this->dbConn = new MySQLi($parameters['server'], $parameters['username'], $parameters['password']);
     if ($this->dbConn->connect_error) {
         $this->databaseError("Couldn't connect to MySQL database | " . $this->dbConn->connect_error);
     }
     /* $this->query("SET sql_mode = 'ANSI'"); */
     /* Risoluzione errore "only_full_group_by" (http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_ansi) */
     $this->query("SET sql_mode = 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'");
     if (self::$connection_charset) {
         $this->dbConn->set_charset(self::$connection_charset);
     }
     $this->active = $this->dbConn->select_db($parameters['database']);
     $this->database = $parameters['database'];
     if (isset($parameters['timezone'])) {
         $this->query(sprintf("SET SESSION time_zone = '%s'", $parameters['timezone']));
     }
 }

 /**
  * @dataProvider data_strip_invalid_text
  * @ticket 21212
  */
 function test_strip_invalid_text($data, $expected, $message)
 {
     if (version_compare(PHP_VERSION, '5.3', '<') && stristr(php_uname('s'), 'win')) {
         $this->markTestSkipped('This test fails in PHP 5.2 on Windows. See https://core.trac.wordpress.org/ticket/31262');
     }
     $charset = self::$_wpdb->charset;
     if (isset($data[0]['connection_charset'])) {
         $new_charset = $data[0]['connection_charset'];
         unset($data[0]['connection_charset']);
     } else {
         $new_charset = $data[0]['charset'];
     }
     self::$_wpdb->charset = $new_charset;
     self::$_wpdb->set_charset(self::$_wpdb->dbh, $new_charset);
     $actual = self::$_wpdb->strip_invalid_text($data);
     self::$_wpdb->charset = $charset;
     self::$_wpdb->set_charset(self::$_wpdb->dbh, $charset);
     $this->assertSame($expected, $actual, $message);
 }

 /**
  * Connect to a MySQL database.
  * @param array $parameters An map of parameters, which should include:
  *  - server: The server, eg, localhost
  *  - username: The username to log on with
  *  - password: The password to log on with
  *  - database: The database to connect to
  *  - timezone: (optional) The timezone offset. For example: +12:00, "Pacific/Auckland", or "SYSTEM"
  */
 public function __construct($parameters)
 {
     if (!empty($parameters['port'])) {
         $this->dbConn = new MySQLi($parameters['server'], $parameters['username'], $parameters['password'], '', $parameters['port']);
     } else {
         $this->dbConn = new MySQLi($parameters['server'], $parameters['username'], $parameters['password']);
     }
     if ($this->dbConn->connect_error) {
         $this->databaseError("Couldn't connect to MySQL database | " . $this->dbConn->connect_error);
     }
     $this->query("SET sql_mode = 'ANSI'");
     if (Config::inst()->get('MySQLDatabase', 'connection_charset')) {
         $this->dbConn->set_charset(Config::inst()->get('MySQLDatabase', 'connection_charset'));
     }
     $this->active = $this->dbConn->select_db($parameters['database']);
     $this->database = $parameters['database'];
     if (isset($parameters['timezone'])) {
         $this->query(sprintf("SET SESSION time_zone = '%s'", $parameters['timezone']));
     }
 }

 /**
  * Set character set of the MySQL-connection.
  *
  * Trys to set  the connection charset and returns it.
  * Throw Exception on failure.
  *
  * @param string $charset
  * @throws Exception
  *
  * @return string
  */
 public function setConnectionCharset($charset = 'utf8')
 {
     if (!$this->_mysqli instanceof mysqli) {
         $this->dbConnect();
     }
     if (!@$this->_mysqli->set_charset($charset)) {
         $this->sqlError($charset . ' ' . $this->_mysqli->error, $this->_mysqli->errno);
     }
     $this->connectionCharset = $this->_mysqli->character_set_name();
     return $this->connectionCharset;
 }

 /**
  * Try to connect to the database
  */
 public function connect()
 {
     $this->mysqli = new Mysqli($this->config['host'], $this->config['user'], $this->config['password'], $this->config['name']);
     if ($this->mysqli->connect_errno) {
         printf("Connect failed: %s\n", $this->mysqli->connect_error);
         exit;
     }
     if ($this->config['charset']) {
         $this->mysqli->set_charset($this->config['charset']);
     }
     return $this;
 }

 /**
  * Hace una conexión a la base de datos de MySQL
  *
  * @param array $config
  * @return resource_connection
  */
 public function connect($config)
 {
     if (!extension_loaded('mysqli')) {
         throw new KumbiaException('Debe cargar la extensión de PHP llamada php_mysqli');
     }
     $this->id_connection = new mysqli($config['host'], $config['username'], $config['password'], $config['name'], $config['port']);
     //no se usa $object->error() ya que solo funciona a partir de 5.2.9 y 5.3
     if (mysqli_connect_error()) {
         throw new KumbiaException(mysqli_connect_error());
     }
     //Selecciona charset
     if (isset($config['charset'])) {
         $this->id_connection->set_charset($config['charset']);
     }
     return TRUE;
 }

	/**
	 * @dataProvider data_strip_invalid_text
	 * @ticket 21212
	 */
	function test_strip_invalid_text( $data, $expected, $message ) {
		$charset = self::$_wpdb->charset;
		if ( isset( $data[0]['connection_charset'] ) ) {
			$new_charset = $data[0]['connection_charset'];
			unset( $data[0]['connection_charset'] );
		} else {
			$new_charset = $data[0]['charset'];
		}

		self::$_wpdb->charset = $new_charset;
		self::$_wpdb->set_charset( self::$_wpdb->dbh, $new_charset );

		$actual = self::$_wpdb->strip_invalid_text( $data );

		self::$_wpdb->charset = $charset;
		self::$_wpdb->set_charset( self::$_wpdb->dbh, $charset );

		$this->assertSame( $expected, $actual, $message );
	}

 /**
  * 连接数据库
  *
  * @return \mysqli|null|resource
  * @throws MysqlConnectException
  */
 public function connect()
 {
     if (is_null($this->mysql)) {
         $this->mysql = new \mysqli($this->host, $this->user, $this->password, $this->database, $this->port);
         $errno = $this->mysql->connect_errno;
         $error = $this->mysql->connect_error;
         if ($errno > 0) {
             $this->errno = $errno;
             $this->error = $error;
             $this->mysql->close();
             throw new MysqlConnectException($error, $errno);
         } else {
             $this->mysql->query('SET NAMES UTF8');
             $this->mysql->set_charset($this->charset);
         }
         return $this->mysql;
     } else {
         return $this->mysql;
     }
 }

 /**
  * Creates the connection to the MySQL DB through the MySQLi interface
  * 
  * @param boolean $useExceptions (optional) | Override on whether to use exceptions.  If not passed will use _DB_USE_EXCEPTIONS
  * @return boolean | TRUE on success (connection was made) / FALSE on failure
  * @throws _Exception | If _DB_USE_EXCEPTIONS is TRUE, will throw an exception instead of returning
  * false on connection error
  */
 private function createConnection($useExceptions = _DbConfig::USE_EXCEPTIONS)
 {
     $this->mysqli = new \mysqli($this->host, $this->username, $this->password, $this->dbName, $this->port, $this->socket);
     if (mysqli_connect_errno()) {
         $msg = 'Unable to connect to MySQL | ' . mysqli_connect_error();
         if ($useExceptions) {
             _Log::fatal($msg);
             $_e = new _Exception($msg, 0, $e);
             throw $_e;
         } else {
             _Log::warn($msg);
         }
     }
     if (isset($this->mysqli) && $this->mysqli !== NULL) {
         // set charset
         $rc = $this->mysqli->set_charset(_DbConfig::CHARSET);
         if ($rc !== TRUE) {
             _Log::warn('Error setting character set');
         }
         $this->isConnected = true;
         return TRUE;
     }
     return FALSE;
 }

 /**
  * Sets the connection's character set.
  *
  * @since 3.1.0
  *
  * @param resource $dbh     The resource given by the driver
  * @param string   $charset Optional. The character set. Default null.
  * @param string   $collate Optional. The collation. Default null.
  */
 public function set_charset($dbh, $charset = null, $collate = null)
 {
     if (!isset($charset)) {
         $charset = $this->charset;
     }
     if (!isset($collate)) {
         $collate = $this->collate;
     }
     if (!$dbh->set_charset($charset, $collate)) {
         if ($this->has_cap('collation') && !empty($charset)) {
             $query = $this->prepare('SET NAMES %s', $charset);
             if (!empty($collate)) {
                 $query .= $this->prepare(' COLLATE %s', $collate);
             }
             $this->query($query);
         }
     }
 }

 /**
  * Send/set output charset in several output media in a proper way
  *
  * @param string   $mode [http|html|mysql|mysqli|pdo|text_email|html_email]
  * @param resource $conn The MySQL connection handler/the link identifier
  *                                  
  * @return string header formula if there is any (in cases of html, text_email, and html_email)
  * @author Khaled Al-Shamaa <khaled@ar-php.org>
  */
 public static function header($mode = 'http', $conn = null)
 {
     $mode = strtolower($mode);
     $head = '';
     switch ($mode) {
         case 'http':
             header('Content-Type: text/html; charset=' . $this->_outputCharset);
             break;
         case 'html':
             $head .= '<meta http-equiv="Content-type" content="text/html; charset=';
             $head .= $this->_outputCharset . '" />';
             break;
         case 'text_email':
             $head .= 'MIME-Version: 1.0\\r\\nContent-type: text/plain; charset=';
             $head .= $this->_outputCharset . '\\r\\n';
             break;
         case 'html_email':
             $head .= 'MIME-Version: 1.0\\r\\nContent-type: text/html; charset=';
             $head .= $this->_outputCharset . '\\r\\n';
             break;
         case 'mysql':
             if ($this->_outputCharset == 'utf-8') {
                 mysql_set_charset('utf8');
             } elseif ($this->_outputCharset == 'windows-1256') {
                 mysql_set_charset('cp1256');
             }
             break;
         case 'mysqli':
             if ($this->_outputCharset == 'utf-8') {
                 $conn->set_charset('utf8');
             } elseif ($this->_outputCharset == 'windows-1256') {
                 $conn->set_charset('cp1256');
             }
             break;
         case 'pdo':
             if ($this->_outputCharset == 'utf-8') {
                 $conn->exec('SET NAMES utf8');
             } elseif ($this->_outputCharset == 'windows-1256') {
                 $conn->exec('SET NAMES cp1256');
             }
             break;
     }
     return $head;
 }