de77.com

Hi. Where do you store .csv file in server? And where are you creating php_db directory?

I keep getting the following error when trying to run the class:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 12 bytes) in /home/labdirec/public_html/ip2country/Ip2Country.php on line 289

Could you help me out?

I’m still getting basically the same error after adding that line.

Here is my code, sorry, the above must have pulled out the parts it didn’t like:

require ‘Ip2Country.php’;

$i = new Ip2Country;
ini_set(‘memory_limit’, ‘48M’);

//run below function once only. It will parse IpToCountry.csv
//file into PHP files and save them into php_db directory
$i->parseCSV();

//to display countryCode:
echo $i->load(‘24.24.24.24′)->countryCode;

//to display country and countryCode:
$i->load(‘24.24.24.24′);
echo $i->countryCode;
echo $i->country;

I updated the class. It now contains new function- parseCSV2(). You can see details in the post above.

if I send you ftp-access, can you install script ?

Thanks,

How to use the updated class??

after i did parseCSV2() it says

Warning: fopen(php_db/0.php)xxxxxxx

i get million lines of errors like this…

what do i do?

Thanks for this. I will try it on my on.

tanks very much for this info

Yes, there is a bug, but please note that:
intval(‘4194304100′) == intval(‘4194304000′)
so your code will not solve the bug.
However floatval() does the trick, so I updated the code. Thanks!

Great website. Thanks!

Suresh N: You can use database, but I am not sure if it won’t be slower..

********
To have it working in the meantime, do a replace in files for “);array” to “array”

Thanks Olivier for pointing the bug and providing a solution. I’ll try to fix the class, but I am terribly busy these days.

Thanks, Pascal!

Or try:

	public function parseCSV($filename = 'IpToCountry.csv')
	{
		$f = fopen($filename, 'r');
		$db = array();

		//parse into array
		while (!feof($f))
		{
			$s = fgets($f);
			if (substr($s, 0, 1) == '#') continue;

			$temp = explode(',', $s);
			if (count($temp)<7) continue;

			list($from, $to, $a, $b, $code, $c, $country) = $temp;

			$from = trim($from, '"');
			$to = trim($to, '"');
			$code = trim($code, '"');	

			$piece = substr($from, 0, 3);

			$db[$piece][] = array($from, $to, $code);
		}
		fclose($f);

		//dump array into many PHP files
		foreach ($db AS $piece=>$entries)
		{
			$f = fopen($this->dir . $piece . '.php', 'w');
			fputs($f, '<?php $entries = array(' . "\n");

			foreach ($entries AS $from=>$entry)
			{
				fputs($f, "array('" . $entry[0] . "','" . $entry[1] . "','" . $entry[2] . "'),\n");
			}

			fputs($f, ');');
			fclose($f);
		}
	}

This represents a really cost-effective method of reaching potential prospects.

Any plans to update this to use the IPv6 database?

A similar project
Ip2Country without Mysql
http://rob72.net78.net
Demo:
http://rob72.net78.net?demo

Yesterday everything worked fine, but now went back to get the syntax error by ); review the files of the arrays and turns out I doubled the lines of code, do not understand why? can anyone help?

Such editors can’t work from textarea. Please copy html from textarea to a div, use the editor and after you are done with editing- copy it back to textarea.

Hi,

I worked with the script / class and was not satisfied with the import duration. I recoded the import and added one function. Reworked class imports geo-data slightly faster and has a new function to change the data path. The code is here: http://pastebin.com/UfmqGwBa

Hope, you’ll like it.

Thanks & best regards.

None of the fixes quite get it right. For example, try this IP address: 50.196.142.177 The problem is that the range of decimal IPs covered can be quite large. The above IP falls into a range with over 8,000,000 IP addresses. So just puttig it in 1 or 2 of the php_db files is not sufficient. This fix corrects that, but it does create a few extra files for IP addresses that will never occur.

*** Ip2Country.php 2012-10-03 05:33:42.412162893 +0000
— /var/www/html/Ip2Country.php 2012-10-03 03:36:24.535563936 +0000
***************
*** 307,353 ****
fclose($f);
}

! public function parseCSV($filename = ‘IpToCountry.csv’)
{
! $f = fopen($filename, ‘r’);
! $db = array();
!
! //parse into array
! while (!feof($f))
{
! $s = fgets($f);
! if (substr($s, 0, 1) == ‘#’) continue;
!
! $temp = explode(‘,’, $s);
! if (count($temp)$entries)
- {
- $f = fopen($this->dir . $piece . ‘.php’, ‘w’);
- fputs($f, ‘$entry)
- {
- fputs($f, “array(‘” . $entry[0] . “‘,’” . $entry[1] . “‘,’” . $entry[2] . “‘),\n”);
- }
-
- fputs($f, ‘);’);
- fclose($f);
- }
}

public function parseCSV2($filename = ‘IpToCountry.csv’)
{
— 307,356 —-
fclose($f);
}

! public function parseCSV($filename = ‘IpToCountry.csv’)
! {
! $f = fopen($filename, ‘r’);
! $db = array();
!
! //parse into array
! while (!feof($f))
{
! $s = fgets($f);
! if (substr($s, 0, 1) == ‘#’) continue;
!
! $temp = explode(‘,’, $s);
! if (count($temp)<7) continue;
!
! list($from, $to, $a, $b, $code, $c, $country) = $temp;
!
! $from = trim($from, '"');
! $to = trim($to, '"');
! $code = trim($code, '"');
! $fromPiece = substr($from, 0, 3);
! $toPiece = substr($to, 0, 3);
!
! for ($piece = $fromPiece; $piece $entries)
! {
! $f = fopen($this->dir . $piece . ‘.php’, ‘w’);
! fputs($f, ‘$entry)
{
! fputs($f, “array(‘” . $entry[0] . “‘,’” . $entry[1] . “‘,’” . $entry[2] . “‘),\n”);
}
+
+ fputs($f, ‘);’);
fclose($f);
}
+ }
+

public function parseCSV2($filename = ‘IpToCountry.csv’)
{
***************
*** 370,387 ****
$from = trim($from, ‘”‘);
$to = trim($to, ‘”‘);
$code = trim($code, ‘”‘);
!
! $piece = substr($from, 0, 3);
! $topiece = substr($to, 0, 3);
!
! $db[$piece][] = array($from, $to, $code);
! $dbSize++;
!
! if ($topiece > $piece) {
! $db[$topiece][] = array($from, $to, $code);
$dbSize++;
}
!
if ($dbSize>100)
{
$this->appendToFile($db);
— 373,386 —-
$from = trim($from, ‘”‘);
$to = trim($to, ‘”‘);
$code = trim($code, ‘”‘);
! $fromPiece = substr($from, 0, 3);
! $toPiece = substr($to, 0, 3);
!
! for ($piece = $fromPiece; $piece 100)
{
$this->appendToFile($db);
***************
*** 467,470 ****
return false;
}

! }

It is not a good code. Look at the no of files you are creating in the process. A better solution would be to 1) to pick entries from excel and post it in a database
2)To use xml file.

But anyways you have shown the way. Good Work

No, sorry. IPv6 is not popular yet.