Excerpt

Now would be a good time to add sample data to the database. You'll need to add data to the Category, Artist and Stock tables. The constraints we added above should prevent you adding an item to the Stock table and giving it an ArtistId which does not exist in the Artist table and similarly for the CatId and the Category table.

Shown below is some sample data to get you started. With SQL Server 7.0 comes the ability to type your data directly into the table. For example, to type data into the Categorytable:

We've included some example data here to get you started, but please do add some more of your own favorite records. A music shop with only five records for sale is a poor one indeed.

Building the Basic Website

We have completed the foundations of our database. We will create the stored procedures as we need them. Our next task is to create the HTML and scripting for the MusicMad web site.

Creating the Initial Frameset

The site consists of two basic frames. The top frame contains a menu bar with links for browsing the site and remains in view at all times. The bottom frame is where the action is at and will be used for displaying all the other pages on the site.

There are two client-side JavaScript functions inside the page. The first returns the value of the cookie whose name is passed as the function's parameter. As discussed in further detail in Chapter 18, document.cookie returns all the cookies for that web site but does not provide a way of retrieving just one particular cookie. The string returned by document.cookie takes the format cookiename=cookievalue; cookiename=cookievalue; and so on…

The second function handles the frasetMain_onload() event. As the web site relies heavily on cookies, particularly for the shopping basket we need to check the user has cookie's enabled. Though this site is designed only for cookie supporting browsers, they can be disabled under a browser's security options. We need to check for this and if the user accesses a part of the site which requires cookies then we will inform them they need to be enabled to use the web site.

Methods for checking if cookies are enabled vary from browser to browser, but I have used one which works for version 3 browsers and above. We set a global variable in the window_onload event of the top frame that we can access later from child windows.

<HTML>
<HEAD>
<SCRIPT language="JavaScript">
var cookiesEnabled = false;
// Retrieves particular cookie
function getCookie(cookieName)
{
   var cookieFoundAt;
   var cookieValue;
   // find start position in cookie string
   cookieFoundAt = document.cookie.indexOf(cookieName + "=");

   if (cookieFoundAt < 0)
      {
         cookieValue = "";
      }
   else
      {
         // move to actual start of cookie's data
         cookieFoundAt = document.cookie.indexOf("=",cookieFoundAt);
         cookieFoundAt++;

         // find end position of cookie's data
         cookieEnd = document.cookie.indexOf(";", cookieFoundAt);
         if (cookieEnd == -1)
            {
             cookieEnd = document.cookie.length - 1;
            }
         cookieValue =document.cookie.substring(cookieFoundAt,cookieEnd);
      }
   return cookieValue;
}
// Check whether cookies enabled
function frasetMain_onload()
{
   document.cookie = "Enabled=true";
   var cookieValid = document.cookie;

   // if retrieving the VALUE we just set actually works
   // then we know cookies enabled
   if (cookieValid.indexOf("Enabled=true") != -1)
   {
      cookiesEnabled = true;
   }
   else
   {
      cookiesEnabled = false;
      alert("You need to enable cookies on your browser to take advantage of our
             online ordering");
   }
}
</SCRIPT>
<TITLE>Welcome to MusicMadness.Com</TITLE>
</HEAD>
<FRAMESET BORDER=5 ROWS="62,*" NAME="frasetMain" onLoad="frasetMain_onload()">
   
   <FRAME SCROLLING="NO" SRC="top_menu.asp" NAME="fraTop" NORESIZE>
      
   <FRAME SCROLLING="AUTO" SRC="home.asp" NAME="fraMain" NORESIZE>
</FRAMESET>
</HTML>

With this page completed you need to save it as MusicMad.htm. To make life easy for yourself create a new directory called MusicMad and put it in there. This is where we will put all the files for this project. You may also wish to make this a virtual directory on your development machine and share it as MusicMad for easy access during development and testing. Note that all of these files are available as part of the source code download for this book from http://www.wrox.com and that the entire of this will be running as a demo from http://rapid.wrox.com/books/270x.

Displaying A List Of Categories

To allow the user to browse the available music categories we need to dynamically produce a list of categories contained in the database table Category.

To retrieve the data from the database we must create a new stored procedure and name it ListCategories:

Right-click the newly created stored procedure and select Manage Permissions from under the All Tasks menu. Tick the EXEC check box for MMCustomer as shown below and then clickOK to close the dialog box.

Affordable, reliable
web hosting solutions

Sample Data

Building the Basic Website

Creating the Initial Frameset

Displaying A List Of Categories

Affordable, reliable web hosting solutions

Sample Data

Building the Basic Website

Creating the Initial Frameset

Displaying A List Of Categories

Affordable, reliable
web hosting solutions