Jump to content
jk1

filter for todays date and sort by name

Recommended Posts

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>

Share this post


Link to post
Share on other sites

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.)

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.