Special PHP characters

It would be nice if you could incorporate your way of connecting, because if you use PDO you should do it like this:

$pdo = new Conexion();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->exec("SET CHARACTER SET utf8"); // <--utf8

In case you do it the old way it would be like this:

$conexion = mysql_connect($dbhost, $dbusuario, $dbpassword);
mysql_query("SET character_set_results = 'utf8', character_set_client ='utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $conexion);
mysql_select_db($db,$conexion);

with mysqli would be

<?PHP

@ $db = new mysqli(localhost, "root", "", "biblioteca");

if ($db->connect_error)
    die('Error de Conexion ('.$db->connect_errno.')'.$db->connect_error);

echo "Conexion correcta con la base de datos...".$db->host_info;
echo "Utilizando un charset, por defecto, de tipo: ".$db->character_set_name()";
$db->set_charset('utf8');

echo "Utilizando un nuevo charset de tipo: ".$db->character_set_name();
$db->close();

?>

And of course check if the database was created with character = utf8 and the collation = utf8_general_ci as well as the specific table to which queries.

Several options for this problem, apparently you tried

a) with the utf8_encode() method

b) Add the header with the charset for utf-8 :

<?php header('content-type: text/html; charset=utf-8');

I recommend as a third option, save your file php with utf-8 .

My problem was solved using this command when connecting to the database:

$connect = new PDO(
    "mysql:host=$host;dbname=$db",
    $user,
    $pass,
    array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));