Rubin Shrestha
Zend certified PHP/Magento developer
Rubin Shrestha
Blog

how we can Insert Form Data into Database magento 2 through controller and model

by |Published 
<?php $_product = $block->getProduct(); 
$exPrice=$_product->getData('ex_price');
?>
<?php if ($exPrice == true): ?>
<div class="note_1">
<p><b style="color: red;">Note:</b> <span style="color: darkblue;">We don't have prices, because the prices depends on the sizes and the quantities</span></p>  
</div>
<div class="product-quote">
<form class="product-qoute-form" action="quote/crud/save" id="my-form" data-mage-init='{"validation": {}}' method="post">
<div style="margin-bottom:10px;" class="row"> 
<div class="col-lg-12 col-md-12">
<div class="field name required">
<div class="control">
<label for="" class="elementor-field-label">Company Name</label>
<input name="company" id="Company Name" title=" Company Name" placeholder="Company Name" value="" type="text" data-validate="{required:true}" aria-required="true" required>
</div>
</div>
</div>
<div class="col-lg-12 col-md-12">
<div class="field email required">
<div class="control">
<label for="" class="elementor-field-label">Email</label>
<input name="email" id="email" title="Email" placeholder="Email" value="" type="email" data-validate="{required:true, 'validate-email':true}" aria-required="true" required>
</div>
</div>
</div>
</div>
<div style="margin-bottom:10px;" class="row"> 
<!-- <div class="col-lg-6 col-md-6">
<div class="field name required">
<div class="control">
<label for="" class="elementor-field-label">Company Name</label>
<input name="company" id="Company Name" title=" Company Name" placeholder="Company Name" value="" type="text" data-validate="{required:true}" aria-required="true">
</div>
</div>
</div> -->
<div class="col-lg-12 col-md-12">
<div class="field telephone">
<div class="control">
<label for="" class="elementor-field-label">Phone</label>
<input name="telephone" id="telephone" placeholder="Telephone" title="Phone Number" type="text" required>
</div>
</div>
</div>
<div class="col-lg-12 col-md-12">
<div class="field name required">
<div class="control">
<label for="" class="elementor-field-label">Shipping Country</label>
<input name="country" id="country" title=" country" placeholder="Country" type="text" data-validate="{required:true}" aria-required="true" required> 
</div>
</div>
</div>
</div>
<!--   <div style="margin-bottom:10px;" class="row"> 
<div class="col-lg-12 col-md-12">
<div class="field name required">
<div class="control">
<label for="" class="elementor-field-label">Width</label>
<input name="width" id="width" title=" width" placeholder="Width" value="" type="text" data-validate="{required:true}" aria-required="true" required>
</div>
</div>
</div>
<div class="col-lg-12 col-md-12">
<div class="field email required">
<div class="control">
<label for="" class="elementor-field-label">Height</label>
<input name="height" id="height" title=" height" placeholder="Height" value="" type="text" data-validate="{required:true}" aria-required="true" required>
</div>
</div>
</div>
</div> -->
<div style="margin-bottom:10px;" class="row"> 
<div class="col-lg-12 col-md-12">
<div class="field email required">
<div class="control">
<label for="" class="elementor-field-label">Quantity</label>
<input name="quantity" id="Quantity" title=" quantity" placeholder="Quantity" type="text" data-validate="{required:true}" aria-required="true" required>
</div>
</div>
</div>
<!-- <div class="col-lg-6 col-md-6">
<div class="field name required">
<div class="control">
<label for="" class="elementor-field-label">Depth</label>
<input name="depth" id="Depth" title=" depth" placeholder="Depth" value="" type="text" data-validate="{required:true}" aria-required="true">
</div>
</div>
</div> -->
</div>
<div style="margin-bottom:10px;" class="row"> 
<div class="col-lg-12 col-md-12">
<div class="field email required">
<div class="control">
<label for="" class="elementor-field-label">Your message</label>
<textarea name="comment" id="comment" placeholder="Your message" title="Your message" cols="5" rows="3" data-validate="{required:true}" aria-required="true" required></textarea>
</div>
</div>
</div>
</div>
<div class="action-toolbar">
<input type="hidden" name="sku" id="sku" value="<?php echo $_product->getSku(); ?>">
<button id="btnSaveIt" type="submit" title="Submit" class="action primary tocart orange_1">
<span>Request for Quote</span>
</button>
</div>
</form>
</div>
<!-- <script type="text/x-magento-init">
{
"#my-form": {
"validation": {}
}
}
</script> -->
<script type="text/javascript" async defer>
require(["jquery","mage/mage","Magento_Ui/js/model/messageList"],function($) {
var dataForm = $('#my-form');
dataForm.mage('validation', {});
$(document).ready(function() {
$("#my-form").on("submit",function(){
var status = dataForm.validation('isValid'); //validates form and returns boolean
var get_data=dataForm.serialize();
// alert($.type(get_data));
if(status){
console.log('form is validated'); //form is valid
var comp_name=jQuery("input[name='company']").val();
var email=jQuery("input[name='email']").val();
var telephone=jQuery("input[name='telephone']").val();
var country=jQuery("input[name='country']").val();
var quantity=jQuery("input[name='quantity']").val();
var msg=jQuery("#comment").val();
// console.log(msg);            
var sku=jQuery("input[name='sku']").val();
var url = "<?php echo $this->getUrl().'quote/crud/save'?>";            
jQuery.ajax({
url: url,
type: "post",
// dataType: "text",
// data:{quote:get_data},
data: {company:comp_name,email:email,telephone:telephone,country:country,quantity:quantity,comment:msg,sku:sku},
showLoader: true,
cache: false,
success: function(data){
if(data.response == 'added'){ // if true (1)
// setTimeout(function(){// wait for 5 secs(2)
//      window.location.reload(); // then reload the page.(3)
// }, 1000);
$("#my-form")[0].reset();
console.log('success');
// messageList.addSuccessMessage({
//   message: 'Quote Email Confirmation is successully sent'
// });
// alert('success'); 
}else{
alert('success is wrong'); 
}
},
error: function (error) {
console.log(error, "fail");
}
});
return false;
}else{
console.log('form is not validated');
}
});
});
});
</script>
<style type="text/css" media="screen">
.product-add-form{
display: none;
}
.price-box{
display: none;
}
.availability.only{
display: none;
}
.product-info-main .product-info-stock-sku .attribute.sku {
float: none !important; 
}
.action-toolbar{
text-align: center;
}
.note_1{
margin-top: 20px;
}
.note_1 p{
font-size: 1.5rem;
}
</style>
<?php endif; ?>

You may also like