php mysql echarts动态生成图表,数据库和表格使用的java Servlet echarts 图表生成的一样数据,不知道的看我前面一篇博文;需要两个文件完成
1. 数据获取文件 weekbar.php
代码如下:
header("Content-type=text/json;charset=UTF-8");
$conn = @mysql_connect("127.0.0.1","root","root") or die("无法连接数据库...");
mysql_query("set names utf-8");
mysql_select_db("test",$conn);
$resultset = mysql_query('SELECT name, num FROM bar ');
$data = array();
class Alteration{
public $name;
public $num;
}
while($row = mysql_fetch_array($resultset,MYSQL_ASSOC)) {
$alter = new Alteration();
$alter->name = $row['name'];
$alter->num = $row['num'];
$data[] = $alter;
}
/*依次存入shop和num列到alyer()*/
echo js