I am having trouble verifying if a user is within a specified I.P. range.
The idea is that if a user is at a library within an I.P. range like
231.55.*.* and their I.P. address is 231.55.122.226 a session would be
registered for them. See my code below. This works but only for some I.P.'s
in a range.
Can anyone suggest a solution or resource that can help me?
$sql = "select * from customers where ip1 <=\"$remote_address\" and ip2
>=\"$remote_address\"";
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query. AUTO SIGN IN SELECT");
while ($row = mysql_fetch_array($sql_result)) {
$ip1 = $row["ip1"];
$ip2 = $row["ip2"];
$fname = $row["fname"];
$lname = $row["lname"];
$institution = $row["institution"];
$num = mysql_num_rows($sql_result);
$sign_in="$fname $lname $institution";
if($num>0){
session_register("sign_in");
}
else{echo" you can't see this page"}
-----------------------
Electronic Publications
Eurekah.com
Landesbioscience.com