1) Create a MySQL table with the following fields <Contact for info on table structure>2.

Suoritettu Julkaistu Dec 24, 2015 Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

1) Create a MySQL table with the following fields

<Contact for info on table structure>

2. Create web interface for user to upload an Excel or CSV file with header row containing the above fields.

2.a. The interface must show a preview to the user in a table view of all the data imported from the file

2.b. The interface must provide the capability to edit the data - specifically delete rows. A single "delete" icon on the first column for each row

2.c The interface must provide a button to cancel the operation or complete the operation

3. Upon user clicking the complete button in step 2, the data must be securely sent to a server. Server side code (to be written in php) must receive this data and insert the data into the table describe in step #1.

3.a Fields must be validated – names should only contain alpha characters, IDs should only contain numeric characters. Check input for buffer overflow, deliberate SQL injection.

3.b Note that, the excel, CSV that is uploaded may not have all the fields in the table. The fields marked mandatory (*) must be checked for existence in the uploaded file. However, the other fields must be set to default values if they do not exist

3.c Gracefully, handle errors and give user maximum information (not internal error codes but logical english statement describing the error)

4. Create a single page C/R/U/D interface for the data in the table. This should show the data in a table view.

4.a Create a "plus" button at the top right of the table that will allow to insert a row. A overlay screen must be shown for the user input.

4.b Create a "delete"/"edit" button for each row (on the first column, just like step #2) to delete the entire row or edit the fields.

4.c Send the data to server where server side code will do data validation and appropriately update the table.

4.d Gracefully, handle errors and give user maximum information (not internal error codes but logical english statement describing the error)

5. The pages must be designed to work on IE, Firefox, Chrome, Safari, on PCs for various screen sizes (HD Apple thunderbird display to 11.1" screens). The design must also work on tablets (ipad, android tablets which have screen sizes between 7-10") on Firefox, Safari and Chrome.

Other Requirements :

1) Highly desired to use phalcon framework for server side php code

2) Highly desired to use bootstrap 3.0 for HTML,CSS design of the web pages

3) Highly desired to use jquery tablesorter for the table view

HTML5 JavaScript jQuery / Prototype MySQL PHP

Projektin tunnus: #9187977

Tietoa projektista

47 ehdotusta Etäprojekti Aktiivinen Jan 2, 2016

Myönnetty käyttäjälle:

anujayk

I am an experience web developer having good hands on latest relevant technologies used for the front end and backend development,i am experienced in doing the similar projects,i could be results a better resource for Lisää

$60 USD 1 päivässä
(10 Arvostelua)
2.9

47 freelanceria on tarjonnut keskimäärin $1917 tähän työhön

meet2amitvw

Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat. I am myself developer so you will directly work with me. No mediators. No managers. No Lisää

$3613 USD 35 päivässä
(183 arvostelua)
9.4
fleetways

Thank you for looking at our bid. Appreciate if you can kindly respond to enable us further discussion on the requirements; we are planning to propose a PHP MVC application (e.g. Codeignitor latest, bootstrap, Jquer Lisää

$3684 USD 45 päivässä
(91 arvostelua)
8.1
toinnisfree

I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor Lisää

$1850 USD 10 päivässä
(786 arvostelua)
8.3
sunsoftpro

Hi Employer, I have read your description and been interested in your project. Please give me more details of your project. May you share me the sample CSV/Excel file. I'm ready to discuss and start to work on it now Lisää

$421 USD 10 päivässä
(189 arvostelua)
7.6
asifchaudhry2015

Hello I have done same like project in my company for one other client i can show you demo so talk to me if you want good product thanks.

$421 USD 5 päivässä
(132 arvostelua)
7.3
claudiu07

Hi, I have extensive experience working on custom CMS/web applications in PHP/MySQL. I'll be happy to help you out. Cheers.

$888 USD 20 päivässä
(59 arvostelua)
7.4
Shopify

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i Lisää

$4123 USD 50 päivässä
(29 arvostelua)
6.9
phamtech211

Dear Sir/ Madam, My name is Henry - the owner of PHAMTECH Co. My team is really interested in this project as it is exactly within our scope of expertise: We are web/ app design & development company located in Lisää

$2949 USD 60 päivässä
(22 arvostelua)
6.8
mvaqasuddin

hi there, please share the further details I am ready to build over Laravel framework with including all the details and data edit delete add row etc. Thanks

$3888 USD 30 päivässä
(227 arvostelua)
6.7
Hudognik

Предложение еще не подано

$2222 USD 7 päivässä
(14 arvostelua)
6.0
wartertall

Hello, I have read your requirement. I can help you do this work, create database and use phalcon framework for backend, bootstrap 3, jquery, tablesorter and maybe using backbone at browser. Please contact and send me Lisää

$400 USD 8 päivässä
(61 arvostelua)
6.1
eGlobalSoft

Dear Sir, I have 4 years of experience in wordpress/php/html/css. I have gone through your requirement and interested to work on your project. Please check my reviews and feedback for your reference. Thanks & Reg Lisää

$1600 USD 30 päivässä
(72 arvostelua)
6.3
herpay

Hello, I'm an experienced php/mysql, html developer and so I can make the requested web interface within max 4-5 days after you accept my bid. Regards, Tamas

$444 USD 5 päivässä
(220 arvostelua)
6.1
chandankandar007

Hi, Sir how are You ? I have read your all requirements .. and completely understood .. i have some small confusion ' about your project if you will come on on-line please send me a message .. i will ready with Lisää

$2110 USD 5 päivässä
(23 arvostelua)
6.3
MilesChino

Hello, How are you? We can absolutely do this project for you with excellence. My name is Miles from FlairCoders and I have been in the web development business since 2006 and have project managed well over 100 Lisää

$3555 USD 30 päivässä
(1 arvostelu)
6.5
manhpham

Hi, I am very interested in your project. Please contact me ................................................ Manh

$1111 USD 15 päivässä
(55 arvostelua)
5.7
ItMasterDev

Congratulations, it's rare to find precise specifications as those of this project. I can realize what is required using bootstrap 3.0 or HTML5 boiler plate. Php will be used without any framework.

$1698 USD 9 päivässä
(20 arvostelua)
5.4
smitakad89

come on chat now so we can discuss more..am waiting to start

$100 USD 1 päivässä
(23 arvostelua)
5.0
Predeko

I am sure I can help you with this. Please let me know if you'r interested so we can discuss the details and the help you need.

$1000 USD 3 päivässä
(11 arvostelua)
3.9
KERConsultancy

Hi, Thanks for very clear specification about your requirement. i have gone through each of requirement you need for data import. MY INTRODUCTION: I am having 7+ years of experience working as a Software engin Lisää

$1111 USD 12 päivässä
(7 arvostelua)
2.7