Laboratory Instructions & Incubator Guide

(1)

PROJECT: RO/03/B/P/PP175006

TITLE

:

New Forms of Learning & Basic Skills

for Advanced, inclusive Lifelong eVET in

Internet Generated Occupations

Laboratory Instructions

&

Incubator Guide

eCommerce/

eBusiness

YEAR 2006

(2)

eCommerce/eBusiness Incubator

Internet Connection, Server for Internet eCommerce, Business to Client (B2C) commerce oriented Incubator

Wireless eCommerce Application, Multimedia connection between clients, Complex services for eCommerce, Mobile eCommerce

(3)

Laboratory Instructions for eCommerce & eBusiness

(Incubator Guide)

Parent institution: UE-B, Bucharest, Romania, 22 Franceza St., Postal Code 030104

Authors: Ciprian-Antoniade Alexandru, Member of Teaching Staff, Fax: + 4021 315 77 30; e-mail: alexcipro@yahoo.com Accessible for consultations daily from 9.00 to 11.00.

CONTENT OF THE eCOMMERCE/eBUSINESS INCUBATOR GUIDE 1. Hardware Description of Laboratory

2. e(places of the great resorts)

3. Low cost or free e-Hosting of the e-Stores

4. Practical ASP software programming for e-Business & e-Commerce 5. How to develop ASP software for eBusiness/ eCommerce

6. Testing of eCommerce / eBusiness applications 7. ASP case study

8. Software development: practical applications for representative B2C model – The Microsoft based solution.

9. Library with important software package

1. eCommerce/eBusiness Incubator - Hardware description

External Modem for Dial-Up and remote administration ADSL Modem 2.1. PC Office 1. Server (Linux) - Router - FireWall - Web - Mail server - MySQL 3. Imprimantă laser Multifuncţională

(Print, Scan, Copy, Fax) UPS WebCam 2.2. PC Multimedia Video Proiector SWITCH Access Point WireLess 2.3. PC WireLess

(4)

2. e(PLACES OF THE GREAT RESORTS)

Creation and hosting of the Web site becoming day after day a common thing and also an easy job for a large number of people. The difficulties occur to find the best solution for creating web sites and hosting them. These mean that we need a balance between effort, cost and the money that we can get from that activity.

For a good understanding for the necessary steps witch you must follow for creation, then to host your eStore, we present some links from where you can start with your work.

However, we recommend, reading the entire lesson and after that, going to the presented resources. The following links are just a short list of possibilities you can have on global Internet resources. You can follow the links presented bellow to start create and host your web site.

http://www.xoom.com http://www.avahost.net http://www.hypermat.com http://www.siteburg.com http://www.catalog.com http://www.geocities.com http://www.3x.ro http://www.freewebhosting.ro

3. LOW COST OR FREE e-HOSTING OF THE e-STORES

3.1. Starting with free web hosting

