這是我從 mysql 獲取數據然后將數據值導入到 morrisjs 的簡單代碼，但我的頁面是純空白的，什么也沒有顯示。我是新來的<?php $conn=mysqli_connect("localhost","root","","userchart"); $query= "SELECT * FROM chart"; $result=mysqli_query($conn,$query); $chart_data=''; while($row=mysqli_fetch_array($result)) { $time= strtotime($row['time']); $chart_data .="{ user:'".$row['uid']."', time:".date('i',$time)."}"; } echo $chart_data = substr($chart_data, 0, -1);?> 我使用此語句來測試我是否以正確的格式獲取值并且格式正確，但最后未顯示折線圖。echo $chart_data = substr($chart_data, 0, -1);<html> <head> <title> CHART USING MORRIS.JS</title> <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.css"> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"></script> <script src="//cdnjs.cloudflare.com/ajax/libs/raphael/2.1.0/raphael-min.js"></script> <script src="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.min.js"></script> </head> <body> <div id="chart" style ="height 250px;"></div> <script> new Morris.Line({ // ID of the element in which to draw the chart. element: 'chart', // Chart data records -- each entry in this array corresponds to a point on // the chart. data: [<?php echo $chart_data; ?>], // The name of the data record attribute that contains x-values. xkey: 'user', // A list of names of data record attributes that contain y-values. ykeys: ['time'], // Labels for the ykeys -- will be displayed when you hover over the // chart. labels: ['time'] }); </script> </body></html>
1 回答
慕虎7371278
TA貢獻1802條經驗 獲得超4個贊
未經測試，但也許你可以嘗試這樣。您應該使用而不是進行一些片狀字符串操作json_encode
<?php
$conn=mysqli_connect("localhost","root","","userchart");
$query= "SELECT * FROM chart";
$result=mysqli_query($conn,$query);
$data=array();
while( $row=mysqli_fetch_array($result) ){
$data[]=array(
'user' => $row['uid'],
'time' => date('i',strtotime( $row['time']) )
);
}
$json=json_encode( $data );
?>
<html>
<head>
<title>CHART USING MORRIS.JS</title>
<link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.css">
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/raphael/2.1.0/raphael-min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.min.js"></script>
</head>
<body>
<div id="chart" style ="height 250px;"></div>
<script>
<?php
printf('var json=%s;',$json);
?>
new Morris.Line({
element: 'chart',
data:json,
xkey:'user',
ykeys:['time'],
labels:['time']
});
</script>
</body>
</html>
- 1 回答
- 0 關注
- 165 瀏覽
添加回答
舉報
0/150
提交
取消