Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- $mysql=mysql_connect('localhost','root','password');
- mysql_select_db('tbse');
- //Получаем метку даты 30 дневной давности о оформляем его в удобовариемый mysql-ем вид
- $last30d=date("c",strtotime("-30 day"));
- //Делаем выборку событий из базы старше нужного
- $res=mysql_query("SELECT COUNT(*),time_added FROM wordstat WHERE time_added>'$last30d' GROUP BY DAY(`time_added`)");
- while($row=mysql_fetch_array($res)) {
- $key=date("Y-m-d",strtotime($row['time_added']));
- $days[$key]=$row['COUNT(*)'];
- }
- //Сортируем массив в нужном порядке
- ksort($days);
- ?>
- <script type="text/javascript" src="https://www.google.com/jsapi"></script>
- <script type="text/javascript">
- // Load the Visualization API library and the piechart library.
- google.load('visualization', '1.0', {'packages':['corechart']});
- google.setOnLoadCallback(drawChart);
- // ... draw the chart...
- function drawChart() {
- // Create the data table.
- var data = new google.visualization.DataTable();
- data.addColumn('date', 'Дата');
- data.addColumn('number', 'Запросов');
- data.addRows([
- <?
- foreach($days as $day=>$count) {
- $date=strtotime($day)*1000;
- echo "[new Date($date), $count],\n";
- }
- ?>
- ]);
- var options = {'title':'Поисковых запросов, в день:',
- 'width':900,
- 'height':200,
- 'legend':{'position':'none'},
- 'titleTextStyle':{'fontName':'Georgia','fontSize':20,'bold':false},
- chartArea: {width: '100%'},
- vAxis: {textPosition: 'in',minValue: 0},
- };
- // Instantiate and draw our chart, passing in some options.
- var chart = new google.visualization.AreaChart(document.getElementById('chart_div'));
- chart.draw(data, options);
- }
- </script>
- <div id="chart_div" style="width: 900px; height: 200px;"></div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement