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 |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
01-19-2015, 11:08 PM
|
#1
|
Member
Registered: Dec 2007
Distribution: Fedora, Oracle Linux & Centos
Posts: 197
Rep:
|
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.
|
|
|
01-19-2015, 11:30 PM
|
#2
|
Senior Member
Registered: Mar 2005
Location: Earth bound to Helios
Distribution: Custom
Posts: 2,524
|
Together with them you may use php for server side scripting. It can handle databases as well.
|
|
|
01-20-2015, 07:29 PM
|
#3
|
Member
Registered: Dec 2007
Distribution: Fedora, Oracle Linux & Centos
Posts: 197
Original Poster
Rep:
|
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.
|
|
|
01-21-2015, 03:08 AM
|
#4
|
Senior Member
Registered: Mar 2005
Location: Earth bound to Helios
Distribution: Custom
Posts: 2,524
|
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.
|
|
|
01-21-2015, 08:44 AM
|
#5
|
LQ Guru
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 27,794
|
Quote:
Originally Posted by veerain
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.
|
|
|
01-22-2015, 04:38 AM
|
#6
|
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.x
Posts: 18,443
|
|
|
1 members found this post helpful.
|
01-24-2015, 03:07 AM
|
#7
|
LQ Guru
Registered: Nov 2003
Location: Canada
Distribution: distro hopper
Posts: 11,372
|
Quote:
Originally Posted by TB0ne
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.
|
|
|
01-24-2015, 07:35 AM
|
#8
|
LQ Guru
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 27,794
|
Quote:
Originally Posted by dugan
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.
|
|
|
01-24-2015, 08:14 AM
|
#9
|
LQ Guru
Registered: Apr 2008
Distribution: Slackware, Ubuntu, PCLinux,
Posts: 11,418
|
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.
|
|
|
All times are GMT -5. The time now is 06:27 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|