Personal Project - Show country of origin of IP address

[SHANE523]

I don't do a lot of coding, very infrequent, so I need some help with this.

I get a log file from my router and I have it parsed to specific IP address information and saved as a windows txt file. What I would like to do is have those IP address used to query a database that shows country of origin. For the final result I would like to have the IP address show and the country code next to it.

The connection to the database, the query and listing the IP addresses work fine. It is the trying to loop the query that I am having the issue. What am I doing wrong?

$file = fopen("ping.txt", "r");  //text file with any number of IP addresses


WHILE ($line = fgets($file)) {
for ($i=0;$i<count($line);$i++) { 

		$result = mysql_query("SELECT glc.glc_country
						FROM geoip_blocks gbl 
						JOIN geoip_locations glc ON glc.glc_id = gbl.gbl_glc_id 
						WHERE gbl_block_start <= INET_ATON('$line[$i]')	
						ORDER BY gbl_block_start DESC
						LIMIT 1")
								or die (mysql_error());

//fetch the results

		$cntry = mysql_fetch_row($result);
		echo $line . $cntry . "<br />";	
}	
}

Any help will be greatly appreciated.

[Weedpacket]

You forgot to say what the issue is. But I do note that [man]mysql_fetch_row[/man] returns an entire row, not just a string (so [font=monospace]$cntry[/font] won't contain what you think it contains).

(A couple of other points: first, the MySQL extension is deprecated and shouldn't be used any more. And second, performance would be much better if you searched for all of the IPs in one query and then looped through the results of that.

[SHANE523]

Sorry.
The issue is that in all my attempts the best I have gotten is the list of IP addresses and the last IP address is the only one to return a value from the query (current version doesn't do that). So it would show the 4 IP addresses in the current file (test file) and the last IP in the list would return US from the query.

I will have to look in to the new PHP commands and look in to what you suggested.