将波斯值插入带有php代码的表中 [英] Insert persian value into a table with php code

问题描述

我想在表格中插入一个值.但是当我在代码下面运行时，我看到用 ???? 显示这个值.我该如何解决这个问题?

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 ?

插入.php

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

connect.php

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();
    }
?>

在此先感谢您的帮助.

推荐答案

TRy: PDO("mysql:host=localhost;dbname=DB;charset=UTF8");
这是一个有帮助的解决方案:
$pdo->query("SET CHARACTER_SET_RESULTS=NULL");
$result = $pdo->query("select * from table");

这篇关于将波斯值插入带有php代码的表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！