Insert persian value into a table with php code

Question

I want to insert a value in a table . But when I am running below code , I see that shows this value with ???? . How can I solve this problem ?

insert.php

<?php
    include "connect.php";
    $query = "INSERT INTO customer_tab (name,phone,address) VALUE ('آزاده','0981245','ایران کرمان')";
    $result = $connect->prepare($query);
    $result->execute();
?>

connect.php

<?php
    $server = "localhost";
    $user = "azadgh";
    $pass = "*******";
    $dbname = "my_db";
    $dsn = "mysql:host=localhost;dbname=$dbname";
    try {
        $connect = new PDO($dsn, $user, $pass);
        $connect->exec("SET character_set_connection = 'UTF8");
        $connect->exec("SET NAMES 'UTF8");
        $connect->exec("SET CHARACTER SET 'utf8'");
    } catch (PDOException $error) {
        echo "unable to connect : " . $error->getMessage();
    }
?>

Thanks in advance for any help.

Missing single quote here. `$connect->exec("SET NAMES 'UTF8");`. Which may solve the problem — Goma, Dec 20 '17 at 07:41
check this:) This might be helpful for you https://stackoverflow.com/questions/6642755/insert-a-persian-text-in-mysql-table — rufatZZ, Dec 20 '17 at 07:42
The code was correct I had to set the collection to `utf8Persian-ci` in DataBase — Azade, Dec 21 '17 at 21:17

halojoy · Answer 1 · 2017-12-20T08:14:54.067

0

TRy: PDO("mysql:host=localhost;dbname=DB;charset=UTF8");
Here is one solution that helped:
$pdo->query("SET CHARACTER_SET_RESULTS=NULL");<br> $result = $pdo->query("select * from table");

edited Dec 20 '17 at 08:14

answered Dec 20 '17 at 07:42

halojoy

225
2
7

score 0 · Answer 2 · answered Dec 20 '17 at 07:50

0

I think database name is not reflecting in your code. Can you try to change your code like below,

$dbname = "my_db";
$dsn = "mysql:host=localhost;dbname="+$dbname+";

or

$dsn = "mysql:host=localhost;dbname=my_db;

answered Dec 20 '17 at 07:50

Hariprakash Sambath

159
1
5

I have no problem for adding Latin values . – Azade Dec 20 '17 at 07:57

Insert persian value into a table with php code

2 Answers2

Linked