Solved

Learning about database driven sites

Posted on 2000-04-02
4
244 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

If you get a (Blue Screen of Death), your system writes a small file called a minidump. Your first step is to make certain your computer is setup to record memory dumps. Right click My Computer, choose properties. Click on the advanced tab, an…
It is becoming increasingly popular to have a front-page slider on a web site. Nearly every TV website,  magazine or online news has one on their site, and even some e-commerce sites have one. Today you can use sliders with Joomla, WordPress or …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
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…

932 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now