filter for todays date and sort by name

[jk1]

I have designed a simple page to get meeting room details to display on our dashboards.

I would like to filter for today's date (start date) and then sort by room name (name) if possible:

(if you believe this could be written better (the server is on php 5.4) then also please let me know:

$ch = curl_init($url); 
   
//curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

$response = curl_exec($ch);
curl_close($ch);

$response = strip_tags($response);
$response = trim(preg_replace('/\s+/', ' ', $response));
$bookingArray = json_decode($response, true);
$timezone = date_default_timezone_get();

{
foreach($bookingArray["result"]["bookings"] as $booking)
{
echo
$booking["name"] 
. " - " .  
$booking["eventStatus"]["type"]
. " - ".
substr($booking["startDate"], -20)
. " - " .
substr($booking["endDate"], -20)
. " - " .  
$booking["eventName"]
. " - ".
$booking["primaryContact"]["givenName"]
. " " .
$booking["primaryContact"]["surName"]
. "<br>";
}
}

?>

</body>
</html>

[requinix]

Are you submitting some request to an API? Does that have any sort of searching, filtering, or sorting capability?

$response = strip_tags($response);
$response = trim(preg_replace('/\s+/', ' ', $response));

Why are those lines there? Are you sure you need them? (You shouldn't.) Does the script still work if you remove them? (It should.)

[jk1]

2 hours ago, requinix said:

Are you submitting some request to an API? Does that have any sort of searching, filtering, or sorting capability?

$response = strip_tags($response);
$response = trim(preg_replace('/\s+/', ' ', $response));

Why are those lines there? Are you sure you need them? (You shouldn't.) Does the script still work if you remove them? (It should.)

I am submitting a request to an api - it then returns the 7 fields on a line in a big list.

ill check to see if the api can filter/sort and also remove the response as well - I'm a beginner to php and only got this far due to my sql knowledge - in php is there an order by command?

[requinix]

6 hours ago, jk1 said:

in php is there an order by command?

Basically, yes, and if the API can't do what you need (I doubt it can) then your PHP can do it instead.