// Compute next product in same category
$next_product = null;
try {
$db_next = new PDO('sqlite:/www/wwwroot/carsledbulb.com_v2/data/midcars.db');
$st_next = $db_next->prepare("SELECT p.slug, p.title, c.slug AS category_slug FROM products p JOIN categories c ON p.category_id = c.id WHERE p.category_id = ? AND p.id > ? AND p.status = 1 ORDER BY p.id ASC LIMIT 1");
$st_next->execute([$product['category_id'], $product['id']]);
$next_product = $st_next->fetch(PDO::FETCH_ASSOC) ?: null;
} catch (Exception $e) {}
