PHP
在pie.php我们要生成数据给前端调用:
$query = mysql_query("select * from chart_pie"); while ($row = mysql_fetch_array($query)) { $arr[] = array($row['title'], intval($row['pv'])); } $data = json_encode($arr);
Mysql
首先我们建一张·chart_pie·表作为统计数据。
CREATE TABLE IF NOT EXISTS `chart_pie` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, `pv` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
INSERT INTO `chart_pie` (`id`, `title`, `pv`) VALUES (1, '百度', 1239), (2, 'google', 998), (3, '搜搜', 342), (4, '必应', 421)