php ส่งข้อมูล sql2008แล้วแสดงแสดงผลไม่เป็นไทย

------------------------------------
<?php
require_once ("inc/functions.php") ;
$view = $_GET['view'];
if ( in_array($account2, $editor_list) && $enable_edit ) {
if ($_GET['sidebar']) {
?>
<div id="item_title"><b class="title">ITEM PANEL MENU</b></div>
<div id="item_detail">
<p class="item_name" style="height: auto;"><img src="images/bullet.jpg" /> <a href="javascript: goPanelPage('add');">Add Item</a></p>
<p class="item_name" style="height: auto;"><img src="images/bullet.jpg" /> <a href="javascript: goPanelPage('modify');">Modify Items</a></p>
<p class="item_name" style="height: auto;"><img src="images/bullet.jpg" /> <a href="javascript: goPanelPage('<?php echo strtolower($cash_name) ;?>');">Add <?php echo $cash_name ;?></a></p>
</div>
<?php
}
else {
?>
<script type="text/javascript">
function addcash()
{
var account = $("#account").val();
var cash = $("#cash").val();

$.post("BackendPanel.php?view=<?php echo strtolower($cash_name) ;?>",{account: account, cash: cash},function(result){
$("#list").html(result);
});
}

function goViewPage(id)
{
goPanelPage('modify&page='+id);
}

function additem()
{
var form = $("#additem").serialize();

$.post("BackendPanel.php?view=add",form,function(result){
$("#list").html(result);
});
}

function edititem()
{
var form = $("#edititem").serialize();
var id = $("#listid").val();

$.post("BackendPanel.php?id="+id,form,function(result){
$("#list").html(result);
});
}

function switchBundle()
{
var display = $(".bundle:first").css("display");

if (display=="none")
$(".bundle").show();
else
$(".bundle").css("display","none");
}
</script>
<div id="item_cat"><b class="title">ITEM PANEL > <?php echo ($view == "add") ? "ADD ITEM" : ( ( $view == strtolower($cash_name)) ? "ADD " . strtoupper($cash_name) : "MODIFY ITEMS" ) ;?></b></div>
<div id="item_content">
<?php
switch ($view) {
case "add" :
if ( count($_POST)) {
$id = getLastID() + 1 ;
$query = "INSERT [{$mssql_db['webshop']}].dbo.PREMIUM_SHOP_TBL " ;
$fields = "(id" ;
$values = "VALUES ('" . $id . "'" ;
$i = 0 ;
foreach ($_POST as $field => $value) {
if ( ($field == "itemid" || $field == "name") && trim($value) == "" )
$error = true ;
if ($field == "price" || $field == "price_sale" || $field == "itemcount")
$value = abs($value) ;
if ($field == "desc")
$field = "[desc]" ;
if ($field == "isbundle" || $field == "forsale") {
if ($value == "on")
$value = 1 ;
else
$value = 0 ;
}
$fields .= ", " . $field ;
$values .= ", '" . preg_replace("/'/", "\'\'", $value) . "'" ;
}
$fields .= ")" ;
$values .= ")" ;
$query .= $fields . $values ;
if (!$error)
$result = mssql_query($query) ;
if ($result)
echo "<p style='text-align: center; color: green'>{$_POST['name']} added successfully.</p>" ;
else
echo "<p style='text-align: center; color: red'>Failed to add item.</p>" ;
}
?>
<style>
table th {padding: 1px; width: 100px;}
table td {border: 0;}
input, select, textarea {padding: 2px; width: 100%;}
select {width: 103%;}
</style>
<p>
<form action="javascript: additem();" id="additem">
<table style="width: 350px; margin: auto;">
<tr>
<th>Item ID:</th>
<td><input name="itemid" maxlength="8" /></td>
</tr>
<tr>
<th>Item Name:</th>
<td><input name="name" maxlength="75" /></td>
</tr>
<tr>
<th>Description:</th>
<td><textarea name="desc"></textarea></td>
</tr>
<tr>
<th>Count:</th>
<td><input name="itemcount" maxlength="4" /></td>
</tr>
<tr>
<th>Price:</th>
<td><input name="price" maxlength="8" /></td>
</tr>
<tr>
<th>Sale Price:</th>
<td><input name="price_sale" maxlength="8" value="0" /></td>
</tr>
<tr>
<th>Category:</th>
<td><select name="category"><option value="A">Special Bundles</option> <option value="B">Chance Boxes</option> <option value="C">New Player Packages</option> <option value="D">Upgrading</option> <option value="E">Stats & Awakenings</option> <option value="F">Functional Items</option> <option value="G">Buffs & Amps</option> <option value="H">Flasks & Potions</option> <option value="I">Food</option> <option value="J">Character</option> <option value="K">Storage</option> <option value="L">Guild & Party</option> <option value="M">Premium EXP Areas</option> <option value="N">Pick-Up Pets</option> <option value="O">Buff Pets</option> <option value="P">Pet Enhancements</option> <option value="Q">Pet Beads</option> <option value="R">Flying Items</option> <option value="S">Fashion Sets</option> <option value="T">Fashion Set Pieces</option> <option value="U">Clocks & Glasses</option> <option value="V">Hair</option> <option value="W">Furniture</option> <option value="X">Misc. Functional</option> <option value="Y">Misc. Fashion</option></select></td>
</tr>
<tr>
<th>Image Extension:</th>
<td><input name="image" maxlength="4" value="." /></td>
</tr>
<tr>
<th>Is Bundle:</th>
<td style="padding: 2px; border: 1px solid #ccc;"><input type="checkbox" name="isbundle" onclick="switchBundle();" /></td>
</tr>
<tr class="bundle">
<th>Item 1 ID:</th>
<td><input name="item1_id" maxlength="8" /></td>
</tr>
<tr class="bundle">
<th>Item 1 Name:</th>
<td><input name="item1_name" maxlength="75" /></td>
</tr>
<tr class="bundle">
<th>Item 1 Count:</th>
<td><input name="item1_count" maxlength="4" /></td>
</tr>
<tr class="bundle">
<th>Item 2 ID:</th>
<td><input name="item2_id" maxlength="8" /></td>
</tr>
<tr class="bundle">
<th>Item 2 Name:</th>
<td><input name="item2_name" maxlength="75" /></td>
</tr>
<tr class="bundle">
<th>Item 2 Count:</th>
<td><input name="item2_count" maxlength="4" /></td>
</tr>
<tr class="bundle">
<th>Item 3 ID:</th>
<td><input name="item3_id" maxlength="8" /></td>
</tr>
<tr class="bundle">
<th>Item 3 Name:</th>
<td><input name="item3_name" maxlength="75" /></td>
</tr>
<tr class="bundle">
<th>Item 3 Count:</th>
<td><input name="item3_count" maxlength="4" /></td>
</tr>
<tr class="bundle">
<th>Item 4 ID:</th>
<td><input name="item4_id" maxlength="8" /></td>
</tr>
<tr class="bundle">
<th>Item 4 Name:</th>
<td><input name="item4_name" maxlength="75" /></td>
</tr>
<tr class="bundle">
<th>Item 4 Count:</th>
<td><input name="item4_count" maxlength="4" /></td>
</tr>
<tr>
<th>For Sale:</th>
<td style="padding: 2px; border: 1px solid #ccc;"><input type="checkbox" checked name="forsale" /></td>
</tr>
<tr>
<td colspan="2" style="border: 0;"><input type="submit" value="Add Item" style="width: auto;" /></td>
</tr>
</table>
</form>
</p>
<?php
break ;
case strtolower($cash_name) :
?>
<p>Please enter a valid account name and a positive integer to add <?php echo $cash_name ;?> to a user's account.<br/>
<small><i>Negative values will be made positive, and if non-interger values in the <?php echo $cash_name ;?> field will be canceled.</i></small></p>
<p>
<form action="javascript: addcash();">
<table style="width: 190px; margin: auto;">
<tr>
<th style="padding: 1px;">Account:</th>
<td style="border: 0;"><input id="account" maxlength="16" style="padding: 2px;" /></td>
</tr>
<tr>
<th style="padding: 1px;"><?php echo $cash_name ;?>:</th>
<td style="border: 0;"><input id="cash" maxlength="10" style="padding: 2px;" /></td>
</tr>
<tr>
<td colspan="2" style="border: 0;"><input type="submit" value="Add <?php echo $cash_name ?>" style="padding: 2px;" /></td>
</tr>
</table>
</form>
<?php
if ( count($_POST)) {
if ( trim($_POST['account']) == "" || trim($_POST['cash']) == "" || !ctype_digit($_POST['cash'])) {
$error = "<div style='color: red; text-align: center;'>Failed to add {$cash_name}.</div>" ;
}
else {
$account = clean($_POST['account']) ;
$cash = clean( abs($_POST['cash'])) ;
$result = mssql_query("UPDATE [{$mssql_db['account']}].dbo.[CHR_LOG_INFO] SET cash = cash + {$cash} WHERE id_loginid = {$account}") ;
if ($result) {
$cash_result = mssql_query("SELECT TOP 1 {$cash_row} FROM [{$mssql_db['account']}].dbo.[CHR_LOG_INFO] WHERE id_loginid = {$account}") ;
$cash_array = mssql_fetch_array($cash_result) ;
$total_cash = $cash_array[$cash_row];
$error = "<div style='color: green; text-align: center;'><b>{$cash} {$cash_name}</b> has been added successfully to <b>{$_POST['account']}</b>'s account.<br/><b>Total Cash:</b> {$total_cash}</div>" ;
}
else
$error = "<div style='color: red; text-align: center;'>Failed to add <b>{$cash} {$cash_name}</b> to <b>{$_POST['account']}</b>'s account.</div>" ;
}
echo $error ;
}
?>
</p>
<?php
break ;
default :
if ($_GET['id']) {
$id = clean( abs($_GET['id'])) ;
$result = mssql_query("SELECT * FROM [{$mssql_db['webshop']}].dbo.PREMIUM_SHOP_TBL WHERE id = {$id}") ;
$row = mssql_fetch_array($result) ;
if ( !mssql_num_rows($result)) {
echo "<p style='text-align: center; color: #FF0000; padding-top: 30%; font-weight: bold'>Invalid item ID.</p>" ;
}
else
if ($_GET['view'] == "delete") {
if ( !isset ($_GET['confirm']))
echo
"<p style='text-align: center; color: #FF0000; padding-top: 25%; font-weight: bold'>Are you sure you wish to delete {$row['name']}?<br/><input type='button' value='Delete' onclick=\"goPanelPage('delete&id={$row['id']}&confirm');\" style='padding: 2px;' /> <input type='button' value='Cancel' onclick=\"goViewPage({$_SESSION['panelpage']});\" style='padding: 2px;' /></p>" ;
else {
$result = mssql_query("DELETE [{$mssql_db['webshop']}].dbo.PREMIUM_SHOP_TBL WHERE id = {$id}") ;
$lastpage = $_SESSION['panelpage'] ? $_SESSION['panelpage'] : 1 ;
if ($result)
echo "<p style='text-align: center; color: #FF0000; padding-top: 30%; font-weight: bold'>{$row['name']} deleted.<br/><a href=\"javascript: goViewPage({$lastpage});\">Back</a></p>" ;
else
echo "<p style='text-align: center; color: #FF0000; padding-top: 30%; font-weight: bold'>Failed to delete.<br/><a href=\"javascript: goViewPage({$lastpage});\">Back</a></p>" ;
}
}
else {
if ( count($_POST)) {
unset ($result) ;
if (!$_POST['isbundle'])
$_POST['isbundle'] = 0 ;
if (!$_POST['forsale'])
$_POST['forsale'] = 0 ;
$update = array() ;
foreach ($_POST as $field => $value) {
if ( ($field == "itemid" || $field == "name") && trim($value) == "" )
$error = true ;
if ($field == "price" || $field == "price_sale" || $field == "itemcount")
$value = abs($value) ;
if ($field == "isbundle" || $field == "forsale") {
if ($value)
$value = 1 ;
else
$value = 0 ;
}
if ($value != $row[$field]) {
if ( stristr($value, "'") || $field == "desc" )
$value = "'" . preg_replace("/'/", "''", $value) . "'" ;
else
$value = clean($value) ;
$update[$field] = $value ;
}
}
$query = "UPDATE [{$mssql_db['webshop']}].dbo.PREMIUM_SHOP_TBL SET " ;
if ( empty ($update))
$error = true ;
if (!$error) {
$i = 0 ;
foreach ($update as $row => $value) {
if ($i != 0)
$query .= "," ;
if ($row == "desc")
$row = "[desc]" ;
$query .= " {$row} = {$value}" ;
$i++;
}
$query .= " WHERE id = {$id}" ;
$result = mssql_query($query) ;
}
$item_name = $_POST['name'] ? $_POST['name'] : $row['name'];
if ($result) {
$row = $_POST ;
echo "<p style='text-align: center; color: green'>{$item_name} updated successfully.</p>" ;
}
else
echo "<p style='text-align: center; color: red'>Failed to update {$item_name}.</p>" ;
}
foreach ($row as $field => $value) {
$row[$field] = br( preg_replace("/'/", "\'", $value)) ;
}
?>
<script type="text/javascript">
$(document).ready(function() {
<?php
foreach ($row as $field => $value) {
if ($field == "desc") {
?>
$("textarea[name='<?php echo $field ;?>']").val('<?php echo $value ;?>');
<?php
}
else
if ($field == "category") {
?>
$("select[name='<?php echo $field ;?>']").val('<?php echo $value ;?>');
<?php
}
else
if ($field == "isbundle" || $field == "forsale") {
$onoff = $row[$field] ? "true" : "false"
?>
$("input[name='<?php echo $field ;?>']").attr('checked', <?php echo $onoff ;?>);
<?php
if ($field == "isbundle" && $onoff == "true") {
echo "$(\".bundle\").show();" ;
}
unset ($onoff) ;
}
else {
?>
$("input[name='<?php echo $field ;?>']").val('<?php echo $value ;?>');
<?php
}
}
?>
});
</script>
<style>
table th {padding: 1px; width: 100px;}
table td {border: 0;}
input, select, textarea {padding: 2px; width: 100%;}
select {width: 103%;}
</style>
<p>
<input id="listid" value="<?php echo $id ;?>" type="hidden" />
<form action="javascript: edititem();" id="edititem">
<table style="width: 350px; margin: auto;">
<tr>
<th>Item ID:</th>
<td><input name="itemid" maxlength="8" /></td>
</tr>
<tr>
<th>Item Name:</th>
<td><input name="name" maxlength="75" /></td>
</tr>
<tr>
<th>Description:</th>
<td><textarea name="desc"></textarea></td>
</tr>
<tr>
<th>Count:</th>
<td><input name="itemcount" maxlength="4" /></td>
</tr>
<tr>
<th>Price:</th>
<td><input name="price" maxlength="8" /></td>
</tr>
<tr>
<th>Sale Price:</th>
<td><input name="price_sale" maxlength="8" value="0" /></td>
</tr>
<tr>
<th>Category:</th>
<td><select name="category"><option value="A">Special Bundles</option> <option value="B">Chance Boxes</option> <option value="C">New Player Packages</option> <option value="D">Upgrading</option> <option value="E">Stats & Awakenings</option> <option value="F">Functional Items</option> <option value="G">Buffs & Amps</option> <option value="H">Flasks & Potions</option> <option value="I">Food</option> <option value="J">Character</option> <option value="K">Storage</option> <option value="L">Guild & Party</option> <option value="M">Premium EXP Areas</option> <option value="N">Pick-Up Pets</option> <option value="O">Buff Pets</option> <option value="P">Pet Enhancements</option> <option value="Q">Pet Beads</option> <option value="R">Flying Items</option> <option value="S">Fashion Sets</option> <option value="T">Fashion Set Pieces</option> <option value="U">Clocks & Glasses</option> <option value="V">Hair</option> <option value="W">Furniture</option> <option value="X">Misc. Functional</option> <option value="Y">Misc. Fashion</option></select></td>
</tr>
<tr>
<th>Image Extension:</th>
<td><input name="image" maxlength="4" value="." /></td>
</tr>
<tr>
<th>Is Bundle:</th>
<td style="padding: 2px; border: 1px solid #ccc;"><input type="checkbox" name="isbundle" onclick="switchBundle();" /></td>
</tr>
<tr class="bundle">
<th>Item 1 ID:</th>
<td><input name="item1_id" maxlength="8" /></td>
</tr>
<tr class="bundle">
<th>Item 1 Name:</th>
<td><input name="item1_name" maxlength="75" /></td>
</tr>
<tr class="bundle">
<th>Item 1 Count:</th>
<td><input name="item1_count" maxlength="4" /></td>
</tr>
<tr class="bundle">
<th>Item 2 ID:</th>
<td><input name="item2_id" maxlength="8" /></td>
</tr>
<tr class="bundle">
<th>Item 2 Name:</th>
<td><input name="item2_name" maxlength="75" /></td>
</tr>
<tr class="bundle">
<th>Item 2 Count:</th>
<td><input name="item2_count" maxlength="4" /></td>
</tr>
<tr class="bundle">
<th>Item 3 ID:</th>
<td><input name="item3_id" maxlength="8" /></td>
</tr>
<tr class="bundle">
<th>Item 3 Name:</th>
<td><input name="item3_name" maxlength="75" /></td>
</tr>
<tr class="bundle">
<th>Item 3 Count:</th>
<td><input name="item3_count" maxlength="4" /></td>
</tr>
<tr class="bundle">
<th>Item 4 ID:</th>
<td><input name="item4_id" maxlength="8" /></td>
</tr>
<tr class="bundle">
<th>Item 4 Name:</th>
<td><input name="item4_name" maxlength="75" /></td>
</tr>
<tr class="bundle">
<th>Item 4 Count:</th>
<td><input name="item4_count" maxlength="4" /></td>
</tr>
<tr>
<th>For Sale:</th>
<td style="padding: 2px; border: 1px solid #ccc;"><input type="checkbox" name="forsale" /></td>
</tr>
<tr>
<td colspan="2" style="border: 0;"><input type="submit" value="Edit Item" style="width: auto;" /></td>
</tr>
</table>
</form>
</p>
<p style="text-align: right;"><a href="javascript: goViewPage(<?php echo $_SESSION['panelpage'] ? $_SESSION['panelpage'] : 1 ;?>);">Back</a></p>
<?php
}
}
else {
$total_query = mssql_query("SELECT id FROM [{$mssql_db['webshop']}].dbo.PREMIUM_SHOP_TBL") ;
$total_pgs = mssql_num_rows($total_query) / $max_panel_list ;
$total_pages = roundUp($total_pgs) ;
if ($total_pages < 1)
$total_pages = 1 ;
if ($page > $total_pages)
$page = $total_pages ;
$pageMax = $page * $max_panel_list ;
$listArray = tableArray("SELECT TOP {$pageMax} * FROM [{$mssql_db['webshop']}].dbo.PREMIUM_SHOP_TBL") ;
$_SESSION['panelpage'] = $page ;
?>
<style>
table.panel-table tr td, table.panel-table tr th, table.panel-table tr th img {height: 35px; padding: 0; margin: 0; overflow: none;}
table.panel-table td, table.panel-table tr.panel-table-header th {padding: 2px; height: auto;}
th img {margin-top: 1px;}

#page_nav {width: 500px; height: 15px; padding: 0; text-align: center; margin: 2px auto;}
#page_nav a {color: #56585d; font-size: 13px; margin: auto 3px; font-weight: bold;}
#page_nav span {color:#5F87E1; font-size: 13px;}
</style>

<table style="width: 100%;" class="panel-table">
<tr class="panel-table-header">
<th>Image</th>
<th>Name</th>
<th style="width: 275px;">Description</th>
<th>Price</th>
<th>Options</th>
</tr>
<?php
for ( $i = $pageMax - $max_panel_list ; $i < count($listArray) ; $i++ ) {
?>
<tr<?php echo ( $i + 1 == count($listArray)) ? " class='last'" : "" ?>>
<th><img src="images/items/<?php echo $listArray[$i]['itemid'];echo $listArray[$i]['bundle'] ? "_bundle" : "" ;echo $listArray[$i]['image'];?>" /></th>
<td><?php echo $listArray[$i]['name'];?></td>
<td><?php echo ( strlen($listArray[$i]['desc']) > 40 ) ? substr($listArray[$i]['desc'], 0, 40) . "..." : $listArray[$i]['desc'];?></td>
<td><?php echo $listArray[$i]['price_sale'] ? $listArray[$i]['price_sale'] : $listArray[$i]['price'];echo " " . $cash_name_min ;?></td>
<td><a href="javascript: goPanelPage('modify&id=<?php echo $listArray[$i]['id'];?>');"><img src="images/management_edit.png" /></a> <a href="javascript: goPanelPage('delete&id=<?php echo $listArray[$i]['id'];?>');"><img src="images/management_delete.png" /></a></td>
</tr>
<?php
}
?>
</table>
<?php
echo '</div>' ;
echo '<p id="page_nav">' ;
echo page_list($total_pages, "goViewPage(") ;
echo '</p><div>' ;
}
}
?>
</div>
<?php
}
}
else {
include ("GetItemList.php") ;
}
?>
-----------------------------------------------
รบกวนช่วยน่อยครับ