I need a PHP script to import a CSV and update a MySQL table
- or -
Post a project like this2793
$
- Posted:
- Proposals: 3
- Remote
- #1236537
- Awarded
Description
Experience Level: Entry
General information for the website: Daily import of scores & game schedules for various professional sports leagues
Description of requirements/features: I have a CSV using carat ^ as enclosure and pipe | as delimiter that I need imported into a MySQL database. The CSV will be fetched and overwritten each day and I need to check the import for updates to existing data, and inserting new rows for new scheduled games.
The goal is to start building a history of games and their scores, while also creating new rows as time goes on. Eventually the data that has already been imported will start disappearing from the CSV, so the script will mostly just check for updated data or new rows.
The first column is a unique game identifier, so this should be pretty easy.
Sample CSV: http://pastebin.com/Tmn6MRQH
MySQL Table: http://pastebin.com/WVDP5jye
Extra notes:
Description of requirements/features: I have a CSV using carat ^ as enclosure and pipe | as delimiter that I need imported into a MySQL database. The CSV will be fetched and overwritten each day and I need to check the import for updates to existing data, and inserting new rows for new scheduled games.
The goal is to start building a history of games and their scores, while also creating new rows as time goes on. Eventually the data that has already been imported will start disappearing from the CSV, so the script will mostly just check for updated data or new rows.
The first column is a unique game identifier, so this should be pretty easy.
Sample CSV: http://pastebin.com/Tmn6MRQH
MySQL Table: http://pastebin.com/WVDP5jye
Extra notes:
Jermaine R.
100% (92)Projects Completed
110
Freelancers worked with
56
Projects awarded
27%
Last project
7 Jan 2020
United States
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