<?php
include '../../../cfg/ahaconn.php';
$mykey = $_GET['keyID'];
if($mykey =="6e59e008b5348b452b615a3033729daae383rateus"){
   $userID = $_GET['userID'];
    $sql = "SELECT * FROM `service_bookings` WHERE `aha_user_id`='$userID' AND `score`=0 AND `cancelled_by` is NULL AND `survey_completed`='No' AND `service_status_id`=15";
    
    $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()) {
            $rows[] = $row;
            $count=$count + 1;
        }
    
        
        
    } else {
        //echo "0 results";
    }
     
    header('Content-Type: application/json');
    echo json_encode([$rows,"count"=>"$count"]);
}
$conn->close();
?>