|
 |
| |
มีปัญหา เกียวกับ PHPMyadmin ครับ เพิ่มข้อมูลเป็นภาษาไทยไม่ได้ |
| |
 |
|
|
 |
 |
|
ทำตาม
https://www.thaicreate.com/community/php-mysql-thai.html
แล้วนะครับ แล้วก็ลองสร้างตารางโดยตรงให้เป็นไทยก็ทำได้ แต่พอใช้โค๊ด PHP มันกลับเป็น ????? ครับ
Code (PHP)
<html>
<head>
<title>ThaiCreate.Com PHP & UTF-8</title>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
</head>
<body>
<?php
$objConnect = mysql_connect("localhost","876351","cyberman");
$objDB = mysql_select_db("876351db2");
mysql_query("SET NAMES UTF8");
/*** for Sample
$_POST["sUsername"] = "a";
$_POST["sPassword"] = "b";
$_POST["sName"] = "c";
$_POST["sEmail"] = "d";
$_POST["sTel"] = "e";
*/
$TableName = $_POST["sTableName"];
$strQuestionNumber = $_POST["sQuestionNumber"];
$strQuestionText = $_POST["sQuestionText"];
$strAChoice = $_POST["sAChoice"];
$strAScore = $_POST["sAScore"];
$strBChoice = $_POST["sBChoice"];
$strBScore = $_POST["sBScore"];
$strCChoice = $_POST["sCChoice"];
$strCScore = $_POST["sCScore"];
$strDChoice = $_POST["sDChoice"];
$strDScore = $_POST["sDScore"];
$strEChoice = $_POST["sEChoice"];
$strEScore = $_POST["sEScore"];
$strType = $_POST["sType"];
/*** Check QuestionNumber Exists ***/
$strSQL = "SELECT * FROM ".$TableName." WHERE QuestionNumber = '".$strQuestionNumber."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if($objResult)
{
$arr['StatusID'] = "0";
$arr['Error'] = "Question Number Exists!";
echo json_encode($arr);
exit();
}
/*** Insert ***/
$strSQL = "INSERT INTO ".$TableName." (QuestionNumber,QuestionText,AChoice,AScore,BChoice,BScore,CChoice,CScore,DChoice,DScore,EChoice,EScore,Type)
VALUES (
'".$strQuestionNumber."',
'".$strQuestionText."',
'".$strAChoice."',
'".$strAScore."',
'".$strBChoice."',
'".$strBScore."',
'".$strCChoice."',
'".$strCScore."',
'".$strDChoice."',
'".$strDScore."',
'".$strEChoice."',
'".$strEScore."',
'".$strType."'
)
";
$objQuery = mysql_query($strSQL);
if(!$objQuery)
{
$arr['StatusID'] = "0";
$arr['Error'] = "Cannot save data!";
}
else
{
$arr['StatusID'] = "1";
$arr['Error'] = "";
}
/**
$arr['StatusID'] // (0=Failed , 1=Complete)
$arr['Error'] // Error Message
*/
mysql_close($objConnect);
echo json_encode($arr);
?>
</body>
</html>
Tag : PHP, MySQL, Android
|
ประวัติการแก้ไข
2015-02-23 22:30:32
2015-02-23 22:30:55
|
 |
 |
 |
 |
| Date :
2015-02-23 22:29:40 |
By :
maxdarline |
View :
605 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
|
| |
|
|
| |
| Date :
2015-02-24 09:40:48 |
By :
LAGO |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
แสดงว่าที่ Database ไม่เป็นภาษาไทย ลองเพิ่มข้อมูลใหม่ดูครับ 
|
| |
|
|
| |
| Date :
2015-02-24 20:45:52 |
By :
mr.win |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 03
|
