-
Dec 20th, 2017, 06:34 AM
#1
Thread Starter
Addicted Member
Eporting reports to be viewed online
I have an old application which stores patients medical results in a MDB file. I want to upload these results online so patients can use their IDs and a given password to view their results online.
I thought the best way is to have a MySQL database where I upload all the needed data to it and use PHP to do the following :
1. Ask for user name and password.
2. Display all visits dates for the patient in a combo box or whatever.
3. Show results using HTML formatting.
I am starting my Web Application Development and I started the following thread :
http://www.vbforums.com/showthread.p...eb-development
I do appreciate if anyone can give his 2 cents or anyone who know of a RAD tool to help me achieve what I want as fast as possible till I master what is needed to do it all by myself.
Thank you very.
-
Dec 20th, 2017, 07:07 AM
#2
Addicted Member
Re: Eporting reports to be viewed online
If you need PHP help, this is not the place to ask it , in my opinion
Utterly useless, but always willing to help
As a finishing touch god created the dutch
-
Dec 20th, 2017, 07:39 AM
#3
Re: Eporting reports to be viewed online
Hi Lab,
use the Datareport and convert it to PDF with PDF-Creator. I think it would be better just
to upload a Report rather the a whole DB-System.
but that's up to you
regards
Chris
to hunt a species to extinction is not logical !
since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.
-
Dec 20th, 2017, 08:13 AM
#4
Thread Starter
Addicted Member
Re: Eporting reports to be viewed online
Originally Posted by Goggy
If you need PHP help, this is not the place to ask it , in my opinion
Thanks!
-
Dec 20th, 2017, 08:18 AM
#5
Thread Starter
Addicted Member
Re: Eporting reports to be viewed online
Originally Posted by ChrisE
Hi Lab,
use the Datareport and convert it to PDF with PDF-Creator. I think it would be better just
to upload a Report rather the a whole DB-System.
but that's up to you
regards
Chris
Thanks Chris but:
How is that will work for users to log in and see their own specific results?
Do you suggest storing PDFs on server in a specific way?
Last edited by labmany; Dec 20th, 2017 at 08:25 AM.
-
Dec 20th, 2017, 08:43 AM
#6
Re: Eporting reports to be viewed online
Hi ,
my wife's a Vet, she recives an Email with a Link to view a Report(Bloodresults etc..).
She could also request to recive the Report per Email from the Lab., but she didn't want that.
You can also print out the DataReport in HTML if you want, rather than PDF.
If you need a sample how to create a Datareport, then let me know.
regards
Chris
to hunt a species to extinction is not logical !
since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.
-
Dec 20th, 2017, 02:57 PM
#7
Re: Eporting reports to be viewed online
Thread moved to Web Dev Forum from Classic VB6 Forum
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it!
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
-
Dec 20th, 2017, 04:22 PM
#8
Thread Starter
Addicted Member
Re: Eporting reports to be viewed online
Originally Posted by ChrisE
Hi ,
my wife's a Vet, she recives an Email with a Link to view a Report(Bloodresults etc..).
She could also request to recive the Report per Email from the Lab., but she didn't want that.
You can also print out the DataReport in HTML if you want, rather than PDF.
If you need a sample how to create a Datareport, then let me know.
regards
Chris
Many thanks Chris for your help.
The problem is many of my software users do have websites and they need to offer a service to their patients to get their results (present and history results) online anytime they want!
-
Dec 22nd, 2017, 11:25 AM
#9
Re: Eporting reports to be viewed online
Originally Posted by labmany
I have an old application which stores patients medical results in a MDB file. I want to upload these results online so patients can use their IDs and a given password to view their results online.
I thought the best way is to have a MySQL database where I upload all the needed data to it and use PHP to do the following :
1. Ask for user name and password.
2. Display all visits dates for the patient in a combo box or whatever.
3. Show results using HTML formatting.
I am starting my Web Application Development and I started the following thread :
http://www.vbforums.com/showthread.p...eb-development
I do appreciate if anyone can give his 2 cents or anyone who know of a RAD tool to help me achieve what I want as fast as possible till I master what is needed to do it all by myself.
Thank you very.
You are in right path.
For converting the data from MDB file to MySQL, have a look at the answers listed here: https://stackoverflow.com/questions/...plain-sql-file
Use PHP or any other serverside language of your choice, and do the coding to validate login, fetch data from the database, etc.
There are a ton of tutorials out there which will aid you. And if you encounter any issues, we might be able to throw some ideas. But be specific when you ask questions.
If my post was helpful to you, then express your gratitude using Rate this Post.
And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet
Social Group: VBForums - Developers from India
Skills: PHP, MySQL, jQuery, VB.Net, Photoshop, CodeIgniter, Bootstrap,...
-
Dec 24th, 2017, 07:44 AM
#10
Thread Starter
Addicted Member
Re: Eporting reports to be viewed online
Originally Posted by akhileshbc
You are in right path.
For converting the data from MDB file to MySQL, have a look at the answers listed here: https://stackoverflow.com/questions/...plain-sql-file
Use PHP or any other serverside language of your choice, and do the coding to validate login, fetch data from the database, etc.
There are a ton of tutorials out there which will aid you. And if you encounter any issues, we might be able to throw some ideas. But be specific when you ask questions.
Thank you very much akhileshbc, I will do just that
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|