<?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();

?>