send and retrive arabic data from mysql database

Question

I want to bring Arabic data from mysql database I wrote the php code but it gives me ????? on arabic data any help to make it wokrs ??

<?php header('Content-Type: charset=utf-8'); 
$link=mysqli_connect("localhost","root","","arabicd");
mysql_set_charset('utf8',$link);
if (mysqli_connect_errno($link))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

mysql_query("SET character_set_results = 'utf8'");
mysql_query("character_set_client = 'utf8'"); 
mysql_query("character_set_connection = 'utf8'");  
mysql_query("character_set_database = 'utf8'");
$result = mysqli_query($link,"SELECT question,answer FROM ask ");
while ($row = mysqli_fetch_array($result))
{
$output[]=$row;
}
print(json_encode($output));

if($data){
echo $data;
}
mysqli_close($con);
?>

You're mixing `mysql_*` and `mysqli_*`. Stick with mysqli for everything. — Mike, May 29 '15 at 03:36
Warning: mysqli_set_charset() expects parameter 1 to be mysqli, string given in C:\wamp\www\ArabicCon.php on line 3 Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\wamp\www\ArabicCon.php on line 9( ! ) Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\wamp\www\ArabicCon.php on line 10 Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\wamp\www\ArabicCon.php on line 11 Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\wamp\www\ArabicCon.php on line 12 [{"0":"????","question":"????","1":"????","answer":"????"}] — Najah Mousa, May 29 '15 at 03:45
possible duplicate of [PHP MYSQL Insert Data in Arabic Language](http://stackoverflow.com/questions/11262965/php-mysql-insert-data-in-arabic-language) — Ansari, May 29 '15 at 04:20

score 2 · Answer 1 · edited Oct 25 '16 at 16:55

2

Use this code in your PHP:

$db= mysqli_connect('localhost','root','225352','project');

$SQL= 'SET CHARACTER SET utf8';

mysqli_query($db,**$SQL**);) 
or die ( mysqli_error($SQL) );

edited Oct 25 '16 at 16:55

Gustavo Morales

2,614
9
29
37

answered Oct 25 '16 at 16:23

rs_

83
7

score 1 · Answer 2 · answered Jun 26 '15 at 05:05

No, don't use the mysql interface, use mysqli.
No, don't use SET NAMES, use mysqli_set_charset.

Do SHOW CREATE TABLE; you will probably find that the column you are trying to write into is CHARACTER SET latin. It needs to be utf8.

Text like \u0633 implies that you need to add JSON_UNESCAPED_UNICODE as the second argument to json_encode.

Abdo Adel · Accepted Answer · 2015-05-29T06:29:26.247

0

Though you can just use set names utf8 instead of all that creepy queries, there is nothing here wrong about Arabic, cheers :)
You are mixing mysql_* and mysqli_* which is not allowed
Even if it's allowed to use mysql & mysqli connections interchangeably, you are passing parameters toquery functions in an order that is different from expected
You should exit the script in case of connection failure (or do what ever, just change the execution flow)
That line print(json_encode($output)); is error prone, what if there are no results came from the table ? the loop will never be entered and $output will not be defined, so you must initialize $output with empty array, it's also a good practice to check if the result set is empty and handle it in a separate block
Also, it's preferred to enclose table names and columns in back ticks (`) in case that a column has a name of a reserved keyword

Here is a working version of your code after fixing errors

<html>

<meta charset="utf-8">
<?php 



$link = mysql_connect("localhost","root","");
if ($link === false)
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    exit;
}
mysql_select_db("arabicd", $link);
mysql_query("SET NAMES utf8");

$result = mysql_query("SELECT `ask`.`question`,`ask`.`answer` FROM `ask` ", $link);
$output = array();
while ($row = mysql_fetch_array($result))
{
    $output[]=$row;
}

print(json_encode($output));

if(isset($data))
{
 echo $data;
}

mysql_close($link);
?>
</html>

edited May 29 '15 at 06:29

answered May 29 '15 at 04:53

Abdo Adel

1,177
2
17
30

Thanks for Your notes it really helpful but still got same problem with arabic letters :\ – Najah Mousa May 29 '15 at 06:20
make sure that the table 'ask' collation is 'utf8_general_ci' – Abdo Adel May 29 '15 at 06:26
no still not working it gives me the following Array[{"0":"\u0633\u0624\u0627\u0644","question":"\u0633\u0624\u0627\u0644","1":"\u062c\u0648\u0627\u0628","answer":"\u062c\u0648\u0627\u0628"}] – Najah Mousa May 29 '15 at 06:33
yeah that's because you are using "json_encode", try "print_r" instead – Abdo Adel May 29 '15 at 06:34
( ! ) Parse error: syntax error, unexpected '$data' (T_VARIABLE) in C:\wamp\www\ArabicCon.php on line 30 :\ – Najah Mousa May 29 '15 at 06:40
print_r($output) not print(print_r($output)) – Abdo Adel May 29 '15 at 06:43
[{"0":"\u0633\u0624\u0627\u0644","question":"\u0633\u0624\u0627\u0644","1":"\u062c\u0648\u0627\u0628","answer":"\u062c\u0648\u0627\u0628"}] im sorry but still not working – Najah Mousa May 29 '15 at 06:46
print_r($output) not print(print_r($output)) not print_r(json_encode($output)) – Abdo Adel May 29 '15 at 06:49
1

thank u its working now mysql_query("SET CHARACTER_SET utf8;"); this line was missing – Najah Mousa May 29 '15 at 07:08

Nouman Tahir · Answer 4 · 2015-05-29T06:24:22.083

0

just use this in your tag in HTML page....

 meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

use < before meta word

edited May 29 '15 at 06:24

answered May 29 '15 at 06:14

Nouman Tahir

1
3

Comments are not for extended discussion; this conversation has been [moved to chat](http://chat.stackoverflow.com/rooms/79114/discussion-on-answer-by-nouman-tahir-send-and-retrive-arabic-data-from-mysql-dat). – Taryn May 29 '15 at 10:48

send and retrive arabic data from mysql database

4 Answers4