How to get customer shopping cart information using sql query

Question

How to get customer shopping cart information using custom sql query.

I want to get shopping cart product information like below.

for example ::

product_name,
product_id,
product_image,
qty,
row_total,
is_in_stock,
base_subtotal,
base_grand_total,
shipping_amount,
street

• Murtuza Zabuawala: why you need sql query you can get all data via magento syntax
• Rakesh Patidar: I am new in magento. I have a this task so please suggest me.

Answer 1

you can get current customer cart/quote detail from below code

$cart = Mage::getSingleton('checkout/session')->getQuote();
foreach ($cart->getAllItems() as $item) {
 $product = Mage::getModel('catalog/product')->load($item->getProductId()) ;
 echo $product->getName();
}

you can get all data from $product as it is a product object so you can easily access product data

• Rakesh Patidar: Thanks, But I want to get cart information using custom sql query.
• Murtuza Zabuawala: you get cart information from this code
• Rakesh Patidar: Yes I know but i want to cart information using custom sql query. so please suggest me.
• Murtuza Zabuawala: why you need custom query ?? please tell me so I can provide you better answer
• Rakesh Patidar: I have get a this task. so please

Answer 2

You can get the code for it in

app/design/frontend/[Your-package]/[Your-theme]/template/Checkout/Cart

There you will find snippet like this

$cart = Mage::getSingleton('checkout/session')->getQuote();