aaiof_dropdown_contact_lists(); _e(''); $this->aaiof_get_list_columns(); _e(''); $this->aaiof_get_list_columns(); _e(''); $this->aaiof_get_list_value(); _e('

'); } public function aaiof_get_list_columns(){ global $wpdb; $table_name = $wpdb->prefix . "advanced_all_form_entry"; $data = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM ".$table_name." WHERE vcf_id = %d", sanitize_text_field($_GET['form_id'])) ); $field = get_post_meta(sanitize_text_field($_GET['form_id']), 'vcf_fields_data', true); $get_fields = unserialize($field); foreach($data as $columns){ $data_id[] = $columns->data_id; /*$k_name[] = $columns->name;*/ foreach($get_fields as $k=>$v){ if($get_fields[$k]['name']==$columns->name){ $k_name[] = $get_fields[$k]['label']; } } } $kname = array_unique($k_name); foreach($kname as $column){ if($column != 'file' && $column != 'hiddenRecaptcha'){ _e(''.substr($column,0,20).''); } } if(!empty($kname)){ _e('Action'); } } public function aaiof_get_list_value(){ global $wpdb; $table_name = $wpdb->prefix . "advanced_all_form_entry"; $data = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM ".$table_name." WHERE vcf_id = %d", sanitize_text_field($_GET['form_id'])) ); foreach($data as $columns){ $data_id[] = $columns->data_id; $k_name[] = $columns->name; } $unique = array_unique($data_id); $kname = array_unique($k_name); foreach($unique as $list){ _e(''); foreach($kname as $name_val){ if($name_val != 'file' && $name_val != 'hiddenRecaptcha'){ $data1 = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM ".$table_name." WHERE vcf_id = %d AND data_id = %d AND name = %s", sanitize_text_field($_GET['form_id']), sanitize_text_field($list), sanitize_text_field($name_val)) ); _e(''.$data1[0]->value.''); } } _e('Remove'); _e(''); } } public function aaiof_dropdown_contact_lists(){ _e('

Overview

'); _e('

Record deleted successfully.

'); } } }