LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 02-08-2009, 01:06 PM   #1
theduck70
LQ Newbie
 
Registered: Feb 2009
Posts: 2

Rep: Reputation: 0
seeking advice -total beginner- how to integrate website and membership database


Hi,

so I'm a TOTAL BEGINNER to linux and databases. I want to start a website that will allow visitors to directly input information, like eg membership details, providing the information for other users.

I have no experience with programming, or databases. I can make a website, and I'm pretty sure I can workout how to make a database, but I have no idea how to marry the two together.

this is what I have. MacBook 2.4GHz 10.5, running Ubuntu desktop 8.04 through vmware fusion, and have just installed XAMPP.

Until this week when I installed these programs i'd had no exposure to command-line, so at least now it doesn't freak me out.

OK so what I'd like, is advice on:

1. What do I need to learn first, second ... kind of thing
2. Where can I learn these things (I'm a student, so I'm trying to keep this as FREE as possible)
3. specifically info on getting the database and website "talking"

I've done a fair bit of search on the net, and to be honest, there is soooo much information it's beginning to get confusing. If someone could point me in the right direction I'd be most greatful.

CHEERS

donaldo
 
Old 02-08-2009, 01:11 PM   #2
mesiol
Member
 
Registered: Nov 2008
Location: Lower Saxony, Germany
Distribution: CentOS, RHEL, Solaris 10, AIX, HP-UX
Posts: 731

Rep: Reputation: 137Reputation: 137
Hi,

first you can take a look at the following things:

- Setup apache webserver with php and mysql (XAMPP should have done this for you)
- learn php a very flexible language which allows you to send and retrieve data from your website to/form the database

I think this should help. Also there are many php forums and a mass of templates available which can help you.
 
Old 02-08-2009, 01:35 PM   #3
Didier Spaier
LQ Addict
 
Registered: Nov 2008
Location: Paris, France
Distribution: Slint64-14.2 on Lenovo Thinkpad W520
Posts: 7,431

Rep: Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396
In a similar situation I have read a book whose title is "Pratique de MySQL et PHP" and founded it interesting. I do not know if you read French but you should be able to find something similar in English.

There are a lot of other possibilities but most websites use Linux + Apache + PHP + MySQL, all open source and free. This combination is known as LAMP.

Last edited by Didier Spaier; 02-08-2009 at 01:35 PM. Reason: missing word
 
Old 02-08-2009, 06:15 PM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,356

Rep: Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367
I'd definitely recommend bookmaking the websites for php and MySQL if you are using them. They both have lots of examples as well as explanations of the tool:
http://dev.mysql.com/doc/refman/5.0/en/
http://www.php.net/manual/en/
 
Old 02-08-2009, 06:42 PM   #5
AuroraCA
Member
 
Registered: Jul 2008
Location: Northern CA USA
Distribution: Ubuntu, Slackware, Gentoo, Fedora, Red Hat, Puppy Linux
Posts: 370

Rep: Reputation: 35
You may wish to look at a Content Management System (CMS) such as Joomla! with Community Builder which will allow you to set up an integrated website with integrated membership community.

See:

http://www.joomla.com with http://extensions.joomla.org/extensions/210/details

You can easily add additional capabilities such as forums, photo galleries, directories, document downloads, etc. without much work. There are som 150+ extension enhancements to Community Builder which allows you to develop very rich community.

The best thing is that Joomla!, Community Builder and most extensions are free. Since you are new to website development this may be a very inexpensive and fast way to develop your concept. Joomla! uses PHP with MySQL databases.
 
Old 02-09-2009, 03:18 AM   #6
theduck70
LQ Newbie
 
Registered: Feb 2009
Posts: 2

Original Poster
Rep: Reputation: 0
Thanks all for the great suggestions. If I wanted a challenge I picked a good one, luckily with the suggestions you've made I can already see a bit of light at the end of the tunnel! Loving OPEN SOURCE!!

cheers

donaldo
 
  


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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
total beginner foxall22 Linux - Wireless Networking 1 11-14-2006 01:22 AM
Apache and PHP for total beginner legendaryhwk Linux - Newbie 6 02-23-2006 07:13 AM
Integrate postfix with existing MySQL database EdMeister Linux - Software 0 04-21-2005 04:52 AM
C++ beginner seeking help with compiling. marlor Programming 6 09-17-2004 09:46 AM
Total noob seeking "where to start" advice DJchicago Linux - Newbie 1 09-06-2004 09:44 PM


All times are GMT -5. The time now is 02: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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration