koreaklubben.com Domain Whois
<?php
$query = $_SERVER["QUERY_STRING"];
$query = substr ($query, 6);
if (preg_match("/^(?:[a-zA-Z0-9]+(?:\-*[a-zA-Z0-9])*\.)+[a-zA-Z0-9]{2,63}$/", $query)){
$serverName = "database.namebay.com";
$connectionOptions = array(
"Database" => "Namebay",
"Uid" => "web",
"PWD" => "web7599"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);
$tsql= "exec P_GetWhoisData ?";
$params = array($query);
$getResults = sqlsrv_query($conn, $tsql, $params);
if ($getResults == FALSE){
die(FormatErrors(sqlsrv_errors()));
}
$i = 0;
while ($row = sqlsrv_fetch_array($getResults, SQLSRV_FETCH_ASSOC)) {
$i++;
echo "Domain Name: ".$query."\n";
echo "Registry Domain ID ".$row['roid']."\n";
echo "Registrar WHOIS Server: whois.namebay.com"."\n";
echo "Registrar URL: www.namebay.com"."\n";
echo "Updated Date: ".$row['date_mod']."\n";
echo "Creation Date: ".$row['date_cre']."\n";
echo "Registrar Registration Expiration Date: ".$row['date_exp']."\n";
echo "Registrar: ".$row['registrar']."\n";
echo "Registrar IANA ID: 88"."\n";
echo "Registrar Abuse Contact Email: abuse@namebay.com"."\n";
echo "Registrar Abuse Contact Phone: +377.97706164"."\n";
// is reseller org or individual?
if ($row['reseller_entity'] == 1){
echo "Reseller Name: ".$row['reseller_org']."\n";
}else{
echo "Reseller Name: ".$row['reseller_name']."\n";
}
echo "Domain Status: ".$row['status']." https://www.icann.org/epp#".$row['status']."\n";
echo "Registry Registrant ID: ".$row['registrant_id']."\n";
echo "Registrant Name: ".$row['registrant_name']."\n";
echo "Registrant Organization: ".$row['registrant_org']."\n";
echo "Registrant Street: ".$row['registrant_street']."\n";
echo "Registrant City: ".$row['registrant_city']."\n";
echo "Registrant State\Province: ".$row['registrant_sp']."\n";
echo "Registrant Postal Code: ".$row['registrant_pc']."\n";
echo "Registrant Country: ".$row['registrant_cc']."\n";
echo "Registrant Phone: ".$row['registrant_phone']."\n";
echo "Registrant Phone Ext: ".$row['registrant_phone_ext']."\n";
echo "Registrant Fax: ".$row['registrant_fax']."\n";
echo "Registrant Fax Ext: ".$row['registrant_fax_ext']."\n";
echo "Registrant Email: https://www.validname.com/whoiscontact/?id=".$row['guid']."&c=O\n";
echo "Registry Admin ID: Not available from the registry"."\n";
echo "Admin Name: ".$row['admin_name']."\n";
echo "Admin Organization: ".$row['admin_org']."\n";
echo "Admin Street: ".$row['admin_street']."\n";
echo "Admin City: ".$row['admin_city']."\n";
echo "Admin State\Province: ".$row['admin_sp']."\n";
echo "Admin Postal Code: ".$row['admin_pc']."\n";
echo "Admin Country: ".$row['admin_cc']."\n";
echo "Admin Phone: ".$row['admin_phone']."\n";
echo "Admin Phone Ext: ".$row['admin_phone_ext']."\n";
echo "Admin Fax: ".$row['admin_fax']."\n";
echo "Admin Fax Ext: ".$row['admin_fax_ext']."\n";
echo "Admin Email: https://www.validname.com/whoiscontact/?id=".$row['guid']."&c=A\n";
echo "Registry Tech ID: Not available from the registry"."\n";
echo "Tech Name: ".$row['tech_name']."\n";
echo "Tech Organization: ".$row['tech_org']."\n";
echo "Tech Street: ".$row['tech_street']."\n";
echo "Tech City: ".$row['tech_city']."\n";
echo "Tech State\Province: ".$row['tech_sp']."\n";
echo "Tech Postal Code: ".$row['tech_pc']."\n";
echo "Tech Country: ".$row['tech_cc']."\n";
echo "Tech Phone: ".$row['tech_phone']."\n";
echo "Tech Phone Ext: ".$row['tech_phone_ext']."\n";
echo "Tech Fax: ".$row['tech_fax']."\n";
echo "Tech Fax Ext: ".$row['tech_fax_ext']."\n";
echo "Tech Email: https://www.validname.com/whoiscontact/?id=".$row['guid']."&c=T\n";
// DNS servers list
$dns = explode(";", $row['ns_list']);
foreach ($dns as $dnsserver) {
echo "Name Server: ".$dnsserver."\n";
}
// is dns zone signed?
if ($row['dns_sec'] == '1') {
echo "DNSSEC: signedDelegation"."\n";
} else {
echo "DNSSEC: unsigned"."\n";
}
echo "URL of the ICANN WHOIS Data Problem Reporting System: http://wdprs.internic.net/"."\n";
echo ">>> Last update of WHOIS database: ".date("Y-m-d H:i:s")." <<<\n";
echo "\n";
echo "For more information on Whois status codes, please visit https://www.icann.org/epp"."\n";
}
if ($i == 0){
echo "The queried object does not exist: URL of the ICANN WHOIS Data Problem Reporting System:http://wdprs.internic.net/\n";
echo ">>> Last update of WHOIS database: ".date("Y-m-d H:i:s")." <<<\n";
echo "\n";
echo "For more information on Whois status codes, please visit https://www.icann.org/epp\n";
}
sqlsrv_free_stmt($getResults);
sqlsrv_close( $conn);
}
?>