<div id="frame">
	<div id="titleFrame"><h2>Thành viên</h2></div>
	<div id="listFrame">
	<?php
		$stmt=$conn->prepare("SELECT * FROM zip_member");
		$stmt->execute();
		$members=$stmt->fetchAll(PDO::FETCH_ASSOC);
		$stt=1;?>
		<table>
			<thead>
				<th>Stt</th>
				<th>user</th>
				<th>email</th>
				<th>điểm</th>
				<th>phân loại</th>
			</thead>
		<?php foreach ($members as $member){ 
				$stmt=$conn->prepare("SELECT * FROM cart_zip WHERE member='".$member['user']."'");
				$stmt->execute();
				$cal=$stmt->fetchAll(PDO::FETCH_ASSOC);
				$total=0;
				foreach($cal as $cal){
					$total+=$cal['price']*$cal['amount'];
				}
			?>
			<tr>
				<td><?php echo $stt;$stt++ ?></td>
				<td><?php echo $member['user']; ?></td>
				<td><?php echo $member['email']; ?></td>
				<td><?php echo $member['point']; ?></td>
				<td><?php if($member['point']<1000){ echo "Thường"; }else{ echo "Vip"; } ?></td>
			</tr>
		<?php } ?>
		</table>
	</div>

</div>