01.<?php
02.$con= mysqli_connect("localhost","tttt","1122","tttt") or die("Error: " . mysqli_error($con));
03.
04.mysqli_query($con, "SET NAMES 'utf8' ");
05.
06.$query = "SELECT SUM(NUM) AS NUM, DATE_FORMAT(DATE, '%d-%m-20%y') AS DATE FROM daily GROUP BY DATE_FORMAT (DATE, '%d%-%m%-20%y%')";
07.$result = mysqli_query( $con, $query);
08.$resultchart = mysqli_query( $con, $query);
09.
10.
11.
12.$DATE = array();
13.$NUM = array();
14.list($b,$a) = array($a,$b);
15.
16.
17.while($rs = mysqli_fetch_array($resultchart)){
18. $DATE[] = "\"".$rs['DATE']."\"";
19. $NUM[] = "\"".$rs['NUM']."\"";
20.}
21.$DATE = implode(",", $DATE);
22.$NUM = implode(",", $NUM);
23.
24.?>
