prepare("SELECT * FROM products WHERE id IN ($placeholders)"); $stmt->execute($product_ids); $products = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($products as $product) { $quantity = $cart[$product['id']]; $price_info = getEffectivePrice($pdo, $product['id'], $client_id); $price_net = $price_info['net']; $price_gross = $price_info['gross']; $line_total_gross = $price_gross * $quantity; $cart_products[] = [ 'id' => $product['id'], 'name' => $product['name'], 'price_net' => $price_net, 'price_gross' => $price_gross, 'quantity' => $quantity, 'line_total' => $line_total_gross, ]; $total_price += $line_total_gross; } } catch (PDOException $e) { die(t('db_connection_error') . $e->getMessage()); } } $user_role = get_user_role(); ?>