Dynamic HTML Using

coordinatedcapableSoftware and s/w Development

Nov 4, 2013 (3 years and 7 months ago)

49 views

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

1

Dynamic HTML Using

Active Server Pages (ASP)

Alberto Espinosa

MIS 45
-
870

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

2

Static HTML and

the HTTP Protocol

HTTP


designed as a doc fetching protocol:


1. User clicks on URL with HTTP protocol

2. Browser requests HTML page to web site

3. Server finds/sends HTML page to client
“as is”

4. Client’s browser interprets HTML and
presents page to user

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

3

Dynamic HTML


Overcoming HTTP Shortcomings


HTML is static: text (info) and tags (formatting)


Corporate information is dynamic


If info changes


HTML pages need to change


How to customize displays for different users?

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

4


Dynamic HTML


2 Solutions to Static HTML


1. Client side scripting

Further processing
by browser

after page is
received


2.

Server side scripting

Prior processing
by web server

before page is sent

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

5

Client Side Scripting


Useful for interactive use with user


Browser needs to support the scripting
language used


Most popular:
JavaScript, VB Script


Embed scripts in HTML page



HTML stuff



<SCRIPT LANGUAGE = “JavaScript”>






script code …………



</SCRIPT>


More HTML stuff

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

6

Server Side Scripting


Useful to interact with data stored on the server
(databases, images, etc.)


And when centralized processing is needed


Sever needs to support the scripting language


Most popular:

CGI


Perl (Unix)

ASP


VB Script or JScript (Windows)


2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

7

Server Side Scripting
(cont’d)


Embedded scripts in HTML page


HTML code


<% (marks the beginning of ASP script)




………..……….



ASP script code


………………....


%> (marks the end of ASP script)

More HTML code


<% more ASP %>

Etc.

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

8

Dynamic HTML with ASP

1. Client clicks on URL with .asp file

2. Web server notices file extension .asp

Note: Only Windows NT IIS web server supports ASP

3. Server then processes .asp file

4. Server creates a new HTML file

5. Contains all original HTML stuff

6. Plus processing results from ASP code

7. Dynamically formatted as HTML

8. Server sends the new HTML file to client

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

9

Dynamic HTML with ASP

<H3>Welcome to my page</H3>

<H2>Here is my product list</H2>


<% ‘Start ASP code


Open a database connection


SQL queries to database


Copy results to a record set


Display records one at a time


Close database connection

%> ‘End ASP code


<P>Thank you very much for
inquiring about our products

<H3>Welcome to my page</H3>

<H2>Here is my product list</H2>


<P>

<B>Product Price</B>

<HR>

<P>Hammer ……... $8.50

<P>Pliers ……….… $7.79

<P>Screwdriver ..… $4.50

<P>Power Drill ….. $49.99

<P>Chainsaw …… $95.95

<P>Wrench ……….. $6.50


<P>Thank you very much for
inquiring about our products

ASP code on server

HTML code sent to client

Same

Same

Dynamically
generated
by ASP

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

10

ASP, SQL, Databases, and HTML

Web Server

MS IIS Web Server





Client Browser

Internet Explorer

Netscape Navigator

HTML

ASP

Databases

HTML

Request

HTML doc

Fetched

ASP

Request

SQL Query

Query
Results

Dynamic

HTML

Produced

On
-
the
-
Fly

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

11

Server Requirements


You can’t do ASP on Andrew


ASP requires an MS Windows
environment


NT Server with Internet Information Server


NT Workstation with “Peer Web Services”
(10
-
user connection limit)


Win95/98 with Personal Web Server

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

12

Common Uses of ASP


Register as a client (insert a record in database)


Products & services listing (query database)


Place orders (inserting records in database)


Track order status (query database)


Tech support (query a knowledge base)


Fill out a survey (insert record(s) in database)

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

13

Very Common


Feed data

to an ASP script using HTML forms


This is typically what the
“Submit”

button does


HTML forms contain items data with
field names


Which are passed to ASP scripts for processing


Often used to embed an
SQL

command


To query a database (product list, etc.)


