Apexcharts Php — Mysql [new]

try $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); catch(PDOException $e) echo json_encode(['error' => 'Database connection failed']); exit;

$categories = array_column($data, 'product_category'); $values = array_column($data, 'total'); apexcharts php mysql

$host = 'localhost'; $dbname = 'analytics_db'; $username = 'root'; $password = ''; try $pdo = new PDO("mysql:host=$host