| public set_charset ( resource $dbh, string $charset = null, string $collate = null ) | ||
| $dbh | resource | The resource given by mysql_connect |
| $charset | string | The character set (optional) |
| $collate | string | The collation (optional) |
public function set_charset($dbh, $charset = null, $collate = null)
{
if (!isset($charset)) {
$charset = $this->charset;
}
if (!isset($collate)) {
$collate = $this->collate;
}
if ($this->has_cap('collation') && !empty($charset)) {
if ($this->use_mysqli) {
if (function_exists('mysqli_set_charset') && $this->has_cap('set_charset')) {
mysqli_set_charset($dbh, $charset);
} else {
$query = $this->prepare('SET NAMES %s', $charset);
if (!empty($collate)) {
$query .= $this->prepare(' COLLATE %s', $collate);
}
mysqli_query($query, $dbh);
}
} else {
if (function_exists('mysql_set_charset') && $this->has_cap('set_charset')) {
mysql_set_charset($charset, $dbh);
} else {
$query = $this->prepare('SET NAMES %s', $charset);
if (!empty($collate)) {
$query .= $this->prepare(' COLLATE %s', $collate);
}
mysql_query($query, $dbh);
}
}
}
} function connect_s9ydb()
{
$s9ydb = new wpdb(get_option('s9yuser'), get_option('s9ypass'), get_option('s9yname'), get_option('s9yhost'));
$s9ydb->set_charset($s9ydb->dbh, get_option('s9ycharset'));
set_magic_quotes_runtime(0);
return $s9ydb;
}
