@ 2017-07-11T17:27:39Z <?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('oxadmin.pr.citeeze.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);
$result = json_decode('[{
"id": 78852,
"domain": "local.dev.citeeze.com",
"categories": null,
"added": "2014-12-04 06:35:38",
"updated": "2014-12-10 21:23:34",
"visible": 1,
"user_added": 0,
"mobile": 0,
"requests": 0,
"completion": 0.00
},
{
"id": 89652,
"domain": "www.citeeze.com",
"categories": null,
"added": "2014-12-04 06:47:25",
"updated": "2014-12-10 21:29:10",
"visible": 1,
"user_added": 0,
"mobile": 0,
"requests": 0,
"completion": 0.00
},
{
"id": 356163,
"domain": "citeeze.com",
"categories": null,
"added": "2015-01-20 13:42:50",
"updated": "2015-01-20 13:42:50",
"visible": 1,
"user_added": 1,
"mobile": 0,
"requests": 0,
"completion": 0.00
},
{
"id": 2739296,
"domain": "dev.citeeze.com",
"categories": null,
"added": "2016-04-18 05:11:23",
"updated": "2016-04-18 05:11:23",
"visible": 0,
"user_added": 0,
"mobile": 0,
"requests": 0,
"completion": 0.00
},
{
"id": 4399187,
"domain": "adunit.brendan.citeeze.com",
"categories": null,
"added": "2016-08-08 17:26:26",
"updated": "2016-08-08 17:26:26",
"visible": 1,
"user_added": 0,
"mobile": 0,
"requests": 0,
"completion": 0.00
},
{
"id": 5862092,
"domain": "tools.brendan.citeeze.com",
"categories": null,
"added": "2016-09-19 21:22:07",
"updated": "2016-09-19 21:22:07",
"visible": 1,
"user_added": 0,
"mobile": 0,
"requests": 0,
"completion": 0.00
},
{
"id": 6335525,
"domain": "oxadmin.pr.citeeze.com",
"categories": null,
"added": "2017-01-09 16:53:54",
"updated": "2017-01-09 16:53:54",
"visible": 0,
"user_added": 0,
"mobile": 0,
"requests": 0,
"completion": 0.00
},
{
"id": 6335537,
"domain": "pr.citeeze.com",
"categories": "",
"added": "2017-07-11 12:53:18",
"updated": "2017-07-11 12:53:25",
"visible": 0,
"user_added": 0,
"mobile": 0,
"requests": 0,
"completion": 0.00
},
{
"id": 6335540,
"domain": "test.oxadmin.prciteeze.com",
"categories": null,
"added": "2017-07-11 11:56:42",
"updated": "2017-07-11 11:56:42",
"visible": 0,
"user_added": 0,
"mobile": 0,
"requests": 0,
"completion": 0.00
}
]');
var_export($result, true);
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for git.master , git.master_jit , rfc.property-hooks array (
0 => 'com',
1 => 'citeeze.com',
2 => 'pr.citeeze.com',
3 => 'oxadmin.pr.citeeze.com',
)
'SELECT modifiers m FROM delivery_host_modifiers WHERE host IN (\'com\',\'citeeze.com\',\'pr.citeeze.com\',\'oxadmin.pr.citeeze.com\') ORDER BY LENGTH(host) ' This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.
Active branches Archived branches Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page
preferences:dark mode live preview
42.93 ms | 401 KiB | 8 Q