補上js代碼,
var xmlHttp = createXmlHttpRequestObject();
function createXmlHttpRequestObject()
{
var xmlHttp;
try
{
xmlHttp = new XMLHttpRequest();
}
catch (e)
{
var XmlHttpVersions = new Array("MSXML2.XMlHTTP.6.0",
"MSXML2.XMlHTTP.5.0",
"MSXML2.XMlHTTP.4.0",
"MSXML2.XMlHTTP.3.0",
"MSXML2.XMlHTTP",
"Microsoft.XMlHTTP");
for(var i=0;i<XmlHttpVersions.length && !xmlHttp;i++)
{
try
{
xmlHttp = new ActiveXObject(XmlHttpVersions);
}
catch (e) {}
}
}
if(!xmlHttp)
alert("Error crearing XMLHttpRequest");
else
return xmlHttp;
}
function CallServer_sn()
{
var js_ip=document.getElementById("ip").value;
var js_sn=document.getElementById("SN").value;
var js_station=document.getElementById("station").value;
var js_mo=document.getElementById("mo").value;
var js_qty=document.getElementById("qty").innerHTML;
var js_total=document.getElementById("total_qty").innerHTML;
var js_num=document.getElementById("total_num").innerHTML;
var js=Math.random();
if(js_qty==''){js_qty=0;}
if(js_total==''){js_total=0;}
if(js_num==''){js_num=0;}
if (js_sn!="")
{
var url ="do.php?station="+js_station+"&SN="+js_sn+"&mo="+js_mo+"&js_qty="+js_qty+"&js_total="+js_total+"&js_num="+js_num+"&js_ip="+js;
xmlHttp.open("GET",url,true);
xmlHttp.onreadystatechange=handleRequestStateChange_name;
xmlHttp.send(null);
document.getElementById("SN").focus()
}else{
document.getElementById("SN").focus()
}
}
function handleRequestStateChange_name()
{
nameDiv = document.getElementById("result");
if(xmlHttp.readyState < 4)
{
//nameDiv.innerHTML = "loading..."+xmlHttp.readyState;
}else if(xmlHttp.readyState == 4){
if(xmlHttp.status == 200){
var res = xmlHttp.responML.getElementsByTagName("RES");
var sn = xmlHttp.responML.getElementsByTagName("sn");
var total = xmlHttp.responML.getElementsByTagName("total");
var qty = xmlHttp.responML.getElementsByTagName("qty");
var num = xmlHttp.responML.getElementsByTagName("num");
document.getElementById("SN").value="";
if(res[0].childNodes[0].nodeValue=='OK'){
nameDiv.innerHTML='SN:'+sn[0].childNodes[0].nodeValue+' 結果:'+res[0].childNodes[0].nodeValue;
document.getElementById("total_num").innerHTML=num[0].childNodes[0].nodeValue;
document.getElementById("total_qty").innerHTML=total[0].childNodes[0].nodeValue;
document.getElementById("qty").innerHTML=qty[0].childNodes[0].nodeValue;
document.getElementById("phr").controls.play();
}
}else{
alert("problrm" + e.toString());
}
}
}
以下是調用過程輸出結果 do.php
<?
header('Content-Type:text/xml;charset=big5');
include "../dblink.php";
$SN=strtoupper(trim($_GET['SN']));
$emp=$_SESSION['username'];
$mo=$_GET['mo'];
$station=$_GET['station'];
$js_qty=$_GET['js_qty'];
$js_total=$_GET['js_total'];
$js_num=$_GET['js_num'];
$ip=$_GET['js_ip'];
$RES='a';$COMM=$SN;
$sql="begin emesc.pub_F40packinginpcWG_KT(ATA,:EMP,:STATION_NUM,:MO,:SC,:COMM,:RES);end;";
$parsed=ociparse($link,$sql);
ocibindbyname($parsed,"ATA",$SN,30);
ocibindbyname($parsed,":EMP",$emp,30);
ocibindbyname($parsed,":STATION_NUM",$station,30);
ocibindbyname($parsed,":MO",$mo,30);
ocibindbyname($parsed,":SC",$SN,30);
ocibindbyname($parsed,":COMM",$COMM,1024);
ocibindbyname($parsed,":RES",$RES,30);
ociexecute($parsed);
if($RES=='OK'){
$js_num=$js_num+1;
$_SESSION['num']=$js_num;
$js_qty=$js_qty+1;
$_SESSION['qty']=$js_qty;
$js_total=$js_total+1;
$_SESSION['total_right']=$js_total;
}
echo '<?xml version="1.0" encoding="BIG5" standalone="yes" ?>';
echo '<serial_number> ';
echo '<sn>'.$SN.'</sn>
<mo>'.$mo.'</mo>
<model>'.$model_name.'</model>
<station>'.$station.'</station>
<qty>'.$js_qty.'</qty>
<total>'.$js_total.'</total>
<num>'.$js_num.'</num>
<com>'.$COMM.'</com>
<RES>'.$RES.'</RES>';
echo '</serial_number>';
?>