LAMP reference materials??

Discuss Programming
Post Reply
User avatar
cdhgold
administrator
administrator
Posts: 382
Joined: Tue Mar 18, 2003 6:11 pm
Location: Texas

LAMP reference materials??

Post by cdhgold » Tue Jul 07, 2009 10:21 am

I'm planning on building my first LAMP app have not written code since
c++ for DOS any good reference recommendations?

I need to
1) create the database
2) create the app

I have not done either of these before

User avatar
Void Main
Site Admin
Site Admin
Posts: 5716
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA
Contact:

Post by Void Main » Tue Jul 07, 2009 1:19 pm

There really is nothing to it. If you are running a modern distro (Fedora for example) everything you need is already installed (or can be with a simple "yum install xxx"). Start the MySQL and httpd services and away you go. Connect to mysql and create your database, tables, and your user then create your PHP app. I don't know of any "one" good source other than plug your questions into google and away you go. Or plug your questions in here and I'll help you if you can wait for me to respond. Google is probably quicker.

Do I assume you already know SQL and HTML? If not then there are really 3 different things you need to learn and that is SQL, HTML and PHP. It's good to have a basic understanding of both SQL and HTML before you embark on building a database PHP app.

User avatar
cdhgold
administrator
administrator
Posts: 382
Joined: Tue Mar 18, 2003 6:11 pm
Location: Texas

Post by cdhgold » Tue Jul 07, 2009 1:48 pm

i do not know any of the above this is my 1st time to try any of them

User avatar
Void Main
Site Admin
Site Admin
Posts: 5716
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA
Contact:

Post by Void Main » Tue Jul 07, 2009 2:15 pm

In that case the first thing I would learn is basic HTML because you will be writing PHP code that generates HTML for a user's web browser to interpret. Then I would learn the basics of PHP. That is how to write simple non-database PHP programs that generate HTML (assuming your app will be web based). Then move on to basic SQL using MySQL. Once you've done all that then tying it all together is fairly trivial.

User avatar
cdhgold
administrator
administrator
Posts: 382
Joined: Tue Mar 18, 2003 6:11 pm
Location: Texas

Post by cdhgold » Tue Jul 07, 2009 2:35 pm

recommended places to start reading?

User avatar
Void Main
Site Admin
Site Admin
Posts: 5716
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA
Contact:

Post by Void Main » Tue Jul 07, 2009 3:21 pm

I would just start doing google searches for "HTML tutorial" and find some place that fits your liking. Here's one that looks like it might be a good place to start:

http://www.echoecho.com/html.htm

You don't have to learn everything about HTML but just understand the basic structure and then you'll use HTML references to check tag options, etc. Since you are going to be doing database work you'll want to be able to do basic HTML and you'll want to understand HTML forms and HTML tables.

Of course http://www.w3.org/ is where the HTML standards are published so it would be a good idea to browse that site. They even have HTML validator so you can put the URL of your page into the validator and it will check it out and tell you whether it follows standards and point out your errors if you have any and tell you how to fix them.

As a matter of fact w3 has tutorials right on their site:

Basic:
http://www.w3.org/MarkUp/Guide/

Advanced:
http://www.w3.org/MarkUp/Guide/Advanced.html

I personally use VIM to edit HTML and PHP. I really like it's color syntax highlighting among other things.

Post Reply