3v4l.org

run code in 200+ php & hhvm versions
Bugs & Features
<?php /** * Returns list of subdomains * @param string $domain * @return array */ function getAllSubDomain($domain) { //strip '<prefix>:' first $dpos = strpos($domain, ':'); if ($dpos !== false) { $domain = substr($domain, $dpos+1); } else { $domain = $domain; } $domainParts = explode('.', str_replace("'", '', $domain)); $ret = array(); for ($off = sizeof($domainParts) -1; $off >= 0; $off--) { $ret[] = implode('.', array_slice($domainParts, $off)); } return $ret; } $subDomains = getAllSubdomain('test.sub.domain.com'); var_export($subDomains); echo "\n"; $queryPart = $q = "SELECT modifiers m" . " FROM delivery_host_modifiers" . " WHERE host IN ('" . implode("','", $subDomains) . "')" . " ORDER BY LENGTH(host) " ; var_export($queryPart);
Output for 5.4.44
array ( 0 => 'com', 1 => 'domain.com', 2 => 'sub.domain.com', 3 => 'test.sub.domain.com', ) 'SELECT modifiers m FROM delivery_host_modifiers WHERE host IN (\'com\',\'domain.com\',\'sub.domain.com\',\'test.sub.domain.com\') ORDER BY LENGTH(host) '