PHP Function (1)

Completato Pubblicato 6 anni fa Pagato alla consegna
Completato Pagato alla consegna

We are developing an application and we need to speed up the work. We have PHP functions to be developed and we need a programmer that offers the service in micro-stages. We will specify the PHP functions, distributing here in isolated tasks, paying by hour (microjobs).

Here's the first function (pure PHP, no frameworks, no objects to be installed on the server):

- - - -

FUNCTION 1 - CSV IMPORT

PHP, where we can:

1 - Inform the CSV path of files with GB size, previously sent via FTP to the PHP file folder with the function.

2 - Inform the path Mysql, user and database (empty, without columns defined) and the name of the table to be created for the csv to be imported.

3 - Create table (+ columns) Mysql naming the columns automatically (in Mysql) according to the first line of the CSV

4 - Need a previous scan: If the entire column only has numbers, in the Mysql store as INTEGER. If you have letters and numbers, store them as STRING.

5 - If a line is 100% the same as the one already imported, ignore the line (this way, in case of fall, interruption, it will continue without polluting)

Accelerators / References:

Https://[login to view URL]

Http://[login to view URL]

Http://[login to view URL]

- - - -

Please give the bid informing the expected number of hours, so we will have reference to the next functions. We will give preference to those who start the project with us.

MySQL PHP

Rif. progetto: #14080187

Info sul progetto

17 proposte Progetto a distanza Attivo 6 anni fa

Assegnato a:

mahendrasharma56

Hello , I have go through with requirement and get understanding ,what will be job for if i am successful winner of the this job . Hope that will happen . About my exp. I have more than 8 year experience in w Altro

$25 USD in 1 giorno
(29 valutazioni)
5.2

17 freelance hanno fatto un'offerta media di $57 per questo lavoro

AdeelAslam4

Hello. I have read your project description but I need to ask few questions. Please feel free to ping me anytime so we can have a detailed discussion.

$277 USD in 7 giorni
(33 valutazioni)
7.3
saagark22

Hi, I can write PHP function which does follow Gives the information of files like you asked, will import data from CSV to MySQL database and will also take care of validation like empty column return.

$111 USD in 1 giorno
(381 valutazioni)
7.4
keithn

Hello, I'm guessing this would take me around 2 to 2.5 hours to complete (with thorough testing). One quick question for you though, will the data types always be INT or VARCHAR, or will additional data types be nee Altro

$60 USD in 1 giorno
(68 valutazioni)
6.3
omagrawal9415

Hi,  I'm a Web Developer, and I'm very interested in your job post as i am having related work experience in fulfilling the need for the job posted and also i am having expertise in web based languages from static t Altro

$25 USD in 1 giorno
(2 valutazioni)
2.5
mrlequoctuan

I can do this in three hours, maybe less ------------------------------------------------------------

$25 USD in 1 giorno
(3 valutazioni)
2.6
yagnik1996

A proposal has not yet been provided

$35 USD in 15 giorni
(0 valutazioni)
0.0