 |
Android - Code ฝั่ง PHP ขึ้น {"StatusID":"0","Error":"Cannot save data!"} ทำให้ Android ไม่สามารถ Save ข้อมูลได้ |
|
 |
|
|
 |
 |
|
Code (PHP)
<?
$objConnect = mysql_connect("localhost","root","root");
$objDB = mysql_select_db("newsextraction");
$strname = $_POST["sname"];
$strpassword = $_POST["spassword"];
$strSQL = "SELECT * FROM member WHERE name = '".$strname."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if($objResult)
{
$arr['StatusID'] = "0";
$arr['Error'] = "name Exists!";
echo json_encode($arr);
exit();
}
$strSQL = "INSERT INTO member (name,password)
VALUES (
'".$strname."',
'".$strpassword."',
)
";
$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);
?>
เมื่อ Run ฝั่ง PHP ขึ้น
Error
{"StatusID":"0","Error":"Cannot save data!"}
ส่งผลให้ฝั่ง Android ไม่สามารถ Saveข้อมูลลง Database ได้ รบกวนด้วยค่ะ
นี่รูปแบบของ ฐานข้อมูลค่ะ
Code (SQL)
CREATE TABLE `member` (
`member_id` int(3) NOT NULL auto_increment,
`name` varchar(30) character set tis620 NOT NULL,
`password` varchar(10) character set tis620 NOT NULL,
PRIMARY KEY (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=71 ;
Tag : Mobile
|
|
 |
 |
 |
 |
Date :
2013-03-18 15:36:33 |
By :
Monkey_CONAN |
View :
1159 |
Reply :
5 |
|
 |
 |
 |
 |
|
|
|
 |
 |
|
 |
 |
|