How do you connect a site to a database?

Hi Mohammed,

This post discusses this briefly:
http://www.microsofttraining.net/post-11275-dreamweaver-cs.html

Basically you will need a database set up on your hosting account (server). Most servers come with at least one database, check with your hosting company. If you run your own server or intranet, you can buy or download the database and install it on your server. One of the free ones is MySQL. You can also use Microsoft Access as your database, although I would recommend using MSSQL or MySQL instead as they are a bit more flexible and/or open-source.

You'll also need to know a server-side scripting language to bridge the HTML and database, such as PHP, ASP, .NET or CGI etc. There is a good tutorial about getting started with MySQL and PHP here: http://dev.mysql.com/tech-resources/articles/ddws/

For more info, you can do Google search on your chosen server-side scripting language, and you should find many tutorials about getting started. There are also many books on the topic in most book shops.

I hope this helps you. Good luck attaching a database to your web site... it really does open a lot of potential and possibilities for your site.

Regards, Rich