subdomain = " . $subdomain . "
"; //echo "domain = " . $domain . "
"; //echo "extension = " . $extension . "
"; // DB connection. $db = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpassword, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'")); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //set DB connection to show error message if any. //SQL to query Domain ID, did. $sql = "select url from tbl_urlfwd where subdom = \"$subdomain\" and did = (select did from tbl_domain where domain = \"$domain\" and ext = \"". idn_to_utf8($extension)."\")"; //echo $sql; //Debug SQL command //get the Domain ID from DB try { $query = $db->query($sql); $query->setFetchMode(PDO::FETCH_ASSOC); $result = $query->fetch(); } catch (PDOException $pe) { die("Query error :" . $pe->getMessage()); } $db = NULL; // Clear the DB query and release the memory used. //if there is result for the URL Forward, send the client to the page. if ($result['url']) { echo $result['url']; //use to debug what is the value return by DB. if(strpos($result['url'],'http://') !== false || strpos($result['url'], 'https://') !== false) { $destination = "Location: ".$result['url']; header("$destination",true,301); echo $destination; //Comment the line above and uncomment this line to show what is the value retrieved from DB. } else { $destination = "Location: http://".$result['url']; header("$destination",true,301); echo $destination; //Comment the line above and uncomment this line to show what is the value retrieved from DB. } } ?>