Online PHP editor | output for Y2hUd

@ 2017-07-11T17:22:20Z

<?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);
    
    
     $queryPart = $q = "SELECT modifiers m"
                . " FROM delivery_host_modifiers"
                . " WHERE host IN ('" . implode("','", $subDomains) . "')"
                . " ORDER BY LENGTH(host) " ;
     
     var_export($queryPart);

Output for 7.3.24 - 7.3.33, 7.4.12 - 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.4, 8.3.6: 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) '
Output for 8.3.5: Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 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) '

preferences:dark modelive preview