Dynamic chart Date range to filter records with PHP MySQL |
02-13-2023, 11:32 PM
(This post was last modified: 09-06-2023, 10:29 AM by ozornick. Edit Reason: Format code )
From the data recieved from the api, it contains a data with date '2017-02-28T00:00:00Z'; when you specify the start_date variable like this $sdate='2017-01-28T00:00:00Z'; and the end_date variable like this $edate='2017-02-28T00:00:00Z'; you get the data returned.
When you specify it like this $sdate='2017-01-28T00:00:00Z'; and the end date as this $edate='2017-03-28T00:00:00Z'; it bring out no data. PHP Code: $baseURL = 'https://myip/DynamicsNAV90/WS/'; what i'm trying to do is to search in between, i could have done this by writing a select statement on the database and specify the date ranges but since i'm only pulling from a web api its really difficult |
Messages In This Thread |
Dynamic chart Date range to filter records with PHP MySQL - by webamies - 12-02-2019, 01:11 AM
RE: Dynamic chart Date range to filter records with PHP MySQL - by InsiteFX - 12-02-2019, 08:58 AM
RE: Dynamic chart Date range to filter records with PHP MySQL - by webamies - 12-02-2019, 09:14 AM
RE: Dynamic chart Date range to filter records with PHP MySQL - by webamies - 12-04-2019, 02:30 AM
RE: Dynamic chart Date range to filter records with PHP MySQL - by chienlo - 11-16-2022, 01:16 PM
RE: Dynamic chart Date range to filter records with PHP MySQL - by AnneGodkoyj - 02-13-2023, 11:32 PM
|