สอบถามคะ ดึงค่าจาก DB มาโชว์ในหน้าเว็บแต่ไม่ขึ้นเป็นภาษาไทยคะ
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
Date :
2014-08-14 00:24:46By :
maisurin
Code (PHP) $con = mysqli_connect("sql3.freesqldatabase.com","sql349437","hE7%aN4%","sql349437");
$con->set_charset("utf8");
Date :
2014-08-14 00:40:13By :
Krungsri
Code (JavaScript)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>TEST</title>
<head>
<body>
<?php
function raw_json_encode($input) {
return preg_replace_callback(
'/\\\\u([0-9a-zA-Z]{4})/',
function ($matches) {
return mb_convert_encoding(pack('H*',$matches[1]),'UTF-8','UTF-16');
},
json_encode($input)
);
}
$test=array('สวัสดีครับ', 'อยู่ไหนกันครับ','ไปก่อนนะครับ','ลาก่อนครับ');
$txt=raw_json_encode($test);
echo $txt;
?>
</body>
</html>
Date :
2014-08-14 11:06:33By :
Chaidhanan
ลองเอาโค๊ดมาแปะดูครับ
Date :
2014-08-14 14:23:06By :
Chaidhanan
Code (PHP) <?php
$con = mysqli_connect("sql3.freesqldatabase.com","sql349437","hE7%aN4%","sql349437");
$con ->set_charset("utf8");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}else{
$result = mysqli_query($con,"select * from student");
while($row = mysqli_fetch_assoc($result)) {
$output[] = $row; }
}
print(json_encode($output));
//mysql_close($con);
?>
ประวัติการแก้ไข
Date :
2014-08-14 15:45:17By :
meannerss
ไม่ทราบ ว่า php version ไหนเหรอครับ
Date :
2014-08-14 15:59:57By :
Chaidhanan
Code (PHP) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>TEST</title>
<head>
<body>
<?php
$test=array( array('txt1'=>'สวัสดีครับ'), array('txt2'=>'อยู่ไหนกันครับ'), array('txt3'=>'ไปก่อนนะครับ'), array('txt4'=>'ลาก่อนครับ'));
$txt=raw_json_encode($test);
echo $txt;
function mat ($matches) {
return mb_convert_encoding(pack('H*',$matches[1]),'UTF-8','UTF-16');
}
function raw_json_encode($input) {
return preg_replace_callback( '/\\\\u([0-9a-zA-Z]{4})/', mat , json_encode($input) );
}
?>
</body>
</html>
Date :
2014-08-14 20:06:25By :
Chaidhanan
<?php raw_json_encode ($input) {raw_json_encode ($output));
Date :
2014-08-14 20:18:39By :
Chaidhanan
ใส่หัวใส่หาง html หรือเปล่าครับ
Date :
2014-08-14 20:42:18By :
Chaidhanan
Code (PHP) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>TEST</title>
<head>
<body>
<?php
$con = mysqli_connect("sql3.freesqldatabase.com","sql349437","hE7%aN4%","sql349437");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}else{
$con->query("SET NAMES UTF8");
$result = $con->query($con,"select * from student");
while($row = $result->fetch_assoc()) {
$output[] = $row;
}
print(json_encode($output));
}
?>
</body>
</html>
ลองดู โค๊ดอันนี้ครับว่าทำได้ไหม
Date :
2014-08-14 20:51:24By :
Chaidhanan
ขอโทษครับผิด ไปนิดCode (PHP) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>TEST</title>
<head>
<body>
<?php
$con = mysqli_connect("sql3.freesqldatabase.com","sql349437","hE7%aN4%","sql349437");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}else{
$con->query("SET NAMES UTF8");
$result = $con->query("select * from student");
while($row = $result->fetch_assoc()) {
$output[] = $row;
}
print(json_encode($output));
}
?>
</body>
</html>
Date :
2014-08-14 21:05:08By :
Chaidhanan
Code (PHP) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>TEST</title>
<head>
<body>
<?php
function mat ($matches) {
return mb_convert_encoding(pack('H*',$matches[1]),'UTF-8','UTF-16');
}
function raw_json_encode($input) {
return preg_replace_callback( '/\\\\u([0-9a-zA-Z]{4})/', mat , json_encode($input) );
}
$con = mysqli_connect("sql3.freesqldatabase.com","sql349437","hE7%aN4%","sql349437");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}else{
$con->query("SET NAMES UTF8");
$result = $con->query("select * from student");
while($row = $result->fetch_assoc()) {
$output[] = $row;
}
print(raw_json_encode($output));
}
?>
</body>
</html>
คาดว่าอันนี้คงไม่ผิดแล้วนะครับ
Date :
2014-08-14 21:19:30By :
Chaidhanan
เอผมก็ลองบน android แล้วนะครับ i-mobile i-style7 andrioid 4.2.2
Date :
2014-08-14 21:36:13By :
Chaidhanan
เป็นจาวาหรือเปล่าเครับ
Date :
2014-08-14 21:46:26By :
Chaidhanan
แอพใช้อะไรเขียนครับ
Date :
2014-08-14 21:47:27By :
Chaidhanan
Server 02
Load balance : Server 02
.
