4

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>
 

 
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值