Solved

Learning about database driven sites

Posted on 2000-04-02
4
242 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 …
Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

762 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

11 Experts available now in Live!

Get 1:1 Help Now