Business Login Login
User Login Business Login

Ask your Question

Play Online Quizzes!

teachers-day-2022-quiz
Teachers Day 2022 Quiz
har-ghar-tiranga-quiz
Har Ghar Tiranga Quiz
python-programming-quiz
Python programming quiz
tableau-online-quiz
Tableau Quiz
power-bi-online-quiz
Power Bi Online Quiz
View all

Write to us

Ask Question

Save contact us queries in database magento and view it's listing in admin panel

Aditya Singh
Save contact us queries in database magento and view it's listing in admin panel

 To save contact us queries we need to override the Contacts_IndexController  and put the insert queries by overriding Post function. Also we need to create a module to show the customer queries listing in Admin  Panel and create a table with relevant field to save the contact us query.

 Below is the code to override Contacts_IndexController in config.xml file.
 
app/code/local/Letsknowit/Contactus/etc/config.xml
 
 
<config>
    <modules>
        <Letsknowit_Contactus>
            <version>0.1.0</version>
        </Letsknowit_Contactus>
    </modules>
<frontend>
       <routers>
            <contacts>
                <args>
                    <modules>
                        <Letsknowit_Contactus before="Mage_Contacts">Letsknowit_Contactus</Letsknowit_Contactus>
                    </modules>
                </args>
            </contacts>
        </routers>
       
    </frontend>
</config>
 
To create the table and fields to save the data we have to write a script at
below path
 
app/code/local/Letsknowit/Contactus/sql/contactus_setup/mysql4-install-0.1.0
 
<?php
 
$installer = $this;
 
$installer->startSetup();
 
$installer->run("
 
-- DROP TABLE IF EXISTS {$this->getTable('contactus')};
CREATE TABLE {$this->getTable('contactus')} (
  `contactus_id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `telephone` varchar(255) NOT NULL default '',
  `comment` text NOT NULL default '',
  `status` smallint(6) NOT NULL default '0',
  `created_time` datetime NULL,
  `update_time` datetime NULL,
  PRIMARY KEY (`contactus_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
    ");
 
$installer->endSetup(); 
 
?>
 
Now in app/code/local/Letsknowit/Contactus/controllers/IndexController.php
we will put our insert query.
 
<?php
require_once 'Mage/Contacts/controllers/IndexController.php';
class Letsknowit_Contactus_IndexController extends Mage_Contacts_IndexController
{
    
 
    public function postAction()
    {
       $post = $this->getRequest()->getPost();
       
 
       /* code to save query , you can write our insert query here*/
       if ( $post ) {
          
                               $model = Mage::getModel('contactus/contactus');
$model->setData($post);
$model->save();
 
            }
     
 
    }
?>
 
 

0   0
Aditya Singh
profile Digital 21st May 2025

Thanks for your time so much for your impressive and amazing guide. I will not be reluctant to endorse your web sites to any individual who should receive direction on this problem. coincheckup

Write a comment ...
Post comment
Cancel
profile Arthur 6th May 2025

Color Block Jam encourages players to experiment with different block arrangements.

Write a comment ...
Post comment
Cancel
profile rick 22nd April 2025

The Crazy Cattle 3D three maps are more than just eye candy—they fundamentally change how you play

Arthur
 06-05-2025 00:00

<a href="https://colorblockjamonline.github.io">color block jam</a>’s intuitive controls make it accessible for all ages.

Arthur
 06-05-2025 00:00

[url=https://colorblockjamonline.github.io]color block jam[/url] offers a satisfying burst when blocks reach their matching doors.

Write a comment ...
Post comment
Cancel
profile Digital 17th April 2025

Cheers for this excellent. I was wondering whether you were planning of publishing similar posts to this. .Keep up the excellent articles! sweet bonanza

Write a comment ...
Post comment
Cancel
profile Digital 12th April 2025

You undoubtedly ensure it is look simple along with your business presentation however i come across this kind of topic being truly an issue that I think I might never recognize. It appears also complex and extremely wide personally. I will be impatient for your next article, I am going to try to get the hang of it! Mantap168

Write a comment ...
Post comment
Cancel
profile Beatrix 22nd March 2025

The city maze is crazy! Escape Road City is among my favorite vehicle games since it requires you to try to survive while dodging all the obstacles.

mrsumit
 25-03-2025 00:00

CERT-In audit penetration testing is crucial for organizations to comply with security regulations and protect against cyber threats. It ensures systems are tested for vulnerabilities and secured against potential breaches. ae.penetolabs offers expert CERT-In audit <a href="https://ae.penetolabs.com/cert-in-audit-services/">CERT-In Audit Penetration Testing Service</a> penetration testing services, helping businesses identify security gaps, achieve compliance, and strengthen their defense mechanisms. Their in-depth assessments follow industry best practices, ensuring data protection and regulatory adherence. Partnering with a CERT-In empanelled service provider enhances cybersecurity resilience and safeguards critical business assets.

Write a comment ...
Post comment
Cancel
profile Suman 12th March 2025

Fight loneliness with Escort Gurgaon, where stunning ladies provide unlimited love and intimacy. Beyond call girls, these gifted companions rid you of boredom with erotic bonding. Their glamorous kiss and fashionable whispers weave a world of passion, as per your dreams.

Write a comment ...
Post comment
Cancel
profile Nick 9th March 2025

If you're not using retargeting advertising, you're missing out on a huge opportunity to boost conversions. It allows you to re-engage users who have already interacted with your brand. VenziMedia offers expert solutions to maximize your ad spend and drive better results

Write a comment ...
Post comment
Cancel
profile Digital 8th March 2025

 

Great post, I think website owners should acquire a lot from this web site its very user pleasant. pre purchase inspection

Write a comment ...
Post comment
Cancel
profile andree 18th February 2025

This Geoguessr game is a masterclass in observational skills. It trains you to see and interpret the world differently, making every round an exciting lesson in geography and culture!

Write a comment ...
Post comment
Cancel
profile Sprunki 12th February 2025

Sprunki Mod offers a wide variety of sounds, rhythms and melodies, allowing you to create many different genres of music.

Write a comment ...
Post comment
Cancel
profile tomm 7th February 2025

The Incredibox Sprunki drag-and-drop functionality allows users to effortlessly combine beats, melodies, and effects, fostering creativity without the need for prior musical experience. 

Write a comment ...
Post comment
Cancel
profile Otis 21st January 2025

Create a custom Drift Hunters Magento module to handle the form submission and save the data to the database.
Step 1.1: Create Directory Structure
Navigate to your Magento installation and create the following directories for your module

Write a comment ...
Post comment
Cancel
profile M. 19th January 2025

 Great blog post! I like your content. I also appreciate your work also mention Awful lot of cough syrup hoodies.<a href="https://awfullotofcoughsyrup.shop/">Awful lot of cough syrup</a>.Awful lot of cough syrup is a fashion-forward choice. With their distinctive designs and premium materials, they're a stylish designs that offers both comfort and a touch of luxury.
 

Write a comment ...
Post comment
Cancel
profile M. 19th January 2025

 Great blog post! I love how you've stressed the rearmost fashion trends, also mention <a href="https://fivefourfives.shop/">FiveFourFive</a>. FiveFourFive clothing is a fashion-forward choice. With their distinctive designs and premium materials
 

Write a comment ...
Post comment
Cancel

Login to Comment

Please rotate your device

We don't support landscape mode on your device. Please rotate to portrait mode for the best view of our site