Closed

Read and Parse Uploaded Text File in PHP

This project was awarded to intel183ins for $13 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $100 USD
Total Bids
3
Project Description

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!

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online