File manager - Edit - /home/autoph/public_html/api/aha/DBA_AHA_userCount.php
Back
<?php include '../../../cfg/ahaconn.php'; $mykey =$_GET['apiKey']; //echo "Arnel " . $mykey; if($mykey =="6e59e008b5348b452b615a3033729daae383"){ $userID = $_GET['userID']; $ahaCount = 0; // SQL query $sql = "SELECT COUNT(1) AS AHACount FROM `customers` WHERE 1"; $result = $conn->query($sql); if ($result->num_rows > 0) { // Array to hold the results $rows = array(); // Fetch data from each row and add it to the array while($row = $result->fetch_assoc()) { $ahaCount = number_format(($row['AHACount']),0,'.',','); } // Output the result in JSON format header('Content-Type: application/json'); //echo json_encode($rows); echo json_encode(["count" => "$ahaCount"]); } else { echo "0 results"; } } $conn->close(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings