Soy nuevo en Apexcharts e intento hacer un gráfico circular con datos, obteniéndolos de la base de datos mysql. Este es el archivo php llamado "get_types_chart.php"

 $year = date('Y'); $month = date('m'); $graf = PDO()->prepare("SELECT COUNT(tickets.id) AS cid, types.ticket_type AS type_name FROM tickets LEFT JOIN types ON tickets.type=types.id WHERE tickets.arch=0 AND tickets.status NOT IN (2, 4) AND MONTH(tickets.date_create)=:month AND YEAR(tickets.date_create)=:year GROUP BY types.ticket_type"); $graf->execute([':year' => $year, ':month' => $month]); $arrData = array(); while($row = $graf->fetch(PDO::FETCH_LAZY)) { array_push($arrData, array( "labels" => $row->type_name, "series" => $row->cid ) ); } $jsonEncodedData = json_encode($arrData); header('Content-Type: application/json'); echo $jsonEncodedData;

Y este es el código js:

 var url3 = 'charts/get_types_chart.php'; var options3 = { series: [], chart: { width: 380, type: 'pie', }, title: { text: '<?php echo lang('MON_STAT_year'); ?>', floating: true, align: 'center' }, labels: [], responsive: [{ breakpoint: 480, options: { chart: { width: 200 }, legend: { position: 'bottom' } } }] }; var chart3 = new ApexCharts(document.querySelector("#chart3"), options3); chart3.render(); $.getJSON(url3, function(response) { chart3.updateSeries([{ name: '<?php echo lang('DASH_STAT_month_all'); ?>', data: response }]) });

Finalmente obtengo un pastel vacío. Por favor, ayúdame a hacer un json correcto.