I gang

PHP to extract data from mysql

I have to create a php file that will be setted as cron.

this cron will generate two csv files extracting datas from a mysql database (it's a wordpress installation).

-------

CSV 1

header:

ID;ragione sociale;indirizzo;nome;email;telefono;prodotto;licenze;db;erp;commento;newsletter;privacy;IP;referrer;data;lingua;mail inviata

rows:

csv will extract all datas from blk_rg_lead table that has form_id = 73 or 80.

fields:

ID --> field id from blk_rg_lead table

ragione sociale --> field with field_number = 1 and with lead_id = previous field, from blk_rg_lead_detail table

indirizzo --> field with field_number = 37 and with lead_id = previous field, from blk_rg_lead_detail table

nome --> field with field_number = 2 and with lead_id = previous field, from blk_rg_lead_detail table

email --> field with field_number = 3 and with lead_id = previous field, from blk_rg_lead_detail table

telefono --> field with field_number = 29 and with lead_id = previous field, from blk_rg_lead_detail table

prodotto --> field with field_number = 39 and with lead_id = previous field, from blk_rg_lead_detail table

licenze db --> field with field_number = 6 and with lead_id = previous field, from blk_rg_lead_detail table

erp --> field with field_number = 32 and with lead_id = previous field, from blk_rg_lead_detail table

commento --> field with field_number = 41 and with lead_id = previous field, from blk_rg_lead_detail table

newsletter --> field with field_number = 40 and with lead_id = previous field, from blk_rg_lead_detail table

privacy --> field id from blk_rg_lead table

IP --> field ip from blk_rg_lead table

referrer --> field source_url from blk_rg_lead table

data --> field date_created from blk_rg_lead table

lingua --> "it" if field form_id from blk_rg_lead table is = 73, "it" if field form_id from blk_rg_lead table is = 80

mail inviata --> OK

--------

CSV 2

header:

"ID";"Titolo";"Nome";"Cognome";"E-mail";"Telefono";"Fax";"Info via mail";"Aree di interesse";"Come siete venuti a conoscenza";"Posizione";"Azienda";"Settore attività";"Fatturato";"Numero dipendenti";"Certificati (sÏ/no)";"Prodotto di cui si richiede il download";"Tipo di certificazione";"Indirizzo";"Località";"CAP";"Provincia";"Nazione";"Attivo";"Scadenza"

rows:

csv will extract all datas from blk_users table

fields:

ID --> field ID from blk_users table

Titolo --> no data to import

Nome --> field with meta_key = first_name and with user_id = previous field, from blk_usermeta table

Cognome --> field with meta_key = last_name and with user_id = previous field, from blk_usermeta table

E-mail --> field user_email from blk_users table

Telefono --> field with meta_key = user_telefono and with user_id = previous field, from blk_usermeta table

Fax --> no data to import

Info via mail --> no data to import

Aree di interesse --> no data to import

Come siete venuti a conoscenza --> no data to import

Posizione --> no data to import

Azienda --> field with meta_key = user_company and with user_id = previous field, from blk_usermeta table

Settore attività --> no data to import

Fatturato --> no data to import

Numero dipendenti --> no data to import

Certificati (sì/no) --> no data to import

Prodotto di cui si richiede il download --> no data to import

Tipo di certificazione --> no data to import

Indirizzo --> no data to import

Località --> no data to import

CAP --> no data to import

Provincia --> no data to import

Nazione --> no data to import

Attivo --> SI if field with meta_key = user_meta_user_status and with user_id = previous field from blk_usermeta table is = active, else NO

Scadenza --> no data to import

Færdigheder: MySQL, PHP, Software Arkitektur

Se mere: php extract data database, php software download, mysql software download, create table php, di data, telefono, nome, extract data , cui, aree, file email extract, php table csv, import csv data mysql, mysql create table data, php extract data email, mysql import csv data, mysql create table fields, table extract, extracting data csv, wordpress mysql data, cron mysql, software cron, cron wordpress, import csv mysql php, email extract software

Om arbejdsgiveren:
( 8 bedømmelser ) Reggio Emilia, Italy

Projekt-ID: #4049401

Tildelt til:

kjanssens

Easy job, can deliver within 1 hour

$30 USD på 1 dag
(5 bedømmelser)
2.6

36 freelancere byder i gennemsnit $129 for dette job

manpreet

We are experts in PHP and MySQL.

$150 USD in 3 dage
(207 bedømmelser)
8.2
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$225 USD in 5 dage
(223 bedømmelser)
7.7
RockStone435

I think it doesnt matter if its WP installation or custom coded website. We can build our PHP file and set it up as cron from web server.

$120 USD in 7 dage
(296 bedømmelser)
7.5
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$250 USD in 2 dage
(368 bedømmelser)
6.9
marchingantssl

Hi, I can start straight away working for you. Thanks

$180 USD in 3 dage
(113 bedømmelser)
6.8
VileGnosis

I have sent a private message to your inbox that contains my relevent skills and any questions I have.

$80 USD in 0 dage
(167 bedømmelser)
6.6
mantislin

Hi sir, please check PM, thx Kimi.

$248 USD in 5 dage
(120 bedømmelser)
6.4
keiespro

Hello. I can make it within 10 hours.

$150 USD in 0 dage
(117 bedømmelser)
6.2
kernelbd

We can help you to build this MySQL-CSV file generator script for cronjobs. Highly interested. Ready to start. Thanks.

$150 USD på 1 dag
(80 bedømmelser)
6.2
thangtqvn

I'm ready, please check your PMB. Thank you

$75 USD in 2 dage
(102 bedømmelser)
6.0
finecodervw

Please check PMB for more details. Thanks

$250 USD in 7 dage
(143 bedømmelser)
6.0
Chtioui86

Hi, Please see your private msg TY

$180 USD in 3 dage
(61 bedømmelser)
5.9
roonex

Hi Please view my message.

$60 USD in 2 dage
(95 bedømmelser)
5.6
phpXpertbd

I worked on many similar projects, I have big experience in data mining projects. I can finish this task in short time, with the best quality.

$125 USD in 2 dage
(17 bedømmelser)
5.3
xpertzdevelopers

lets start :)

$199 USD in 5 dage
(25 bedømmelser)
5.1
webedict

HELLO SIR, READY TO START, LETS START AND FINISH IT ASAP. I HAVE 4 YEARS OF EXPERIENCE IN php, mysql, ajax, js, xhtml. THANKS !!

$50 USD in 3 dage
(56 bedømmelser)
5.1
parthcoder

Consider it done :) Let me know when to start, I can easily do this job for you. Noddy

$75 USD in 3 dage
(42 bedømmelser)
5.2
pyostrike

Hello. I can do this for you. Anton.

$45 USD på 1 dag
(58 bedømmelser)
4.8
mike25

Some remarks via Inbox. Regards, Mike

$150 USD in 10 dage
(27 bedømmelser)
4.8
pixecs

Dear sir, i can help you with this project. I have a vast experience with php and mysql database programming.

$35 USD in 3 dage
(25 bedømmelser)
4.7