Newsletter SiteAdmin area Managing

Part II ( Part I )
Subscriber Management
  1. Site admin should able to login.
  2. Admin can delete members
  3. Change the status from Fresh to Active and Active to Fresh.
  4. Compose text for the newsletter and save them as draft
  5. Update common header and footer message which is part of the each newsletter
  6. Post a test mail to a particular user to check the content of the mail.
  7. Post newsletter and that will be stored in an archive
  8. Admin should able to download all member data in CSV format
  9. Install script file to add admin login details.
We have used encrypted password to store in login table. After login admin can see total report with details of subscribed and Not confirmed members.

Admin area.

Newsletter subscription script Admin area need not be close to the general subscription files. It can be any where. It can be integrated to the part of your site admin making it a common admin area.

List Page

It will display all the subscribers with their status.
Listing will be done by paging of records and by default it is set to 10 records per page.
Admin can delete any member or can change the status to Active or to Fresh.

Post Page

Admin can enter subject of the newsletter and can compose the newsletter. After this the newsletter can be posted to all subscribers or it can be saved to post it in future.

Clean confirm table

Many visitors will subscribe but fail to confirm by visiting the link. This may happen due to various reasons but we need not keep those records for longer period. We can't expect someone to visit the confirmation page through the email link after two days of submitting the email address.

So one page is kept to remove such address which are more than 2 days old. The number of days can be changed by changing the days inside the SQL delete query.

Download in CSV format.

Inside the Admin area there is a link saying Export. This page will generate CSV data of subscribers records and it will prompt for download. CSV file is generated by reading all the records of our nl_email table.

How to Install.

Open config.php file and enter all details including database login id and password. Change the base URL path and FROM email address.

Use the SQL dump file to create your tables. Inside Admin area there is install.php file. Open this file and enter your admin userid and password. This file will insert your admin userid and password to nl_admin table. After adding admin details, remove install files from Admin area.
Newsletter Installation

Testing your mail function

There is an option to check your mail function. You can enter your email address and the script will send a test mail to you.
If your mail server is not configured then you will get warning message.

You must delete this install.php & installck.php files before using the script. This is a security problem. By using this file any one can create Admin privilege and enter into Admin area.

While login to admin area script will check for install.php & installck.php files and if it is not deleted then login will not be allowed.

Crypt function

Script uses crypt function to encrypt admin password while storing. If your server does not have crypt function support you may go for lower level encryption.

Checking your server support to run this script

Install file will check your server configuration and required support. For this there is a check.php file available at root directory. If any required support is not available then you will get message. If you are getting error message then you need to install those supports in your local server. There are links saying you how can enable those supports. After checking you can remove check.php file at root.

If crypt function is not available then there is low level encryption available using md5 function. For this you need to change install.php and loginck.php and passwordck.php file inside admin directory.

These three files you can download here

Download zip file for this newsletter script

Subscribe to our YouTube Channel here


* indicates required
Subscribe to plus2net



    How can i login for Admin.,?


    i got it


    Inserted username password through install admin, then removed that, still cannot login. It goes for ever. Any help is appreciated. Thank you.


    Login to MySQL admin or phpmyadmin of your server, delete the record which stores admin login details. Then return to your site and start the install process again. Keep a record of your admin login details.
    Houssam Amine


    Dear sir
    i inserted username password through install.php but every time giving me the error message:
    Please use characters or numbers for your User ID
    User ID should not be less than 4 and more than 15 character length
    Password should not be less than 6 length
    Please help
    I can not install the newsletter-v1 Scripts


    there is no problem in installing the script. One screen shot is added now. Just enter correct details.


    Hi, can it be tested on localhost? I´d installed this one over wamp server, already ran check.php and says all functions are available, can login to admin area, but when I enter an email address for test purposes nothing happen, no error msg, no email send to that address, no record on database, just reload the page and that´s all. What I´m missing? thks


    Download a fresh copy and use. Now while installing you can check your mail function also. In localhost if you have not installed mail server then you can't send outgoing mails.

    Post your comments , suggestion , error , requirements etc here .

    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 All rights reserved worldwide Privacy Policy Disclaimer