Create new row in Database when we click on button

Question

By Default Magento create new row in Database in table sales_flat_quote_item_option once we click on ADD TO CART

We are giving an option of uploading custom image on Product image with help of custom module.

When we upload custom image on Product image [ link ] & click on Add to cart, we are saving custom image in Database in table sales_flat_quote_item_option & in column : value .

As like Add to cart button, we want same feature for one more custom button Save Design.

Save design button

<button id="submit-editorApply-{{rand}}" >Save Design</button>

i want to know which code is responsible for creating new row in Database after clicking Add to cart button.

Where i need to look in Module's Block or Controllers or Data or Helper or Model ?

I can just copy Add to cart code and just rename to "Save design", but once we click on "Save design", i don't want to add Product to cart , I just want to create new row in Database.

Answer 1

You can try below trick for that

 jQuery(document).ready(function(){
    jQuery("button[title='SAVE DESIGN']").click(function(){
     openCustimage("UserImage");
     setTimeout(function(){
        jQuery('.button.btn-cart').get(0).click();              
     }, 2000);  

    });    
 });

Answer 2

You can try do something like this:

1. add new column in sales_flat_quote_item_option named eg allowed_in_cart as bool (true / false) with default false value.

2. Rewrite cart action app\code\core\Mage\Checkout\controllers\CartController.php :: indexAction for don't display products with value allowed_in_cart as false.

   However better way is 'disable' cart when allowed_in_cart is false instead of only don't display products.

3. To Save Design Button add action change allowed_in_cart value to true for specific cart.