field_table_name = $wpdb->prefix . 'visual_form_builder_fields'; $this->form_table_name = $wpdb->prefix . 'visual_form_builder_forms'; $this->entries_table_name = $wpdb->prefix . 'visual_form_builder_entries'; add_action( 'admin_init', array( &$this, 'entries_detail' ) ); } public function entries_detail(){ global $wpdb; $entry_id = absint( $_REQUEST['entry'] ); $query = "SELECT forms.form_title, entries.* FROM $this->form_table_name AS forms INNER JOIN $this->entries_table_name AS entries ON entries.form_id = forms.form_id WHERE entries.entries_id = $entry_id;"; $entries = $wpdb->get_results( $query ); echo '
' . sprintf( '« Back to Entries', $_REQUEST['page'], $_REQUEST['view'] ) . '
'; /* Get the date/time format that is saved in the options table */ $date_format = get_option('date_format'); $time_format = get_option('time_format'); /* Loop trough the entries and setup the data to be displayed for each row */ foreach ( $entries as $entry ) { $data = unserialize( $entry->data ); ?>