Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 05-12-2012, 05:21 AM   #1
Registered: Mar 2007
Distribution: Fedora
Posts: 263

Rep: Reputation: 23
create an online database

Dear friends,
I am planning to create an online database(using mysql). This will have facility to have inputs from users and users will be free to view it.
Since I am a novice in the field, can anyone show/redirect me to a tutorial page to achive this?
Old 05-12-2012, 08:43 AM   #2
Senior Member
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,541

Rep: Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060
At its simplest, you may have users connecting to your data base with terminal windows and interacting with MySQL as text over a LAN, but more likely, you're talking about LAMP (Linux-Apache-MySQL-PHP), where users connect with a browser to a web page and interact with forms.

In the simple case, you enable networking in MySQL on your data base server and everybody connects with SSH. That's discussed in MySQL documentation.

LAMP is the more common method (and much easier on users and you, too) where your web page (the Apache part) interacts with the data base with PHP doing the queries and handing the result back for display. There are all kinds of books, courses and tutorials available for PHP (many books include sample applications on CD-ROM/DVD that you can build on). Those materials demonstrate how to configure Apache, how to configure MySQL and how to construct PHP queries and displays in a web page. It would probably be a big help to look around for books and tutorials for PHP, starting, perhaps at along with reviews at Google for PHP and take a look at a few of the results to get a feel for it.

Keep in mind that many web pages you view (such as Amazon and almost every shopping site) make use of PHP. It's not difficult, but it is a different way of thinking that will take a little effort on your part -- thus the suggestion to buy a book or two (after reading the reviews) that will show you what to do, how to do it and guide you as you go.

Hope this helps some.
Old 05-12-2012, 03:32 PM   #3
LQ Guru
Registered: Nov 2003
Location: Canada
Distribution: Slackware
Posts: 7,518

Rep: Reputation: 2873Reputation: 2873Reputation: 2873Reputation: 2873Reputation: 2873Reputation: 2873Reputation: 2873Reputation: 2873Reputation: 2873Reputation: 2873Reputation: 2873
Just to to add and view data? Would adminer or phpmyadmin be good enough as a frontend? If you want something higher level, choose a web framework that gives you prebuilt admin pages: Django, Web2Py, SQLAlchemy+Rum, Rails (via "scaffolding"), etc.

Last edited by dugan; 05-12-2012 at 03:36 PM.
Old 09-09-2012, 12:27 PM   #4
Registered: Mar 2008
Posts: 16,883

Rep: Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498
Might start off with kexi for simple test of your design. Even a stab at openoffice base might help you get started.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Any advice on software to generate online reports from a MYSQL database? will103 Linux - Software 1 05-07-2010 03:29 PM
save input from an online form to a file/database? portia Programming 4 01-30-2010 09:22 AM
Free Online Database Web hosting teluguswan Linux - General 2 05-19-2007 02:37 AM
Online Database atko Linux - Software 2 05-27-2003 01:42 PM
Manage data and maintenance of MySQL database online rhuser Linux - Software 2 02-17-2003 08:31 PM > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 07:48 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration