คือรับค่ามาจากแอนดรอย แล้วเอาไปเช็คใน mssql แล้วก็เอามาโชว์ครับ 
อันนี้ php ตัวเช็คหรือเอาไปเทียบหาค่าใน mssql ครับ 
-------------------------------------------------------------------
<?php
    $host = "192.168.xxx.x" ; // Host ip
    $username = "name" ;   //  Username
    $password = "pass" ;   // Password
    $db = "xxxxxx" ;  // Database Name
    $objConnect = mssql_connect($host, $username, $password);
    $objDB = mssql_select_db("xxxxx");
    //$_POST["sUID"] = "17314";
    //$_POST["strUser"] = "weerachai@1";  // for Sample
    $strUID = $_POST["sUID"];
    $strSQL = "SELECT * FROM view_stocklist WHERE 1 AND  UID = '".$strUID."'   ";
    $objQuery = mssql_query($strSQL);
    $objResult = mssql_fetch_array($objQuery);
    $intNumRows = mssql_num_rows($objQuery);
    if($intNumRows==0)
    {
        $arr['StatusID'] = "0"; 
        $arr['UID'] = "0"; 
        $arr['Error'] = "No barcode  ";
    
    }
    else
    {
        $arr['StatusID'] = "1"; 
        $arr['UID'] = $objResult["UID"]; 
        $arr['Error...'] = "";    
    }
    /**
        $arr['StatusID'] // (0=Failed , 1=Complete)
        $arr['MemberID'] // MemberID
        $arr['Error' // Error Message
    */
    
    mssql_close($objConnect);
    
    echo json_encode($arr);
?>
-----------------------------------------
ส่วนอันนี้ ตัวget ค่ามาโชว์
-----------------------------------------
<?php
$host = "192.168.xxx.xx" ; // Host ip
 $username = "xxxx" ;   //  Username
 $password = "xxxxx" ;   // Password
 $db = "xxxxxxx" ;  // Database Name
    $objConnect = mssql_connect($host, $username, $password);
    $objDB = mssql_select_db("xxxxxxx");
    
    $strUID = $_POST["sUID"];
    $strSQL = "SELECT * FROM view_stocklist WHERE  UID = '".$strUID."'  ";
    $objQuery = mssql_query($strSQL);
    $obResult = mssql_fetch_array($objQuery);
    if($obResult)
    {
        $arr["PARTNUMBER"] = $obResult["PARTNUMBER"];
        $arr["DESCRIPTN"] = $obResult["DESCRIPTN"];
        $arr["WHCODE"] = $obResult["WHCODE"];
        $arr["LOCATION"] = $obResult["LOCATION"];
        $arr["QTY"] = $obResult["QTY"];
        $arr["UM"] = $obResult["UM"];
        $arr["COND"] = $obResult["COND"];
    }
    //mysql_close($objConnect);
    
    echo json_encode($arr);
    
    ?>
----------------------
ช่วยดูทีครับควรเปลี่ยนตรงไหนพอดี มัน error แบบนี้ แต่มันไปเช็คถูก แต่ถ้าผมเอา WHERE 1 ออก ค่ามันไปเช็ค {"StatusID":"1","MemberID":null,"Error...":""} ตรง else แทน 
---------------------------------------------------------------
Warning: mssql_query() [function.mssql-query]: message: An expression of non-boolean type specified in a context where a condition is expected, near 'AND'. (severity 15) in C:\AppServ\www\joyMssql.php on line 16
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\joyMssql.php on line 16
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\joyMssql.php on line 17
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\joyMssql.php on line 18
{"StatusID":"0","MemberID":"0","Error":"No barcode "}																															
						 
												
						
					
ขอคำแนะนำทีครับ รับค่ามา1ค่าแล้วเอาไปเช็คใน mssql
อันนี้ php ตัวเช็คหรือเอาไปเทียบหาค่าใน mssql ครับ
-------------------------------------------------------------------
<?php
$host = "192.168.xxx.x" ; // Host ip
$username = "name" ; // Username
$password = "pass" ; // Password
$db = "xxxxxx" ; // Database Name
$objConnect = mssql_connect($host, $username, $password);
$objDB = mssql_select_db("xxxxx");
//$_POST["sUID"] = "17314";
//$_POST["strUser"] = "weerachai@1"; // for Sample
$strUID = $_POST["sUID"];
$strSQL = "SELECT * FROM view_stocklist WHERE 1 AND UID = '".$strUID."' ";
$objQuery = mssql_query($strSQL);
$objResult = mssql_fetch_array($objQuery);
$intNumRows = mssql_num_rows($objQuery);
if($intNumRows==0)
{
$arr['StatusID'] = "0";
$arr['UID'] = "0";
$arr['Error'] = "No barcode ";
}
else
{
$arr['StatusID'] = "1";
$arr['UID'] = $objResult["UID"];
$arr['Error...'] = "";
}
/**
$arr['StatusID'] // (0=Failed , 1=Complete)
$arr['MemberID'] // MemberID
$arr['Error' // Error Message
*/
mssql_close($objConnect);
echo json_encode($arr);
?>
-----------------------------------------
ส่วนอันนี้ ตัวget ค่ามาโชว์
-----------------------------------------
<?php
$host = "192.168.xxx.xx" ; // Host ip
$username = "xxxx" ; // Username
$password = "xxxxx" ; // Password
$db = "xxxxxxx" ; // Database Name
$objConnect = mssql_connect($host, $username, $password);
$objDB = mssql_select_db("xxxxxxx");
$strUID = $_POST["sUID"];
$strSQL = "SELECT * FROM view_stocklist WHERE UID = '".$strUID."' ";
$objQuery = mssql_query($strSQL);
$obResult = mssql_fetch_array($objQuery);
if($obResult)
{
$arr["PARTNUMBER"] = $obResult["PARTNUMBER"];
$arr["DESCRIPTN"] = $obResult["DESCRIPTN"];
$arr["WHCODE"] = $obResult["WHCODE"];
$arr["LOCATION"] = $obResult["LOCATION"];
$arr["QTY"] = $obResult["QTY"];
$arr["UM"] = $obResult["UM"];
$arr["COND"] = $obResult["COND"];
}
//mysql_close($objConnect);
echo json_encode($arr);
?>
----------------------
ช่วยดูทีครับควรเปลี่ยนตรงไหนพอดี มัน error แบบนี้ แต่มันไปเช็คถูก แต่ถ้าผมเอา WHERE 1 ออก ค่ามันไปเช็ค {"StatusID":"1","MemberID":null,"Error...":""} ตรง else แทน
---------------------------------------------------------------
Warning: mssql_query() [function.mssql-query]: message: An expression of non-boolean type specified in a context where a condition is expected, near 'AND'. (severity 15) in C:\AppServ\www\joyMssql.php on line 16
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\joyMssql.php on line 16
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\joyMssql.php on line 17
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\joyMssql.php on line 18
{"StatusID":"0","MemberID":"0","Error":"No barcode "}