WeberDev.com PHP and MySQL Code

LOG IN
BEGINNER GUIDESPHP CLASSESCODE SEARCHARTICLES SEARCHPHP FORUMSPHP MANUALPHP FUNCTIONS LISTWEB SITE TEMPLATES
Start typing to search for PHP and MySQL Code Snippets and Articles Search
Submit a code Example / Snippet Join us on FaceBook
Submit a code Example / Snippet Submit Your Code
Poker Tournaments Poker Tournaments
Poker Guide for Developers Poker Guide for Developers
Search Engine Optimization Monitor SEO Monitor
Web Site UpTime Monitor UpTime Monitor
Your Personal Examples List My Favorite Examples
Your Personal Articles List My Favorite Articles
Edit Account Info Update Your Profile
PHP Code Search
Web Development Forums
Learn MySQL Playing Trivia
PHPBB2 Templates
Web Development Resources
Web Development Content
Internet Security Software
PHPClasses
PHP Editor
PHP Jobs
Vision.To Design
Ajax Tutorials
PHP Programming Help
PHP/MySQL Programming
Webmaster Resources
Webmaster Forum
XML meta language
website builder
פרייסז - הכח לקנות עובר לידיים שלך
Texas Holdem Poker Evangelists

Go Back Add a Comment Send this example to a friend Add this Article to your personal favoritest for easy future access to your favorite Code Examples and Articles. Submit a code example Print this code example.
BACK ADD A COMMENT SEND TO A FRIEND ADD TO MY FAVORITES ADD CODE EXAMPLES PRINT
Title : Convert an IP address to the country name and display them to your visitor.
Categories : PHP, PHP Classes Update Picture
Fabien HADDADI
Date : May 05th 2001
Grade : 3 of 5 (graded 12 times)
Viewed : 27282
File : ianacode.sql
Images : No Images for this code example.
Search : More code by Fabien HADDADI
Action : Grade This Code Example
Tools : My Examples List

Submit your own code examples  Submit your own code examples 
 

To view the script in action check this link :

http://www.weberdev.com/GeneralDev/IP2Country/index.html


==================
Class clientinf.cls:
==================

<?php
class ClientInfo {
/*this class requires an open MySQL connection to a database*/

/*************************************************************************************/
/*this function returns a country name corresponding to code*/
cfunction getctrybycode($code) {

$code=strtolower($code);
$qry="SELECT country FROM ianacode WHERE code='$code'";
$row=mysql_fetch_row(mysql_query($qry));

if($row[0]=='') return($code);

return($row[0]);
}

/*************************************************************************************/
/*this function returns a country name corresponding to a hostname*/
cfunction getctrybyhost($hostname) {

return($this->getctrybycode($this->getctrycodebyhost($hostname)));
}

/*************************************************************************************/
/*this function returns a country code name corresponding to a hostname*/
cfunction getctrycodebyhost($hostname) {
return(substr(strrchr($hostname,'.'),1));
}

/*************************************************************************************/
/*this function mask an IP address different from current client using '#'
it returns an unaltered IP if same than client*/
cfunction MaskOtherIP($IP) {

if($IP==getenv("REMOTE_ADDR"))
        return($IP);

$IP=strtr($IP,"0123456789","##########");
return($IP);
}

};
?>

===============
Table ianacode:
===============
See Attached File ianacode.sql

===================
Usage by an example
===================

<?php

require("$ROOTURL/lib/cls/clientinf.cls");
$myCliInf = new ClientInfo;

{ connect your dabase here }

/*Say $IP is the IP of current visitor*/
$IP=getenv("REMOTE_ADDR");

/*try to get hostname */
$hostname=gethostbyaddr($IP);
if(!strcmp($hostname,$addr))
        $hostname='(unknown)';

/*get country if known in table ianacode*/
$country=$myCliInf->getctrybyhost($hostname);

print "IP $IP is registered in country=$country.\n";

/*Note:
If0 you chose to display the access log to your visitors,
you may just want to show the numeric IP to the current visitor,
and hide other IP, but not the country names,
then you will do:*/

print "IP ".$myCliInf->MaskOtherIP($IP)." is registered in country=$country.\n";

?>



PHP Class to calculate Degrees Minutes Seconds to Decimal Degrees
Categories : PHP, PHP Classes, Geo Related, Beginner Guides
Class to Create protected URLs
Categories : PHP, PHP Classes, URLs
Form is a utility class for generating html forms. It provides form initialization and regex based data validation (both server and client side) with a convenient interface. This version obsoletes version 1.0a
Categories : HTML, PHP, PHP Classes, Regexps
shopping cart class with add/edit/delete product functionality.
Categories : PHP, PHP Classes, Ecommerce
HTML_Graphs provides a simple PHP interface for creating pure HTML charts.
Categories : Graphics, PHP, PHP Classes, Charts and Graphs
very simple ftp class
Categories : PHP, PHP Classes, FTP
DBXML- A Class to backup databases in XML Format using web interface
Categories : PHP, PHP Classes, Databases, MySQL, XML
FormChecker Package - validate any data via classes and patterns.
Categories : PHP, Form Processing, PHP Classes, Regexps
Menu in sliding bar or tree style. Handles frames by using small amount of javascript. Handles external and internal pages. Allows custom code to replace a menu item.
Categories : PHP Classes, PHP, Java Script, DHTML
PHP5 URL Object
Categories : PHP, PHP Classes, URLs, Strings
MySQL Class to ease Database connectivity
Categories : MySQL, PHP Classes, Databases, PHP
Excel class in PHP
Categories : PHP, PHP Classes, Excel
Example Shopping cart class
Categories : Ecommerce, PHP, PHP Classes
Php Input Output Library - access the parallel and serial(rs232) port directly.
Categories : PHP, Hardware, PHP Classes
class formHTML build your HTML Forms from PHP
Categories : PHP, PHP Classes, HTML and PHP, HTML
 wilton bennet wrote :764
Ok. But include also;
/*in code.php, only */
mysql_connect("localhost","user","pass");
mysql_select_db("your_db");