Or to insert records in a database (orders, etc.)

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

14

Example
--
ASP on Server (Query)

<% Set conn = Server.CreateObject("ADODB.Connection")


conn.open "orders "


Set rs_customers = Conn.Execute("SELECT clientID, clientName,_


shipAddress, telephone FROM clients") %>


<IMG SRC="music22.gif"><B>Alberto's Music Instruments, Inc.<p>

<TABLE BORDER="0"><B>Customer List</B>

<TR><TH>ClientID</TH> <TH>Client Name</TH> <TH>Shipping
Address</TH> <TH>Telephone</TH></TR>


<% do while Not rs_customers.eof %>


<TR><TD><%= rs_customers.Fields("clientID") %></TD>


<TD><%= rs_customers.Fields("clientName") %></TD>


<TD><%= rs_customers.Fields("shipAddress")%></TD>


<TD><%= rs_customers.Fields("telephone") %></TD></TR>

<% rs_customers.MoveNext


loop


Conn.Close %>


</TABLE></BODY></HTML>


2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

15

Example
--
Response to Browser

<IMG SRC="music22.gif"><B>Alberto's Music Instruments, Inc.<p>

<TABLE BORDER="0"><B>Customer List</B>

<TR><TH>ClientID</TH> <TH>Client Name</TH>


<TH>Shipping Address</TH> <TH>Telephone</TH> </TR>


<TR><TD>josee</TD>


<TD>Alberto Espinosa</TD>


<TD>Schenley Park, GSIA Building, #20</TD>


<TD>412
-
268
-
3681<BR></TD> </TR>


<TR><TD>sandy</TD>


<TD>Sandra Slaughter</TD>


<TD>5000 Forbes Avenue, Pittsburgh PA 15213</TD>


<TD>412
-
268
-
3681<BR></TD> </TR>


etc.


</TABLE></BODY></HTML>


2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

16

Example
--
ASP on Server (Data Input)

<B>Customer Registration</FONT></B><P>



<FORM ACTION=


"http://softrade
-
11.gsia.cmu.edu/data/
customerSubmit.asp
"


METHOD="POST" ENCTYPE="x
-
www
-
form
-
urlencoded">


<TABLE>

<TR><TD>Please enter a customer ID (4 to 16 characters)</TD>


<TD><INPUT TYPE="text" SIZE="35"
NAME="CustomerID"

VALUE=" ">


</TD></TR>

<TR><TD>Please enter your name</TD>


<TD><INPUT TYPE="text" SIZE="35"
NAME="CustName"

VALUE=" ">


</TD></TR>

etc.

</TABLE>


<INPUT
TYPE="submit"

VALUE="Submit"></TD></TR>


</TABLE></FORM></BODY></HTML>


2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

17

Example
--
ASP on Server (Data Input)

<!
--

customerSubmit.asp
--
>

<HTML><BODY><CENTER>


<% Set conn = Server.CreateObject("ADODB.Connection")


conn.open "orders”


customerId = Request.Form("customerId")

custName = Request.Form("custName") …. etc.


Set rs = Conn.Execute("INSERT INTO Clients (ClientID, CustName, _


etc. VALUES ('" & customerID & "', '" & customerName & "', _


'" & shippingAddress & "', '" & phone & "') ")


Conn.Close %>


Your Customer Registration has been processed!<BR>

Thank you very much<BR>

<A HREF="http://softrade
-
11.gsia.cmu.edu/data/orders.html">


Back to main page</A>&nbsp;&nbsp;&nbsp;


</CENTER></BODY></HTML>


2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

18

2/22/00

J. Alberto Espinosa
--

CMU/GSIA
MIS 45
-
870

19

IT Exercise III


A restaurant food delivery service company


Participant restaurants subscribe to service


Company developed a web site using
ASP

to let:

1. Restaurants

subscribe and enter menu items

2. Customers

place orders


Web server runs on Windows NT with IIS


Participant restaurants need to produce their
HTML

pages with order
forms


Which don’t need to run on IIS (nor ASP)


But need to
feed data

to existing ASP scripts