Fermé

Create CSV file from database

Requirement: A script that generate a downloadable CSV file containing a list of contacts along with the person (resident) they are associated with and the type of relationship to that person (resident). This information is stored in PODS tables in a mySQL database. The script should be written in PHP and runnable from a Wordpress page.

The CSV file should contain the following columns:

From wp_pod_tbl_contact:

name

date_of_birth

mobile_phone_number

email

next_of_kin

From wp_pod_tbl_relationship_to_resident:

name

From wp_pod_tbl_resident:

name

inactive

From wp_pod_tbl_care_home:

name

User interface: The CSV file will be created by selecting a menu option from a Wordpress website and then clicking a download button on a form. No other form fields are required. The file should be generated and presented to the user for download to their browser.

Coding: The script should be written in PHP and should use the following PODS api methods for database access:

findRecords() - [url removed, login to view]

fetchRecords() - [url removed, login to view]

get_field() - [url removed, login to view]

The script should only permit authorised users to run it. The following security check should be included at the start of the script:

global $gcUser

gc_user();

$userRole=$gcUser['role'];

if ( $userRole != 'Group Manager' ) die() ;

Tables:

wp_pod_tbl_contact (a table of friends and family of residents)

wp_pod_tbl_relationship_to_resident (the type of link between contacts and residents, eg son, daughter, brother, friend, etc)

wp_pod_tbl_resident (a table of people staying in a care home)

wp_pod_tbl_care_home (a table of care homes)

Skills needed for this task:

Wordpress

PODS CMS Framework plugin

PHP

Compétences : PHP, WordPress

en voir plus : wordpress website manager needed, wordpress codex, user group manager, skills needed for manager, requirement in wordpress to create a website, create api for wordpress, c# plugin framework, codex wordpress org, codex wordpress, database skills, mysql database manager, php script create table, file manager, Family Care, database security, csv file, csv api, menu csv file, email page friend php script, api access access database, pods plugin, wordpress create, home user interface, csv form, php create csv file

Concernant l'employeur :
( 0 commentaires ) Shepperton, United Kingdom

Nº du projet : #2370654

16 freelance font une offre moyenne de £131 pour ce travail

ahtsolutions

We are interested in your projects. Website, mobile apps development are our range projects. Please check PMB for our profile & portfolio. Thanks a lot! ArrowHiTech Jsc!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(454 Commentaires)
8.8
toinnisfree

pls chk pmb

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(775 Commentaires)
8.3
brycep

Hi,Lemme do [login to view URL]!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(262 Commentaires)
8.0
ssahilsl

!!!!!!!!Hi, ONE STOP SHOP for PHP, WORDPRESS, SEO and WEB DESIGN. Open message board for discussion & previous work. We are a team of PHP, WORDPRESS developers and web designers who are in this field since last 10 year Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(161 Commentaires)
7.3
rakhon

Hi, I already have half of your script...

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(25 Commentaires)
6.1
pablotorres

I can do it!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 15 jours
(130 Commentaires)
6.0
imode101

Hi, I have 6 years of PHP experience and work on your task. I would be happy to provide you the solution. Assuring you the best result. Looking forward. Thanks, Ansh

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(14 Commentaires)
5.3
pixecs

Dear sir, i can help you with this project. I have over 6 years of experience with Html + Css + JavaScript and over 2 with Php and jQuery.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(47 Commentaires)
5.1
naranili

Please see my message at the PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(38 Commentaires)
5.3
GoldenSoft86

Hello Sir. PHP Expert here. I can do it quickly. Best regards. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(6 Commentaires)
3.5
bestpro126

Dear sir. I am a skilful expert in web domain. I have been working in this domain over 7 years, and have many experience. My coding ability will provide good result to you. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(13 Commentaires)
3.4
manimaran1048

Hi There, We are very much interested to work in your project. We have extensive experience in wordpress. Check message box for samples. regards Mani

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 20 jours
(0 Commentaires)
0.0
ashwindparmar

Hi, see my pm.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(0 Commentaires)
0.0
aritmukherjee

I'm ready to start.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 6 jours
(0 Commentaires)
0.0
reformconsulting

Dear Sir, Greetings! We are Reform Consulting with 5 years of experience under our belt. We are really interested to work on your project. Please see PM. Thank you. Regards, RCPL.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(3 Commentaires)
4.4
mizanurrahaman

Please check our private message..

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 6 jours
(0 Commentaires)
0.0