/** * Display a table showing the latest members * @param int $limit The amount of rows to show (default all) * @param string $header the header text of the table * @return void */ function wp_email_capture_writetable($limit = 0, $header = '') { global $wpdb; $registered_members_table = WP_EMAIL_CAPTURE_REGISTERED_MEMBERS_TABLE; $get_registered_members_sql = "SELECT id, name, email FROM " . $registered_members_table; if ($limit != 0) { $get_registered_members_sql .= " ORDER BY id DESC LIMIT 3"; } $registered_members = $wpdb->get_results($get_registered_members_sql); $tabletoshow = ""; if ($header == '') { $header = "<h3>" . __('Members', 'wp-email-capture') . "</h3>"; } echo $tabletoshow .= $header; $tabletoshow .= ' <table border="0"> <tr><td><strong>' . __('Name', 'wp-email-capture') . '</strong></td><td colspan="2"><strong>' . __('Email', 'wp-email-capture') . '</strong></td></tr>'; foreach ($registered_members as $member) { if ($limit == 0) { $delid = wp_email_capture_formdelete($member->id, $member->email); } else { $delid = ''; } $tabletoshow .= '<tr><td style="width: 300px;">' . $member->name . '</td><td style="width: 300px;">' . $member->email . '</td><td style="width: 300px;">' . $delid . '</td></tr>'; } $tabletoshow .= '</table>'; $tabletoshow = apply_filters('wp_email_capture_display_table', $tabletoshow); echo $tabletoshow; }
function wp_email_capture_writetable($limit = 0, $header = '') { global $wpdb; $table_name = $wpdb->prefix . "wp_email_capture_registered_members"; $sql = "SELECT id, name, email FROM " . $table_name; if ($limit != 0) { $sql .= " ORDER BY id DESC LIMIT 3"; } $results = $wpdb->get_results($sql); if ($header == '') { $header = "<h3>" . __('Members', 'WPEC') . "</h3>"; } echo $header; ?> <table border="0"> <tr><td><strong><?php _e('Name', 'WPEC'); ?> </strong></td><td colspan="2"><strong><?php _e('Email', 'WPEC'); ?> </strong></td></tr> <?php foreach ($results as $result) { if ($limit == 0) { $delid = wp_email_capture_formdelete($result->id, $result->email); } else { $delid = ''; } echo "<tr><td style='width: 300px;'>" . $result->name . "</td><td style='width: 300px;'>" . $result->email . "</td><td style='width: 300px;'>\n\t" . $delid . "</td>\n\n\t</tr>"; } ?> </table> <?php }