utf 8 - PHP y MySQLi UTF8
mi tabla char set es utf8 y su compilación es utf8.now tengo este código:
<code> $mysqli = new mysqli("localhost", "root", "", "Amoozeshgah"); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); } if (!$mysqli->set_charset("utf8")) { printf("Error loading character set utf8: %s\n", $mysqli->error); } else { printf("Current character set: %s\n", $mysqli->character_set_name()); } mysql_set_charset('utf8'); if ($stmt = $mysqli->prepare("SELECT About_Title FROM Tbl_About WHERE About_Id=?")) { $city = 8; /* bind parameters for markers */ $stmt->bind_param("s", $city); /* execute query */ $stmt->execute(); /* bind result variables */ $result = $stmt->get_result(); /* fetch value */ while ($myrow = $result->fetch_assoc()) { // use your $myrow array as you would with any other fetch printf("%s is in district %s\n", $city, $myrow['About_Title']); print("shod"); } </code>
pero fuera de lugar es:
<code>Current character set: utf8 8 is in district نتمنتشس shod </code>
¿que puedo hacer? Edición: he sustituido:
<code>if (!$mysqli->set_charset("utf8")) { printf("Error loading character set utf8: %s\n", $mysqli->error); } else { printf("Current character set: %s\n", $mysqli->character_set_name()); } mysql_set_charset('utf8'); </code>
con
<code>$mysqli->set_charset("utf8") </code>
Pero no hay diferencia.