[RyanRobinson]

Hi guys,

I am trying to get my If statement to check if the IP address of a user who visits a page matches an IP address in the MySQL database. At the moment, I can see the "Thank you" page as my IP address is the first record in the table. However, I have been using a proxy to test another IP address and it shows me the "Error" page. I think this has something to do with my query array only checking the first record and not the rest.

Here's the PHP code

<?php

	require_once 'db.php';
	
	$ip_user = $_SERVER['REMOTE_ADDR'];
	
	$query = "SELECT ip_add FROM signup";
	
	if(!mysql_query($query))
	{
		echo "<h4>Query failed</h4>";
	}
	
	$result = mysql_query($query);
	
	$rec = mysql_fetch_array($result);
	
	if($ip_user == $rec['ip_add'])
	{
		echo "You can download these ebooks.";
		echo "<p>Your IP: $ip_user</p>";
	}else {
		echo "Trying to get a free ride?";
		echo "<p>Your IP: $ip_user</p>";
	}


?>

[JackOfAllTrades]

Check out this comment in the PHP documentation.

[RyanRobinson]

Thanks for the reply.

My problem is not with the Server Remote address. What I need to do, is check whether a users IP matches one within the mysql table. If the users IP address matches one of the IPs in the table then I will display some content, and if it doesn't it will just output some message.

At the moment, the PHP code above only checks the first IP address in the table and I need it to check through every record. I am guessing by using loop?

[codeprada]

If you want to just verify if there's a specific entry in your table you can use MySQL's function COUNT. This will return the amount of rows that matches the executed query. Also utilize MySQL's keyword WHERE that will do the matching for you instead of iterating the entire database.

Another function that will come in handy when comparing data in your database is LIKE.

<?php

	require_once 'db.php';
	
	$ip_user = $_SERVER['REMOTE_ADDR'];
	
	$query = "SELECT COUNT(ip_add) TOTAL FROM signup WHERE ip_add = $ip_user";
	
	if(!mysql_query($query))
	{
		die("<h4>Query failed</h4>");
	
	}
	
	$result = mysql_query($query);
	
	$rec = mysql_fetch_assoc($result);
	
	if((int)$rec['TOTAL'] > 0)
	{
		echo "You can download these ebooks.";
		echo "<p>Your IP: $ip_user</p>";
	}else {
		echo "Trying to get a free ride?";
		echo "<p>Your IP: $ip_user</p>";
	}


?>

[JackOfAllTrades]

Read about how to use MySQL with PHP.

[RyanRobinson]

Thanks codeprada,

I actually read about that method in my book but I completely forgot about it. Thanks!