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) ");

No comments:

Post a Comment

Thank you for your Comment....

Popular Posts