Sedang Disiapkan

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

Kemahiran: MySQL, PHP, Kejuruteraan Perisian

Lihat lebih lanjut: 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, php import csv file mysql, wordpress mysql data, cron mysql, software cron, cron wordpress, import csv mysql php

Tentang Majikan:
( 8 ulasan ) Reggio Emilia, Italy

ID Projek: #4049401

Dianugerahkan kepada:

kjanssens

Easy job, can deliver within 1 hour

$30 USD dalam sehari
(5 Ulasan)
2.6

36 pekerja bebas membida secara purata $129 untuk pekerjaan ini

manpreet

We are experts in PHP and MySQL.

$150 USD dalam 3 hari
(207 Ulasan)
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 dalam 5 hari
(223 Ulasan)
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 dalam 7 hari
(296 Ulasan)
7.5
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$250 USD dalam 2 hari
(368 Ulasan)
6.9
marchingantssl

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

$180 USD dalam 3 hari
(113 Ulasan)
6.8
VileGnosis

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

$80 USD dalam 0 hari
(167 Ulasan)
6.6
mantislin

Hi sir, please check PM, thx Kimi.

$248 USD dalam 5 hari
(120 Ulasan)
6.4
keiespro

Hello. I can make it within 10 hours.

$150 USD dalam 0 hari
(117 Ulasan)
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 dalam sehari
(80 Ulasan)
6.2
thangtqvn

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

$75 USD dalam 2 hari
(102 Ulasan)
6.0
finecodervw

Please check PMB for more details. Thanks

$250 USD dalam 7 hari
(143 Ulasan)
6.0
Chtioui86

Hi, Please see your private msg TY

$180 USD dalam 3 hari
(61 Ulasan)
5.9
roonex

Hi Please view my message.

$60 USD dalam 2 hari
(95 Ulasan)
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 dalam 2 hari
(17 Ulasan)
5.3
xpertzdevelopers

lets start :)

$199 USD dalam 5 hari
(25 Ulasan)
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 dalam 3 hari
(56 Ulasan)
5.1
parthcoder

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

$75 USD dalam 3 hari
(42 Ulasan)
5.2
pyostrike

Hello. I can do this for you. Anton.

$45 USD dalam sehari
(58 Ulasan)
4.8
mike25

Some remarks via Inbox. Regards, Mike

$150 USD dalam 10 hari
(27 Ulasan)
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 dalam 3 hari
(25 Ulasan)
4.7