Tamamlanmış

Join CSV files and sort them in PHP, to look like it's result from query in Database

I have MySQL database, and i run sql query on that database with joins and where clause, lets say query will look like

SELECT [url removed, login to view],

[url removed, login to view],

[url removed, login to view],

[url removed, login to view]

FROM table1 a

LEFT JOIN table2 b ON a.some_value=b.some_value

LEFT JOIN table3 c ON a.some_value=c.some_value

WHERE a.some_value = 'some_text';

and i run query 1000times from PHP to get average time needed for this query on database with 4.5milions [url removed, login to view] that, i export these 3 tables in CSV files.

Now, i need some programmer who can load these CSV files in PHP and to create script that will JOIN these CSV files and filter with some where clause, and to get result to look similar like sql query in database.

Also, it's needed to go through 1.000 times and measure each time of execution to get average time.

First i want to know someone if someone is able to do this kind of job, as fast as it possible, after that, i will provide csv files for job.

Feel free to contact me if you have any questions.

Best regards

Beceriler: PHP, Scripting, Yazılım Mimarisi

Daha fazlasını gör: Write a command line program to \ join\ .csv files., sort csv file save php, php upload csv files save database code, php searching csv files search, php read client side csv files, php pull csv files, load large csv files php, import csv files mysql php, php look files ftp, php read csv files, upload csv files database php, php upload csv files, php csv files, php script upload csv files, create multiple csv files php

İşveren Hakkında:
( 2 değerlendirme ) Belgrade, Serbia

Proje NO: #15243635

Seçilen:

ksc1025

I can do it. it's very fun. if you give me the CSV file, i try it and i'll send the proper PHP program as soon. Thank you. Relevant Skills and Experience I have already the experiences for CSV files manipulating. Pr Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(4 Değerlendirme)
2.5

Bu iş için 13 freelancer ortalamada $28 teklif veriyor

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(58 Değerlendirme)
6.4
NayaPakistan

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(213 Değerlendirme)
6.4
rambanstola

I am available for this project. Task will can be delivered in next two hours max.

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(47 Değerlendirme)
5.4
jayshreeganeshha

hello,software developer here having experience of more than 5 years and i would like to work on your project .you can see my reviews and discuss with me.I hope you would like to hire [login to view URL] Relevant Skills and Exp Daha Fazla

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(21 Değerlendirme)
5.0
in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
3.9
umar540

hi i have more than 5 years of experience in web development, i will work on your project on minimum budget. hire me and we will discuss this project further. Relevant Skills and Experience HTML, CSS, BOOTSTRAP, WORDP Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(9 Değerlendirme)
3.7
player4zone

Hi, I understand that you want to load CSVs of 3 tables, get them joined and filtered according to the conditions. Then I have to this 1000 times to get the average time. Relevant Skills and Experience I have experien Daha Fazla

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
3.5
amitadubey

I am specializing in web development, web design and app expert.. We offer a wide range of experience & expertise. We provide these services to offshore clients across the globe. Relevant Skills and Experience I am sp Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
2.5
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
1.5
mahendrageet

I have rich experience in php, mysql, ajax, Linux. We can discuss more over chat

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
creativesols3

Hi, i am a full stack mobile & web dev having similar technical skills & experience & have already worked on a similar project before so can do this Ref : [login to view URL] Relevant Skills a Daha Fazla

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
asa5921a12e3c0f1

i have worked with json and csv in php

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0