Current Project – MinisculeCMS

Well hello there people.
I have been busy coding the last 2 days.

I am currently working on a very basic and simple Content Management System(CMS), you can track my progress here, nothing really works on the live version of the site except posting articles, all the work is being done in the background, writing functions and such.

The CMS is coded in PHP, and is using a MySQL database, i plan on implementing some jQuery at some point(for fancy effects and such), and I am utilizing HTML5 and CSS3.

So I got a lot on my hands at the moment, especially for the fact that I SUCK at MySQL… But, luckily for me i found a solution to my suckiness: MyQuery Builder;

“MyQuery Builder is a browser-based MySQL query editor for PHP web developers that makes building MySQL queries easy.”

So that works perfectly for me!

Anyways, while I am still rambling on, I can tell you what software and such I am using:

  • Notepad++ – for writing and editing the source code.
  • FileZilla - for uploading and downloading all my files on the website.
  • MyQuery Builder – For constructing SQL queries(because i suck at SQL syntax)
  • Spotify - to keep me from going insane while coding… in the dark… alone :(
  • Ritalin - To keep concentrated while coding(I have ADHD)

And that is pretty much it.
I hope you enjoyed reading this little update, Thanks :)

Where to begin learning?

Ok guys, i know that some people in my area that want to get into web development.

So to help all you guys out i’ll give you links to the BEST places to learn PHP, HTML, CSS and Javascript etc.
Don’t waste money on expensive books and online courses!
I have used these sites myself and loved them all, enjoy!

PHP

I really recommend PHPAcademy.org, TheNewBoston.com and the TheNewBoston Forums.
Both Bucky(thenewboston) and Alex(phpacademy guy) explain concepts and code in great detail and makes sure you understand what they do and how they work before they move on to the next topic, very good for beginners as well as experienced programmers.
And you can find great support on the forums.

 

HTML and CSS

I also recommend TheNewBoston’s videos for HTML and CSS, as always Buck explains everything in great detail, shows you examples and use the knowledge to create something meaningful in the end.

But of course you can’t learn everything from one place, so when you have watched all his videos(yes all of them), then you should try to create something on your own, and when(not if) you get stuck you can refresh your memory by visiting w3schools.com.

I usually use w3schools for a reference and to look up information I have forgotten(stuff like certain CSS attributes etc).

 

Javascript & jQuery

I have to be honest, i don’t know very much Javascript nor jQuery, but i know where to start learning it.
Again i recommend that you check out TheNewBoston’s videos for Javascript, but also for jQuery, TheNewBoston have gotten Alex from PHPAcademy to create his jQuery videos, which you can find here.

 

MySQL

If you are going to create an interesting website you need to have a database, and the best way to learn about that is by far PHPAcademy’s videos, for more videos from PHPAcademy on MySQL just browse around on their Youtube channel and website.

TheNewBoston recently posted a new series on MySQL databases on his youtube channel, you can find part 1 here.

As always Bucky and Alex gives greatly detailed information and explains concepts and code, and doesn’t run through everything like most other people do.

By the way, did i mention that EVERYTHING i just listed is FREE?

That’s about all i can come up with, if you got any suggestion or something you want to share, either send me an email or write it in the comments below.

HostGator <3

Just to clarify, HostGator nor any of their affiliates or partners have paid me to write this “omg i love this company”‘y post.

Here is the only reason you need:
Their customer support is FANTASTIC, 5 minutes ago i had a problem with not being able to login by SSH, i clicked on the “live chat” button on HostGator’s website and waited in line(not long, worth the wait), before i had even explained my problem a friendly guy called Carlos gave me the solution to my problem.

Apparently you have to enable Shell access in your billing options.
So i got that fixed, and now i can use SSH :)

Also even TheNewBoston agrees HostGator is the best, look here.