homepage Welcome to WebmasterWorld Guest from 54.237.184.242
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / WebmasterWorld / New To Web Development
Forum Library, Charter, Moderators: brotherhood of lan & mack

New To Web Development Forum

    
creating online Database
syedumairali




msg:3654468
 1:28 pm on May 20, 2008 (gmt 0)

I wish to create a simple online database e.g.students information and adding search option on it.
The problem is I am new to this and dont know much about it, so i only like to create a simple database and a web form for entering data into databse.
could some one teach me a step by step tutorial of how to make a database , and how to link with some front end programming, I dont want to make any fancy stuff, just wish to have it done in an easy way.

 

Lovejoy




msg:3654539
 2:38 pm on May 20, 2008 (gmt 0)

I use a free program from [sqlmaestro.com...] to do the forms, your webhost likely has a tutorial for database creation.

Lovejoy

rocknbil




msg:3654570
 3:28 pm on May 20, 2008 (gmt 0)

The most popular method is mysql as a database engine, which is open source, free, and heavy with documentation. Most hosting services offer a control panel to manipulate the database when you opt to use a database on the site.

IMO, many of these don't give you the full power of database interaction, and from what I've read are often attacked and have vulnerabilities. If you have command line access, god old command-line entry is all that's required.

MySQL documentation [dev.mysql.com]
Basic SQL Tutorials [w3schools.com]

Note that the last is a quick reference to **ALL** SQL languages, not specific to mySQL. The cool thing about mysql is you can download it and install it on your local computer, play with it as required before creating a database on your site and throwing statements at it.

Your form is the browser interface. To interact with the database from the form, you will need some scripting language. The preference these days is PHP, although this can be done with any scripting language: perl, ASP, ColdFusion, etc.

The function of a script is to accept input from your form, then connect to the database to manipulate the data.

PHP tutorials [w3schools.com]

You will find tutorials for other languages there at W3C Schools, once you choose one you can search out other samples and examples on the web.

You could probably do a "quick fix" and download a working script, but if it goes wrong you won't know how to fix it. Get a few tutorials under your belt and you'll be on your way.

syedumairali




msg:3656323
 1:07 pm on May 22, 2008 (gmt 0)

many Thanks..
much helpful link ....

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / New To Web Development
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved