Advanced Newsletter & Mailing System
Run your own mailing list with PHP and MySQL
Instant Download
Lifetime Access & Updates
User Guide
30-Day Money-Back Guarantee
Screenshots
Overview
The Advanced Newsletter & Mailing System is a PHP newsletter script for building a mailing list and sending email campaigns from your own server, with MySQL doing the bookkeeping instead of a monthly-fee email service. One payment, full source code, and your subscriber data stays yours.
Visitors subscribe through popup or in-content widgets, and you write newsletters in a WYSIWYG editor, organize subscribers into groups, attach files, and schedule campaigns that a cron job sends in the background. Tracking pixels and link redirects tell you who opened, who clicked, and who unsubscribed, and subscribers and campaigns can be imported or exported as CSV, JSON, or XML.
Setup is the usual routine: upload the files, import the SQL file, update the config, and point a cron job at the cron file. The user guide covers each step, and support is included if you hit a snag.
Features
Secure Mailing Script Advanced coding techniques are pre-applied to prevent SQL injection and other known vulnerabilities.
Interactive Subscription Widgets Pre-coded widgets can be placed anywhere on your website, either as a popup or an in-content form.
Automated Campaigns Create campaigns and automate newsletter dispatch logic using the included admin interface.
Scheduled Tasks Included cron job scripts update campaigns in the background, handling large lists efficiently.
Email Tracking Logic Built-in scripts track which subscribers have read your newsletters, unsubscribed, or clicked embedded links.
Subscriber Groups Database architecture allows you to organize subscribers into groups for targeted mailing.
WYSIWYG Editor Create HTML newsletters easily with the integrated WYSIWYG editor module.
Import & Export Data Functional modules allow you to import and export subscribers and campaigns in CSV, JSON, and XML formats.
File Attachments Built-in logic to securely attach files to your newsletters and automated campaigns.
AJAX Integration Subscription widgets utilize JavaScript AJAX to execute form requests silently in the background.
Admin Panel UI View the dashboard, manage campaigns, create newsletters, and edit global settings from a central hub.
SCSS Files Included Preprocessor CSS language files are included to make modifying the stylesheet highly convenient.
Clean, Commented Source Code Thoroughly commented code helps you understand every aspect of the logic for easier modifications.
Lifetime Access & Documentation Your one-time purchase includes free lifetime updates and a comprehensive technical setup guide.
Technical Requirements
To ensure the software package runs smoothly and efficiently on your server, please verify your hosting environment meets the following specifications.
- Web Server: Apache or Nginx. For setting up and testing on your local machine, we find XAMPP to be an excellent choice.
- PHP Version: PHP 5.5.0 or newer is required. However, for the best performance and enhanced security, we strongly recommend using PHP 8.0 or higher.
- Database: MySQL version 5.6 or newer, or MariaDB.
- Code Editor: We recommend Visual Studio Code or Notepad++ for making custom modifications.
FAQs
Why am I encountering a MySQL error after installation?
This usually happens if the database connection details aren't configured correctly. Double-check that the host, username, password, and database name in your 'config.php' file exactly match your MySQL setup. Also, ensure you've successfully imported the provided SQL file into your database using a tool like phpMyAdmin.
My campaigns aren't sending automatically. What's the fix?
For automated campaign sending, you'll need to set up a cron job on your server. This task should be configured to execute the 'cron.php' file regularly, typically every 1 to 5 minutes. Our user guide provides detailed technical steps on how to configure this on your host.
How can I change the 'from' email address for my newsletters?
You can easily update the sender's email address directly within the admin panel. Head to the Settings section, where you'll find options to specify the default 'from' name and email address for all outgoing campaigns.
I've lost my download ZIP file. How can I get it again?
No problem! You can re-download the software package using the unique download link that was sent to your email address when you made the purchase. If you can't locate that email, please use our receipt resend page to get a new link. Remember, these links are for your use only, so please keep them private.
Can I import my existing list of subscribers into the system?
Yes, absolutely! The codebase supports importing subscribers from CSV files, and the admin panel provides an interface to manage this process. Check the Import & Export Data module for more details.
Is this system secure against common web threats?
Security is built into the script. We've implemented advanced PHP techniques (like PDO) to protect against common vulnerabilities like SQL injection and Cross-Site Scripting (XSS). We also recommend keeping your server environment and PHP version up to date for optimal security.
What are the limits on the number of subscribers or emails I can send?
The script itself doesn't impose any hard limits on the number of subscribers or emails. However, your sending capacity will be determined by your web hosting provider's policies and your configured SMTP service.
How does the email tracking feature work?
Email tracking is achieved by embedding a tiny, invisible pixel image in outgoing HTML emails and by redirecting links through a tracking script. When a subscriber opens the email, the pixel is loaded, signaling an 'open'. When they click a link, it's recorded before they're forwarded to the actual destination.
Can I customize the appearance of my newsletters and subscription widgets?
Yes! You can create and design newsletters using the built-in WYSIWYG editor, or use your own HTML code for full control. Subscription widgets can also be styled to match your website's branding, and the included SCSS files make advanced customization easier for developers.
What kind of updates and documentation can I expect?
Your purchase includes free lifetime access to version updates and a comprehensive User Guide. We are committed to keeping the codebase up-to-date with new features, improvements, and compatibility with the latest PHP versions.
Can I use the package on multiple websites?
Yes, but each website needs its own license.
Change Log
Version 2.0.1 03/06/2025
- [Updated] the MySQL database collation to utf8mb4_unicode_ci to support a wider range of characters.
- [Added] additional details to the campaign overview page.
- [Fixed] an issue with the groups table and groups column in the campaign table. They have been renamed to support newer versions of MySQL.
- [Fixed] a few issues with the TinyMCE editor.
Version 2.0.0 23/09/2024
- [Updated] the subscription widgets and added the ability to specify groups.
- [Updated] the admin UI and added a bunch of new features, including filters, new columns, and more.
- [Updated] the email confirmation page and made it more elegant.
- [Updated] the unsubscribe logic to direct the user to a form where they can enter the reason for unsubscribing.
- [Added] customizable placeholders for newsletters and campaigns.
- [Added] the ability to export and import data in various formats, including CSV, JSON, and XML.
- [Added] WYSIWYG editor (TinyMCE) for creating newsletters with ease. You no longer have to input raw HTML. The feature is toggleable in the settings.
- [Added] file attachments to newsletters and campaigns.
- [Added] subscriber groups that allow you to organize subscribers into groups.
- [Fixed] quite a few bugs.
Version 1.0.1 28/11/2022
- [Fixed] a bug when the user subscribes again after unsubscribing.
Version 1.0.0 19/08/2022
- [Release] the newsletter & mailing system initial release.