6
来源：互联网 发布：vincizhang淘宝上有吗 编辑：程序博客网 时间：2024/05/14 09:58
<pre class="php" name="code">saleQuery.js
<p>var xmlHttpfunction showSaler(str){ xmlHttp=GetXmlHttpObject() if (xmlHttp == null) { alter("Browser does not support HTTP Request.") return } var url="salerQuery.php" url = url + "?saler=" + str url = url + "&sid=" + Math.random() xmlHttp.onreadystatechange=stateChanged xmlHttp.open("GET",url,true); xmlHttp.send(null)}</p><p>function stateChanged(){ if (xmlHttp.readyState == 4 || xmlHttp.readyState == "complete"){ document.getElementById("listSalers").innerHTML = xmlHttp.responseText }}</p><p>function GetXmlHttpObject(){ var xmlHttp = null; try{ //Firefox,Opera 8.0+, Safari xmlHttp = new XMLHttpRequest(); } catch (e){ //IE try { xmlHttp = new ActiveXObject("Msxm12.XMLHTTP"); } catch (e){ xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp;}</p><p> </p><p>salerQuery.php</p><pre class="php" name="code"><html><head></head><body><?php$saler = $_GET["saler"];//连接数据库$con = mysql_connect("localhost","root","root123");if (!$con) {die("Could't not connect: " . mysql_error());}//选择数据库mysql_select_db("my_db",$con);$querySql = "select id,goodsIdent,saleCounts,saleDate,salePrice,discountPrice,dealPrice,saler,memPhonefrom t_sale_detail where saler = '0" . $saler . "'";$result = mysql_query($querySql,$con);echo "<table border='1'><tr><th>编号</th><th>货号</th><th>数量</th><th>售货日期</th><th>售价</th><th>优惠金额</th><th>成交价格</th><th>营业员</th><th>会员电话</th></tr>";while ($row = mysql_fetch_array($result)) {echo "<tr>";echo "<td>" . $row['id'] . "</td>";echo "<td>" . $row['goodsIdent'] . "</td>";echo "<td>" . $row['saleCounts'] . "</td>";echo "<td>" . $row['saleDate'] . "</td>";echo "<td>" . $row['salePrice'] . "</td>";echo "<td>" . $row['discountPrice'] . "</td>";echo "<td>" . $row['dealPrice'] . "</td>";echo "<td>" . $row['saler'] . "</td>";echo "<td>" . $row['memPhone'] . "</td>";echo "</tr>";}echo "</table>";mysql_close($con);?></body></html> 0 0
