Should I Learn PHP and MySQL or Not?

I've had quite a few people ask me this question: "Should I learn PHP and MySQL?".

The answer is never easy. It all depends on what you're trying to accomplish. Are you looking to be involved in your own website? Is it being run on PHP and MySQL? What would you like to do with your website?

There's a million questions you can ask yourself. I, personally, believe that anyone who wants to become more involved with their own website or run their own Web Design and Development Company should, at the minimum, learn the basics of PHP and MySQL.

Why should you? Well, let's take a few examples...

Maybe you want to create a Members are on your site and you want to be able to offer downloads, use a more interactive Contact script, show information dynamically for your customers (i.e. Time and Date, Their personal information, the information they searched for last, Billing information, Download history, username and/or password, etc) to make it easier for them to browse through your site.

Maybe you want to be able to use PHP for your Search Engine Optimization needs? Needs such as 404 Redirects, 301 redirects, etc.

Maybe you need to create a built in search system for your e-commerce site? Maybe you're looking to simply redirect people to an Affiliate program?

See the many, MANY ways you can use PHP? It's a very valuable tool to know and understand. Imagine yourself having the knowledge to take a product like Wordpress and fully customize it to your own, personal, needs?

Think you can make money off of one of your Wordpress Plugin Ideas by knowing PHP? Think you can build a better Content Management System than what's currently available? What about a new Social Networking Script - OR Community?

Companies like PHPFox have made a killing with their php knowledge. Likewise for companies such as Mambo, vBulletin and various other scripts that you can purchase.

So the next question would be HOW you can learn PHP?

There's a million ways to learn but I try to explain to everybody that watching Videos and DOING the coding practices they ask you to do is how you'll learn quickly.

Sure... lot's of people have learned PHP by reading books. But I find the problem with books is a lack of support. You're always going to learn more by seeing and doing rather than reading and doing. Luckily there are solutions to this problem.

You can also visit popular forums such as Sitepoint, Digitalpoint and other Webmaster related forums or communities that allow other members to help with questions and answers.

No matter what you choose to do - just remember that DOING is how you learn. Practice without reading or watching. Just take the little knowledge you have at the time and make it grow with practice.

I hope you figure out what you need to accomplish and good luck!

By Clint Lenard

How to Learn PHP and MySQL as Quickly as Possible

Learning Programming is a tough subject, no matter which language you choose.

It took me months to figure out php and MySQL enough to build real, quality, Websites that were "good enough".

Eventually I figured out the easiest way to learn. It took me MONTHS to figure it out... but I did.

So what does it take to learn a Programming Language such as PHP?

"Doing" is what it takes. 90% of the people who try to take on such a task end up feeling "dumb" or "slow". This usually is NOT the case. I've found that, like myself, most people try to learn PHP from reading and going through code to "understand" what it means.

I was the same way until I was told "just do it". My mentor must have been the most patient man on the face of this earth - because I was constantly telling him I could not do it. But he kept on me telling me the same line I'm telling you: "just do it".

What does this mean? It means trying to create your very own scripts, whether small or of decent size. Start out with printing out the date to the browser. Continue with Loops. Create scripts that create mathematical equations. Print out your name, last name, etc.

Once you figure out the basics, make sure you continue to learn by doing! You will never be able to take your skills to the next level just by reading.

I also stress to other newbies that they need to learn by watching as well. Writing code can become quite a task and it's better to see someone else do that, if possible (which it is by watching videos).

It's quite easy to get caught up in bad practices while writing code if you do not follow good programming standards. Sloppy (spaghetti) code seems to be the evil of the programming world that occurs from newbies who read online tutorials by so called "programmers". Most of these "programmers" are NOT what they claim to be. So be careful of whom you choose to learn from.

PHP and MySQL (database) go together like peanut butter and jelly. I cannot tell you how important it is to learn these two languages together. MySQL may not be the "best" Database in the world but it is very easy to learn and very capable of building large scale applications.

So remember: if you're not "doing", you're not learning. Start learning PHP basics and make sure you're following along and trying to code your own small scripts when starting out. I know, I know... it LOOKS like it's too hard. It's not. This is not something you're going to learn overnight, but it's quite possible that you can learn enough to do what you need to do in just a matter of weeks!

Keep learning and continue doing.

If you're looking to become a PHP programmer - you need to see these videos!

By Clint Lenard