Chart.js and PHP

Question

I am using Chart.js to create charts on my site. The data needs to come from a database so PHP needs to be inside the javascript.

This is what I have: (as just testing not the database part yet)

<?php
   $set1 = 20;
   $set2 = 30;
   $set3 = 40;
?>

And then to create the pie chart I have:

var pieData = [
  {
      value: <?php echo $set1; ?>,
      color:"#F38630"
  },
  {
      value : <?php echo $set2; ?>,
      color : "#E0E4CC"
  },
  {
      value : <?php echo $set3; ?>,
      color : "#69D2E7"
  }

];

var myPie = new Chart(document.getElementById("canvas").getContext("2d")).Pie(pieData);

With this code I recieve this error:

Uncaught SyntaxError: Unexpected token < when it reached the first <?php call.

What is the file extension?

Stephen Corcoran
– Stephen Corcoran

2014-02-04 17:08:57 +00:00
Commented Feb 4, 2014 at 17:08 — Stephen Corcoran
– Stephen Corcoran, Commented Feb 4, 2014 at 17:08

Community · Accepted Answer · 2017-05-23 12:01:55Z

4

I guess you are doing it in an .js file. I guess your webserver ist not interpreting php code. Instead it is serving it as static javascript code.

Do it in a <script></script> in an .php file.

If you dont want to pass variable by variable to javascript: Pass it as json.

An example can be found here:

Best way to transfer an array between PHP and Javascript

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Feb 4, 2014 at 17:09

Langusten Gustel

11k9 gold badges48 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vaibhav · Accepted Answer · 2015-01-09 06:14:54Z

1

Make the array of colors and pass your $row inside a foreach loop just like this.

foreach($row as $key=>$value)
            {
                $data[$key]['value']=(int)$value['id'];
                $data[$key]['color'] = $color[$key];
            }

And after that convert data into json like this

 var Data = <?php echo json_encode($dataArr['data']); ?>;

answered Jan 9, 2015 at 6:14

Vaibhav

2,5561 gold badge15 silver badges8 bronze badges

Comments

enrigama · Accepted Answer · 2014-05-18 00:13:37Z

This was helpfull!

I just changed my HTML doc to PHP, and then IT WORKS!

I am a rookie in code-develeper stuff, but my tip por MySQL cx is this.

Query:

<?php
session_start();
include_once "con.php"; #my conex in another doc

$query= "SELECT * FROM data ORDER BY id";
$result= mysql_query($query);

#For a simple first look, or rookies like me... I show the query result w/ an echo.  

while ($row= mysql_fetch_assoc($result)){
    echo $row['id'] . ' | ' . $row['mes'] . ' | ' . $row['valor1'] . ' % | ' . $row['valor2'] . ' % | ' . $row['valor3']. ' %' ."\n";


#This is what we need: I put data from my query in $setx, and then I use user3271851's code... it works!

    $set1= $row['valor1'];
    $set2= $row['valor2'];
    $set3= $row['valor3'];
}
?>

For the Chart, just like the post:

var pieData = [
  {
      value: <?php echo $set1; ?>,
      color:"#F38630"
  },
  {
      value : <?php echo $set2; ?>,
      color : "#E0E4CC"
  },
  {
      value : <?php echo $set3; ?>,
      color : "#69D2E7"
  }

];

var myPie = new Chart(document.getElementById("canvas").getContext("2d")).Pie(pieData);

P.S.: Sorry, my english is not good at all. :)

Collectives™ on Stack Overflow

Chart.js and PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related