这就是我要做的。
我有供应商,我从购买线索,我需要查看在我的系统中所有可计费的线索的比较,看看哪些供应商正在执行,哪些不是。Q代表可计费的线索。与我现在的代码,我得到我的图表,它列出了所有供应商的传说,但每个供应商的可计费(Q)金额显示了所有可计费(Q)的金额总额,从每个供应商的所有供应商。我很确定,我需要有我的$rowcount=mysqli_num_rows($result);在某处,而($row = mysqli_fetch_array($result)){我只是不能弄清楚,我已经读了一切我可以…如果有人知道如何解决这个问题,请帮助。谢谢我使用CanvasJS和PHP
<head>
<script type="text/javascript">
window.onload = function () {
var chart = new CanvasJS.Chart("chartContainer",
{
title:{
text: "Top Oil Reserves"
},
axisY: {
title: "Reserves(MMbbl)"
},
legend: {
verticalAlign: "bottom",
horizontalAlign: "center"
},
theme: "theme1",
data: [
{
type: "column",
showInLegend: true,
legendMarkerColor: "grey",
legendText: "MMbbl = one million barrels",
dataPoints: [
<?php
include 'include/dbconnect.php';
$result = mysqli_query($con,"SELECT * FROM EduCampaign1 WHERE leadstatus='Q'");
$rowcount=mysqli_num_rows($result);
while($row = mysqli_fetch_array($result)) {
?>
{y:<?php echo $rowcount; ?>, label: "<?php echo( htmlspecialchars($row['rid'] ) ); ?>"},
<?php
}
mysqli_close($con);
?>
]
}
]
});
chart.render();
}
</script>
<script src="lib/js/canvasjs.min.js"></script>
<body>
<div id="chartContainer" style="height: 300px; width: 100%;">
</body>
尝试在while语句之前添加以下代码:$ c = 0;
在while语句中:c++美元;
它的作用是创建一个简单的行计数器。