 |
ขอคำแนะนำทีครับ รับค่ามา1ค่าแล้วเอาไปเช็คใน mssql |
|
 |
|
|
 |
 |
|
ติดปัญหาตรงไหนครับ
|
 |
 |
 |
 |
Date :
2015-06-04 16:15:09 |
By :
mr.win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
คือถ้าเปลี่ยนแล้ว ก็เหลือแค่เอาค่ามาเทียบนี้ก็น่าจะถูกเลยปะครับ
มันได้แบบนี้
{"StatusID":"1","UID":null,"Error...":""}
|
ประวัติการแก้ไข 2015-06-04 16:43:52
 |
 |
 |
 |
Date :
2015-06-04 16:42:23 |
By :
oreo1109 |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
อันนี้แล้วแต่คุณจะดึงค่าอะไรครับ
|
 |
 |
 |
 |
Date :
2015-06-04 16:46:04 |
By :
mr.win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Query ผิดครับ น่ามีผิดตรง AND
|
 |
 |
 |
 |
Date :
2015-06-04 17:19:59 |
By :
mr.win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ขอบคุณครับ
|
 |
 |
 |
 |
Date :
2015-06-04 20:20:49 |
By :
oreo1109 |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|

|
 |
 |
 |
 |
Date :
2015-06-05 09:01:27 |
By :
mr.win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ตือผมทำใน mysql มันได้แต่ผมจะไปเช็คใน mssql มันไม่ได้อ่ะครับ ช่วยดูให้อีกทีครับ
อันนี้โค้ดแอนดอรย
Code (Android-Java)
String url = "http://192.168.102.14/SSQL.php";
List<NameValuePair> params = new ArrayList<NameValuePair>();
params.add(new BasicNameValuePair("strUid", textView1.getText().toString()));
// params.add(new BasicNameValuePair("strPass", txt_name.getText().toString()));
/** Get result from Server (Return the JSON Code)
* StatusID = ? [0=Failed,1=Complete]
* MemberID = ? [Eg : 1]
* Error = ? [On case error return custom error message]
*
* Eg Login Failed = {"StatusID":"0","MemberID":"0","Error":"Incorrect Username and Password"}
* Eg Login Complete = {"StatusID":"1","MemberID":"2","Error":""}
*/
String resultServer = getHttpPost(url,params);
/*** Default Value ***/
String strStatusID = "0";
String strMemberID = "0";
String strError = "Unknow Status!";
JSONObject c;
try {
c = new JSONObject(resultServer);
strStatusID = c.getString("StatusID");
strMemberID = c.getString("MemberID");
strError = c.getString("Error");
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// Prepare Login
if(strStatusID.equals("0"))
{
// Dialog
ad.setTitle("Error! ");
ad.setIcon(android.R.drawable.btn_star_big_on);
ad.setPositiveButton("Close", null);
ad.setMessage(strError);
ad.show();
//textView1.setText("");
//txt_name.setText("");
}
else
{
// showInfo();
Toast.makeText(MainActivity.this, "barcode OK", Toast.LENGTH_SHORT).show();
// Intent newActivity = new Intent(MainActivity.this,MainActivity.class);
// newActivity.putExtra("MemberID", strMemberID);
// startActivity(newActivity);
}
}
});
-------------------------------
อันนี้โค้ด php ครับ
-------------------------
Code (PHP)
<?php
$host = "192.168.xxx.x" ; // Host ip
$username = "name" ; // Username
$password = "pass" ; // Password
$db = "ITREPORT" ; // Database Name
$objConnect = mssql_connect($host, $username, $password);
$objDB = mssql_select_db("ITREPORT");
//$_POST["sUID"] = "17314";
//$_POST["strUser"] = "weerachai@1"; // for Sample
$strUID = $_POST["sUID"];
//$strSQL = "SELECT PARTNUMBER, DESCRIPTN, WHCODE, LOCATION, QTY, UM, COND FROM view_stocklist where UID = 142294 ";
$strSQL = "SELECT * FROM view_stocklist WHERE UID = '".$strUID."' ";
$objQuery = mssql_query($strSQL);
$objResult = mssql_fetch_array($objQuery);
$intNumRows = mssql_num_rows($objQuery);
if($objResult==0)
{
$arr['StatusID'] = "0";
$arr['MemberID'] = "0";
$arr['Error'] = "No barcode ";
}
else
{
$arr['StatusID'] = "1";
$arr['MemberID'] = $objResult["MemberID"];
$arr['Error...'] = "";
}
/*
$arr['StatusID'] // (0=Failed , 1=Complete)
$arr['MemberID'] // MemberID
$arr['Error' // Error Message*/
mssql_close($objConnect);
echo json_encode($arr);
?>
|
 |
 |
 |
 |
Date :
2015-06-05 11:21:38 |
By :
oreo1109 |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
คับไปดึงจาก view_stocklisl ครับ
|
 |
 |
 |
 |
Date :
2015-06-05 13:09:43 |
By :
oreo1109 |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|