Ttdfjt

I have tried to display the data from Quote_item table in the database to file .phtml but it shows this error

the code in Magento/MyHistory/Block/View.php

<?php
 namespace MagentoHistoryBlock;
 class View extends MagentoFrameworkViewElementTemplate
 
 public function __constructor(
 ....
 /Magento/Checkout/Model/Cart $cart
 ....)
 
 ...
 $cart = $cart;
 ...
 
 public function getCartData()
 $data = $this->cart()->create()->getCollection()- 
 >addFieldToSelect('*');
 return $data;
 
 

in Magento/MyHistory/view/frontend/template/index.phtml like this

<?php
 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $orders = $objectManager->create('MagentoCheckoutModelCart')- 
 >getCollection();
 $orders->addFieldToSelect('*');
?> 

<table class="data table" id="test-data-table">
 <h2 style="color: red;">Your Order Detail</h2>
 <caption class="table-caption">Look at this table</caption>
 <thead>
 <tr>
 <th scope="col" class="col image">Image</th>
 <th scope="col" class="col sku">Sku</th>
 <th scope="col" class="col name">Name</th>
 <th scope="col" class="col qty">Quantity</th>
 <th scope="col" class="col created_at">Create at</th>
 <th scope="col" class="col updated_at">Update at</th>
 </tr>
 </thead>
 <tbody>
 <?php foreach ($orders as $item): ?>
 <tr>
 <td data-th="Title" class="col sku"><?php echo $item- 
 >getImage(); ?></td>
 <td data-th="Title" class="col sku"><?php echo $item- 
 >getSku(); ?></td>
 <td data-th="Author" class="col name"><?php echo $item- 
 >getName(); ?></td>
 <td data-th="Content" class="col qty"><?php echo $item- 
 >getQty(); ?></td>
 <td data-th="Date" class="col created_at"><?php echo 
 $item->getCreatedAt(); ?></td>
 <td data-th="Date" class="col updated_at"><?php echo 
 $item->getUpdatedAt(); ?></td>
 </tr>

 <?php endforeach; ?>
 </tbody>
 </table>

Anyone can help me, please?

You can use the below code to get data from Quote Item

MagentoHistoryBlockView.php

<?php
namespace MagentoHistoryBlock;
class View extends MagentoFrameworkViewElementTemplate


 protected $cart;

 public function __constructor(
 ...
 MagentoCheckoutModelCart $cart
 ...
 )
 
 $cart = $cart;
 

 public function getCartData()
 $itemsCollection = $cart->getQuote()->getItemsCollection();
 // get array of all items what can be display directly
 $itemsVisible = $cart->getQuote()->getAllVisibleItems();
 // get quote items array
 $items = $cart->getQuote()->getAllItems();
 return $items;
 

Magento/MyHistory/view/frontend/template/index.phtm

<?php $cartData = $block->getCartData(); ?> 

Now here in the Phtml you can get your data with using this $cartData variable.

Try like this :

<?php
$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$orders = $objectManager->get('MagentoCheckoutModelCart');

// get quote items collection
$itemsCollection = $orders->getQuote()->getItemsCollection();

// get array of all items what can be display directly
$itemsVisible = $orders->getQuote()->getAllVisibleItems();

// get quote items array
$items = $orders->getQuote()->getAllItems();

foreach($items as $item) 
 echo 'ID: '.$item->getProductId().'<br />';
 echo 'Name: '.$item->getName().'<br />';
 echo 'Sku: '.$item->getSku().'<br />';
 echo 'Quantity: '.$item->getQty().'<br />';
 echo 'Price: '.$item->getPrice().'<br />';
 echo "<br />"; 

You get a fatol error for ->addFieldToSelect('*') you can use addFieldToSelect when you inject collection model in your construct. and also you don't have to use addFieldToSelect you can also get data without it.

app/code/Namespace/Modulename/Block/YourCustomBlock.php

class YourCustomBlock extends MagentoFrameworkViewElementTemplate

protected $_cart;

protected $_checkoutSession; 

public function __construct(
 MagentoFrameworkViewElementTemplateContext $context,
 MagentoCheckoutModelCart $cart,
 MagentoCheckoutModelSession $checkoutSession,
 array $data = []
) 
 $this->_cart = $cart;
 $this->_checkoutSession = $checkoutSession;

 parent::__construct($context, $data);


public function getCart() 
 return $this->_cart;


public function getCheckoutSession() 
 return $this->_checkoutSession;

Your phtml file should be like this

// Get all items in cart
$quote = $block->getCheckoutSession()->getQuote();
$items = $quote->getAllItems();

foreach($items as $item) 
 echo 'Product Id: ' . $item->getProductId() . '<br />';
 echo 'Name: ' . $item->getName() . '<br />';
 echo 'Sku: ' . $item->getSku() . '<br />';
 echo 'Quantity: ' . $item->getQty() . '<br />';
 echo 'Price: ' . $item->getPrice() . '<br />';
 echo "<br /><br />"; 



// Get total items and total quantity in cart
$totalItems = $quote->getItemsCount();
$totalQuantity = $quote->getItemsQty();

//Get subtotal and grand total price of cart
$subTotal = $quote->getSubtotal();
$grandTotal = $quote->getGrandTotal();

//Get billing and shipping addresses
$billingAddress = $quote->getBillingAddress();
$shippingAddress = $quote->getShippingAddress();

Take reference from Get Shopping Cart Data (Items, Subtotal, Grand Total, Billing & Shipping Address) in Magento 2? and Magento 2: Get all shopping cart items, subtotal, grand total, billing & shipping address

I hope it helps!