LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-19-2015, 11:08 PM   #1
vwtech
Member
 
Registered: Dec 2007
Distribution: Fedora, Oracle Linux & Centos
Posts: 197

Rep: Reputation: 26
What software can meet my goal?


I'd like to build a small internal website were I can input info into a database (including attaching pdf's or other attachments).

Example:
I decide to perform an oil change on my car. Afterwards I'd like to pull up my website to a form and input fields (like date, service done and scanned receipt of materials used).

Having such a system would save me some much time. I'd like to make a database for automotive stuff initially.

I'm think I could use apache, mariadb/mysql but I'm not sure how to configure submitting and retrieving data for a database.

Any help you all could provide would be great.
 
Old 01-19-2015, 11:30 PM   #2
veerain
Senior Member
 
Registered: Mar 2005
Location: Earth bound to Helios
Distribution: Custom
Posts: 2,524

Rep: Reputation: 319Reputation: 319Reputation: 319Reputation: 319
Together with them you may use php for server side scripting. It can handle databases as well.
 
Old 01-20-2015, 07:29 PM   #3
vwtech
Member
 
Registered: Dec 2007
Distribution: Fedora, Oracle Linux & Centos
Posts: 197

Original Poster
Rep: Reputation: 26
Never used php or know how to code any but simple html, is it something a beginner could do?
I'm okay with apache, but new to mysql also.
 
Old 01-21-2015, 03:08 AM   #4
veerain
Senior Member
 
Registered: Mar 2005
Location: Earth bound to Helios
Distribution: Custom
Posts: 2,524

Rep: Reputation: 319Reputation: 319Reputation: 319Reputation: 319
Mysql uses SQL Language.

Php was based like Perl scripting language.

You can visit Php site: http://php.net

The php site has tutorial, manual, and many code examples.
 
Old 01-21-2015, 08:44 AM   #5
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,836

Rep: Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007
Quote:
Originally Posted by veerain View Post
Mysql uses SQL Language.
No, SQL is NOT a language, but a common interface method for RDBMS systems.
Quote:
Php was based like Perl scripting language.
No, it wasn't..it was designed from the ground up to be what it is now:
http://en.wikipedia.org/wiki/PHP
Quote:
You can visit Php site: http://php.net The php site has tutorial, manual, and many code examples.
And if the OP is brand new to things, the documentation can be daunting, and that CERTAINLY isn't the place to go for tutorials or examples. Please, don't direct people to things that will confuse them, or give them incorrect information.

OP, you should be able to load the PHP system, database connection/interface modules, and other pieces/parts from your online repositories. You don't say what version/distro of Linux you're using, so we can't tell you EXACTLY how, but post back and we can try. You can also find some great tutorials online, such as these:

Building a web based form:
http://www.w3schools.com/php/php_forms.asp

To connect to a MySQL database:
http://www.w3schools.com/php/php_mysql_connect.asp

If you know basic HTML now, this shouldn't be TOO difficult to pick up and follow. If you know another programming language already (like Perl, Ruby, or Python), it'll make even more sense.
 
Old 01-24-2015, 03:07 AM   #7
dugan
LQ Guru
 
Registered: Nov 2003
Location: Canada
Distribution: distro hopper
Posts: 11,275

Rep: Reputation: 5342Reputation: 5342Reputation: 5342Reputation: 5342Reputation: 5342Reputation: 5342Reputation: 5342Reputation: 5342Reputation: 5342Reputation: 5342Reputation: 5342
Quote:
Originally Posted by TB0ne View Post
No, SQL is NOT a language
Seriously, TB0ne?

SQL is not a programming language, but it certainly is a language.

And for this requirement, I'd honestly just use Google Docs (or Microsoft or Apple's counterparts).

Last edited by dugan; 01-24-2015 at 03:10 AM.
 
Old 01-24-2015, 07:35 AM   #8
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,836

Rep: Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007Reputation: 8007
Quote:
Originally Posted by dugan View Post
Seriously, TB0ne?

SQL is not a programming language, but it certainly is a language.
My answer remains correct; its a common interface method for RDBMS systems. You could define a language that way, certainly. So I'm not sure why the "seriously"? Also, my comment was in regards to what was said previously, about being able to use SQL *TO* program and/or use in a website. Since it's not a programming language......
Quote:
And for this requirement, I'd honestly just use Google Docs (or Microsoft or Apple's counterparts).
Will those things work for what the OP asked for: a small, INTERNAL website?

Last edited by TB0ne; 01-24-2015 at 07:53 AM.
 
Old 01-24-2015, 08:14 AM   #9
yancek
LQ Guru
 
Registered: Apr 2008
Distribution: Slackware, Ubuntu, PCLinux,
Posts: 10,622

Rep: Reputation: 2516Reputation: 2516Reputation: 2516Reputation: 2516Reputation: 2516Reputation: 2516Reputation: 2516Reputation: 2516Reputation: 2516Reputation: 2516Reputation: 2516
Quote:
Never used php or know how to code any but simple html, is it something a beginner could do?
Just do an online search for "how to install LAMP server on Debian", replace Debian with whichever Linux you are using. As far as coding html and php, you should find a lot of examples online including at some of the sites posted above.
 
  


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
LXer: Meet Solaris 11.2, where SDN means 'Software-Defined Net profit' LXer Syndicated Linux News 0 08-05-2014 03:40 PM
LXer: Meet the prophet of free software LXer Syndicated Linux News 0 01-23-2008 11:41 PM
LXer: Meet on free software demands policy changes LXer Syndicated Linux News 0 03-05-2007 07:16 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:15 AM.

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
Open Source Consulting | Domain Registration