Postingan lainnya
Update tanggal automatis
Halo teman teman Bagaimana caranya agar membuat tanggal di chart terus update dengan bertambahnya hari, dan meninggalkan tanggal sebelumnya di chart terimakasih https://pastebin.com/LE1KXTCi (Source Code)
0
1 Jawaban:
coba ini gan, date berdasarkan hari sekarang sampe 10 hari kebelakang
<?php
$datenow = date('Y-m-d');
$batastgl = date('Y-m-d',strtotime('-10 days', strtotime($datenow))); // bisa disesuaikan
$select_services = mysqli_query($db, "SELECT * FROM orders WHERE date between '".$batastgl."' and '".$datenow."' and user='$sess_username' order by id ASC");
$total_ordr = mysqli_query($db, "SELECT * FROM orders WHERE user = '$sess_username' ORDER BY id ASC");
$cek_total_ord = mysqli_num_rows($total_ordr);
$nomor_chart = 1;
?>
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.3.0/Chart.bundle.js"></script>
<script type="text/javascript">
var ctx = document.getElementById("myChart");
var myChart = new Chart(ctx, {
type: 'line',
data: {
labels: [<?php while ($b = mysqli_fetch_array($select_services)) { echo '"' . $b['date'] . '",';}?>],
datasets: [{
label: '# of Votes',
data: [
<?php while ($p = mysqli_fetch_array($total_ordr))
{
echo '"' . $cek_total_ord . '",';
}?>
],
1