insert, update, select utf-8 to database mysql use php.md

Insert, Update database

must setting

in html

in php

in mysql

html

• meta utf-8 ex:

php

for query mysql_query("SET NAMES utf8");

ex:

• mysql_query("SET NAMES utf8");
• $result = mysql_query("INSERT INTO comment(message) VALUES('".$_POST["txtmessage"]."')");

mysql

table: structure collection have utf-8

ex: database mc_data table comment column message structure collection utf8mb4_vietnamese_ci

#Select database demo

$connection = mysql_connect('localhost', 'user', 'pw');

mysql_select_db('yourdb', $connection);

mysql_query("SET NAMES 'utf8'", $connection);

// Now you get UTF-8 encoded stuff

$query = sprintf('SELECT name FROM place where id = 1');

$result = mysql_query($query, $connection);

$result = mysql_fetch_assoc($result);

for insert, update query
http://tympanus.net/codrops/2009/08/31/solving-php-mysql-utf-8-issues/
for select query
http://stackoverflow.com/questions/6225013/how-do-i-make-mysql-return-utf-8