-
Notifications
You must be signed in to change notification settings - Fork 0
/
functions.php
86 lines (73 loc) · 2.68 KB
/
functions.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
<?php
function style_scripts(){
wp_enqueue_style( 'inquiry-style', get_stylesheet_uri(), array(), '20190509' );
wp_deregister_script( 'jquery' );
wp_register_script( 'jquery', get_template_directory_uri() . '/lib/jquery.js', '20151215', true, '' );
wp_enqueue_script( 'jquery' );
wp_enqueue_script(
'bootstrap_js',
get_template_directory_uri() . '/lib/bootstrap.min.js',
'20151215',
true);
/*wp_enqueue_script(
'jquery_min',
get_template_directory_uri() . '/lib/jquery.min.js',
'20151215',
true
);*/
wp_enqueue_style( 'bootstrap_css', get_template_directory_uri() . '/lib/bootstrap.css', '1.0' );
}
add_action('wp_enqueue_scripts','style_scripts');
/********************** SHORTCODE FOR FORM ************************/
function form(){
global $wpdb;
//$charset_collate = $wpdb->get_charset_collate();
$table_name = $wpdb->prefix .'inquiry';
if( $wpdb->get_var("SHOW TABLES LIKE '".$table_name."'") != $table_name ){
$sql = "CREATE TABLE {$wpdb->base_prefix}inquiry (
Name varchar(50) NOT NULL,
Surname varchar(50) NOT NULL,
email varchar(50) NOT NULL,
Gender varchar(50) NOT NULL,
Hobbies varchar(50) NOT NULL )";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);
}
echo'
<form method="post" class="form-group" action="">
<h3 style="text-align : center; margin-bottom : 10px;">Inquiry Form</h3>
<b>Name</b></br><input type="text" name="Name" required></br>
<b>Surname</b></br><input type="text" name="Surname" re0quired></br>
<b>email</b></br><input type="text" name="email" required></br>
<b>Gender</b></br><input type="radio" name="gender" value="Male" >Male  <input type="radio" name="gender" value="Female" >Female </br>
<b>Hobbies</b></br><input type="checkbox" name="Hobbies[]" value="Cricket">Cricket  <input type="checkbox" name="Hobbies[]" value="Music" >Music  <input type="checkbox" name="Hobbies[]" value="Dance" >Dance  </br>
<input type="submit" class="btn btn-primary" value="Submit">
</form>';
if(!function_exists("run")){
function run(){
global $wpdb;
$table_name = $wpdb->prefix .'inquiry';
$hobiie = $_POST['Hobbies'];
$Hobbies = implode(", ", $hobiie);
$data = array(
'Name' => $_POST['Name'] ,
'Surname' => $_POST['Surname'],
'email' => $_POST['email'],
'Gender' => $_POST['gender'],
'Hobbies' => $Hobbies);
$format = array('%s','%s','%s','%s','%s' );
$success = $wpdb->insert($table_name, $data,$format);
if($success){
echo '
<div class="col-sm-10 col-sm-offset-2" >
<div class="alert alert-success">Successfull</div>
</div>
';
}
}
}
if(!empty($_POST)){
run();
}
}
add_shortcode('inquiry_form','form');