PHP my_mysqli::character_set_name Examples

Example #1

File: bug37090.php Project: badlamer/hhvm

<?php

require_once "connect.inc";
$mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
$cs = array();
$cs[] = $mysql->set_charset("latin1");
$cs[] = $mysql->character_set_name();
$cs[] = $mysql->set_charset("utf8");
$cs[] = $mysql->character_set_name();
$cs[] = $mysql->set_charset("notdefined");
$cs[] = $mysql->character_set_name();
var_dump($cs);
print "done!";

Example #2

File: ext_mysqli_tests_mysqli_character_set_name_oo.php Project: zaky-92/php-1

<?php

/* NOTE: http://bugs.mysql.com/bug.php?id=7923 makes this test fail very likely on all 4.1.x - 5.0.x! */
require_once "connect.inc";
$tmp = NULL;
$link = NULL;
if (!($mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket))) {
    printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket);
}
if (!is_null($tmp = @$mysqli->character_set_name($link))) {
    printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
}
if (!($res = $mysqli->query('SELECT version() AS server_version'))) {
    printf("[003] [%d] %s\n", $mysqli->errno, $mysqli->error);
}
$tmp = $res->fetch_assoc();
$res->free_result();
$version = explode('.', $tmp['server_version']);
if (empty($version)) {
    printf("[006] Cannot determine server version, need MySQL Server 4.1+ for the test!\n");
}
if ($version[0] <= 4 && $version[1] < 1) {
    printf("[007] Need MySQL Server 4.1+ for the test!\n");
}
if (!($res = $mysqli->query('SELECT @@character_set_connection AS charset, @@collation_connection AS collation'))) {
    printf("[008] [%d] %s\n", $mysqli->errno, $mysqli->error);
}
$tmp = $res->fetch_assoc();
$res->free_result();
if (!$tmp['charset']) {
    printf("[009] Cannot determine current character set and collation\n");

Example #3

File: mysqli_character_set_name_oo.php Project: alphaxxl/hhvm

$res->free_result();
$version = explode('.', $tmp['server_version']);
if (empty($version)) {
    printf("[006] Cannot determine server version, need MySQL Server 4.1+ for the test!\n");
}
if ($version[0] <= 4 && $version[1] < 1) {
    printf("[007] Need MySQL Server 4.1+ for the test!\n");
}
if (!($res = $mysqli->query('SELECT @@character_set_connection AS charset, @@collation_connection AS collation'))) {
    printf("[008] [%d] %s\n", $mysqli->errno, $mysqli->error);
}
$tmp = $res->fetch_assoc();
$res->free_result();
if (!$tmp['charset']) {
    printf("[009] Cannot determine current character set and collation\n");
}
$charset = $mysqli->character_set_name();
if ($tmp['charset'] !== $charset) {
    if ($tmp['collation'] === $charset) {
        printf("[010] Could be known server bug http://bugs.mysql.com/bug.php?id=7923, collation %s instead of character set returned, expected string/%s, got %s/%s\n", $tmp['collation'], $tmp['charset'], gettype($charset), $charset);
    } else {
        printf("[011] Expecting character set %s/%s, got %s/%s\n", gettype($tmp['charset']), $tmp['charset'], gettype($charset), $charset);
    }
}
$charset2 = $mysqli->character_set_name();
if ($charset2 !== $charset) {
    printf("[012] Alias mysqli_character_set_name returned %s/%s, expected  %s/%s\n", gettype($charset2), $charset2, gettype($charset), $charset);
}
$mysqli->close();
/* Make sure that the function alias exists */
print "done!";