Archive for March, 2008

BASIC SQL TUTORIAL

Monday, March 31st, 2008

Hi,

mysql-logo

I’ve just put up a new sub-section on SQL – the language of relational databases.

This is beginners stuff, so if you’re a know-it-all nerd, you can ignore this. On the otherhand, if you’re new to the database thing (mySQL for example) then these first couple of videos should help you get started.

Videos out so far:

- Introduction to SQL
- Introduction to the SQL ‘insert’ statement.

I plan on having a bunch of new videos out soon that cover:

  • The big four SQL statements.
  • The basics of database design.
  • The cardinal rules of database design.

My goal is to not turn you guys into database gurus, rather, I want to just give you enough so we can get you going with PHP and mySQL.

Thanks,

Stefan Mischook

www.killerphp.com

Killer Open Source PHP Projects

Thursday, March 27th, 2008

Part of PHP’s power is actually found in the variety of open source (free to use) PHP based applications. I’m talking about things like blogs, web frameworks, forums, cms’ etc …

… I was just thinking, that a list of ‘killer’ PHP open source projects would be useful … for a few reasons:

  1. Once upon a time, a master programmer I know gave me a great piece of advice:

    “Grasshopper, it is always a much better idea to use proven code (that means good open source projects) than to start from scratch.”

  2. Checking out examples of quality code, is a great way to learn how to become a better programmer.
  3. Who doesn’t need a list of ‘best of breed’ projects?

I’ve been snooping about the PHP world for a while now, and I’ve come across some crappy PHP projects (I will not name names) but I’ve also come across many great PHP projects.

To be totally honest about it, we’ve seen much of the good stuff coming out of the PHP world, in the last few years.

… PHP developers are leap-frogging ahead with regards to their level of skill and the quality of code they produce.

That all said, the following are my favorite ‘killer’ PHP open source projects:

(more…)

Setting up an MVC structure with the Zend Framework – part 2

Wednesday, March 26th, 2008

Hi,

I’ve released our second video (part 2 of 2) on setting up an MVC structure with the Zend Framework.

zend framework logo

This Zend Framework video is from our resident Zend-nerd: Jon Lebensold.

Again, let us know what you think and should you have any suggestions or request, please feel free to comment.

Running time: 19+ minutes
Part 2 of 2

Thanks,

Stefan Mischook

www.killerphp.com
www.killersites.com

Setting up an MVC structure with the Zend Framework – part 1

Monday, March 24th, 2008

Hi,

I just released a new video on setting up an MVC structure with the Zend Framework. This video is a little more basic than the previous Zend videos … I had to twist Jon’s arm a little.

zend framework logo

Anyway, let us know what you think and should you have any suggestions or request, please feel free to comment.

Running time: 12+ minutes
Part 1 of 2.

Thanks,

Stefan Mischook

www.killerphp.com
www.killersites.com

MYSQL Video Tutorials

Tuesday, March 18th, 2008

Hi,

mysql-logo

I finally got around to creating a new section dedicated to teaching basic MySQL.

At this time, I only have a few videos on basic database theory and phpMyAdmin … the most commonly used administrative program for MySQL.

But I have several others in the works.

Thanks,

Stefan Mischook

www.killerphp.com

Object Oriented Video Tutorials for your Ipod

Friday, March 14th, 2008

Hi,

I just released my beginners object oriented php video tutorials in iPod format.

ipod-php-video-icon

These videos target total beginners to object oriented programing. Though I talk about PHP, the principles are universal and so they apply to all OO (object oriented) languages including:

  • Java
  • Actionscript
  • C#
  • Ruby

.. and others. So if you are struggling to understand OOP concepts while trying to learn another language, these should help you along.

That said, I strongly believe that PHP is the best choice for web designers today.

Thanks,

Stefan Mischook

www.killerphp.com

PEAR vs. Zend Framework

Friday, March 14th, 2008

PEAR vs. Zend Framework

Now that the Zend Framework is ready for ‘prime time’, I’ve been considering the Pear framework with regards to how it now fits in the PHP world.

zend framework logo

NOTE:

Several picky nerds have pointed out that PEAR is not a framework – check out the comments below. OK, I would agree, technically speaking, PEAR is not a framework. That said, this is what the PEAR people say on the home page of their web site:

‘PEAR is a framework and distribution system for reusable PHP components. You can find help using PEAR packages in the online manual and the FAQ.’

Anyway, that is an argument of semantics and nerd-details … not the point of my article.

… Back to my article:


Both Zend and Pear are frameworks but how are they different?

I would say that the Zend Framework attempts to create a comprehensive whole – a consistent set of components that are designed to work together in a unified manner.

… That is one of the reasons for a framework in the first place.

Though unified, one of the cool things about the Zend Framework is that you can just pick and choose what components you want to use – you don’t have to buy the whole cake to take advantage of all that juicy object oriented PHP code.

About PEAR:
pear-framework-logo

With the Pear framework, it is more of a hodgepodge/motley of assorted components. Pear is widely used (and useful) but it does cross over (in terms of functionality) with what we have in the Zend Framework. So the question that comes to my mind is:

Do we still use Pear, if we have the Zend Framework?

(more…)

Zend Framework Video Tutorials

Sunday, March 9th, 2008

zend framework logo

I just launched a new section on Killerphp.com on the Zend Framework.

I figured it only made sense, given that we’ve built two live web applications based on it:

Video sharing site: www.idea22.com
Web template sharing site: www.webshapes.org

-

For those of you who are not familar with the Zend Framework:

The Zend Framework is a web application framework designed to make building complex PHP based web applications easier.

The Zend Framework contains a series of components (built using PHP 5) that manages many common task in web application development:

* Zend_Form: to make form handling/processing easier.
* Zend_Mail: makes email functionality trivial to create in PHP.
* Zend_Db_Adapter: to connect to databases.
* Zend_Pdf: allows you to easily create and edit PDF documents.

… And this is just a small sampling.

-

There is a lot more in the works in terms of our videos and articles.

Thanks,

Stefan Mischook

www.killerphp.com
www.killersites.com

Top of page  go to top of page