LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
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.

Notices



Reply
 
Search this Thread
Old 05-12-2012, 06:21 AM   #1
RudraB
Member
 
Registered: Mar 2007
Distribution: Fedora
Posts: 262

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, 09:43 AM   #2
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,119

Rep: Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818
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 http://www.oreilly.com/ along with reviews at http://www.amazon.com. 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, 04:32 PM   #3
dugan
Senior Member
 
Registered: Nov 2003
Location: Canada
Distribution: distro hopper
Posts: 4,984

Rep: Reputation: 1555Reputation: 1555Reputation: 1555Reputation: 1555Reputation: 1555Reputation: 1555Reputation: 1555Reputation: 1555Reputation: 1555Reputation: 1555Reputation: 1555
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 04:36 PM.
 
Old 09-09-2012, 01:27 PM   #4
jefro
Guru
 
Registered: Mar 2008
Posts: 12,087

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


Reply


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 04:29 PM
save input from an online form to a file/database? portia Programming 4 01-30-2010 10:22 AM
Free Online Database Web hosting teluguswan Linux - General 2 05-19-2007 03:37 AM
Online Database atko Linux - Software 2 05-27-2003 02:42 PM
Manage data and maintenance of MySQL database online rhuser Linux - Software 2 02-17-2003 09:31 PM


All times are GMT -5. The time now is 05:48 PM.

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