PHP Classes

File: helper.folder/installDatabase.php

Recommend this page to a friend!
  Classes of azizny   User Info & GeoIP   helper.folder/installDatabase.php   Download  
File: helper.folder/installDatabase.php
Role: Application script
Content type: text/plain
Description: Install GeoIP Database
Class: User Info & GeoIP
Get information about the current user browser
Author: By
Last change:
Date: 15 years ago
Size: 2,097 bytes
 

Contents

Class file image Download
<?php
/**************************************************/
/*
Released by AwesomePHP.com, under the GPL License, a
copy of it should be attached to the zip file, or
you can view it on http://AwesomePHP.com/gpl.txt
*/
/**************************************************/

/*
User Edits
*/

$hostName = 'localhost';
$userName = 'root';
$passWord = 'master';
$dataBase = 'test';
$fileLocation = 'GeoIPCountryWhois.csv';


/* End User Edits */

$connection = mysql_connect ($hostName, $userName, $passWord ) or die(mysql_error());
mysql_select_db($dataBase,$connection) or $error = mysql_error();
if(
$error != NULL){ mysql_close($connection); die($error);}


/*
First query to create table
*/
$createTable = "CREATE TABLE `geo_ip` (
  `record_id` bigint(20) NOT NULL auto_increment,
  `begin_ip` varchar(25) NOT NULL default '',
  `end_ip` varchar(255) NOT NULL default '',
  `begin_num` bigint(20) NOT NULL default '0',
  `end_num` bigint(20) NOT NULL default '0',
  `iso_code` varchar(4) NOT NULL default '',
  `country_name` varchar(255) NOT NULL default '',
  PRIMARY KEY (`record_id`)
) COMMENT='Geo IP Table' ;"
;

if(!
is_file('GeoIPCountryWhois.csv')){
    die(
'Unable to locate GeoIPCountryWhois.csv');
}

$file = fopen('GeoIPCountryWhois.csv','r');
if(
$file){
   
mysql_query($createTable,$connection) or die(mysql_error());
    while(
$cont = fread($file,1026467)){
       
$cvs_data .= $cont;
    }
   
fclose($file);
   
$lines = explode("\n",$cvs_data);
   
$queryies = array();
    foreach(
$lines as $line){
       
$cvs_info = explode(',',$line);
        foreach(
$cvs_info as $sub => $is){
           
$cvs_info[$sub] = str_replace('"','',$is);
        }
       
array_push($queryies,"INSERT INTO `geo_ip`
            (`begin_ip`,`end_ip`,`begin_num`,`end_num`,`iso_code`,`country_name`) VALUES
            ('
$cvs_info[0]','$cvs_info[1]','$cvs_info[2]','$cvs_info[3]','$cvs_info[4]','".addslashes($cvs_info[5])."')");
       
    }
   
mysql_query("TRUNCATE TABLE `geo_ip`");
    foreach(
$queryies as $query){
       
$insert_record = mysql_query($query,$connection);
    }
    echo
'Done';
}
mysql_close($connection);
?>