PHP Script to upload csv, check mysql database, and return list.
- or -
Post a project like this4065
$$
- Posted:
- Proposals: 12
- Remote
- #219210
- Awarded
Expert Laravel | JS | Angular | Web services | API Development | MySQL | Scraping | Chrome Extensions
Chandigarh
337583506666438488814104459191680324155372773389899408396376553
Description
Experience Level: Intermediate
I have a MySQL database that has a table with a list of mobile phone numbers in it.
I would like a script creating that allows a person to select a local excel or csv file, select which column in their file contains the mobile phone number, and for the script to cross reference their file with the MySQL database, and return a list of which phone numbers are on their file and in the database.
I would also like their file to be uploaded to a folder on the webserver and date/time stamped in the file name.
So to summarise - person uploads file - selects column that contains mobile phone number - receives either onscreen list or txt file of those numbers that appear on both their file and in the MySQL database.
I only need the script and the form creating as I already have a webpage template and the MySQL database setup.
I would like a script creating that allows a person to select a local excel or csv file, select which column in their file contains the mobile phone number, and for the script to cross reference their file with the MySQL database, and return a list of which phone numbers are on their file and in the database.
I would also like their file to be uploaded to a folder on the webserver and date/time stamped in the file name.
So to summarise - person uploads file - selects column that contains mobile phone number - receives either onscreen list or txt file of those numbers that appear on both their file and in the MySQL database.
I only need the script and the form creating as I already have a webpage template and the MySQL database setup.
Barry B.
100% (9)Projects Completed
9
Freelancers worked with
8
Projects awarded
42%
Last project
1 Oct 2013
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies