'id', 'created_on' => 'created_on', 'submitted' => 'submitted', 'default' => 'created_on' ); $orderby = isset($_GET['orderby']) && isset($columns[$_GET['orderby']]) ? $columns[$_GET['orderby']] : $columns['default']; $order = isset($_GET['order']) && $_GET['order'] == 'asc' ? 'ASC' : 'DESC'; global $wpdb; if (isset($_GET['delete'])) { $wpdb->delete( "{$wpdb->prefix}bwsurvey_entries", array( 'id' => $_GET['delete'], ), array( '%d', ) ); } $per_page = 25; if (isset($_GET['survey'])) { $item_count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(id) FROM {$wpdb->prefix}bwsurvey_entries WHERE LENGTH(data) > 6 AND survey_id = %d;", $_GET['survey'])); $page_count = ceil($item_count / $per_page); $paged = isset($_GET['paged']) ? min($page_count, max(1, $paged)) : 1; $survey_title = $wpdb->get_var($wpdb->prepare("SELECT title FROM {$wpdb->prefix}bwsurvey_surveys WHERE id = %d;", $_GET['survey'])); $results = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}bwsurvey_entries WHERE LENGTH(data) > 6 AND survey_id = %d ORDER BY {$orderby} {$order} LIMIT %d OFFSET %d", $_GET['survey'], $per_page, $per_page * ($paged - 1) )); } else { $item_count = $wpdb->get_var("SELECT COUNT(id) FROM {$wpdb->prefix}bwsurvey_entries WHERE LENGTH(data) > 6;"); $page_count = ceil($item_count / $per_page); $paged = isset($_GET['paged']) ? min($page_count, max(1, $paged)) : 1; $results = $wpdb->get_results($wpdb->prepare("SELECT entry.*, survey.title AS survey FROM {$wpdb->prefix}bwsurvey_entries AS entry INNER JOIN {$wpdb->prefix}bwsurvey_surveys AS survey ON entry.survey_id = survey.id WHERE LENGTH(entry.data) > 6 ORDER BY {$orderby} {$order} LIMIT %d OFFSET %d", $per_page, $per_page * ($paged - 1) )); } ?>

Entries

1): ?> of

Survey Pages list

survey)) $survey_title = $result->survey; $data = unserialize($result->data); $length = empty($data) ? 0 : count($data); ?>
Date Survey Status
created_on; ?>
View | Delete
submitted ? 'Submitted' : 'Not Submitted'; ?> ()
Date Survey Status
1): ?> of

CSV Export

get_results("SELECT id, title FROM {$wpdb->prefix}bwsurvey_surveys ORDER BY title"); $survey_id = isset( $_GET['survey'] ) ? intval( $_GET['survey'] ) : ( isset( $results[0] ) ? $results[0]->id : 0 ); ?> Download CSV