Create CSV file from database
£20-250 GBP
Paid on delivery
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
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() - [login to view URL]
fetchRecords() - [login to view URL]
get_field() - [login to view URL]
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
Project ID: #2370654
About the project
14 freelancers are bidding on average £136 for this job
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!
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.
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.
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
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.