How to create ajax cart widget in woocommerce?

Question

SQL

Tell me how to implement the cart ajax widget in woocommerce - initially the widget is not visible, and appears when the first product is sent to the cart , it is a simple carousel in which all the goods added to the cart are scrolled (more precisely, their image), you can also remove from this "basket" goods.

Answer 1

0ldn0mad ,

SELECT * 
FROM (
   SELECT * 
   FROM workers 
   WHERE id >0 LIMIT 2,6 
) AS T1
ORDER BY age

Answer 2

What does "Get workers two through six" mean? In normal operation, this is not done through LIMIT, because he will give us who knows who, and we most likely need specific workers, I will assume that from the 2nd to the 6th by id, then:

SELECT 
        * 
    FROM workers 
    WHERE id>=2 AND id<=6
    ORDER BY age

Answer 3

second to sixth

There are no numbers in the DBMS, only sort order.
The identifier usually starts with 1.

select first, then sort

Subquery.