 |  |  |  |  |  |  |  |
Connecting A Website To a DataBase
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Nov 2007
Posts: 62
Reputation: 
Solved Threads: 0
Junior Poster in Training
Hello everyone,
I need Help connecting my website to a database.
i could use anyones help.
Thanks
I need Help connecting my website to a database.
i could use anyones help.
Thanks
•
•
Join Date: Nov 2007
Posts: 62
Reputation:
Solved Threads: 0
Junior Poster in Training
i have a website that i wanna connect to a database but i dont know how to link it to my database.
Hmm, that's a simple question that requires a long answer. Here's a few pointers.
1) First, HTML alone does not allow linking a website to a database. You need another language in between that will interface with the database and produce the HTML code on the fly using the query results. For example, you have a list of students in your database along with exam results and you want to post that list on a web site, in a table. The "middle language" would send the query to the database and fetch the results. Then, it would create your HTML tags (<table><tr><td> etc.) and form a valid HTML page with the results inside.
2) There are many "middle languages" available, the most popular (I think) being PHP. It's easy to install and will run on Windows, Linux and OS X all the same. It will interface with all of the most popular database management systems such as MySQL, PostgreSQL, MS SQL, etc.
3) Read read read. Nothing you get you started quicker than a good book. I recommend O'Reilly's Learning PHP and MySQL which was of great use to me.
Hope this helps.
1) First, HTML alone does not allow linking a website to a database. You need another language in between that will interface with the database and produce the HTML code on the fly using the query results. For example, you have a list of students in your database along with exam results and you want to post that list on a web site, in a table. The "middle language" would send the query to the database and fetch the results. Then, it would create your HTML tags (<table><tr><td> etc.) and form a valid HTML page with the results inside.
2) There are many "middle languages" available, the most popular (I think) being PHP. It's easy to install and will run on Windows, Linux and OS X all the same. It will interface with all of the most popular database management systems such as MySQL, PostgreSQL, MS SQL, etc.
3) Read read read. Nothing you get you started quicker than a good book. I recommend O'Reilly's Learning PHP and MySQL which was of great use to me.
Hope this helps.
What if you are using Microsoft Access as the database package.. what scripting Language does that require when linking your database to your website?.... or Oracle...
jwaldron82:
It is incorrect to assume that the choice of a database system "requires" a scripting language. In fact, in many cases a scripting language will support many database systems. For example, PHP will support mySQL, PostgreSQL, Oracle and even Access.
In an ideal world you are free to choose the scripting language and the database system independently. In the real world, you are sometimes restricted as you suggest by one or the other (in your case, you appear restricted to using Access). That will of course influence the choice of the other. As far as I know, Access is supported by most scripting languages through ODBC, which is like a driver for databases. Any scripting language that supports database connections through ODBC should be able to connect to Access.
PHP and ODBC: http://ca.php.net/odbc
It is incorrect to assume that the choice of a database system "requires" a scripting language. In fact, in many cases a scripting language will support many database systems. For example, PHP will support mySQL, PostgreSQL, Oracle and even Access.
In an ideal world you are free to choose the scripting language and the database system independently. In the real world, you are sometimes restricted as you suggest by one or the other (in your case, you appear restricted to using Access). That will of course influence the choice of the other. As far as I know, Access is supported by most scripting languages through ODBC, which is like a driver for databases. Any scripting language that supports database connections through ODBC should be able to connect to Access.
PHP and ODBC: http://ca.php.net/odbc
|
Similar Threads
- Beginners Guide To Creating Database Driven Website (Site Layout and Usability)
- MSSQL - MySql Database Connectivity (MS SQL)
- JSP Database (JSP)
- Help me in username and password validation through accessing the database (ASP.NET)
- ASP.NET: Connecting to database (ASP.NET)
- Connecting ASP to Ms Access (ASP)
- Problems using a php generator (PHP)
- database application on cd (JavaScript / DHTML / AJAX)
- Registration and Login scripts using VB and Oledbconnection to Access Database (ASP.NET)
- Connecting to MySQL (MySQL)
Other Threads in the Database Design Forum
- Previous Thread: basic question
- Next Thread: how can put hotel reservation engine on a website
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Database Design Posts
- Today's Posts
- Unanswered Threads
