Ditutup

CSV data to website (mysql php)

Hello,

This would be all down using mysql/python/php/html5, on a linux machine.

I have a CSV file with around 400,000 entries of the following format: (We'll call this MAIN table)

name1, color, date created, notes

name2, color, date created, notes

name3, color, date created, notes

I would want a python script that can take the format above and import the data automatically into the given sql database. From there you'll use php/html5 to display back the data via web browser.

Some functionally includes, search & filter options (like filter by multiple names and color) & edit field (only for the note field).

There will also be another table with the format: (We'll call this external table)

name2 extra, text:text, text:text, text:text

name3, text:text

name2, text:text, text:text

name1, text:text, text:text

This external table will have different amounts of text:text per line, but it will all be seperate by a comma.

----------

With the MAIN table, if I click: “name2, color, date created, notes”

It will exapand and show contents of External table that has the same “name2” in it.

In this example, it will show like this:

name1, color, date created, notes

name2, color, date created, notes

name2 extra, text:text, text:text, text:text

name2, text:text, text:text

name3, color, date created, notes

and If I click name3 it should show like this:

name1, color, date created, notes

name2, color, date created, notes

name2 extra, text:text, text:text, text:text

name2, text:text, text:text

name3, color, date created, notes

name3, text:text

and If I click name2 again (while it's expanded):

name1, color, date created, notes

name2, color, date created, notes

name3, color, date created, notes

name3, text:text

-----------

Some notes:

-Displaying this much data in a web browser might crash it, if I can limit it to show only 50,000 per page.

-Have it look modern and have color (this is why I mention html5)

-I'll be adding data to the tables frequently, having a python script that can automatically add the new cvs data is needed.

Kemahiran: MySQL, PHP, Python

Lihat lagi: php upload csv file to server -mysql, upload csv file in php example, how to read csv file in php and store in mysql, export data from mysql table to csv file using php, import csv file into mysql using php demo, import large csv file into mysql php, import excel file into mysql using php, export csv file in php mysql, data website rip php, flex data providers mysql php, data mining mysql php, csv file upload mysql php code, can extract data website using php, display csv data website, track visit time website mysql php, manage multilingual websites data using mysql php, crawl data website using php, upload csv file update mysql php, display product data website mysql, data excel mysql php

Tentang Majikan:
( 0 ulasan ) Canada

ID Projek: #17568216

8 pekerja bebas membida secara purata $33 untuk pekerjaan ini

$70 USD dalam 2 hari
(89 Ulasan)
5.8
$25 USD dalam sehari
(54 Ulasan)
5.2
surendramuduli

We are highly expertise and experienced to developed custom eCommerce website and CMS website using WordPress, Woo commerce, Big commerce and Shopify. Please talk to us, we will start work on it straight away.

$20 USD dalam sehari
(13 Ulasan)
4.5
shwetankit

Dear Sir, I have gone through your requirement and things are clear to [login to view URL] share details and ping me for further discussion. Spare a moment on our previous work [login to view URL] [login to view URL] Lagi

$25 USD dalam sehari
(3 Ulasan)
2.6
dineshchand73

Hello I have experience with python and php /html5/mysql so I can easily create the script to import data and the php script to show it on web. I think even 50,000 might be quite a bit to be shown at once but we wi Lagi

$20 USD dalam 2 hari
(13 Ulasan)
2.6
$25 USD dalam sehari
(1 Ulasan)
0.8
liilyeezy

Hello, I’ve carefully gone through your job posting, and I am very much interested to work in your project. I'm a 22 years old computer engineering student from morocco and I am a Full-Stack web developer. I absolut Lagi

$55 USD dalam sehari
(1 Ulasan)
0.1
kalithas804

Hi, I already done silmilar [login to view URL] you are interested, Please call +91 9710441298. Thanks Kalidoss G, chennai.

$25 USD dalam 2 hari
(0 Ulasan)
0.0