We need to download a file and insert data in a database, after some processing. We need a php/mysql script to do the job. The script would do following tasks :
1) Get the file from the website, via curl or whatever.
2) Analyze the data to retrieve appropriate information, as described below.
3) Inject the data in the database, after saving the existing information
Analyze the data : as you will see the spreadsheet has 15 columns, A to I. Columns B to I do not need processing, the information can be stored as is.
The processing is on column A, identity.
In this field, we have the name of the person, possible alias(es), nationality, DOB, etc..
The most important information to process is the name and the aliases.
The database should have an alias table, and a main table (same table as existing + one field ‘NAME’), or an aliases table, a names table, and the main table (existing).
To get the alias(es), if any, the program would probably use regular expressions, because the presentation is not always exactly the same.
We need a very basic demo form to show a simple search (LIKE operator) on names and aliases to find possible names : the user inputs a name, and the form will return matches.
The document is there: [url removed, login to view]
freelancer 29 คน กำลังเสนอราคาเฉลี่ยที่ $138 สำหรับงานนี้
Hello Good Day Thanks for inviting me for this project. I can do all what you are requiring your project requirement. Please feel free to contact me for any discussion. Thanks Rinsad
Hi, I am joomla, virtuemart expert having 5 years of experience... recently i completed these projects [url removed, login to view] [url removed, login to view] [url removed, login to view] please award me the project.
Hi there - My name is Jhalak. I’ve read your [url removed, login to view] team has 4 years experience designing and developing mobile apps and Websites.I would approach your project by starting with wireframes and getting the site complet เพิ่มเติม
Hi I'm interested in your project. I have understood your project requirements. I can complete the functionality. please accept the bid. I am ready to start the project.
Hi, i'm interested, could you give me more details please? could you send me a sample spreadsheet? i can do a php scraper right now regards [url removed, login to view]
Dear Sir I can help you out in doing the analysis and updating the data to be inserted in [url removed, login to view] initiate further conversation for better understanding of the issue regards Amit