Read and Parse Uploaded Text File in PHP

In Progress

Given a form that allows the user to upload a text file with each row having the following format:

Title|Description|Tags|Thumb Location|Category|Video Embed, Blog Code or Link|V. B or L value|Date|

title: varchar(255)

description: text

tags: varchar(255)

thumb location: url of thumb, needs to be grabbed, uniquely named and stored in a folder /thumbs, and store the filename in char(14)

category: varchar(50)

Video Embed, Blog Code or Link: text

V. B or L value: represents if previous field is video embed, blog code or link. Need switch to create three different sql statements based on this value

Date is in unix date format, ex. 1202071358

need to parse and build sql statement similar to:

INSERT INTO TABLE_NAME

( title, description, tags, thumb, category, embed, blog_code, link, date )

VALUES

('title', 'description', 'tags', 'thumb', 'category', 'embed', 'blog_code', 'link', 'date');

exact database fields will be provided once the job has been awarded. There will be slight variations depending on the V, B or L value.

The form will be submitted. Text file will be processed and resulting sql statements will be echoed to the screen.

Not worried about styling output, just functionality. Should be a simple job, thanks!

Skills: Amazon Web Services, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: text file, sql l, read and, parse, parse and, user uploaded, sql statement stored, php read text file, url based form values, text row, row text php, create folder upload php, text sql, url parse, simple file upload form, insert text file database, simple sql statements, read text file insert database, simple php video upload, read code database, uploaded link, location category, simple video upload php, parse sql, create form link sql database php

Project ID: #3753855

Awarded to:

intel183ins

See private message.

$13 USD in 14 days
(23 Reviews)
3.2

3 freelancers are bidding on average $24 for this job

cheapexcell

See private message.

$15 USD in 14 days
(148 Reviews)
6.5
vctheguru

See private message.

$42.5 USD in 14 days
(36 Reviews)
5.8