Example: Logging In and Frames

This is a very small demonstration of how to enable an application to login to a database and also use frames at the same time. All the frames are logged in because login happens before the frames are generated.

Below is a schematic of the project that you will build here.

When you look at the listing of the HTML of the login screen on the next page, you will notice that the two items that are returned by the form are given the names "SALOGIN" and "SAPASSWORD". These may considered as being keywords for Sapphire/Web; the values associated with them are retained by the server application and used automatically whenever a username and password are subsequently required. Other settings in the options editor - specifically Use Common Login and Use Native OS Login - determine which login requests should be satisfied by these strings and which should be passed out to the user.

Preparation

Make sure that the keyword SRC is in your /config/SaKeyWds.ini file. It must be on a line of its own, and in capitals.
Create a new project in Sapphire/Web - it is called FrameLogin here.
Open the Options Editor and select the Project section. Ensure that the option "Secure Login" is set to "True", so that an encrypted login and password are sent to the browser and used for all database requests.

Login Screen

Create a new document (home.html). For a template, use loginform.html from the list of available templates. The code is this, although we have added a title.

<HTML>
<HEAD><TITLE>Frame Login Demo</TITLE></HEAD>
<BODY>
<H5>Please Login:</H5>
<FORM ACTION="loginform" METHOD="post" >
<INPUT TYPE="INPUT" NAME="SALOGIN" VALUE=""><BR>
<INPUT TYPE="PASSWORD" NAME="SAPASSWORD" VALUE=""><BR>
<INPUT TYPE="SUBMIT" VALUE="Submit">
<INPUT TYPE="RESET" VALUE="Reset"><BR>
</FORM>
</BODY>
</HTML>

Frameset Form

Create this form, called frameset.html (use the default style), which will be linked to by the login form, and create your frameset in it. You use activators instead of HTML URLs to define the HTML documents in the frameset.

<HEAD>
<TITLE>Frame Login Demo</TITLE>
</HEAD>
	<FRAMESET rows="20%,*">
		<FRAME src="topframe" name="topframe">
		<FRAME src="bottomframe" name="bottomframe"> 
	</FRAMESET>
<body>
	<noframes><center> 
		Sorry.<br> This page has frames<br>
	</center></noframes> 
</body>
</html>

Example: Logging In and Frames

Preparation

Login Screen

Frameset Form

Display Forms

Bindings

Results