File manager - Edit - /home/custbahd/cornerstoneassetmanagers.com/admin/counter/get-gender/index.php
Back
<!DOCTYPE html> <html> <head> <link rel="stylesheet" href="../../vendor/chartist/css/chartist.min.css"> <link href="../../vendor/bootstrap-select/dist/css/bootstrap-select.min.css" rel="stylesheet"> <link href="../../vendor/owl-carousel/owl.carousel.css" rel="stylesheet"> <link href="../../css/style.css" rel="stylesheet"> </head> <body> <?php session_start(); include_once "../db/config.php"; include_once('../db/count_db.php'); // Clients Count $sql = "SELECT COUNT(DISTINCT email), SUM(quantity) FROM checkout"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $clients_count = $row['COUNT(DISTINCT email)']; $quantity_count = $row['SUM(quantity)']; } echo '<div class="card">'; echo '<div class="card-header pb-0 border-0">'; echo '<div>'; echo '<h5 class="mb-0 text-black font-weight-bold">Gender</h5>'; echo '<p class="fs-14 mb-0">Analytics</p>'; echo '</div>'; echo '<select class="form-control style-1 default-select">'; echo '<option>Based on sales</option>'; echo '<option>Overall</option>'; echo '</select>'; echo '</div>'; echo '<div class="card-body">'; $sql = "SELECT gender, COUNT(DISTINCT email), SUM(quantity) FROM checkout GROUP BY gender ORDER BY SUM(quantity) DESC"; $result = $conn->query($sql); //display data on web page while($row = mysqli_fetch_array($result)){ $clients_one = $row["SUM(quantity)"] / $quantity_count; $clients_two = $clients_one * 100; $clients_ptg = round($clients_two, 0); include('../../modals/charts.php'); } echo '</div>'; echo '</div>'; ?> <script src="../../vendor/global/global.min.js"></script> <script src="../../vendor/bootstrap-select/dist/js/bootstrap-select.min.js"></script> <script src="../../vendor/chart.js/Chart.bundle.min.js"></script> <script src="../../js/custom.min.js"></script> <script src="../../js/deznav-init.js"></script> <script src="../../vendor/owl-carousel/owl.carousel.js"></script> <!-- Chart piety plugin files --> <script src="../../vendor/peity/jquery.peity.min.js"></script> <!-- Apex Chart --> <script src="../../vendor/apexchart/apexchart.js"></script> <!-- Dashboard 1 --> <script src="../../js/dashboard/analytics.js"></script> <script src="../../vendor/highlightjs/highlight.pack.min.js"></script> <!-- Circle progress --> <!-- Rating --> <script src="../../vendor/star-rating/jquery.star-rating-svg.js"></script> <!-- Animations --> <script src="../../js/animations/letter/script.js"></script> <script src="../../js/js/bootstrap.min.js"></script> <script src="../../js/js/owl.carousel.min.js"></script> <script src="../../js/js/main.js"></script> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 1.1 |
proxy
|
phpinfo
|
Settings