insert variable to mysql database as utf-8

Question

I have some value in other language and i want to use utf-8 for this value.for now i use this code for store variable in database.

<?php
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);
$stmt=$mysqli->prepare("INSERT INTO user (fname , lname) VALUES (? , ? ) ");
$stmt->bind_param("ss",$fname,$lname);
$stmt->execute();
?>

I set collation for fname and lname column to utf-8.but i do not know how to modify database connection for insert variable as utf-8.I set collation of user table as utf-8.

@adib16 header('Content-Type: text/html; charset=utf-8'); on top of your file — Tommy
– Tommy, Commented Mar 6, 2014 at 7:50
@cryptivous yes thank you for that.but i think i must try both of your answer and the above comment.otherwise i must put uft8 header in php file and $mysqli->set_charset("utf8") . — adib16
– adib16, Commented Mar 6, 2014 at 7:51

nanobash · Accepted Answer · 2014-03-06 07:53:17Z

1

Try:

header("Content-Type: text/html; charset=utf-8"); // at the top of the file

$mysqli->set_charset("utf8"); // before the query

Set Charset, Header

edited Mar 6, 2014 at 7:53

answered Mar 6, 2014 at 7:41

nanobash

5,4967 gold badges41 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

insert variable to mysql database as utf-8

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related