Most free Web Hosting Services offer varying degrees of implementation of servers and software you can use at the creation of web pages. Some of them offer possibility to have an actual domain name or other require to have a sub domain under their primary domain (i.e.

http://primarydomain/yourname/..).

When we speak about what type of programming language or scripts accepted by a free web host we see diversity from simple HTML to ASP or PHP. Other one accepts CGI scripts while others do not.

The amount of disk space witch you can use to post the web site is also important. Usually web hosting are oriented to the persons and you must find proper ePlace to accept an eStores, eCommerce or eBusiness.

3.2. Web Hosting Features

General Features for Web Hosting:

50 Mb Web Storage

1 Gb Monthly Transfer

subdomain yourname.primarydomain.com

domain name yourname.com

FTP access

(5)

Extended Features for Web Hosting:

> 1 Gb Web Storage

> 50 Gb Monthly Transfer or unlimited

free subdomain yourname.primarydomain.com

domain name yourname.com

more domains in one account

Web based Control Panel

> 5 E-mail accounts

E-mail autoresponders

SMTP Mail Server

Personal CGI scripts

Preinstalled CGI scripts like forum, chat, shopping cart, guestbook

PHP, Perl, MySQL

Microsoft Access Database

SSL (Secure pages)

More than one FTP accounts

HTML Editors Support (i.e. FronPage)

Non-Stop Support (24/7/365)

Recommended Features for Web Hosting, also used in the study case presented in present lesson:

> 500 Mb Web Storage

> 5 Gb Monthly Transfer or unlimited

free subdomain yourname.primarydomain.com

ASP, PHP, Perl

MS Access, MySQL

3.3. Evaluate your needs and Select an ePlace

From the beginning you have to do an evaluation of resources you’ll need for the web site. We suggest to keep in mind as main topics:

Domain – it’s good to get yourself a domain name. The name it’s necessary to be simple and business oriented. (i.e.: for a book online library:

http://www.YourNameBookOnLine.com). You can register your domain at the

http://www.register.com) at $30 cost per year. In every country you can register a domain specific, for example: www.YourName.it for Italy or www.YourName.ro for Romania and so on. Into the Internet there is no difference and both after dot termination are fully available. If you choose a .com termination cold means that you try to have world wide customers otherwise you are focused on national customers.

Disk space – this is the total disk space for the entire site, including text, images, sound, movies. Also if you use databases to keep record of your clients, order, bill or anything else take into consideration growing of those files. It’s better to have an amount of 50% free disk space free from maximum allowed.

Traffic – some company witch offer free web host, limit the traffic per month from 1 GB to 4 GB. If your site is based on text with few pictures and no sound or movies, will be enough, but if you offer to clients, from your web site, melody, pictures, movies or books in on-line format, than maybe 50 GB limits of traffic is more appropriate. For example, a 50K page and 10,000 page views you’ll need 500 MB monthly traffic. When you evaluate a web hosting keep watching at the possible upgrade of traffic at

(6)

Databases – for an eStores, usually are used various databases. Most used databases are MySQL and MS Access. Some hosting offer limited databases engine, (i.e. 1 or 2 database in MS Access).

Customer Support – lack of customer support can be a problem for you. Some Web Hosts have support by phone and also vie email, but other ones just through by email, witch is usually slower.

Bank payments – for accepting credit cards you will need a merchant account. This is practically an account that allows you to process credit card payments from customers. In the same time the money are deposited into a bank account. The price per month for merchant is between $25 and even $800. (i.e.: RodopiPaymentGateway.com is one of the lowest cost leader at only $20 per month. Before making a contract please verify this information).

Note: You are not being able to register a domain name until you’ve decided on a server. It’s good to find a domain name while you’re looking for a host server. You must register your domain name immediately upon contracting for services.

After evaluation of needed resources you may decide to place the eStores Web Site on free web hosts or low costs hosts. From other experiences we can recommend to start with free eStores Host and then migrate on quality and cheap paid web hosting.

4. PRACTICAL ASP SOFTWARE PROGRAMMING FOR BUSINESS &

e-COMMERCE

4.1. Integrated Development Environment (IDE)

An Integrated Development Environment allows you too easily develop different objects. Working into an IDE you are more efficient and quick, so that bring the product to market much faster. Another important issue, solved with success by an IDE, is to debug an application and this work made by your self, without the adequate tools, cold take more time than you wrote application itself. Common characteristics are specific for most of IDEs:

internal browser,

built in FTP client,

syntax recognition and highlight,

file/server explorer,

function/parameter/tag completion and

code explorer.

Microsoft Visual Studio .NET

Dot NET technologies is very appreciate one because offer multiple advantage to developers. Multiple tools are built in and also application samples or different objects are simple ready to use into your Web based application. It provides a highly productive, standards-based, enterprise-ready, multi-language environment that simplifies application development. Microsoft .NET enables developers to make use of their existing skill set, facilitates integration with existing software, and eases the challenges of deploying and operating Internet-scale applications.

(7)

Visual Studio .NET is the comprehensive tool for rapidly building Microsoft .NET–connected applications for Microsoft Windows® and the Web. [ 1.] With this IDE we can use ASP .NET, an environment for building smart client applications (Windows Forms).

Visual Basic .NET 2003 is included in Visual Studio .NET and delivers "Visual Basic for the Web." Using Web Forms, you can easily build true thin-client Web-based applications that intelligently render on any browser and on any platform. The enhanced HTML editor delivers IntelliSense statement completion for HTML tags, and the separation of user interface (UI) from code enables more efficient team-based development. [ 2.]

With Visual Studio .NET 2003 you can build applications for PCs and for almost any mobile device, like: Pocket PCs, Tablet PCs and mobile phones.

Visual Studio .NET 2003 are available in four editions:

Visual Basic .NET 2003 Standard edition,

Visual Studio .NET 2003 Professional,

Visual Studio .NET 2003 Enterprise, and

Visual Studio .NET 2003 Enterprise Architect editions 4.2. Editors

For developing web application is not necessary to write only into the dedicated environment like IDE, described above. Small web application can be developed only with usually text editors.

The most popular editors are from Microsoft and Macromedia. From Microsoft cold be used:

Notepad

WordPad

Word

FrontPage

Macromedia have Dreamweaver software witch can be used with success to write your application for a small and medium eStore.

On the Internet are a lots of HTML editors (1st Page 2000, CoffeCup HTML Editor, etc.), but it’s better to choose one witch have syntax recognition and highlight. These facilities help the developers to find more quickly syntax errors and organize better the text.

5. How to develop ASP software for eBusiness / eCommerce?

Developing a application or a web site for eCommerce and eBusiness is more responsible because you are directly involved with the client through the selling and deliver different products or services and collect the money in exchange of invoice.

Working, in fact, continuously with money, the security issue is very important and the source code of your application must be safe, clear and easy to debug. From this important point of view you have to take into consideration the recommendations.

(8)

5.1. To comment the code

The programming code for a web commercial site cold be small for the beginning, but will grow in the same time with your experience in developing applications. The complexity of your ebusiness cold also brings you into the situation to have a lot of source code.

Commenting the code with different remarks helps you to remember after a period the functionality of a specific line or one of the modules.

We have two different comments into our code:

Html comments,

ASP comments

Into a HTML syntax use  to finish one.

Between a ASP tags is more simply. You can start a comment anywhere, at the beginning of the line or into the line.

<html>

<title> IT eStore </title>

<!-- this is a beginning of the commentary that module create header for the entire web site name of the file is header.asp

this the commentary is ending --> <body>

...

<html>

<title> IT eStore </title> <body>

<%

‘ this is a commet between a ASP tag

Response.Write “testing an comment ASP code” ‘ this is a comment at the end of the line %>

...

5.2. Programming in modules

Mainly are two ways to programming:

Linear programming and

Module programming

The linear programming means that the source code is build into one file and the code are running step by step, from beginning of the file through the end of the file without major step. The web application and specially, the eBusiness web sites contain many links and functions witch conduct to a very big file in case you use simple programming. This strategy makes a lot of difficulties to debug your application and more than that trouble in modify and upgrade the web site.

Bellow you can see the difference between showing products into the web page with both methods.

(9)

Simple source code:

In module programming, for this example, we make two files. One generally named:

default.asp where are the generally code and one for showing products: showproducts.asp.

In the default.asp file we have generally code for creation the page and the unsorted list of

products are created dynamic in showproducts.asp file.

The main advantage of this method is for updating automatically the page. When we have few products like in our example maybe you say is more easily first method and you are right. But thing about to an eStore with more that one hundred products witch specified also the characteristics for the products. In this case the modules method are sure more efficiently because you modify just the access database and the page are build automatically without interfering.

<html>

<title> IT eStore - Products</title> <body>

<h2>Our products category are:

<ul> <li>Monitors</li> <li>HDD</li> <li>CD/DVD</li> <li>Printers</li> <li>PDAs</li> <li>Scanners</li> <li>Faxes</li> </ul> </body> </html> Default.asp <html>

<h2>Our products category are:

</body>

</html>

Showproducts.asp <ul>

<%

' Open the Database Connection

Set Conn = Server.CreateObject( "ADODB.Connection" ) Conn.Open "eStore"

sqlString = "SELECT id, name FROM Products ORDER BY name" SET RS = Conn.Execute( sqlString )

WHILE NOT RS.EOF %>

<li> <%=RS( "name" )%> </li> <%

RS.MoveNext WEND %>

(10)

5.3. Programming guidelines

Planning up first

On a simple web page is not a problem to use ASP script. The complex problem could appear when you have to do a eStore. A good planning save you a lot of time in the developing even you loose some with the making a plan.

On other hand you can identify from the beginning the resources (financier, human resources, logistics), the administrative problems, legal issue and other which could cost you a lot of money latter or even your business.

For programming is good to have a plan for:

design – here we are not interesting only in the how the web site will look, but specially how the proposed design will be constructed and how will be displayed, with what programming code;

futures of the web site – the futures must be careful discussed with the client and must be stated into the contract or in some annexes to the main contract. You could loose money because the client ask every day something new which consume time and money for you. Most dangerous is that this modification of the futures push you to don’t finish the at the promised time;

functionality of the entire eStore, step by step (how the clients will buy, how will pay, how make commands) from the point of view of programmers not from commercial aspect.

Create your own tools

At the beginning you have not too much code programmed. With passing the time is better to create a library with most used function and useful parts of the code. This library could always be used partially or entirely to otfer eStore or other web pages that will be create by you in the future.

Other recommendation is regarding about the administrative tools for manage the databases. Also, there are on the software market some tools which make you manage faster the databases, but almost for all you must pay some money. Still is better you have your personalized tools. Some of the tools, after some revision is possible to become also a product for your clients.

Reusability of the code

Reusing the code is most important aspect in the programmers job. Many parts of the eStore can have same functionality and is not recommended to write the code again and again, each time you have need.

Reusability comes with the using of the function which contain the code that must be executed in different places of the eStore. Using again the respective code is simply, just call the function.

In the same time using re-used code like function use we to produce more robust application and much maintainable solution. In general the ASP is not an unstructured language and give you a large perspective and ways to do things. This also be with a bad side because if you are not ordered the chaos will dominate your application.

(11)

Connect to the Access databases

For connection to the database, firstly, we define the driver and we build a string connection:

strconnect="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("estore.mdb")

Now, we can open a connection object through the database.

set dbconn=server.createobject("adodb.connection")

Opening effective the database is easy:

dbconn.open strconnect

For closing the database use the command:

dbconn.close

And, for free the memory from the connection object we will set it with nothing.

set dbconn=Nothing

Show the records from a table

The main steps for showing the records from the table are:

open a connection;

make a selection;

open the HTML table where the fields are completed;

go step by step from each record from the database and build the HTML table for the screen;

close the connection;

close the HTML table.

After you connect and open the database like previous example, make a selection:

strSQL="SELECT Name, Price FROM Products” set myrs=server.createobject("adodb.recordset") myrs.open strSQL, dbconn

Open the HTML table where the fields will be completed.

response.write "<table border=’0’ width=’80%’>"

Go step by step by the database.

do while not myrs.eof

' for each record, write a row from the HTML table

response.write "<tr><td>" & myrs(‘Name’) & "/td><td>” & myrs(‘Price’) & "</td></tr>”

‘ go to the next record myrs.movenext

loop

Close the connection.

myrs.close set myrs=Nothing

Close the HTML table.

(12)

Now, let’s see all example in a single file:

As you can see we use a function named showrecords to do all jobs necessary to show the records from one table on web browser.

The function has a generally usability because the connection, the tablename, and those two fields can be variable.

This function can be modified to obtain more complex situation by selecting just some records introduced a criteria or with many fields.

default.asp <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html>

<h2>Our products are:</h2> <%

‘define and build a string connection

strconnect="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("estore.mdb") set dbconn=server.createobject("adodb.connection")

dbconn.open strconnect ‘build the HTML table

call showrecords(dbconn, “Products”, “Name”, “Price”) dbconn.close set dbconn=Nothing %> </body> </html> <%

function showrecords(dbconnection, tablename, field_1, field_2) ‘select the records and open a recordset with this selection strSQL="SELECT “ & field_1 & “,” & field_2 & “ FROM “ & tablename set myrs=server.createobject("adodb.recordset")

myrs.open strSQL, dbconnection ‘start the HTML table

response.write "<table border=’0’ width=’80%’>" ‘build the table

do while not myrs.eof

' for each record, write a row from the HTML table

response.write "<tr><td>" & myrs(‘Name’) & "/td><td>” & myrs(‘Price’) & "</td></tr>” ‘ go to the next record

myrs.movenext loop

‘close the connection myrs.close

set myrs=Nothing ‘close the HTML table response.write "</table>" end function

(13)

6. Testing of eCommerce / eBusiness applications

Finally, we are in the front of the last big step to finish our work. We need to evaluate:

the impact of our site in the real eBusiness world not only in our minds and imagination;

if is our site really attractive for the clients;

if is our site ready to publish on the Web, and so on.

Now, you must understand the importance of testing the just finished site and, also, how to do this. The site shall be a public place and it will represent our daily job.

Testing operation must be in accomplishing with the purposes of job:

Situation 1st: we design the Web site and we must to host it at an ISP’s computer.

Situation 2nd: we design the Website, we upload it on own computer and the computer must be collocate.

Situation 3rd: we are ISP and we design a Web site to present our collocation and hosting offer/other IS.

Situation 4th: we are ISP and we have our client club.

Should be more situation but we will analyze only the nearest 4 situation.

Before the site become public you must verify all the facilities from your eStore. All links must be available, the database up to date and payment systems verified (in collaboration with bank entity).

7. ASP Case Study

An eStore Web site is possible to be created on different platform create by various companies. In our case study we start to create an eStore developed with ASP (Active Server Pages) - Microsoft technologies. You can adapt this case study to your specific needs and use it to make some money on the Internet.

Case study includes:

Witch is the technologies used to create an eStore.

Objectives and requirement for an eStore 7.1. Technologies used to create an eStore

A commercial electronic store available through the Internet contains:

Operating system

Web server

Database support

Email

Microsoft Windows XP Professional

To create an eStore, firstly, we need an operating systems witch allow us to run Web application with ASP and MS Access. The cheapest one is Microsoft Windows XP Professional and is good to start your commercial web sites. Usually this solution is good for small sites with reduced traffic. Anyway Windows XP Professional can be used with great success cu create and test your application. So, the first step is to buy this operating systems

(14)

and to install it on computer. The smart way is to buy it in the same time with the computer because the OEM software price is about 50% from the full price.

Microsoft Windows Server 2003

For a good eCommerce web site based on ASP is necessary to install on your computer Windows Server 2003. This system allows you to offer on the internet a strong and secure application for your clients.

Medium web site application can use standard edition of Windows Server 2003. Once the number of clients is growing to thousand you can migrate on Windows Advanced Server 2003.

Personal Web Server

For a small cost for developing a web site you can use Personal Web Server. It works on Windows 95, Windows 98 or Windows NT Workstation. It can be downloading for free from the following address: http://www.microsoft.com/windows/ie/pqs/default.htm. Personal Web Server doesn’t work with many users, but it can be used for developing and testing the web sites before uploading the files to the host provider.

Internet Information Server (IIS)

With IIS your site will be active on Internet and allow hundreds of users to access your eStore. The numerous of company use this technologies for their electronic commerce (i.e. http://www.dell.com).

Install the IIS from Control Panel with “Add or Remove Programs”. From the next window, on the right side, you must pick up “Add/Remove Windows Components” option and the image is:

(15)

Check the option with Internet Information Services (IIS) and stroke the Details button. The Details screen of IIS is:

Fig 2. Installing subcomponents of IIS on Windows XP Professional or Windows Server 2003 For web server you must check the World Wide Web Service and also you can install the other components for feature use.

Microsoft Access

Any eStore worked with databases for keeping records about products, clients, orders, bills or other usefully information. The present study case will use Microsoft Access witch is component software from Microsoft Office.

Microsoft Access is database software for personal use. It’s not a client/server database engine like SQL Server. So we use Access for creating a database and testing the web site on our local computer. After the site work properly we upload the access file to the ISP.

ODBC set-up

Set-up your ODBC from Control Panel choosing Administrative Tools. This make link between your database and Web site.

(16)

Click twice on “Data Sources (ODBC)”, than the tab “System DSN”.

Click “Add” button, from the list of driver pick up “Microsoft Access Driver (*.mdb)”, click ‘Finish”.

(17)

Click on “Select” button and browse and pick up the file eStore.mdb from c:\Inetpub\wwwroot where you save it when create with MS Access (see below subchapter). Type the name eStore in “Data Source Name” and than “OK”.

7.2. Objectives and requirement

The main objectives for our eStore are:

Virtual Shopping Cart,

Products catalog,

(18)

8. Software development. Examples: the practical applications for representative B2C

model. – The Microsoft solution.

8.1. Form design

We build a classic design for our web site.

The Web page look mostly like in the picture below. top.asp main.asp L E F T . a s p down.asp

(19)

Like all the web pages, our page starts with an section delimited by <head> tag. This section include the tile, the style files declaration, used into the eStore and some description. We place all this information in the file header.asp.

After the header declaration is time for top part of the web page. This is representative and important regarding the aspect of the site. If we could not tell you about what design can use, we can show you a little example about how can be constructed the top.asp file. Mainly this file contain the logo of the eStore.

The down.asp file is on the end of the project, but we will explain here because is simple and than come the most important part of the web page. So, down.asp contain, in our example, just the copyright sign, year of construction and the name of company. In this section is better to study other web pages and you will find other imformation:

header.asp <html>

<head>

top.asp

<td>

</td> </tr> </table>

Term and conditions of use;

Contact information;

Confidentiality terms;

General menu;

Trafic information for own counter or from third party.

Into the middle section we need two section. One on the left which contain the menu, so is much little than the second section where we place the content of the page.

down.asp <hr>

middle.asp

(20)

main.asp page will show when somebody access the web page, so only on the beginning of surfing. When pick-up a link form the left-menu the main.asp page will be changed with the respective page.

For instance if we have in menu a link named <HDD>, coming for hard drive for computer, by selecting them pe main.asp page will be replaced by hdd.asp, and so on.

In hdd.asp page we have again the left.asp file and in the

Now we describe the biggest file from our project: default.asp.

This page is the start page when somebody access the eStore, delivered to the Internet by your IIS server.

The code start with a request of a selection made my the surfer. Because for the first time the selection is not made will be displayed the page main.asp.

hdd.asp

</td> </tr> </table> </td> </tr> </table> default.asp <% vparam = trim(Request("category")) if vparam <> "" then if isnumeric(vparam) then

Set Con = Server.CreateObject( "ADODB.Connection" ) Con.Open "estore"

Set RS = Server.CreateObject( "ADODB.Recordset" ) RS.ActiveConnection = Con

RS.Open "SELECT * FROM Category WHERE cat_id=" & vparam if not rs.eof then

vcatname = RS("cat_name") RS.close con.close else vcatname=vparam end if Set RS = nothing Set Con = nothing else

vcatname=vparam end if

end if

select case vparam case ""

estoreTitle="IT Store Home Page" estoreDesc="IT Store Home Page"

(21)

default.asp (continue) case "1"

estoreTitle="IT Store - " & vcatname estoreDesc="IT Store Home Page"

estoreKeys="it, store, estore, computers" case "2"

estoreKeys="it, store, estore, computers"

<table width="100%" border="0" cellspacing="0" cellpadding="0">  <tr bgcolor="lightblue"> <td>  </td> </tr>  <tr> <td> <%

select case vparam case "1" %>  <% case "2" %>  <% case "3" %>  <% case "4" %>  <% case "5" %>  <% case "add" %>  <% case else %>  <% end select %> </td> </tr> <tr bgcolor="yellow"> <td>  </td> </tr> </table>

(22)

left.asp

<td><a href="default.asp?category=1" class="menulink">Motherboards</a></td> </tr>

<tr>

<td><a href="default.asp?category=2" class="menulink">Processors</a></td> </tr>

<tr>

<td><a href="default.asp?category=3" class="menulink">Memory</a></td> </tr>

<tr>

<tr>

<tr>

<td><a href="default.asp?category=add" class="menulink">Add product</a></td> </tr>

</table>

add.asp

</td>

<tr>

<font face="Arial" size="3"><b>Add Product</b></font> </td> </tr> <tr> <td> <b>Name:</b> </td> <td>

<input name="txtName" size="50" maxlength="50"> </td> </tr> <tr> <td> <b>Price:</b> </td> <td>

(23)

add.asp <tr> <td> <b>Picture:</b> </td> <td>

<input name="txtPicture" size="50" maxlength="50"> </td> </tr> <tr> <td> <b>Category:</b> </td> <td>

<input name="txtCategory" size="20" maxlength="20"> </td> </tr> <tr> <td> <b>Brief Description:</b> </td> <td>

<textarea name="txtBriefDesc" cols="50" rows="2" wrap="virtual"></textarea> </td> </tr> <tr> <td> <b>Full Description:</b> </td> <td>

<textarea name="txtFullDesc" cols="50" rows="10" wrap="virtual"></textarea> </td> </tr> <tr> <td> <b>Product Status:</b> </td> <td> <select name="optFlag"> <option value="0">INACTIVE <option value="1">ACTIVE </select> </td> </tr> <tr> <td colspan=2 align="right">

</tr> </table> </center>

(24)

8.2. Database structure

Our database name is eStore and we create it with MS Access. The database contains two tables: Products and Category. Products table structure

No. Name of Field Type and Length Description 1. ID Long Integer with

AutoIncremention 2. Name Text, 50

3. Price Currency 4. Image Text, 30 5. Category Long Integer 6. BriefDesc Memo 7. FullDesc Memo 8. Flag Integer

Category table structure

No. Name of Field Type and Length Description 1. cat_id Long Integer with

AutoIncremention 2. cat_name Text, 15

3. cat_description Text, 100 4. flag Integer

8.3. Products Management

Administration of products is permitted from administration page witch name is:

http://www.YourStore.com/admin

From this page the people who administrate the database could:

Add, modify or delete a category

Add, modify or delete a product

Make a product unavailable for a period 8.4. Order

Your clients orders your products by eMail and receive it through the Post office. The client make a payment at receiving the products and money is collecting into your account.

This way of payment is difficult because you have a large delay between transmitting the products and receiving the money. Other usefully way is that your clients make electronic card payment. For this you have to contact a local bank branch to implement a card payment system.

(25)

8.5. Object required

We use ASP object like: Response, Request. The Response object sends text to the Web browser. The Request object is usefully for work with HTML query string and process received client information from HTML form.

9. Library with important software package

Fedora core 3

Fedora core 4

Mandrake

Slackware

RedHat Linux 7.2

MySQL for Windows

Administrative MySQL for Windows.