Question

How to set mysqli charset to UTF-8 in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'user';
$db_password    = '';
$db_name        = 'mydatabase';
 
$mysqli = new mysqli($db_host, $db_user, $db_password , $db_name);
$mysqli->set_charset("utf8");
 
if (mysqli_connect_errno()) 
    die("Connection Error: " . mysqli_connect_error() . "<br />");

 

70+ SQL courses for beginners and professionals