var xmlHttpq02
function q02trans(){
var mgd01;
var mgd02;
var mgd03;
var mgd04;
var mgd05;
var mgd06;
var mgd07;
var mgd08;
var mgd09;
var mgd10;
var mgd11;
var mgd12;
var mgd13;
var zorozt;
mgd01=document.getElementById("nampcfrq").value;
mgd02=document.getElementById("namhsfrq").value;
mgd03=document.getElementById("valpc").value;
mgd04=document.getElementById("valpc2").value;
mgd05=document.getElementById("gclass_1a").value;
mgd06=document.getElementById("gclass_2a").value;
mgd07=document.getElementById("gclass_3a").value;
mgd08=document.getElementById("beizpc").value;
mgd09=document.getElementById("jiangu").value;
mgd10=document.getElementById("date4").value;
mgd11=document.getElementById("date5").value;
mgd12=document.getElementById("nameim").value;
mgd13=document.getElementById("unitpc").value;xmlHttpq02=GetXmlHttpObjectq02()
if (xmlHttpq02==null)
{
alert ("Browser does not support HTTP Request")
return
}
var url="rsq02.php"
url=url+"?ma="+mgd01
url=url+"&mb="+mgd02
url=url+"&mc="+mgd03
url=url+"&md="+mgd04
url=url+"&me="+mgd05
url=url+"&mf="+mgd06
url=url+"&mg="+mgd07
url=url+"&mh="+mgd08
url=url+"&mi="+mgd09
url=url+"&mj="+mgd10
url=url+"&mk="+mgd11
url=url+"&ml="+mgd12
url=url+"&mm="+mgd13
url=url+"&sid="+Math.random()
xmlHttpq02.onreadystatechange=stateChangedq02
xmlHttpq02.open("GET",url,true)
xmlHttpq02.send(null)
}function stateChangedq02()
{
if (xmlHttpq02.readyState==4 || xmlHttpq02.readyState=="complete")
{
document.getElementById("jgdiv").innerHTML=xmlHttpq02.responseText
}
}function GetXmlHttpObjectq02()
{
var xmlHttpq02=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttpq02=new XMLHttpRequest();
}
catch (e)
{
//Internet Explorer
try
{
xmlHttpq02=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttpq02=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttpq02;
}
function q02trans(){
var mgd01;
var mgd02;
var mgd03;
var mgd04;
var mgd05;
var mgd06;
var mgd07;
var mgd08;
var mgd09;
var mgd10;
var mgd11;
var mgd12;
var mgd13;
var zorozt;
mgd01=document.getElementById("nampcfrq").value;
mgd02=document.getElementById("namhsfrq").value;
mgd03=document.getElementById("valpc").value;
mgd04=document.getElementById("valpc2").value;
mgd05=document.getElementById("gclass_1a").value;
mgd06=document.getElementById("gclass_2a").value;
mgd07=document.getElementById("gclass_3a").value;
mgd08=document.getElementById("beizpc").value;
mgd09=document.getElementById("jiangu").value;
mgd10=document.getElementById("date4").value;
mgd11=document.getElementById("date5").value;
mgd12=document.getElementById("nameim").value;
mgd13=document.getElementById("unitpc").value;xmlHttpq02=GetXmlHttpObjectq02()
if (xmlHttpq02==null)
{
alert ("Browser does not support HTTP Request")
return
}
var url="rsq02.php"
url=url+"?ma="+mgd01
url=url+"&mb="+mgd02
url=url+"&mc="+mgd03
url=url+"&md="+mgd04
url=url+"&me="+mgd05
url=url+"&mf="+mgd06
url=url+"&mg="+mgd07
url=url+"&mh="+mgd08
url=url+"&mi="+mgd09
url=url+"&mj="+mgd10
url=url+"&mk="+mgd11
url=url+"&ml="+mgd12
url=url+"&mm="+mgd13
url=url+"&sid="+Math.random()
xmlHttpq02.onreadystatechange=stateChangedq02
xmlHttpq02.open("GET",url,true)
xmlHttpq02.send(null)
}function stateChangedq02()
{
if (xmlHttpq02.readyState==4 || xmlHttpq02.readyState=="complete")
{
document.getElementById("jgdiv").innerHTML=xmlHttpq02.responseText
}
}function GetXmlHttpObjectq02()
{
var xmlHttpq02=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttpq02=new XMLHttpRequest();
}
catch (e)
{
//Internet Explorer
try
{
xmlHttpq02=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttpq02=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttpq02;
}
rsp02.php(部分)
================
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>
<body>
<?php$con = mysql_connect("localhost","root","122609louis");if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$ccds201=$_GET["ma"];
$getmt201=iconv("gb2312","UTF-8",$ccds201);
$getmt202=$_GET["mb"];
$getmt203=$_GET["mc"];
$getmt204=$_GET["md"];
$ccds205=$_GET["me"];
$getmt205=iconv("gb2312","UTF-8",$ccds205);
$ccds206=$_GET["mf"];
$getmt206=iconv("gb2312","UTF-8",$ccds206);
$ccds207=$_GET["mg"];
$getmt207=iconv("gb2312","UTF-8",$ccds207);
$ccds208=$_GET["mh"];
$getmt208=iconv("gb2312","UTF-8",$ccds208);
$getmt209=$_GET["mi"];
$getmt210=$_GET["mj"];
$getmt211=$_GET["mk"];
$ccds212=$_GET["ml"];
$getmt212=iconv("gb2312","UTF-8",$ccds212);
$ccds213=$_GET["mm"];
$getmt213=iconv("gb2312","UTF-8",$ccds213);
//类归法??
if($getmt201==""&&$getmt202==""&&$getmt203==""&&$getmt204==""&&$getmt205==""&&$getmt206==""&&$getmt207==""&&$getmt208==""&&$getmt209==""&&$getmt210==""&&$getmt211==""&&$getmt212==""&&$getmt213==""){
$fenglaiff="0-0-0-0-0-0-0-0-0-0-0-0-0";
}
//单价格模式OR无价格模式,及无日期或单日期模式mysql_select_db("jsp_db", $con);
if($getmt204==""&&$getmt211==""){
$result = mysql_query("SELECT * FROM intoput WHERE namhs LIKE '%$getmt201%' AND namhs LIKE '%$getmt202%' AND valpc LIKE '%$getmt203%' AND gclass_1a LIKE '%$getmt205%' AND gclass_2a LIKE '%$getmt206%' AND gclass_3a LIKE '%$getmt207%' AND beizpc LIKE '%$getmt208%' AND jiangu LIKE '%$getmt209%' AND D0ate4 LIKE '%$getmt210%' AND nameim LIKE '%$getmt212%' AND unitpc LIKE '%$getmt213%'") or die(mysql_error());$result1 = mysql_query("SELECT * FROM intoput WHERE namhs LIKE '%$getmt201%' AND namhs LIKE '%$getmt202%' AND valpc LIKE '%$getmt203%' AND gclass_1a LIKE '%$getmt205%' AND gclass_2a LIKE '%$getmt206%' AND gclass_3a LIKE '%$getmt207%' AND beizpc LIKE '%$getmt208%' AND jiangu LIKE '%$getmt209%' AND D0ate4 LIKE '%$getmt210%' AND nameim LIKE '%$getmt212%' AND unitpc LIKE '%$getmt213%' order by valpc desc limit 1") or die(mysql_error());
$result2 = mysql_query("SELECT * FROM intoput WHERE namhs LIKE '%$getmt201%' AND namhs LIKE '%$getmt202%' AND valpc LIKE '%$getmt203%' AND gclass_1a LIKE '%$getmt205%' AND gclass_2a LIKE '%$getmt206%' AND gclass_3a LIKE '%$getmt207%' AND beizpc LIKE '%$getmt208%' AND jiangu LIKE '%$getmt209%' AND D0ate4 LIKE '%$getmt210%' AND nameim LIKE '%$getmt212%' AND unitpc LIKE '%$getmt213%' order by valpc limit 1 ") or die(mysql_error());
$fltzme="分类特征为:";
$tgname="。";
}$nubok=0;
$zhiok=0;while($row = mysql_fetch_array($result1)){
$maxok=$row["valpc"];
}
while($row = mysql_fetch_array($result2)){
$mixok=$row["valpc"];
}
while($row = mysql_fetch_array($result)){
$nubok=$nubok+1;
$zhiok=$zhiok+ $row["valpc"];
}
if($nubok!=0){
$pjzhiok=$zhiok/$nubok
;}
else{ $pjzhiok=0;
$maxok=0;
$mixok=0;}
echo "<div id='ttlsaid' class='ttlsaid'>";
echo"<div class='bgcolor005' id='jgdivpriceban'>";
echo"<p> </p>";
echo" <p>查询价格为:</p>";
echo"<div class='bgcolor006' id='prpjttl'>";
echo"<p class='bgcolor006'>";
echo number_format($pjzhiok, 2, ". ", " ");