<?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);
- Output for 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.7
- Array
(
[trafficadbar.com] => 3
[4acesmailer.com] => 5
)
preferences:
215.52 ms | 403 KiB | 292 Q