asked on

Search and replace urls with email addresses

hi there

I have a list of urls in one text file and then some emails in another.

What im after is a way of comparing and finding the domain name of an email with the list of the urls in a text file

for example

url list

http://www.thisisadomain.com/?=23453
http://www.acooldomain.com/?=34234
http://noemailmatches.com/?=23454
hhp://ifonlyihadasportscar.com?=34234

then in the email list you would have something like this that matches that domain

admin@thisisadomain.com
support@acooldomain.com
contact@ifonlyihadasportscar.com

now if there are missing emails or it cannot find the right address for that matched domain just copy the original URL in its place.

So the final master file would be a combo of matched emails to domain and the urls that have no matches.

admin@thisisadomain.com
support@acooldomain.com
http://noemailmatches.com/?=23454 <-------------------- no matches from email list
contact@ifonlyihadasportscar.com

can you make sure the output is line by line

Best regards

Marcus Bointon

$urls = file('urllist.txt');
$emails = file('emails.txt');
$output = fopen('out.txt', 'w');
foreach($urls as $url) {
      if (preg_match('/http[s]?:\/\/(www\.)?(.*)\//', $url, $matches)) {
            $domain = $matches[2];
            $out = '';
            foreach($emails as $email) {
                  if (strpos($domain, $email) !== false) {
                        $out = $email;
                        break; //stop looking
                  }
            }
            if ($out = '') {
                  fwrite($output, "$url\n");
            } else {
                  fwrite($output, "$out\n");
            }
      }
}
fclose($output);

Not tested, other than the regex, but that should be roughly what you need. Not the most efficient, but shouldn't be too slow.

Marcus Bointon

oops:

if (strpos($domain, $email) !== false) {

should be:

if (strpos($email, $domain) !== false) {

playstat

ASKER

it doesnt work

ASKER CERTIFIED SOLUTION

Marcus Bointon

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rajkumar_G

$data="http://www.thisisadomain.com/?=23453";
// get host name from URL
preg_match("/^(http:\/\/)?([^\/]+)/i",
"http://www.thisisadomain.com/?=23453", $matches);
$host = $matches[2];

// get last two segments of host name
preg_match("/[^\.\/]+\.[^\.\/]+$/",$host,$matches);
echo " domain name from URL : ".$matches[0]."\n";

$email = "admin@thisisadomain.com";
$str_pos=strpos($email,'@');
$domain_email=substr($email,$str_pos+1);
echo " Domain Email : ".$domain_email;

if(strcmp($domain_email,$matches[0])==0)
{
echo " Matched";
$data = preg_replace('|\\b(http://[^\s)<]+)|',$email, $data);
echo " Result :".$data;
}
else
{
echo " Not Matched";
}

I have done it with an example, not the full code, but the main part of it. I think u know how to read from and write in to a text file. Customize this code according to your need.