Please take a look the below code snippet for the same. You can call getData.php service upon changing the year through dropdown and render the chart with data received from the service. Replace (2 occurrences): colsisearchoptionssopt. x column is in timestamp, convert unixtimestamp(seconds) to javascript timestamp(milliseconds) by multipying the x value by 1000 Please refer for more informationĪrray_push($data_points, array("x"=> strtotime($row->x)*1000, "y"=> $row->y)) Įcho json_encode($data_points, JSON_NUMERIC_CHECK) You need to modify lib/inc/jqgriddist.php and allow null search operator for datepicker. $result = $handle->fetchAll(\PDO::FETCH_OBJ) $handle->bindParam(":year",$_GET, PDO::PARAM_INT) $handle = $link->prepare("SELECT * FROM datapoints where YEAR(x) = :year order by x") \PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, $link = new \PDO( 'mysql:host=localhost dbname=canvasjs_db charset=utf8mb4', //'mysql:host=localhost dbname=canvasjs_db charset=utf8mb4', header('Content-Type: application/json') Please take a below code snippet for getData.php service. That filter code means: If the current page is in the Edit or Add page, then filter the Products records which have the ProductCode only as the following: P-001, P-002, and P-003, otherwise display all products in the other pages (List and Search pages) which do not use the filter (represented by the empty string of filter in that code above). Creating a chart based on dropdown filter in php using data from database, you need to first create a php service getData.php which will provide data for any given year from database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |