PHP, mysql, xls. Website data tracking, data merging, data output.

Budget $100 - $500 USD
Bids 1
Average Bid $679

PHP programming needed to track web visitors.

When a (one) web page is accessed, check for cookie, If no cookie, set cookie with unique identifier and input time, date, website domain name, and unique identifier into mysql database. If user enters zip code into form field and clicks form button, record zip code in database in that user's database record. Data must be in specific format.

Identical code will go in a page on second website with the "website domain name" being changed.

Create web page for user to upload xls file to same database. Create script to extract only four fields from xls file, convert them to appropriate format, and load into database. Upon uploading data from xls file, extract data from database from the previous day, (which will include the data just uploaded in xls file), and send as email attachments to several accounts. Data must be in a fixed-width text file in a specific format.

Create web page to display data online. Be able to sort by date range and show totals in each field. Be able to download data as xls file.

All times must be America/New York time (adjusted for Daylight Savings Time/Standard Time). I have some script that does that if you need it.

## Deliverables

The attached files show the requirements more thoroughly.

There are 17 fields which must be outputted daily as a fixed width text file and sent as an email attachment. 10 of those fields are hard-coded (1-9 and 14). They will not be necessary to have as database fields, but can be added programmatically when outputting the text file.

*Telemarketing Data File Layout [url removed, login to view]* has the specifications of the outputted text file.

*Template [url removed, login to view]* shows the file layout of the data which will be converted and put into the database.

Please contact me with your questions before you waste time creating code which you will need to change. This project seems complicated, but it is really pretty simple.

Post a Project Like This

Looking to make some money?

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

Bids on this Project

  • sunjove Profile Picture


    United Kingdom

    ## BIO <u>**Our Developed Web Applications are: **</u> • Static and Dynamic Site • Restaurant Management system • E-Accounting System • Online Banking System • Property Searching Application • Student Management System • Shopping Cart ( CS cart, Zen cart, X cart, also Customized cart ) • OS-Commerce/E-Commerce • SMS Sending System • Forum ( PHPBB/Customized )  • Blog Site  • Community/Social Network Site  • Online Money Transfer system  • Customized Modules  • and more...  **<u>Our Developed desktop Softwares are:</u> ** •Inventory + Accounting Software (Using .NET). •Hospital Management System (HMS). (Using VB and .NET) •Restaurant Management System. ( .NET ) •SMS and FAX sending system ( .NET ) •Banking Software. (Using VB also .NET) •Network Controller (Wireless). (Using VB) •35MHz wireless controller for PC (Any kind of key can be controled). •Security with Laser Software. •Audio Controller Software. •Desktop synchronization Software. •Video and Audio Player. (Using VB) •DVD Management Software (Easy to find and see the available DVD’s). •VB FTP software for upload files (Using VB) •Address Book (Using VB) •Talking Software (Using VB). •Voice Command Software (in C#). •Travel Agency’s Software (Using VB). •Karnugh Map Minimizer Software (Its an Excelent software for EEE & CSE students). •Room Management System (This System can use for control the fan, light, and other necessary switch, it also controlled remotely). •Traffic Control System using C++. •Water Label Detection System.  *<u>**DISCOVER what we can do for you.** </u>* ## Area of Expertise ***<u>Programming Languages </u>*** *For Web Development* • **PHP ** • **Java Script, Ajax, Mootools **• **HTML, XML, DHTML **• **MYSQL ( DataBase ) ** *For Desktop Software Development* • **Visual Basic, .NET **• **C/C++, ** • **MSSQL ( DataBase ) ** **<u>Designing Tools </u>** • **Adobe PhotoShop **• **Adobe Illustrator **• **Adobe Go live** **<u>Animation Tools </u>** • **Flash **• **Swish Max 2007 ** **<u>Audio & Video Effects Tools </u>** • **Sony Sound Froge 9 **• **Fruit Loops** • **Adobe Premiere** ** ** <u>**Others **</u>• **Server Configuration **• **Articles Writing** • **Advertising & Consultancy **

    PHP, Perl, ASP, and C Programming