File manager - Edit - /home/autoph/public_html/api/aha/aha_checkPendingserviceRatings.php
Back
<?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'"; $result = $connhr->query($sql); if ($result->num_rows > 0) { $rows = array(); $count=0; while($row = $result->fetch_assoc ()){ $count = $count + 1; $selectedFields = [ 'id' => $row['id'], 'car_plate' => $row['car_plate'], 'serviceDate' => $row['date'] ]; $rows[] = $selectedFields; } } header('Content-Type: application/json'); echo json_encode([$rows,"count"=>"$count"]); } $connhr->close(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings