Google Chart by AngularJS table’s row click,display line chart

wp-admin

6 years ago

AngularJS : 1.6.5
Bootstrap : 3.x

Demo

  <head>
//
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
  </head>
  <body>
    <div ng-controller="MyCtrl">
      <div id="chart_div1"></div>
      <div id="chart_div2"></div>
    </div>
    <script type='text/javascript' src='js/angular.min.js'></script>
    <script type="text/javascript" src="js/app.js"></script>
  </body>

google.charts.load('current', {packages: ['table','corechart']});

google.charts.setOnLoadCallback(function() {
  angular.bootstrap(document.body, ['myApp']);
});

var myApp = angular.module('myApp', []);

myApp.controller('MyCtrl', function($scope,$http) {
  $scope.grphdisplay = function (site_name) {
    var url = '../pdo-webana2.php?site_name=' + site_name ;
    $http.get(url).then(function(response) {
      var data1 = new google.visualization.DataTable();
      data1.addColumn('string', 'year/mon');
      data1.addColumn('number', 'page_view');
      for(i = 0 ; i

(pdo-webana1.php)
require("db_info.php");

$dsn = 'mysql:host=localhost;dbname='.$database.';charset=utf8';

try {
  $dbh = new PDO($dsn, $username, $password,
    array(
      PDO::ATTR_EMULATE_PREPARES =>false,
      PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"
    )
  );
} catch (PDOException $e) {
  exit('データベース接続失敗。'.$e->getMessage());
}

date_default_timezone_set('Asia/Tokyo');
$result = array();

$st = $dbh->prepare('select year_mon,site_name,sum(page_view) as page_view from wp_sample where group by site_name');

$st->execute();
$result = $st->fetchAll(PDO::FETCH_ASSOC);

echo json_encode($result);


(pdo-webana2.php)
require("db_info.php");

$site_name = filter_input(INPUT_GET, 'site_name');
$dsn = 'mysql:host=localhost;dbname='.$database.';charset=utf8';

try {
  $dbh = new PDO($dsn, $username, $password,
    array(
      PDO::ATTR_EMULATE_PREPARES =>false,
      PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"
    )
  );
} catch (PDOException $e) {
  exit('データベース接続失敗。'.$e->getMessage());
}

date_default_timezone_set('Asia/Tokyo');
$result = array();

$st = $dbh->prepare('select year_mon, sum(page_view) as page_view from wp_sample where site_name = :site_name group by year_mon order by year_mon');

$st->bindValue(':site_name', $site_name , PDO::PARAM_STR);
$st->execute();
$result = $st->fetchAll(PDO::FETCH_ASSOC);

echo json_encode($result);