Завершено

176072 Phone Number Lookup

I need a script that will attempt to lookup a phone number using public databases (anywho-com, whitepages-com, infospace-com) when given the following: first and last name, city, state, zip. In the event multiple records are returned, then the street address should be used for further identification. The table structure is below:

The variables of interest are: Last, First, City, Zip. Upon matching these the phoneNumber database field should be updated with the information extracted from the web.

CREATE TABLE `allVoters` (

`houseHoldNameFromPhoneList` varchar(255) default NULL,

`id` int(10) unsigned NOT NULL auto_increment,

`County` varchar(255) default NULL,

`Registration Number` varchar(255) default NULL,

`votedLastElection` enum('Y','N') default 'N',

`phoneNumber` varchar(255) default NULL,

`Last` varchar(255) default NULL,

`Middle` varchar(255) default NULL,

`First` varchar(255) default NULL,

`Suffix` varchar(255) default NULL,

`Street Number` varchar(255) default NULL,

`Street` varchar(255) default NULL,

`City` varchar(255) default NULL,

`Zip` varchar(255) default NULL,

`Mail Street #` varchar(255) default NULL,

`Mail Street Name` varchar(255) default NULL,

`Mail City` varchar(255) default NULL,

`Mail State` varchar(255) default NULL,

`Mail Zip` varchar(255) default NULL,

`Sex` varchar(255) default NULL,

`Race` varchar(255) default NULL,

`Registration Date` varchar(255) default NULL,

`DOB` varchar(255) default NULL,

`Last Date Vote` varchar(255) default NULL,

`Gen Elec` varchar(255) default NULL,

`Gen Elec Previos` varchar(255) default NULL,

`Dem Elec Last Vote` varchar(255) default NULL,

`Dem Elec Previous` varchar(255) default NULL,

`Rep Elec Las` varchar(255) default NULL,

`Rep Elec Previous` varchar(255) default NULL,

`water shed` varchar(255) default NULL,

`Precinct` varchar(255) default NULL,

`Precinct Name` varchar(255) default NULL,

`Township` varchar(255) default NULL,

`County Council` varchar(255) default NULL,

`School Dist` varchar(255) default NULL,

`City Council` varchar(255) default NULL,

`Congressional` varchar(255) default NULL,

`Status Cade` varchar(255) default NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Квалификация: Разное, MySQL, Perl, PHP

Показать больше whitepages com, the street com, php script school, php script null, php school script, infospace, phone number in, whitepages, phone number, phone name, name phone, LOOkup, gen, following number, elec, city zip, state lookup city, county zip, phone number name city, php lookup

О работодателе:
( 7 отзыв(-а, -ов) )

ID проекта: #1922273

Поручен:

eugeneglova

I can help you. Thanks, Eugene.

$80 USD за 2 дней(-я)
(0 отзывов(-а))
0.0