I have a sample CSV file as follows. I will paste this file into a text box and submit it to a PHP script. I need the PHP script to parse it apart and then insert the various pieces into a mysql table. I will need to do a few other things such as read the unit number and match it in a table to get an address and insert the address and break the dates apart into month, day, and year. folio,lastname,firstname,checkin,checkout,unitnumber,phonenumber 83694,Vogelbachur, Ernest,12/18/2007,12/27/2007,208,562 - 0251 81618,Shimasaki, Joe,12/17/2007,12/21/2007,3137,562 - 1159 81627,Ling, Kay Ing,12/15/2007,12/21/2007,5097,562 - 0708 78430,Brigance, Jim & Linda,12/15/2007,01/05/2008,735,562 - 0352 78485,Reisinger, Joseph/Vicki,12/15/2007,12/22/2007,392,562 - 1303 78669,Hutchinson, Wilbur,12/16/2007,12/31/2007,315,562 - 0778 79710,Wilson, Alex/Beverlee,12/18/2007,01/02/2008,319,562 - 0863 79711,Wilson, Alex/Beverlee,12/18/2007,01/02/2008,203,562 - 1628 80060,Cornes, Stephen,12/17/2007,12/21/2007,4015,562 - 0450 80412,Cooper, Melissa,12/17/2007,12/21/2007,311,562 - 0490 80606,Nyland, Barbara or Michael,12/19/2007,01/07/2008,4027,562 - 8717 80866,Shaw, Mark,12/18/2007,12/22/2007,4110,562 - 1336 80868,Alarid, Penny,12/18/2007,12/22/2007,312,562 - 1283 80879,Lee, Kevin,12/19/2007,12/23/2007,1803,562 - 2667 81362,O'Brien, Katherine,12/19/2007,12/23/2007,3173,562 - 0249 83725,Williams, Tom or Marla,12/19/2007,12/22/2007,5035,562 - 1837 83752,Larkin, Blake,12/16/2007,12/21/2007,226,562 - 1439 80723,Vecchi, Pamela,12/19/2007,12/23/2007,309,562 - 1907 82523,Patterson, Ann,12/19/2007,12/22/2007,4116,562 - 1472 82152,Dow, Norman,12/16/2007,12/21/2007,5025,562 - 1167 82159,Chua, Ngo Kai,12/15/2007,12/21/2007,5103,562 - 0263
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
PHP / MySql