php杂记自留

最新推荐文章于 2025-12-20 20:43:01 发布

原创最新推荐文章于 2025-12-20 20:43:01 发布 · 200 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#php #mysql #开发语言

pid 表字段名定义为 parent_id 那么查询时给该字段取别名为 "parent_id as pid ";

php 使用无限级分类实现省市区…等的树形分层调用
网址1 https://blog.youkuaiyun.com/qq_42961790/article/details/102296361?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165521722416781435465584%2522%252C%2522scm%2522%253A%252220140713.130102334…%2522%257D&request_id=165521722416781435465584&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allsobaiduend~default-1-102296361-null-null.142^v14pc_search_result_control_group,157^v14new_3&utm_term=php%E5%81%9A%E7%9C%81%E5%B8%82%E5%8C%BA%E6%A0%91%E7%8A%B6%E5%9B%BE&spm=1018.2226.3001.4187

网址2
https://blog.youkuaiyun.com/leo_jk/article/details/81613249?spm=1001.2101.3001.6650.5&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromBaidu%7ERate-5-81613249-blog-7481820.pc_relevant_antiscanv2&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromBaidu%7ERate-5-81613249-blog-7481820.pc_relevant_antiscanv2&utm_relevant_index=10

网址3（数据库可用）
https://blog.youkuaiyun.com/weixin_29001327/article/details/114355471?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165521967616781685368094%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=165521967616781685368094&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_blogfirst_rank_ecpm_v1~rank_v31_ecpm-1-114355471-null-null.nonecase&utm_term=php+mysql+%E6%A0%91%E5%BD%A2%E6%95%B0%E6%8D%AE&spm=1018.2226.3001.4450

树状图
php mysql 柱状图,使用EChat通过php连接mysql数据库从而实现将数据转换为柱状图

网址4
https://blog.youkuaiyun.com/weixin_39900023/article/details/115925564?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165522143216782248552450%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=165522143216782248552450&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_blogfirst_rank_ecpm_v1~rank_v31_ecpm-1-115925564-null-null.nonecase&utm_term=phpmysql%E6%9F%B1%E7%8A%B6%E5%9B%BE&spm=1018.2226.3001.4450

网址5
jpgraph+php+mysql生成柱状图(含代码)

https://blog.youkuaiyun.com/syc1988109/article/details/8514677
jpgraph说明

https://blog.youkuaiyun.com/lyjtynet/article/details/2878746?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165522224316781667891800%2522%252C%2522scm%2522%253A%252220140713.130102334…%2522%257D&request_id=165522224316781667891800&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allsobaiduend~default-2-2878746-null-null.142^v14pc_search_result_control_group,157^v14new_3&utm_term=jpgraph&spm=1018.2226.3001.4187

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 id="container" style="min-width: 310px; height: 400px; margin: 0 auto"></div>
71 
72 </body>
73 </html>