客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
1 <html> 2 <head> 3 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> 4 <title>Highcharts Example</title> 5 6 <?php 7 $conn=mysql_connect("localhost","root","") or die ("连接失败"); 8 mysql_query("set names utf8",$conn); 9 mysql_select_db("office",$conn); 10 $sql="SELECT convert(SUM(`total2`) ,decimal(10,2)) as total,`payment_date`as day FROM `toa_order`WHERE TIMESTAMPDIFF(DAY,`payment_date`,DATE(NOW()))<7 group by `payment_date`"; 11 $result=mysql_query($sql,$conn); 12 $day[] = array(); 13 $count[] =array(); 14 15 while($row = mysql_fetch_array($result)) 16 { 17 $day[]=$row['day']; 18 $count[]=intval($row['total']); 19 } 20 $day = json_encode($day); 21 22 $data1 = array(array("name"=>"day","data"=>$count)); 23 $data1 = json_encode($data1); //把获取的数据对象转换成json格式 24 ?> 25 26 <script type="text/javascript" src="http://cdn.hcharts.cn/jquery/jquery-1.8.3.min.js"></script> 27 <script src="js/highcharts.js"></script> 28 <script src="js/modules/exporting.js"></script> 29 <script type="text/javascript"> 30 $(function () { 31 $('#container').highcharts({ 32 title: { 33 text: 'Publish times', 34 x: -20 //center 35 }, 36 subtitle: { 37 text: 'write by:DongGe', 38 x: -20 39 }, 40 xAxis: { 41 categories: <?php echo $day; ?> 42 }, 43 yAxis: { 44 title: { 45 text: '金 额' 46 }, 47 plotLines: [{ 48 value: 0, 49 width: 1, 50 color: '#808080' 51 }] 52 }, 53 tooltip: { 54 valueSuffix: '元' 55 }, 56 legend: { 57 layout: 'vertical', 58 align: 'right', 59 verticalAlign: 'middle', 60 borderWidth: 0 61 }, 62 series: <?php echo $data1; ?> 63 }); 64 }); 65 </script> 66 67 </head> 68 <body> 69 70 <div ></div> 71 72 </body> 73 </html> 需引用的js:highcharts.js、jquery.highchartTable.js、jquery-1.8.2.min.js |
2022-08-17
2022-11-06
2022-07-18
2022-07-08
2022-08-17
shaodongtang/gaokao_exam: 高考试卷LaTeX模板
方法一： onLoad: function () { this.setData({ height: wx.getSystemInfoSync().win
bradtraversy/iweather: Ionic 3 mobile weather app
joaomh/curso-de-matlab
魔兽世界怀旧服已经开启两个多月了，但作为一个猎人玩家，抓到“断牙”，已经成为了一
rugk/mastodon-simplified-federation: Simplifies following and interacting with r
Directory listing is a web server function that displays the directory contents
takuoka/TKSubmitTransition: Animated UIButton of Loading Animation and Transitio
Tangshitao/Dense-Scene-Matching: Learning Camera Localization via Dense Scene Ma
相信不少果粉在对自己的设备进行某些操作时，都会碰到Respring，但这个 Respring 到底
请发表评论