score:1
Accepted answer
I got the answer. I thought it is very difficult but its not.
This is my answer:
<?php
require_once('includes/database.php');
$stmt = mysqli_prepare($con, "SELECT date_format(entry_date, '%d-%b-%y'),
sum(doc_count) as pAmount FROM report_details GROUP BY entry_date
DESC");
$result = array('day' => array(), 'amount' => array());
if ($stmt) {
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $day, $amount);
while (mysqli_stmt_fetch($stmt)) {
$result['day'][] = $day;
$result['amount'][] = (int)$amount;
}
mysqli_stmt_close($stmt);
}
?>
I delete the alias 'pDate' and used the 'entry_date' to my query, and it works for me.
Source: stackoverflow.com
Related Query
- PHP Highcharts Group By Date
- Simple, Open source PHP wrapper for Highcharts library
- What's the code in Highcharts such that the bars (columns) in the same group use the same color?
- Converted PHP code that built an array to JS and now highcharts doesn't work - what did I do wrong?
- Replace PHP code in HIGHCHARTS code
- How to display Day and Date in Highcharts Column Graph using PHP
- Highcharts code with same set of code/data works in PHP but does not work in JSfiddle
- Highcharts - Date format from MS SQL to PHP issue
- How to filter date in highcharts by using php and mysql
- Highcharts data series issue with ajax/json and PHP
- Highcharts graph X-axis label for different date ranges
- json date format to Highcharts date format
- Highcharts - change background color along specific date range
- Highcharts - Highlight / Shade date range
- Rails - convert date string into javascript date object for highcharts
- Populate Highcharts X-Axis With Dates Given a From And To Date
- Highcharts date off by one day
- Highcharts - Skip date in series
- Remove UTC date from Highcharts tooltip
- Highcharts missing first date label on xAxis
- Using PhantomJS to create HighCharts grahps server side for use in PDF creation (PHP) - results in exit code 11 from PHPs exec();
- Highcharts tooltip date format when using pointFormat
- Proper x-axis for Highcharts stack group column
- HighCharts Date format
- highcharts is not respecting my x-axis' date interval
- Highcharts - Global configuration with common code and unique data & Headings
- Highcharts x axis date full range even if there is not enough data
- How to populate a Highcharts axis with string formatted data from a PHP array
- PHP JSON Highcharts load database result
- Highcharts X-Axis time from JS date
More Query from same tag
- How to access any particular data in highchart tooltip?
- HighCharts column unknown number of series
- rCharts Highcharts change xAxis labels
- Chart area exceeding series length
- Require highcharts-browserify to use specific version of highcharts?
- React highcharts, show legends as bar
- Highcharts - Add Axys properties when series are added later to Plot
- How do I filter countries/us/us-all-all to only show ca and nv?
- Highcharts missing information in scatterplot CSV/XLS export
- time data with irregular intervals in HighChart
- In highcharts horizontal bar chart, I can't display the default ticks
- HighChart Test React error#13
- Change Highmaps map colour
- How to show the legend in HighCharts
- External JSON from API into array?
- put condition depending on the value HIGHCHARTS
- Dynamically add data to series in Highcharts
- Why isn't my spline chart showing when using combo charts?
- could not find function "hc_add_series_density" Highcharter R
- Highcharts - How can I decrease space between categories?
- Array issue in rails and highcharts
- Highcharts css styles when exporting
- Set background color to DotNet.Highcharts
- How do I disable interaction on a Highcharts chart?
- Wkhtmltopdf + Highcart export issue
- Updating Highcharts realtime using Socket.io
- How to parse dates in highcharts from csv
- How to Draw graph in ASP.NET MVC 4 using High-Charts?
- Why would the label of the vertical axis only show after the button is clicked?
- How to retrieve/display title, units, copyright along with JSON data in Highcharts