prefix . 'test_email_logs'; $to = implode(', ', array_column($phpmailer->getToAddresses(), 0)); $subject = sanitize_text_field($phpmailer->Subject); $body = sanitize_textarea_field($phpmailer->Body); $status = 'Sent'; // Assuming it's sent unless there's an error $wpdb->insert( $table_name, array( 'time' => current_time('mysql'), 'to_email' => $to, 'subject' => $subject, 'body' => $body, 'status' => $status, ) ); } // Create table to store email logs on plugin activation register_activation_hook(__FILE__, 'wp_test_email_create_table'); function wp_test_email_create_table() { global $wpdb; $table_name = $wpdb->prefix . 'test_email_logs'; $charset_collate = $wpdb->get_charset_collate(); $sql = "CREATE TABLE $table_name ( id mediumint(9) NOT NULL AUTO_INCREMENT, time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, to_email varchar(100) NOT NULL, subject varchar(255) NOT NULL, body text NOT NULL, status varchar(20) NOT NULL, PRIMARY KEY (id) ) $charset_collate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); } // Register the Email Logs page function register_wp_test_email_logs_page() { add_submenu_page('tools.php', "Email Logs", "Email Logs", 'manage_options', 'wp-test-email-logs', 'wp_test_email_logs'); } add_action('admin_menu', 'register_wp_test_email_logs_page'); function wp_test_email_logs() { global $wpdb; // Pagination and search variables $table_name = $wpdb->prefix . 'test_email_logs'; $items_per_page = 10; $current_page = isset($_GET['paged']) ? max(1, intval($_GET['paged'])) : 1; $offset = ($current_page - 1) * $items_per_page; // Sorting variables $sort_by = isset($_GET['orderby']) ? sanitize_text_field($_GET['orderby']) : 'time'; $order = isset($_GET['order']) ? strtoupper(sanitize_text_field($_GET['order'])) : 'DESC'; $allowed_sort_columns = ['time', 'to_email', 'subject', 'status']; if (!in_array($sort_by, $allowed_sort_columns)) { $sort_by = 'time'; // Default to time if invalid } if ($order !== 'ASC' && $order !== 'DESC') { $order = 'DESC'; // Default to DESC if invalid } $search_query = ''; if (isset($_GET['s'])) { $search_query = sanitize_text_field($_GET['s']); } // Query for email logs with search, sorting, and pagination $query = "SELECT * FROM $table_name"; if (!empty($search_query)) { $search_query_escaped = '%' . $wpdb->esc_like($search_query) . '%'; $query .= $wpdb->prepare( " WHERE to_email LIKE %s OR subject LIKE %s OR body LIKE %s", $search_query_escaped, $search_query_escaped, $search_query_escaped ); } $query .= " ORDER BY $sort_by $order LIMIT $offset, $items_per_page"; $results = $wpdb->get_results($query); // Total items for pagination $total_items_query = "SELECT COUNT(*) FROM $table_name"; if (!empty($search_query)) { $total_items_query .= $wpdb->prepare( " WHERE to_email LIKE %s OR subject LIKE %s OR body LIKE %s", $search_query_escaped, $search_query_escaped, $search_query_escaped ); } $total_items = $wpdb->get_var($total_items_query); $total_pages = ceil($total_items / $items_per_page); ?>

time); ?> to_email); ?> subject); ?> status); ?>
add_query_arg('paged', '%#%'), 'format' => '', 'prev_text' => __('«', 'wp-test-email'), 'next_text' => __('»', 'wp-test-email'), 'total' => $total_pages, 'current' => $current_page )); echo $paginate_links; ?>
prefix . 'test_email_logs'; $date_threshold = date('Y-m-d', strtotime('-30 days')); $wpdb->delete( $table_name, array('time <' => $date_threshold), array('%s') ); } ?>