Using databases - Post ID 300405

User 492718 Photo


Registered User
3 posts

I'm a relative newbie to web design. I need to implement a database and allow queries and retrieval of data back to the client's html page. I'm somewhat confused about the process and I was wondering if I can be steered me down the right path.

I'm using MS-Access with a single table. I've uploaded it to the server. I know SQL syntax in order to retrieve data from the tables.

I understand that I need to connect to the database. I've seen several examples via Google on how to use php to connect to the database. I think I understand that process.

What I don't understand is the query, extraction, and presentation. If I have a html page with multiple selection options, I assume I need to send a properly structured SQL statement to the server. Assuming I have the correct statements for connecting to the MS-Access database and a properly structured SQL statement for data retrieval, how do I get the SQL results displayed back to the client's html page?
User 462238 Photo


Registered User
144 posts

User 37670 Photo


Registered User
2,138 posts

Hi Tonynix,

I use databases all the time, and I think you may be taking the wrong approach. Micro$oft Access, to my knowledge does not work with php, and I thought it did not work on-line, but have been corrected.

EDIT Looks like I was wrong in my assuptions, sorry

You could look up MySQl (free online database) used by millions around the world. It works extremely well with php, and runs on most Linux servers. If your web pages are hosted on Windows, then you may need to use ASP to connect to your database. Check with your server, see what you have and go from there. Your control panel for your website (most hosting packages have something like 'cpanel') will have a link to database software where you can create your on-line database.

After that, google up some php or asp tutorials, depending on what your server is and needs.
E-Learning Specialist
www.mainsites.ca is my website, and yes, some of it is crappy.
User 364143 Photo


Guest
5,410 posts

MS Access can certainly be used online. I have used this ASP and MS Access Forum software in the past with great success.

http://forum.snitz.com/

If you download the files there and look at the scripts, you will get an idea of what you need to do.
CoffeeCup... Yeah, they are the best!
User 37670 Photo


Registered User
2,138 posts

Tom wrote:
MS Access can certainly be used online. I have used this ASP and MS Access Forum software in the past with great success.

http://forum.snitz.com/

If you download the files there and look at the scripts, you will get an idea of what you need to do.

YAHOOOO! I learn something new every day. I have tried many ways to get a MS access database to work from an on-line system of some sort, with no luck at all! I gave up a long time ago. Now I just have to learn ASP :(
E-Learning Specialist
www.mainsites.ca is my website, and yes, some of it is crappy.
User 3126433 Photo


Guest
1 post

Looking to connect a MS SQL database. Anyone find a solution and use Coffee Cup? Thanks
User 187934 Photo


Senior Advisor
20,181 posts
Online Now

Hi hkkul,
I use the HTML Editor to write all the code needed for Databases.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.