php mailing list

Discussion in 'PHP' started by prateekcassanova, Jul 11, 2009.

0
  1. #1
    i am using php mailing list for my website. But the database i have created is not created through double opt-in .


    Now my hosting website is saying kindly create your database with double opt-in. so how can we do so? as we have a database of 50000 email addresses and we want to use these email addresses.
     
    prateekcassanova, Jul 11, 2009 IP
  2. The-host

    The-host Peon

    Messages:
    40
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Backup the tables to your local computer, reupload them after changing the database?
     
    The-host, Jul 12, 2009 IP
  3. prateekcassanova

    prateekcassanova Guest

    Messages:
    300
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    when we reupload them? after that what we have to do? pls be in detail
     
    prateekcassanova, Jul 12, 2009 IP
  4. newgenservices

    newgenservices Well-Known Member

    Messages:
    862
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    105
    Digital Goods:
    1
    #4
    5 Easy steps for double opt-in.

    1) Backup your entire database and files
    2) Add another column "status" with default as "InActive" and then edit the column default to empty (blank)
    3) Create a PHP file to select * from $table where status = 'InActive'; and send a mail to all those users using while loop.
    4) If a user confirms, change status to Active else change status to "Unsubscribed"
    5) Similarly update your subscribe.php or whatever file that adds emails to the database to ensure the user gets a email to confirm.
     
    newgenservices, Jul 14, 2009 IP