I need a simple script (perl or php) that reads data from a web sites and puts it into a database (MySQL).
1. Script reads baby names (and corresponding data) from site [login to view URL]
(example - male names starting from letter D - [login to view URL];detail=D&gender=male)
Database table should have the following structure
Table - tNames
______________
Name_ID (counter)
Sex (integer. 0 - Male, 1 - Female)
Name (text)
Nation (text)
Meaning (text)
______________
example - 12345, 0, "Dabert", "French", "Bright action."
2. Script takes 1000 most popular male&female names in 2005, their ranks and percent of total births from this site - [login to view URL]
Script adds top 1000 names to the existing database. Extra fields needs to be added to table structure.
If the name is already in database, then scrips just updates the record with extra values.
Database table should now have the following structure
Table - tNames
______________
Name_ID (counter)
Sex (integer. 0 - Male, 1 - Female)
Name (text)
Nation (text)
Meaning (text)
Rank (integer) (NULL if name not in top 1000)
Births (double) (percent of total births)
______________
example - 12346, 1, "Julia", "Latin", "From a Roman, possibly meaning youthful.", 31, 0.3498
3. For every name in Top1000, script should query the site [login to view URL]
to get popularity data for this particular name for the last 50 years, and puts this data to a separate table.
Table - tPopularity
______________
Name_ID (link to tNames)
Year2005 (integer)
Year2004 (integer)
Year2003 (integer)
....
Year1957 (integer)
Year1956 (integer)
===================================
I need both - ready mysql database and script itself.
Also, I need a very simple web interface to edit 'tNames' table values.
'Meaning' and 'Nation' fields needs to be edited from web for top1000 names.
Please only post your bid if (1) you are serious (2) you already have at least one review on this site.
Dear Client ----
Thanks you for opportunity to bid on your project ----
We have already experience of working on related projects especiall parsing data from different websites, we have expereince of parsing projects for hotmail, yahoo, myspace etc ----
Please check PM for more details ----
Thanks and Best Regards,
SVT - Sigma Visual Technologies
Hi, this is quite a lot of job. Consisting of 3 script, 1 web form, and running the scripts to give you the desired database. I can do this for $250 only, within a week! Let me do this and you'll get the job done!
I am the best you can get, I have 6 + years of Experience of PERL Programming. I am doing this at a very low price just because I have recently started bidding on GAF. The quality of our work will be perfect. Just give it a try and you will never regret spending $150.