D7net Mini Sh3LL v1
Current File : C:/Domains/maymaytinson.com/httpdocs/lib/images/13/../10/../7/../16/../activity/../JUKI/../15/../zip_food/../18/../17/../2/../21/../20/../22/../5/../11/../7/../5/../22/../22/../../../upload/../upload/../conn/../include/zip_member.php |
<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>
AnonSec - 2021 | Recode By D7net