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

Voir plus : wordpress website manager needed, wordpress codex, user group manager, skills needed manager, requirement wordpress create website, create api wordpress, codex wordpress org, codex wordpress, database skills, mysql database manager, php script create table, family care, database security, csv file, csv api, menu csv file, pods plugin, wordpress create, home user interface, csv form, php create csv file, access database api, create file table access, wordpress email download, script php file manager

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

N° du projet : #2370654

17 freelance ont fait une offre moyenne de 132 £ 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!

150 £ GBP en 4 jours
(276 Commentaires)
8.5
toinnisfree

pls chk pmb

200 £ GBP en 4 jours
(540 Commentaires)
7.9
brycep

Hi,Lemme do it.Thanks!

140 £ GBP en 5 jours
(184 Commentaires)
7.7
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

99 £ GBP en 2 jours
(83 Commentaires)
6.7
pablotorres

I can do it!

40 £ GBP en 15 jours
(66 Commentaires)
5.4
naranili

Please see my message at the PMB

50 £ GBP en 3 jours
(38 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.

50 £ GBP en 7 jours
(34 Commentaires)
4.8
idealtechnologys

Dear Client, We have gone through with your project requirement. Please check PMB for more details. Thanks

150 £ GBP en 10 jours
(3 Commentaires)
4.3
GoldenSoft86

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

150 £ 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.

30 £ GBP en 3 jours
(13 Commentaires)
3.4
rakhon

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

80 £ GBP en 7 jours
(5 Commentaires)
2.9
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

80 £ GBP en 3 jours
(0 Commentaires)
0.0
mizanurrahaman

Please check our private message..

180 £ GBP en 6 jours
(0 Commentaires)
0.0
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

240 £ GBP en 20 jours
(0 Commentaires)
0.0
aritmukherjee

I'm ready to start.

200 £ GBP en 6 jours
(0 Commentaires)
0.0
ashwindparmar

Hi, see my pm.

250 £ GBP en 10 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.

150 £ GBP en 7 jours
(3 Commentaires)
3.9