How to Set Up a Web Database
- 1). Create a database of information that you wish to publish to the web. Use any database development system you prefer, provided it contains programming hooks that can be used to connect to middleware you will choose later.
- 2). Write the HTML pages that will act as the front-end of your website. Leave blanks or nonsense words where you expect database information will be used later. Many people use "lorem ipsum," a stock paragraph of nonsense Latin, for this purpose.
- 3). Select middleware software you can use to tie your web server with your database. Most web servers and database packages have several middleware packages from which you may choose. You will be doing much of your web development work in this middleware package, so choose one based on its speed and flexibility, as well as your familiarity with the language it uses for programming and control.
- 4). Write the middleware programming code which replaces the nonsense text in your HTML pages with data populated from the database. Most middleware development is done one HTML page at a time. This allows you to check for errors as you go, and then reuse that programming code as necessary on subsequent pages you write.
Source...