Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = 'localhost';
- $dbuser = 'root';
- $dbpass = '';
- $dbname = 'grupo++';
- $options = [PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES UTF8"];
- $db = new PDO("mysql:dbname=" . $dbname . ";host=" . $host, $dbuser, $dbpass, $options);
- $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
- $sql = "SELECT * FROM usuarios";
- $stmt = $db->prepare($sql);
- try {
- $stmt->execute();
- if ($stmt->rowCount() > 0) {
- $dados = $stmt->fetchAll();
- }
- } catch (PDOException $e) {
- die($e->getMessage());
- }
- $labels = null;
- $dados_chart = null;
- foreach ($dados as $user) {
- $labels[] = $user['nome'];
- $dados_chart[] = $user['idade'];
- }
- ?>
- <!DOCTYPE>
- <html lang="pt-br">
- <head>
- <title>Gráficos com ChartJs</title>
- </head>
- <body>
- <?php ?>
- <div id="container" style="width: 75%;">
- <canvas id="myChart" width="200" height="100"></canvas>
- </div>
- <script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.7.2/Chart.min.js"></script>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.7.2/Chart.bundle.min.js"></script>
- <script>
- var ctx = document.getElementById("myChart").getContext('2d');
- var myChart = new Chart(ctx, {
- type: 'bar',
- data: {
- labels: <?php echo json_encode($labels); ?>,
- datasets: [{
- label: 'Idade do Usuário',
- data: <?php echo json_encode($dados_chart); ?>,
- backgroundColor: [
- 'rgba(255, 99, 132, 0.2)',
- 'rgba(54, 162, 235, 0.2)',
- 'rgba(255, 206, 86, 0.2)',
- 'rgba(75, 192, 192, 0.2)',
- 'rgba(153, 102, 255, 0.2)'
- ],
- borderColor: [
- 'rgba(255,99,132,1)',
- 'rgba(54, 162, 235, 1)',
- 'rgba(255, 206, 86, 1)',
- 'rgba(75, 192, 192, 1)',
- 'rgba(153, 102, 255, 1)'
- ],
- borderWidth: 1
- }]
- },
- options: {
- scales: {
- yAxes: [{
- ticks: {
- beginAtZero: true
- }
- }]
- }
- }
- });
- </script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement