File manager

File manager - Edit - /home/custbahd/cornerstoneassetmanagers.com/admin/counter/get-raffle/index1.php

Back
<?php session_start(); include '../../db/saucerer.php'; // Super //$sql = "SELECT count() FROM participants WHERE draw='' AND super='1'"; //$result = $conn->query($sql); //while($row = mysqli_fetch_array($result)) { //$draw_count = $row['count()']; } // Category 1 $sql = "SELECT count() FROM participants WHERE draw='' AND category='1' AND account_type='personal'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $cat_count1 = $row['count()']; } $sql = "SELECT count() FROM participants WHERE draw='1' AND category='1' AND account_type='personal'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $cat_draw_count1 = $row['count()']; } // Category 2 $sql = "SELECT count() FROM participants WHERE draw='' AND category='2' AND account_type='personal'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $cat_count2 = $row['count()']; } $sql = "SELECT count() FROM participants WHERE draw='1' AND category='2' AND account_type='personal'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $cat_draw_count2 = $row['count()']; } // Category 3 $sql = "SELECT count() FROM participants WHERE draw='' AND category='3' AND account_type='personal'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $cat_count3 = $row['count()']; } $sql = "SELECT count() FROM participants WHERE draw='1' AND category='3' AND account_type='personal'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $cat_draw_count3 = $row['count()']; } // Category 4 $sql = "SELECT count() FROM participants WHERE draw='' AND category='4' AND account_type='personal'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $cat_count4 = $row['count()']; } $sql = "SELECT count() FROM participants WHERE draw='1' AND category='4' AND account_type='personal'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $cat_draw_count4 = $row['count()']; } // Category 5 $sql = "SELECT count() FROM participants WHERE draw='' AND category='5' AND account_type='personal'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $cat_count5 = $row['count()']; } $sql = "SELECT count() FROM participants WHERE draw='1' AND category='5' AND account_type='personal'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $cat_draw_count5 = $row['count()']; } if ($cat_count1>0 AND $cat_draw_count1<1) { $sql = "SELECT * FROM participants WHERE draw='' AND category='1' AND account_type='personal' ORDER BY rand() LIMIT 1"; //$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 '<input type="hidden" id="member_no" name="member_no" value="'.$row["id"].'-'.$row["category"].'" class="form-control">'; } } elseif ($cat_draw_count1==1 AND $cat_count2>0 AND $cat_draw_count2<1) { $sql = "SELECT * FROM participants WHERE draw='' AND category='2' AND account_type='personal' ORDER BY rand() LIMIT 1"; //$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 '<input type="hidden" id="member_no" name="member_no" value="'.$row["id"].'-'.$row["category"].'" class="form-control">'; } } elseif ($cat_draw_count2==1 AND $cat_count3>0 AND $cat_draw_count3<2) { $sql = "SELECT * FROM participants WHERE draw='' AND category='3' AND account_type='personal' ORDER BY rand() LIMIT 1"; //$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 '<input type="hidden" id="member_no" name="member_no" value="'.$row["id"].'-'.$row["category"].'" class="form-control">'; } } elseif ($cat_draw_count3==2 AND $cat_count4>0 AND $cat_draw_count4<2) { $sql = "SELECT * FROM participants WHERE draw='' AND category='4' AND account_type='personal' ORDER BY rand() LIMIT 1"; //$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 '<input type="hidden" id="member_no" name="member_no" value="'.$row["id"].'-'.$row["category"].'" class="form-control">'; } } elseif ($cat_draw_count4==2 AND $cat_count5>0 AND $cat_draw_count5<1) { $sql = "SELECT * FROM participants WHERE draw='' AND category='5' AND account_type='personal' ORDER BY rand() LIMIT 1"; //$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 '<input type="hidden" id="member_no" name="member_no" value="'.$row["id"].'-'.$row["category"].'" class="form-control">'; } } else { //echo '<h4 class="text-gradient p-3"><b>Congratulations</b></h4>'; } ?>

| ver. 1.4 | Github | . | PHP 8.1.33 | Generation time: 3.6 | proxy | phpinfo | Settings