PHP Sql Server Show Lao Font With Problem (The result is ?????????????) that i use mssql_connect()
Config data type using NVARCHAR()
Date :
2016-02-18 06:16:11By :
mr.win
Yes that column i had create by using data type Nvarchar() like below image
Date :
2016-02-18 08:54:15By :
linouk
I think that code i had already putted as below but not worked for lao fontCode (PHP) <?php ob_start(); ?>
<?php
$ServerName = "LINOUKSOFT";
$UserName = "sa";
$Password = "linouk992.smf";
$conn = mssql_connect($ServerName, $UserName, $Password);
if($conn)
{
//echo "Server Connected...!";
mssql_select_db("RestaurantManagementSystem");
}
?>
Code (PHP) <?
include_once("ConnectionInfor.php");
$SQL = "SELECT * FROM TB_Product WHERE Product_ID = '$Product_ID' ";
$Query = mssql_query($SQL) or die ("Error Query [".$SQL."]");
$Result = mssql_fetch_array($Query);
echo $Result["Product_ProductImage"];
?>
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" />-->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Customer Service</title>
<link href="CSS/Services.css" rel="stylesheet" type="text/css" />
</head>
<body onload="noBack();"onpageshow="if (event.persisted) noBack();" onunload="">
<form id="form1" name="form1" method="post" action="">
<?php
include_once("ConnectionInfor.php");
$SQL = "SELECT Product_ProductImage, Product_ID, Product_NameLao FROM TB_Product";
$Query = mssql_query($SQL) or die ("Error Query [".$SQL."]");
?>
<table style="font-size:50px; font-family:'Phetsarath OT'; text-align:left; color:#FFF; background-color:#607D8B" width="970" border="1" cellpadding="0" cellspacing="0">
<tr>
<th width="200" style="background-color:#424242"> <div align="center">ຮູບເມນູ</div></th>
<th width="152" style="background-color:#424242"> <div align="center">ລະຫັດ</div></th>
<th width="513" style="background-color:#424242"> <div align="center">ລາຍລະອຽດເມນູ</div></th>
<th width="95" style="background-color:#424242; text-align:center;"> <div>$$$</div></th>
</tr>
<? while($objResult = mssql_fetch_array($Query)) { ?>
<tr>
<td><center><img width="300" height="250" src="ServicesImageView.php?Product_ID=<?php echo $objResult["Product_ID"];?>"></center></td>
<td style="font-size:50px; font-family:'Phetsarath OT'; text-align:left; color:#000000;"><div align="center"><?php echo $objResult["Product_ID"];?></div></td>
<td style="font-size:40px; font-family:'Phetsarath OT'; text-align:left; color:#000000;"><?php echo $objResult["Product_NameLao"];?></td>
<td style="font-size:40px; font-weight:bold; font-family:'Phetsarath OT'; text-align:center; color:#F00;"><a href="PHPSqlShowData.php">ສັ່ງ</a></td>
</tr>
<? } ?>
</table>
<a href="<?php echo $logoutAction ?>" style="font-family:'Phetsarath OT'; font-size:70px; width:550px; height:100px; color:#FFC107; margin-left:350px;">Log out</a>
</form>
</body>
</html>
Date :
2016-02-18 13:26:47By :
linouk
Date :
2016-02-18 13:31:39By :
mr.win
Server 02
Load balance : Server 02
