jk1 Posted February 11, 2019 Share Posted February 11, 2019 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> Link to comment Share on other sites More sharing options...
requinix Posted February 11, 2019 Share Posted February 11, 2019 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.) Link to comment Share on other sites More sharing options...
jk1 Posted February 11, 2019 Author Share Posted February 11, 2019 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? Link to comment Share on other sites More sharing options...
requinix Posted February 11, 2019 Share Posted February 11, 2019 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.