info required

Discussion in 'PHP' started by rockwell, Jul 24, 2008.

  1. #1
    hello
    i would like to know how to filter email id.


    suppose i have 5 email id in mysql database table.








    now i want to check if these are vaild and remove the invalid entries from mysql database, how do i do it??
     
    rockwell, Jul 24, 2008 IP
  2. CristianR

    CristianR Peon

    Messages:
    704
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #2
    The only good way to verify an email address is by sending a verification link and asking the owner of that email to click it. Other than that, the used methods to verify an email address are not even 30% good at this kind of thing, they can only check the domain and see if it's valid ( at least from what I know ).

    Just my 2c ..
    sorry if this doesn't help too much..
     
    CristianR, Jul 24, 2008 IP
  3. jayshah

    jayshah Peon

    Messages:
    1,126
    Likes Received:
    68
    Best Answers:
    1
    Trophy Points:
    0
    #3
    Two ways:

    1) As CristianR said, split the domain and fsockopen to it to test if its alive.

    2) fsockopen to port 25 of the domain. If it connects, try sending commands to the mail server (HELO, MAIL FROM, RCPT TO) - sometimes the RCPT TO fails if the inbox doesn't exist.

    Hope that helps.
     
    jayshah, Jul 24, 2008 IP
  4. rockwell

    rockwell Peon

    Messages:
    211
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    i have millions of record in the bale this would be a time consuming processs and also increase load on server. is there any faster process???
     
    rockwell, Jul 24, 2008 IP
  5. jayshah

    jayshah Peon

    Messages:
    1,126
    Likes Received:
    68
    Best Answers:
    1
    Trophy Points:
    0
    #5
    Erm, no. Which method did you try?
     
    jayshah, Jul 24, 2008 IP