<?php
//skipped retrieving from the database, and doing
// $urls = array_column($rows, 'urls');
$urls = [
'http://www2.trafficadbar.com/__a4w4',
'http://trafficadbar.com/__a4w4',
'http://www.trafficadbar.com/__a4w4',
'http://4acesmailer.com/credit_click.php?userid=2472&openkey=gbyp2vcm',
'http://4acesmailer.com/credit_click.php?userid=2714&openkey=gbyp2vcm',
'http://4acesmailer.com/credit_click.php?userid=2723&openkey=gbyp2vcm',
'http://4acesmailer.com/credit_click.php?userid=3245&openkey=gbyp2vcm',
'http://4acesmailer.com/credit_click.php?userid=3259&openkey=gbyp2vcm',
];
$results = [];
foreach($urls as $url){
//eg: www2.trafficadbar.com
$host = parse_url($url,PHP_URL_HOST);
$matches = [];
//find top level domain or skip to next URL
if(!preg_match('/[^\.]*\.[^\.]+$/',$host,$matches)) continue;
//eg: trafficadbar.com
$domain = $matches[0];
//increment the count for this domain in results
if(!isset($results[$domain])) $results[$domain]=0;
$results[$domain]++;
}
print_r($results);
preferences:
17.83 ms | 402 KiB | 5 Q