Solved

Learning about database driven sites

Posted on 2000-04-02
4
251 Views
Last Modified: 2013-12-25
Hi there,

I've been designing simple web sites for a while now but am keen to get into designing more sophisticated database driven sites (for E-commerce and user customization).  I'm interested to know what the best way to start educating myself about such things as CGI, ASP, server-side scripting languages, server software, and  the general design principles involved in creating database driven sites.

I'm happy to award points to all good suggestions.



Thanks in advance,

Justin
0
Comment
Question by:jtp101
4 Comments
 
LVL 10

Expert Comment

by:makerp
ID: 2679865
download personal web server or iis etc from microsoft and install it.

for asp visit http://www.asp101.com. it is probably the best beginners/intermediate site on the web. thatl show you loads of database examples and demonstrate the way it all works

for perl:

download activeperl from http://www.activestate.com

dowload the dbi and dbd:odbc modules from http://www.activestate.com/packages/zips
read thye read me file in each zip thatl tell you how to install.

when you install activestate perl it will set up the mapping to the perl.exe in iis for you. all you have to do is set the permissions on the dir to execute. (see iis help)

0
 
LVL 16

Expert Comment

by:maneshr
ID: 2680366
In order to "cook" up the recipe you are looking for you will need to have...

A simple, yet-sturdy Web server installed and configured on your system.
  For Winnt you can get IIS, Sambar or Apache. All are free.
  For UNIX you can get CERN HTTP, Apache for free.

With these web servers you will find bundled support for CGI scripting. For Eg. with IIS you will get support fof ASP and PERL. You will get support for PERL with Apache. in addition to these you can find other server-side scripting languages like PHP, C and C++.

Next you would need a decent back-end DB. With Windows you dont have lot of options as far as free DB is concerned. However on Unix, especially Linux you can get MySql, mSQL and Postgress SQL RDBMS's for free.

Finally, if you are looking at an E-commerce implementation you will need a secure web server. Again apache provides the same to you.

The final choice would depend on the OS you want to implement this on and your comfort level with Windows and/or Unix systems.

Rgds
0
 
LVL 1

Expert Comment

by:mafweb
ID: 2683001
hi jtp101,

if you're looking for a cool book treating general considerations concerning database driven sites,
http://photo.net/wtr/thebook/
migtht be what you're looking for. Although Phil works with Oracle and AOLServer, you get a good idea of how to work with sql and some hints for your site.

maf
0
 

Accepted Solution

by:
krirob earned 50 total points
ID: 2690078
For best preformens and cheapest.
go for PHP (www.php.net),Apache (www.apache.org), MySQL (www.mysql.com), and some Linux version and it is all for free.  

Some info on install it on www.devshed.com 
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction:   Welcome to my first article ever. To begin with, the reason I write this article.  I participated in a question on Experts Exchange about the start command in Windows and there were some discussion about the usage. The discussio…
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
The viewer will learn how to dynamically set the form action using jQuery.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question