db 배열값에 넣고 풀기 채택완료

<?php
$sub_menu = '400010';
include_once('./_common.php');

$max_limit = 7; // 몇행 출력할 것인지?

$g5['title'] = ' 쇼핑몰현황';
include_once(G5_MNG_PATH . '/admin.head.php'); ?>
<?php

unset($save);
unset($tot);
$cnt = 0;
$margin = $member["mb_5"];
$bx_pay = intval($pay * $margin / 100);
$date = '';
$sql = "SELECT  SUM(ct_price) as total_pay,
      COUNT(*)  as cnt FROM `g5_shop_cart` cart JOIN
        g5_shop_item itm  ON cart.it_id  = itm.it_id
         WHERE itm.it_2_subj ='{$member["mb_id"]}' AND  at_status=0
         AND  SUBSTRING(ct_time,1,10) = '$date'";
$row = sql_fetch($sql);


?>
<div class="chart-container" style="position: relative; height:100; width:100">
    <canvas id="myChart"></canvas>
</div>

<?php
$arr_total = array();
$x_val = array();
for ($i = 6; $i >= 0; $i--) {
    $date= date('Y-m-d', strtotime('-' . $i . ' days', G5_SERVER_TIME));
    $x_val[] = $date;
    $arr_total[] = $date;

print_r($arr_total[$i]);
}


for ($i = 0; $i < count($x_val); $i++) {
//    var_dump($arr_total[$i]) ;
}

?>


<script src="https://cdn.jsdelivr.net/npm/chart.js@3.7.0/dist/chart.min.js"></script>
<script>
    const labels = [
        <?php
        $term = 7;
        for($i = ($term - 1); $i >= 0; $i--) {
        $date = date("Y-m-d", strtotime('-' . $i . ' days', G5_SERVER_TIME));
        $day = substr($date, 5, 5) . ' (' . get_yoil($date) . ')';
        ?>
        '<?= $day ?>',
        <?php  } ?>

    ];

    const data = {
        labels: labels,
        datasets: [{
            label: '마이 머니',
            backgroundColor: 'rgb(255, 99, 132)',
            borderColor: 'rgb(255, 99, 132)',


            data: [0, <?= $row['total_pay'] ?>, 5, 2, 20,],
        }]

    };

    const config = {
        type: 'line',
        data: data,
        options: {
            responsive: true,
            animation: {
                animateScale: true,
                animateRotate: true
            }

        }
    };
</script>
<script>
    const myChart = new Chart(
        document.getElementById('myChart'),
        config
    );
</script>

<?php
include_once(G5_MNG_PATH . '/admin.tail.php');
?>

datasets: [{
    label: '마이 머니',
    backgroundColor: 'rgb(255, 99, 132)',
    borderColor: 'rgb(255, 99, 132)',


    data: [0, <?= $row['total_pay'] ?>, 5, 2, 20,],
}]

<?php
$arr_total = array();
for ($i = 6; $i >= 0; $i--) {
    $date= date('Y-m-d', strtotime('-' . $i . ' days', G5_SERVER_TIME));
   array_push($arr_total,$date);
}

?>
<?php
for($k=0; $k < $arr_total.length; $k++) {
$sql = "SELECT  SUM(ct_price) as total_pay,
      COUNT(*)  as cnt FROM `g5_shop_cart` cart JOIN
        g5_shop_item itm  ON cart.it_id  = itm.it_id
         WHERE itm.it_2_subj ='{$member["mb_id"]}' AND  at_status=0
         AND  SUBSTRING(ct_time,1,10) = '$arr_total[$k]'";
$row = sql_fetch($sql);
}
var_dump($row);
?>