prefix . "m_analtics" ;
$time = date('Y-m-d H:i:s');
$gcode = sanitize_text_field($_POST['gcode']);
$lastid = $wpdb->insert_id;
// $meetcheck = $_POST['meet-check'];
$meetcheckvalue = 0;
if($_POST['meet-check']){
$meetcheckvalue = 1;
}
if (strlen($gcode)<18 && preg_match('/^ua-\d{4,9}-\d{1,4}$/i', strval($gcode))){
$result = $wpdb->get_results("SELECT id from $table_name WHERE id IS NOT NULL");
if(count($result) == 0){
$success = $wpdb->insert($table_name, array("g_code" => $gcode, "mit_flag" => $meetcheckvalue));
}
else{
$success = $wpdb->query($wpdb->prepare("UPDATE $table_name SET hit_date=CURRENT_TIMESTAMP ,g_code='%s',mit_flag='%d' WHERE id=1",$gcode,$meetcheckvalue));
}
}
else{
echo"";
}
}
global $wpdb;
$table_name = $wpdb->prefix . "m_analtics" ;
$lastid = $wpdb->insert_id;
$result = $wpdb->get_results("SELECT * FROM $table_name" );
$checkbox_box_check ="";
$dis_var = "";
foreach($result as $row) {
?>