Showing posts with label Contact form connectivity with php form. Show all posts
Showing posts with label Contact form connectivity with php form. Show all posts

Wednesday, January 22, 2014

Contact form connectivity with php form

$query=mysql_query("SELECT * FROM wp_cf7dbplugin_submits ORDER BY id DESC LIMIT 1 ");
$row=@mysql_fetch_array($query);
$time=$row['submit_time'];
$timeA=explode(".",$time);

$t1=strtotime("now");
$t2=$timeA[1]+1;
$newtime=$t1.".".$t2;

$query1=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Name','$name',0, NULL) ");

$query2=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Email','$email',1, NULL) ");

$query3=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','ContactNo','$mob',2, NULL) ");

$query4=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Event Details','$eventdetail',3, NULL) ");

$query5=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Event Date','$date',4, NULL) ");

$query6=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Event Venue','$venue',5, NULL) ");
$query7=mysql_query("INSERT INTO  `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Event City','$city',5, NULL) ");

Popular Posts