<?php
$link = mysqli_connect('localhost', 'mijnmeter', 'xmeter00')
    or die('Could not connect: ' . mysqli_error());
mysqli_select_db($link, 'mijnmeter') or die('Could not select database');

$query = 'select loc_ip from hosts where ip="' . $_SERVER['REMOTE_ADDR'] . '"';
$result = mysqli_query($link,$query) or die('Query failed: ' . mysqli_error());
if ( mysqli_affected_rows($link) == 1 ) {
        $row = mysqli_fetch_assoc($result);
        echo '<script language="javascript"> window.location.href = "http://' . $row['loc_ip'] . '" </script>';
} else {
        echo "host not found.";
}
?>

