Postingan lainnya
Kelas Premium!
Belajar Javascript untuk website
Gunakan kupon "mulaijs" untuk diskon 75 ribu!
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