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'] ) . '

'; /* Loop trough the entries and setup the data to be displayed for each row */ foreach ( $entries as $entry ) { $data = unserialize( $entry->data ); echo '

Details

Form Title: ' . stripslashes( $entry->form_title ) . '

Date Submitted: ' . $entry->date_submitted . '

IP Address: ' . $entry->ip_address . '

Email Subject: ' . stripslashes( $entry->subject ) . '

Sender Name: ' . stripslashes( $entry->sender_name ) . '

Sender Email: ' . stripslashes( $entry->sender_email ) . '

Emailed To: ' . preg_replace('/\b([A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4})\b/i', '$1', implode( ',', unserialize( stripslashes( $entry->emails_to ) ) ) ) . '

' . sprintf( 'Delete', $_REQUEST['page'], $_REQUEST['view'], 'delete', $entry_id ) . '

'; echo '

' . $entry->form_title . ' : Entry #' . $entry->entries_id . '

'; foreach ( $data as $k => $v ) { echo '

' . ucwords( $k ) . '

'; //echo '

' . $v . '

'; echo $v; } echo '

'; } echo '

'; } } ?>