A membrane solution to your water treatment application is closer than you may think. With locations on every continent, Hydranautics delivers solutions based upon your needs and situation. Finding the nearest Hydranautics location is easy. Simply select your world region, country and determine if you want a regional office, one of our many distributors or both. The results, including contact information automatically appear.
Contact us today. We look forward to hearing from you!
[insert_php]
$servername = “localhost”;
$username = “aimpl_hydra”;
$password = “}d})J;94STcr”;
$dbname = “aimpl_hydra”;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
if (isset($_POST[‘submit’]))
{
//echo “isset submit”;
$region = $_POST[“region”];
$country = $_POST[“country”];
//$type = $_POST[“address”];
if($region == 1){$regionvalue = “Indian Sub Continent”;}
if($region == 2){$regionvalue = “China”;}
if($region == 3){$regionvalue = “Europe & Africa”;}
if($region == 4){$regionvalue = “Middle East”;}
if($region == 5){$regionvalue = “North America”;}
if($region == 6){$regionvalue = “South America”;}
if($region == 11){$regionvalue = “South East Asia & Ocenia”;}
if($region == 10){$regionvalue = “North East Asia”;}
//echo $regionvalue;
echo ”
You are searched for Region = $regionvalue, Country = $country
“;
echo ”
$country
“;
$sql = “SELECT id,region,country,address,tel,fax FROM regional_office where status=’active’ and country=’$country'”;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo ”
Regional Office
“;
while($row = $result->fetch_assoc())
{
echo ”
“;}
echo ”
| Hydranautics A Nitto Group Company $row[address] “; echo” |
“; if($row[tel] !=””) { echo ” Tel
:
$row[tel]
“; } Fax
:
$row[fax]
“; } echo” |
“; echo” |
“;
}
else {
echo ”
Regional Office
| Please contact the regional office. |
“;
}
$sql = “SELECT id,region,country,name,name1,name2,designation,tel,tel1,tel2,email,email1,email2 FROM regional_sales where status=’active’ and country=’$country'”;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
//print_r($result);
echo ”
Regional Sales Contact
“;
while($row = $result->fetch_assoc())
{
echo ”
“;
if($row[name1] !=””)
{
echo ”
“;
}
if($row[name2] !=””)
{
echo ”
“;
}
}
echo ”
| “; echo ” Name
:
$row[name]
“; if($row[email] !=””) { “; echo” |
“;
if($row[tel] !=””) { Tel
:
$row[tel]
“; } echo” |
“; echo” |
| “; echo ” Name
:
$row[name1]
“; if($row[email1] !=””) { “; echo” |
“;
if($row[tel1] !=””) { Tel
:
$row[tel1]
“; } echo” |
“; echo” |
| “; echo ” Name
:
$row[name2]
“; if($row[email2] !=””) { “; echo” |
“;
if($row[tel2] !=””) { Tel
:
$row[tel2]
“; } echo” |
“; echo” |
“;
}
else {
echo ”
Regional Sales Contact
| Please contact the regional sales team. |
“;
}
$sql = “SELECT id,region,country,company_name,address,name1,name2,phone,mobile,fax,email,web,logo FROM distributor_office where status=’active’ and country=’$country'”;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo ”
Authorized Distributors
“;
while($row = $result->fetch_assoc())
{
echo ”
“; }
echo ”
| $row[company_name] $row[address] “; if($row[name1] !=””) { echo “Contact Person1: $row[name1] “; } if($row[name2] !=””) { echo “Contact Person2: $row[name2] “; } echo” |
“; if($row[phone] !=””) { echo ” Tel
:
$row[phone]
“; } Mob.
:
$row[mobile]
“;} Fax
:
$row[fax]
“; } “; } “; } |
 “; }echo” |
“;
}
else {
echo ”
Authorized Distributors
| Please contact the regional sales team. |
“;
}
}
else
{
echo “”;
}
[/insert_php]