Need a script to take data from different fields mySQL database and output to Excel
- or -
Post a project like this$$
- Posted:
- Proposals: 13
- Remote
- #1846535
- Expired
44040157705719276211989018197842119629441660041158846815179691537355476041760240
Description
Experience Level: Intermediate
We have a client request who needs to get data from a mySQL database to Excel.
The mySQL database is to do with a medical patients record system (OpenEMR). OpenEMR (www.open-emr.org) is developed around php & mySQL.
The system in question is for an optometry client who stores patient data in OpenEMR.
Calendar (to store patient's next visit) is part of OpenEMR
Patient demographics is part of OpenEMR
But the form to store prescriptions, is an LBV form (http://www.open-emr.org/wiki/index.php/LBV_Forms)
Every prescription is linked to the respective patient.
As for the demographics file, every patient has a PID (patient ID) and the same can be seen in the mySQL table patient_data
The challenge we're facing is, we don't see any field in the mySQL table lbv_data (which stores the prescriptions) linking each prescription to the respective patient.
I shall be in a better position to share more information and data from the related mySQL tables once we're in communication.
The mySQL database is to do with a medical patients record system (OpenEMR). OpenEMR (www.open-emr.org) is developed around php & mySQL.
The system in question is for an optometry client who stores patient data in OpenEMR.
Calendar (to store patient's next visit) is part of OpenEMR
Patient demographics is part of OpenEMR
But the form to store prescriptions, is an LBV form (http://www.open-emr.org/wiki/index.php/LBV_Forms)
Every prescription is linked to the respective patient.
As for the demographics file, every patient has a PID (patient ID) and the same can be seen in the mySQL table patient_data
The challenge we're facing is, we don't see any field in the mySQL table lbv_data (which stores the prescriptions) linking each prescription to the respective patient.
I shall be in a better position to share more information and data from the related mySQL tables once we're in communication.
Muhammad K.
100% (5)Projects Completed
6
Freelancers worked with
3
Projects awarded
15%
Last project
11 Aug 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Please let me know if still available? I have this kind of daily working so I can do best . We can discuss if you want and I will find out solution after discussing about fields from mysql table. You can find me as maximum php hourlie sold in PPH.
Thanks
Naresh Shaw
566357
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies