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)

avatar riffshop
@riffshop

9 Kontribusi 0 Poin

Diperbarui 6 tahun yang lalu

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 . '",';
                     }?>
                   ],
avatar dianarifr
@dianarifr

642 Kontribusi 316 Poin

Dipost 6 tahun yang lalu

Login untuk ikut Jawaban