File manager - Edit - /home/custbahd/cornerstoneassetmanagers.com/admin/counter/get-raffle/index2.php
Back
<?php session_start(); include '../../db/saucerer.php'; echo '<div class="row">'; $sql = "SELECT COUNT(*) FROM participants WHERE draw='1'"; $result = $conn->query($sql); //display data on web page while($row = mysqli_fetch_array($result)){ $top_count = '1'; $winner_count =$row['COUNT(*)']; } $sql = "SELECT * FROM participants WHERE draw='1' ORDER BY last_update DESC"; //$sql = "SELECT * FROM clients WHERE ban='' ORDER BY id DESC"; $result = $conn->query($sql); //display data on web page while($row = mysqli_fetch_array($result)){ echo '<div class="col-lg-4 col-md-4 col-6 single-item floating"> <div class="item" style="background: none; border: 1px solid #A87E2C; border-radius: 6px; font-size: 14px;"> <!--<div class="thumb"> <div class="cats1"> <a>'.$top_count++.'</a> </div> </div>--> <div class="info" style="padding-top: 15px; padding-bottom: 0px;"> <div class="meta"> <ul> <li> <!--<span style="position: absolute;top: -15px;left: -22px;">'.$top_count++.'</span>--> <i class="fa fa-user-tie text-gradient mr-2"></i> <span class="text-white">'.$row["member_no"].'</span> </li> </ul> </div> </div> </div> </div>'; } if ($winner_count==0) { echo '<p>The Raffle has not started yet</p>'; } echo '</div>'; ?>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 1.19 |
proxy
|
phpinfo
|
Settings