6

最新推荐文章于 2021-03-24 13:43:43 发布

lyp880924

最新推荐文章于 2021-03-24 13:43:43 发布

阅读量213

点赞数 1

分类专栏： C++

本文链接：https://blog.csdn.net/lyp880924/article/details/52402284

版权

C++ 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

<pre class="php" name="code">saleQuery.js

<p>var xmlHttp
function 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,memPhone
			from 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>

lyp880924

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
6

saleQuery.jsvar xmlHttpfunction showSaler(str){ xmlHttp=GetXmlHttpObject() if (xmlHttp == null) { alter("Browser does not support HTTP Request.") return } var url="salerQuery.php"
复制链接

扫一扫