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.
|