Guest User

Untitled

a guest
Feb 18th, 2019
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. <?php
  2. $connect = mysqli_connect("localhost", "root", "", "repo");
  3. $q = "SELECT SUM(importe_fac) as total , YEAR(fecha_fac) as anio FROM facturas GROUP BY YEAR(fecha_fac) ORDER BY id_fac ASC";
  4. $r = mysqli_query($connect, $q);
  5. $chart_data = '';
  6. while($row = mysqli_fetch_array($r))
  7. {
  8. $chart_data .= "{ y:'".$row["anio"]."', Total:".$row["total"]."}, ";
  9. }
  10. $chart_data = substr($chart_data, 0, -2);
  11. ?>
Add Comment
Please, Sign In to add comment