melaniecarr23 Posted September 9, 2011 Share Posted September 9, 2011 Hi, It's been a while since I've done any programming, and I was wondering if anyone can recommend an application for the following use: users from various places enter data into an online MySQL database using a web form. Some users have the ability to manipulate the data (run queries, export to Excel, etc.) Relatively simple, but like I said, it's been a while! I prefer opensource, as I'm not getting paid for this and it is being done not for profit (school project). Thanks Melanie Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted September 9, 2011 Share Posted September 9, 2011 This is far too vague. Every application written in PHP that requires MySQL will read / write data to the database from forms and queries. What kind of application do you need? Is it a CRM? Chances are, what you are looking for is a niche and you will have to write it yourself. Have you tried looking on script websites such as http://www.hotscripts.com Quote Link to comment Share on other sites More sharing options...
melaniecarr23 Posted September 14, 2011 Author Share Posted September 14, 2011 A patient walks into the office. Doctor enters health information into a database from his/her computer, which enters that data into a database. A different user with permissions to do so queries the information (based upon what they are looking for in each field) using a web interface (not a programmer doing this). Data can also be exported to excel, as needed, so it can be analyzed for research. I have considered using Drupal with the Data module, but am not sure if it would work or not. I realize I might need to just create the database and entry page myself (not a problem). The biggest thing I'd like to know about is if there is an app I can install that would use the database and allow someone to pull whatever information they want out of it (patients between the ages of 20-40 who are pregnant and had a certain type of care within certain dates). That information could then be pulled up and exported. Does that help? I forgot about hot scripts. Thanks, I'll check it out in the meantime. Quote Link to comment Share on other sites More sharing options...
KevinM1 Posted September 14, 2011 Share Posted September 14, 2011 You do realize that medical information must be handled under strict guidelines, right? You do NOT want to run the risk of violating HIPAA or whatever patient confidentiality laws your country has. Given the delicacy of the data involved, this is something you should hire a professional with a solid history of working on medical software for. Quote Link to comment Share on other sites More sharing options...
TOA Posted September 14, 2011 Share Posted September 14, 2011 You do realize that medical information must be handled under strict guidelines, right? You do NOT want to run the risk of violating HIPAA or whatever patient confidentiality laws your country has. Given the delicacy of the data involved, this is something you should hire a professional with a solid history of working on medical software for. You ain't kiddin'. I work in the healthcare field. Do not take the consequences lightly. If I'm understanding your OP, I would just store permissions in the db with the user data, so if they have the right permission, they can view/export data, but this is based off very little information. But I would take Nightslyr's suggestion if I were you; nothing personal, more of a CYOA kinda deal. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.