xpBdErn2

1<?php /* Template Name: The custom email */ ?>
2<?php get_header(); ?>
3<?php 
4$sql =  "CREATE TABLE IF NOT EXISTS " . $wpdb->prefix.credofy_contact_form. " (
5                  id mediumint(12) NOT NULL AUTO_INCREMENT,
6                  your_name VARCHAR(200) NOT NULL,
7                  your_email VARCHAR(200) NOT NULL,
8                  your_phone VARCHAR(200) NOT NULL,
9                  your_hobby VARCHAR(200) NOT NULL,
10                PRIMARY KEY (id));";
11$wpdb->query($sql);
12require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
13dbDelta($sql);
14?>
15
16<form action="" method="post"  enctype="multipart/form-data">
17    <input type="text" name="cr-your-name" placeholder="Enter your Name"/>
18    <input type="text" name="cr-your-email" placeholder="Enter your Email"/>
19    <input type="text" name="cr-your-phone" placeholder="Enter your Phone"/>
20    <input type="text" name="cr-your-hobby" placeholder="Enter your Hobby"/>
21    <input type = "submit" name = "cr-submit" value = "Insert">
22</form>
23
24<?php
25if(isset($_POST['cr-submit'])){
26global $wpdb;
27$table=$wpdb->prefix.'credofy_contact_form';
28$post_data=array(
29'yourName' => $_POST['cr-your-name'],
30'yourEmail' => $_POST['cr-your-email'],
31'yourPhone' => $_POST['cr-your-phone'],
32'yourHobby' => $_POST['cr-your-hobby']
33);
34$wpdb->insert( $table, $post_data);
35}
36?>
37<?php get_footer(); ?>