Web Hosting Info

Search:

featured partner

The IP to Country Database
  Forum Topics : Development / Using MySQL/PHP to create IP Addr, Num or Domain to Country app
Submitted by TheJohnDoe2005 on Fri, 09/09/2005 - 15:45.
Standard WebLayout
This is the standard layout of the website with the description and the user's input form (3 Options to choose from. ie IP Address, IP Number and Domain Name).
Image hosted by TinyPic.com
Alternative Images Link, Click me to View

Extended WebLayout
This is the extended layout of the website with the information options being maximise. You can view the additional information as provided.
Image hosted by TinyPic.com
Alternative Images Link, Click me to View

Search WebLayout
This is the first Output example of the layout by using the 3rd Option of searching the country through the URL address.
Image hosted by TinyPic.com
Alternative Images Link, Click me to View

Search WebLayout
This is the Output example of the layout by using the 1st Option of searching the country through IP Address.
Image hosted by TinyPic.com
Alternative Images Link, Click me to View

Error Detected WebLayout
Lastly, I have added certain functions to verify the IP Address, IP Number and the Domain name. This also include MySQL database Connection check.
Image hosted by TinyPic.com
Alternative Images Link, Click me to View

Currently, I do not have anywhere to host the files for users to do a live test..therefore the above pictures taken were done locally on my PC.

To transfer .Csv files into MYSQL Database,
I would recommend you to try using a program called "Navicat 7.08", it took me only a couple of minutes to get the database being transferred over.

Now my current development would be on trying to use Php to search the database directly from the .csv file.

Enjoy
» login or register to post comments | previous forum topic | next forum topic | 1556 reads
Comment viewing options:
Select your preferred way to display the comments and click 'Save settings' to submit your changes.
If I can be of assistance
Posted by dupex on Fri, 10/28/2005 - 14:20.
Hi!

Just have to say that you app looks nice, and that it will be a 
shame not to make it available.

So I'm trying to put together all kinds of nice scripts, apps, etc.
 in one site. And I was wondering if I could host your app as well?

It will contain IP search from file, database and optimized 
database. Not only ip 2 country, but also include the database from
www.hostip.info

So that it will feature city search as well, with many nice scripts 
collected from the community. Like the zoom in applet made in java, 
inspired by 'enemy of the state'.

The site will also allow a more intuitive update database feature.

Many plans, but I have to start somewhere.

Send me an email at lars DONOTINCLUDETHIS [at - @]
 eid [dot] online [dot] no, if you would like your app hosted.

And by the way, I really like the flag you posted in a screenshot 
here:
http://ip-to-country.webhosting.info/node/view/387

Are they available for download anywhere?
» login or register to post comments
 
I have replied you with an em
Posted by TheJohnDoe2005 on Mon, 11/14/2005 - 02:37.
I have replied you with an email....didn't see this post until today..sorry
» login or register to post comments
 
Seen it?
Posted by tecM0 on Mon, 11/14/2005 - 14:31.
hi dupex,

have you checked out my binarySearch method?
seems to be much faster than the idx/dat method!?

--
Sven Truemper
Development and Research
sven@siteforum.com
http://www.siteforum.com
_____________________________________________________
SITEFORUM GROUP - Realtime Business Portals
Konrad-Zuse-Str. 15 * 99099 ERFURT * Germany
PHONE: +49 (361)
» login or register to post comments
 
BinarySearch
Posted by dupex on Mon, 11/14/2005 - 15:57.
I have seen your post about binary search, but I'm wondering how it is different from this method or if it is faster?
http://weirdsilence.net/software/ip2c

Their pure C implementation is able to do at 3.2 million lookups every second!!
» login or register to post comments
 
...
Posted by tecM0 on Wed, 11/16/2005 - 15:29.
my binary search differs from the idx/dat method posted there.
and its much faster than the PHP and/or SQL versions i have seen here.

ok, pure C is incedible fast...but i cant use code like this on our
webserver....so i tryed to make the script-version faster.

--
Sven Truemper
Development and Research
sven@siteforum.com
http://www.siteforum.com
_____________________________________________________
SITEFORUM GROUP - Realtime Business Portals
Konrad-Zuse-Str. 15 * 99099 ERFURT * Germany
PHONE: +49 (361)
» login or register to post comments
Problem with php sqlite
Posted by hall on Mon, 09/18/2006 - 01:38.
hello,

first, i cant post a new topic. so i started a comment ;-)

i have installed the csv-file in a sqlite database but i retrieve not the correct country-name for my tested ips. my tested ips matched with germany country code. i have used your sql-statement with

sprintf("%u,ip2long($ip));

but the query tells me united states.
can anyone help me. thank you

best regards

sorry for my baaaad english.
» login or register to post comments