Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. <div id="container" style="height: 600px; width: 900px"></div>
  2.  
  3. var cats = [];
  4. var data = [];
  5. $.get("http://test.controlcash.ru/get.php", function(resp){
  6. for (i=0; i<resp.length; i++) {
  7. cats.push(resp[i].x);
  8. data.push(resp[i].y);
  9. }
  10. }).done(function() {
  11. chart.xAxis[0].setCategories(cats);
  12. chart.series[0].setData(data);
  13. })
  14.  
  15. var chart = new Highcharts.Chart({
  16. chart: {
  17. renderTo: 'container',
  18. marginBottom: 80
  19. },
  20. xAxis: {
  21. labels: {
  22. rotation: 90
  23. }
  24. },
  25. series: [{
  26. data: [0]
  27. }]
  28. });
  29.  
  30. var cats = [];
  31. var data = [];
  32. $.get("http://test.controlcash.ru/get.php", function(resp){
  33. for (i=0; i<resp.length; i++) {
  34. cats.push(resp[i].x);
  35. data.push(resp[i].y);
  36. }
  37. }).done(function() {
  38. chart.xAxis[0].setCategories(cats);
  39. chart.series[0].setData(data);
  40. })
  41.  
  42. var chart = new Highcharts.Chart({
  43. chart: {
  44. renderTo: 'container',
  45. marginBottom: 80
  46. },
  47. xAxis: {
  48. labels: {
  49. rotation: 90
  50. }
  51. },
  52. series: [{
  53. data: [0]
  54. }]
  55. });
  56.  
  57. <?php
  58. $db = mysqli_connect("db_host", "db_user", "db_pass", "db_name");
  59. if ($result = mysqli_query($db, "select name, click from chart")) {
  60. while($obj = $result->fetch_object()){
  61. $array[]=array("x"=>$obj->name, "y"=>(int)$obj->click);
  62. }
  63. /* очищаем результирующий набор */
  64. mysqli_free_result($result);
  65. }
  66. mysqli_close($db);
  67.  
  68. $ar_js = json_encode($array);
  69. header("HTTP/1.0 200 OK");
  70. header('Content-type: application/json; charset=utf-8');
  71. header("Cache-Control: no-cache, must-revalidate");
  72. header("Expires: Mon, 26 Jul 2017 05:00:00 GMT");
  73. header("Pragma: no-cache");
  74.  
  75. echo $ar_js;
  76. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement