|
![](/images/resource/spacer.gif) |
|
iOS - ล็อกอินผ่านแต่ว่า ไม่โชว์ข้อมูลล็อกอินค่ะ ช่วยดูการ Select ฐานข้อมูลให้หน่อยค่ะ |
|
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
![w w](https://www.thaicreate.com/upload/stock/20140322001116.png?v=1001)
หรือว่าจะดึงข้อมูลผิดค่ะช่วยดูให้หน่อยคะ่
Checklogin.php
Code (PHP)
<?
$objConnect = mysql_connect("localhost","root","root");
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
$objDB = mysql_select_db("movedb");
//$_POST["sPassword"] = ""; // for Sample
$strID = $_POST["sID"];
$strPassword = $_POST["sPassword"];
$strSQL = "SELECT * FROM STUDENT WHERE 1
AND ID = '".$strID."'
AND Password = '".$strPassword."'
";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
$intNumRows = mysql_num_rows($objQuery);
if($intNumRows==0)
{
$arr["Status"] = "0";
$arr["ID"] = "0";
$arr["Message"] = "Username and Password ไม่ถูกต้อง";
echo json_encode($arr);
exit();
}
else
{
$arr["Status"] = "1";
$arr["ID"] = $objResult["ID"];
$arr["Message"] = "Login Successfully";
echo json_encode($arr);
exit();
}
/**
return
// (0=Failed , 1=Complete)
// MemberID
// Error Message
*/
mysql_close($objConnect);
?>
getUserByMember.php
Code (PHP)
<?
$objConnect = mysql_connect("localhost","root","root");
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
$objDB = mysql_select_db("movedb");
$strID = $_POST["sID"];
$strSQL = "SELECT STUDENT.*, borrow.*
FROM STUDENT, borrow WHERE STUDENT.ID = ".$strID." AND borrow.ID = ".$strID." " ;
$objQuery = mysql_query($strSQL);
$obResult = mysql_fetch_array($objQuery);
if($obResult)
{
$arr["ID"] = $obResult["ID"];
$arr["FNameT"] = $obResult["FNameT"];
$arr["LNameT"] = $obResult["LNameT"];
$arr["Namebook"] = $obResult["Namebook"];
$arr["Startday"] = $obResult["Startday"];
$arr["Endday"] = $obResult["Endday"];
mysql_close($objConnect);
echo json_encode($arr);
?>
ฐานข้อมูลมี 2 ตาราง
1 ตาราง STUDENT เก็บข้อมูล User
2 ตาราง borrom เก็บข้อมูล หนังสือที่ Userได้ยืมไว้
รวบกวนด้วยค่ะ
Tag : Mobile, MySQL, iOS, iPhone, Objective-C, Mac
![](/images/adv.jpg?v=1001)
|
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2014-03-22 00:20:26 |
By :
foen |
View :
999 |
Reply :
1 |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
![](https://www.thaicreate.com/upload/tutorial/ios-iphone-login-check-username-password-14.jpg?v=1001)
iOS/iPhone Login Username and Password from Web Server
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2014-03-23 07:30:08 |
By :
mr.win |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
|
|
|
![](/images/digitalocean-banner.jpg)
|
Load balance : Server 02
|