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 Urban 2nd June 2026

Urban Venture Real Estate Development (UVRED) is built on a vision to connect global investors with Dubai’s most rewarding real estate opportunities. As one of the world’s leading property markets, Dubai offers tax-free income, strong infrastructure, and exceptional return potential—and UVRED helps clients unlock these advantages with confidence.

profile Tannu 27th May 2026

At RK Puram Escort Service, we go beyond mere companionship—we deliver an unforgettable experience for you. Now is your moment to break free, to immerse yourself in the comfort of someone's embrace, and to pursue every longing without restraint. With our RK Puram escorts, each moment is designed to ensure you feel entirely satisfied, indulged, and thoroughly fulfilled.

profile Servis 23rd May 2026

Servis stands out among gents shoes brands in Pakistan with formal shoes, sandals, and casual designs that match every lifestyle.

profile Shop 22nd May 2026

Find your signature scent with ECS's captivating perfume for men. Explore bold to refined fragrances to match your style. Shop now!

profile Emaan 1st April 2026

Choosing the right formal wear for wedding events can elevate your overall look. From stylish gowns to refined suits, discover formal wear that blends elegance, comfort, and the latest fashion trends for unforgettable wedding moments.

profile Miss 31st March 2026

Create precise and bold eye looks with a premium eyeliner pencil. Easy to apply, highly pigmented, and long-lasting eyeliner pencils are perfect for everyday and party makeup.

profile Alex 21st March 2026

Because each round is short, heardle fits easily into a daily routine. Players can complete the challenge in just a few minutes, making it a convenient form of entertainment.

profile Jerome 16th March 2026

New additions are released weekly by the very creative fnf mod community. There are thousands of fan-made works with mods available for download, and they range from entertaining to horrifying. This is what ensures FNF remains relevant and appealing throughout the years.

profile 17th December 2025

Can you become the richest person playing grow a garden? Plant, harvest, and sell your produce for money. Each yield corresponds to a different amount of money.

profile Cheetah 13th November 2025

Shop stylish sweatshirts for every season. Stay warm and trendy with our cozy collection for men in Pakistan.

profile Servis 12th November 2025

Discover the latest collection of branded shoes for men at Servis. Step up your style game with our exclusive range of footwear.

profile Brisk 11th November 2025

Shop the best men’s polo shirts offering style, comfort, and durability. Perfect choice for work, travel, or any casual day out in all seasons.

profile Grow 11th November 2025

Enjoy healthy pancake mix in Pakistan made with natural grains and ingredients. The perfect choice for a tasty and nourishing morning meal.

profile Adoro 10th November 2025

Using our unique selection of men loafers find the ideal fashion and comfort. These adaptable shoes provide trendy style and classic beauty, making them perfect for every occasion. Get outstanding quality and affordable costs by shopping now.

profile Shop 10th November 2025

Upgrade your wardrobe with ECS' simple trouser design. Made with high-quality materials, our trousers offer a comfortable and stylish fit for any occasion. So, grab your trousers today.

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