PHP COde Multi Grafik

      <script>
  var index=1;
      $( function() {
        $( "#accordion" ).accordion({
          collapsible: true
        });
      } );
      </script>

<div id="accordion">
<?php 

$sql="select `tanggal` from `$tbpenjualan` order by `tanggal` asc";
$d=getField($conn,$sql);
$tanggal1=$d["tanggal"];
$sql="select `tanggal` from `$tbpenjualan` order by `tanggal` desc";
$d=getField($conn,$sql);
$tanggal2=$d["tanggal"];
$ar1=explode("-",$tanggal1);
$thn1=$ar1[0];
$bln1=$ar1[1];

$ar2=explode("-",$tanggal2);
$thn2=$ar2[0];
$bln2=$ar2[1];

$sel=($thn2-$thn1)*12;//2=24bln
$tahun=$thn1;
$bulan=$bln1;
//$gb="";
for($i=0;$i<$sel;$i++){
$bulan=$bulan+0;
if($bulan>12){$tahun=$tahun+1;$bulan=1;}
if($bulan<10){$bulan="0".$bulan;}

$ARR1[$i]="$tahun-$bulan-01";
$ARR2[$i]="$tahun-$bulan-31";
//echo $i."#".$ARR1[$i]." - ".$ARR2[$i]."<br>";
$bulan=$bulan+1;

}
//echo $gb."=$sel<hr>";
//4#2019-07-01 #2023-01-30

  $sql="select * from `$tbbarang` order by `id_barang` asc";
  $jum=getJum($conn,$sql);
if($jum <1){
echo"Maaf Data Belum Tersedia....";
}
$no=1;
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_barang=$d["id_barang"];
$nama_barang=$d["nama_barang"];
$deskripsi=$d["deskripsi"];
$kategori=$d["kategori"];
$gambar=$d["gambar"];
$gambar0=$d["gambar"];
                $status=$d["status"];
$keterangan=$d["keterangan"];
$harga=RP($d["harga"]);
$color="#F8F8FF";

echo"<h3>$no. Data Barang $nama_barang</h3><div>";
echo"<b>$nama_barang</b>";
echo"<table width='100%'>";
echo"<tr><td width='30%' valign='top'>
<div align='center'>";
echo"<a href='#' onclick='buka(\"barang/zoom.php?id=$id_barang\")'>
<img src='$YPATH/$gambar' width='120' height='120' title='date ke $no'/></a>
<br>
ID Barang: $id_barang<br>
Kategori: $kategori<br>
Harga: $harga
</div>";
$nom=0;
$mydata="";

for($i=0;$i<$sel;$i++){
$w1=$ARR1[$i];
$w2=$ARR2[$i];

  $nom=$i+1;
   $sql="select sum(`$tbpenjualandetail`.`jumlah`) as `total`
   from `$tbpenjualandetail`,`$tbpenjualan` where
   `$tbpenjualandetail`.`id_barang`='$id_barang' and
   `$tbpenjualandetail`.`id_penjualan`=`$tbpenjualan`.`id_penjualan` and
    `$tbpenjualan`.`tanggal` between '$w1' and '$w2'
   ";
  $d=getField($conn,$sql);
  $in=$d["total"]+0;
  $mydata.="[$nom,$in],";

}

$mydata=substr($mydata,0,strlen($mydata)-1);
echo"<td valign='top'>";

?>

     <script type="text/javascript">
      google.charts.load('current', {'packages':['line']});
      google.charts.setOnLoadCallback(drawChart);

    function drawChart() {
      var data = new google.visualization.DataTable();
      data.addColumn('number', 'Periode');
      data.addColumn('number', 'Penjualan');
 
      data.addRows([<?php echo $mydata;?>]);

      var options = {
        chart: {
          title: 'Grafik Perbandingan Data Forecasting',
          subtitle: 'Pemasukan Barang - Pengeluaran Barang'
        },
        width: 400,
        height: 300
      };

      var chart = new google.charts.Line(document.getElementById("curve_chart"+index));
chart.draw(data, google.charts.Line.convertOptions(options));
index=index+1;
}

   </script>
    <div id="curve_chart<?php echo $no;?>" style="width: 400px; height: 300px"></div>
<?php

echo "</td></tr>";
echo"</table><br>";
echo"</div>";
$no++;
}//foreach
?>
</div>