Custom form that store input in database | WordPress

Insert data in a database using the form in WordPress. Customs form that store input in the database.  What if you already have a databa...

Insert data in a database using the form in WordPress. Customs form that store input in the database. What if you already have a database of say, request information table, but you want to be able to save that data into a database it within a WordPress template? Today I’ll be showing you just how to do that, safely within the WordPress engine.


  • Your own self-hosted WordPress site, obviously.
  • Basic PHP and MySQL skills
  • An existing dataset in MySQL.

What Are We Going to Do Before Coding?

Create a relevant table on database, I have created table like below (MySQL Code)

CREATE TABLE `request` (
  `Name` varchar(255) NOT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Service` varchar(25) DEFAULT NULL,
  `Date` date DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  `Phone` int(11) DEFAULT NULL,
  `Message` varchar(100) DEFAULT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'start',

Making a Custom Template

If you want to use some of your own PHP code, the easiest way to do this is to create a custom template, then apply the template to a particular page you create in WordPress. Start by opening up your theme files and duplicating the page.php (or single.php if there isn’t one). You can find page.php file in wp-content\themes\<<Your Theme Name>> then duplicating. Rename it something obvious, like “Request.php” as I’ve chosen.

At the very top of the file, we need to tell WordPress this is a custom template. Do this by adding the following (this is a PHP style comment, so it should be after any opening PHP tag if present).

Template Name: Request Page
Obviously, call it whatever you like

Now, find the main content function. You can delete it if you want, but I’m just going add the extra code after it. With the default twenty-fifteen theme, you’re looking for: Here I have created template according to my table "request':


Then we’ll need to create a page on the WordPress admin page, and apply our page template to it.

Publish, and check out the page to see if your form has worked.

Yeah! Now you can Submit data through this form, it will insert into request table.

Form Validation / Required

Here I have demonstrated how basically store data into a table using the form if have to validate every field and make as required  install Wp plugin Contact form 7, Then use these classes in your form.
Ref links All classes

class="wpcf7-form-control wpcf7-text wpcf7-email wpcf7-validates-as-required wpcf7-validates-as-email" aria-required="true" aria-invalid="false"


I hope this comes in useful to some of you in your WordPress projects. Next week I’ll be tackling the slightly trickier topic of how to view database tables' data in your admin dashboard.  WordPress backend customization.

If you have any questions please post your comments below.

Thank you!
WordPress 222608647607191638

Post a Comment Default Comments Disqus Comments

  1. Thanks a lot. It's the easiest and works perfectly. Thanks again.

  2. Thanks a lot. It's the easiest and works perfectly

  3. This comment has been removed by a blog administrator.

  4. I am so new to wordpress. I don't know how to thank you . you have done a great job. I spent few days trying to figure out this. finally i found your document. Thank you so much

  5. Wix, WordPress and Weebly are three major companies that offer custom web development services. I am currently doing all my Wordpress development, from a theme to a fully integrated online store. I love it and have been using it for years, and recommend it for all my clients. Their are lot of Wordpress Developer for any assistance.



Home item

Popular Posts

Random Posts