Question

How to get the character set of MySQLi connection to MySQL in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = new mysqli('localhost', $db_user, $db_password, $db_name);

if ($con->connect_error) 
    die('Connection Error: ' . $con->connect_error);

echo "<pre>";
var_dump($con->get_charset());
echo "</pre>";
                                 
$con->close();


/*
run: 

object(stdClass)#2 (8) {
  ["charset"]=>
  string(6) "latin1"
  ["collation"]=>
  string(17) "latin1_swedish_ci"
  ["dir"]=>
  string(0) ""
  ["min_length"]=>
  int(1)
  ["max_length"]=>
  int(1)
  ["number"]=>
  int(8)
  ["state"]=>
  int(1)
  ["comment"]=>
  string(0) ""
}

*/

 

70+ SQL courses for beginners and professionals