使用MYSQL从Prestashop中的订单ID获取产品清单

Question

Im new in Prestashop ,i want to get the details of products from the id order from the data base so can anyone help me with the mysql query .

Answer 1

Use PrestaShop classes instead of mysql query:

    $order = new Order($id_order);
    $details = $order->getProductsDetail();
    d($details);