Web Hosting Talk







View Full Version : What front end to use to populate db?


bak2bak
07-18-2002, 11:11 AM
I am trying to learn how to build an application that would let me populate a db from the web. What applications are the easiest to use? It would be similar to a inventory system but not entirely. I want to be able to decrement a count an administrator set forth along with what items are available? There would be several administrators.

beley
07-18-2002, 11:34 AM
I'm not sure if I completely understand what you want to do... but I'm thinking some php scripts would solve your problem... they can connect to almost any db... mysql, postgre sql, sql server (on windows machine), etc.

Asp could as well.

bak2bak
07-18-2002, 11:41 AM
what is php and asp? i am new to this. do i need to have the db setup first then build the front end?

Angel78
07-18-2002, 12:01 PM
try searching google for php+mysql ( mysql = db, php = language for querying DB (not just that))

EasySite
07-18-2002, 02:05 PM
If you are new to code and learning how to create database applications there are several places to learn on the web, but having a book on hand for reference is allways best.

One I could reccomend for beginners is:

MySQL/PHP Database Applications
By
Jay Greenspan and Brad Bulger

This book will take you step by step in building simple to semi advanced programs and give you a good start on creating your own.

Also visit www.hotscripts.com

This is a great resource for downloads of programs and most are offered for free. You may even find one that is similar to what you want to create.

bak2bak
07-18-2002, 02:27 PM
thank you angel78 and easysite, i appreciate the help!!!!!!!:D

freakysid
07-18-2002, 07:38 PM
Yep PHP and MySQL are what you are probably after.

Here is a good place to start!
http://www.sitepointforums.com/showthread.php?s=&threadid=18699

bak2bak
07-18-2002, 08:54 PM
do i have to have a HTTP server running to try my PHP scripts?

Gem Hexen
07-18-2002, 11:18 PM
you need PHP on the server too

Angel78
07-19-2002, 03:20 AM
www.apache.org www.php.net www.mysql.com get

win32 zips and install them = just read the Install.txt it is really simple to do, then get few tutorials from the net and you are ready to start :)

freakysid
07-19-2002, 08:54 AM
Or better yet, if you are wanting to develop and test out your scripts in windoze, then download and unzip the phpdev bundle in the root directory of your C: drive

www.firepages.com.au

bak2bak
07-19-2002, 10:16 AM
freakysid, is that on the PHP site as well? that is what i am trying to do.

mwatkins
07-19-2002, 11:07 AM
If you are new to web development, you have a huge learning curve ahead. As much as I prefer Python over PHP, ASP, JSP etc, I agree with the PHP / MySQL comments. Best to stick with something that the masses are also using.

You should become familiar with hotscripts.com and the like - search and find a simple script that sounds similar to what you want to do, download, install, and study it. Check out a few. See how they are structured. Learn from them. Perhaps consider modifying something that exists already.

The Laughing Cow
07-19-2002, 02:19 PM
I think I would like to throw a spanner in the works. Access/ASP is the way to go. Simply because Access is something a lot of people know the basics around. Why learn two things when you can just learn ASP.

Access also gives the user the security of not having to faff around with SQL to as great an extent creating the tables.

EzSnake
07-19-2002, 05:17 PM
:emlaugh: :o If your usin access in a web enviorment!!!!!
LOL I can't even finish..... the thought of it is killin me!!!!!:liplick: :eek4:

The Laughing Cow
07-19-2002, 05:31 PM
Not at all, Access Is by far a good database environment. It works fine and it's just the rediculouse anti-Microsoft crap that makes people just reproduce the MS is ****e bolox.