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)