Looking to learn HTML, PHP, SQL, Java, web-dev in general!

[Nymphx]

Basically, I've not coded in nigh on 4 years, but I'm sure that the logical part of my brain still works, it's just a tad rusty.

I'm looking to start with web development, but I have little experience with it. I've played with xampp in the past and started a book on how to learn PHP, but never really had the time or resources for the projects that I started.

Now, however, a good understanding of HTML, PHP, SQL and Java, as well as any other important web development tools/languages could help me progress in my job. My problem is that I cannot find a good tutorial anywhere on the web. I know that sites such as W3schools offer tutorials, but they don't seem structured or beneficial.

If anyone can help me out by sending a few links or files this way, it'd be highly appreciated. I've installed Brackets, Notepad++, Wamp and Firebug, and I'm ready for this.

[ev0]

I try and tell everyone who has basic coding knowledge, to just create a blog. Lol

I know it sounds so over simplified, but really making a blog, doing your own changes/updates, installing plugins as well as actually posting articles and adjusting the design of the post...well that's a great start. There are so many guides out there. Just check out Wordpress.

For development tools, I use Aptana. A free workbench for a lot of languages. It hooks right up to your FTP server.

[Fisher]

I'm with LOW on this. Set a goal for yourself and build it. Aptana is nice, I use Sublime Text 2 hooked with WinSCP. While I don't really code php or js or html off the top of my head, I know the logic behind it and function names. This allows me to google for code snippets and implement them together. Maybe not the best way, but it works. In time, you will learn syntax and then you'll be able to write from scratch. Or you will just learn how to optimize such codes. I never found it entertaining to read a tutorial, building something and learning along the way is much more fun. While blog is nice, try building a shop. It has many more functions and you'll learn a lot doing it. But blog's a nice start too, if you are interested in CMS, which is a simple way of doing the same thing, with some limits of course. I prefer doing it all myself, no idea why.

[Nymphx]

Thanks for the quick replies guys. I do like the idea of starting up some kind of personal project such as a blog or shop.

As for the snippets and CMS suggestions, I'd like to learn to code the old raw way, so I can grasp the best understanding I possibly can of the syntax. Obviously once I feel comfortable in understanding the language(s), then I can move into using snippets. Does this make sense?

The reason why I wanted a good tutorial is so that I can learn all of the basic and advanced functions that I will need to know, and I'm a sucker for structure.

[Fisher]

If you take an existing project source code you will find php is easy to read: insert, select, update etc. Then you would, in turn, learn the logic behind it. I don't know any good books as most are really vast and out of date, but this is a way.

Grab a php template, host it somewhere and play around. If you google a specific command from php, you will get a nice brief explanation of it and its usage. Same goes for HTML. JS is bit harder as it's closer to programming, and harder to understand by looking at the code.

Also yeah it makes sense considering most devs use snippets from previous projects and simply modify them for new ones. Writing sql injection protection or db login for each project is pointless.

[bt411]

I woul search for university courses online, they will be up to date and progressive, if you find a script you should be golden.