Store magento contact form data in database?

Store magento contact form data in database?

August 5, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Store magento contact form data in database?

Storing Magento Contact Form Data into Your Database

As a developer, I often receive queries like this from clients who want to store their Magento contact form data. In this post, I’ll guide you through the process step by step.

Understanding Magento’s Contact Form

By default, when a customer submits a contact form in Magento 2, the data is sent via email to the specified recipient(s). It doesn’t get stored directly in your database. However, we can modify this behavior and store the data in our own custom table instead.

Creating a Custom Table for Contact Form Data

First, let’s create a new table to hold our contact form data. You can do this using the Magento 2 setup script or directly via SQL. Here’s an example of what the table might look like:

CREATE TABLE `contact_form_data` (
    `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `name` VARCHAR(255) NOT NULL,
    `email` VARCHAR(255) NOT NULL,
    `subject` VARCHAR(255),
    `message` TEXT,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Overriding the Default Controller

The contact form is handled by the Magento_Contact module. To store the data in our custom table, we need to override the indexPostAction method in the Controller/Index.php file.

To do this, first create a new module if you don’t have one already. Then, navigate to your module’s directory and locate or create a copy of vendor/magento/module-contact/Controller/Index.php.

Storing Data and Sending Emails

In the overridden indexPostAction method, we’ll fetch the form data, insert it into our custom table using the Magento 2 framework’s persistence layer (the Magento\Framework\App\ResourceConnection), and then send the email as before.

public function execute()
{
    $post = $this->getRequest()->getPostValue();

    try {
        // Insert data into our custom table
        $connection = $this->_resourceConnection;
        $data = [
            'name' => $post['name'],
            'email' => $post['email'],
            'subject' => $post['subject'],
            'message' => $post['message']
        ];
        $connection->insertOnDuplicate('contact_form_data', $data, ['id']);
    } catch (Exception $e) {
        // Handle exception
    }

    // Send the email as before
    return parent::execute();
}

Sending Emails

Magento 2 uses a template system for sending emails. You can customize these templates by overriding them in your theme or through a custom module.

For more information on Magento’s email templates, you can refer to the official documentation here.

Conclusion

Storing Magento contact form data into a database isn’t complex once you understand where the data is being processed. By overriding the default controller and using the Magento 2 framework’s persistence layer, we can easily insert this data into our custom table.

Remember to always test your changes thoroughly before deploying them to a production environment.

If you’re looking for more advanced solutions or need help with larger-scale projects, I recommend checking out Laravel Company. They offer expert Magento development services to help businesses optimize their e-commerce platforms.

Magento 2 Database Extensions Email

Our network