homepage Welcome to WebmasterWorld Guest from 54.226.136.179
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
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

5+ Year Member



 
Msg#: 3654466 posted 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

10+ Year Member



 
Msg#: 3654466 posted 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

WebmasterWorld Senior Member rocknbil us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3654466 posted 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

5+ Year Member



 
Msg#: 3654466 posted 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