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