4

最新推荐文章于 2023-04-06 18:11:15 发布

lyp880924

最新推荐文章于 2023-04-06 18:11:15 发布

阅读量271

点赞数

分类专栏： C++

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

版权

C++ 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

memberQuery.php

<html>
<head>
</head>
<body>
	<?php
		$memberPhone = $_GET["memberPhone"];
		
		//连接数据库
		$con = mysql_connect("localhost","root","root123");
		if (!$con) {
			die("Could't not connect: " . mysql_error());
		}
		
		echo $memberPhone;
		//选择数据库
		mysql_select_db("my_db",$con);
		$querySql = "select 
			id,goodsIdent,
			saleCounts,saleDate,
			salePrice,discountPrice,
			dealPrice,saler,memPhone
			from t_sale_detail where memPhone = '" . $memberPhone . "'";
		$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>";
		echo "******************************************";
		echo "<br>";
		//获取会员消费总金额
		$memTotalFeeSql = "select sum(dealPrice) as totalfee from t_sale_detail where memPhone = '" . $memberPhone . "'";
		echo "会员消费总金额：";
		$row = mysql_fetch_array(mysql_query($memTotalFeeSql,$con));
		echo $row['totalfee'];
		
		mysql_close($con);
	?>
	

</body>

</html>