/**
* 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
}
