Archive for the ‘PHP Videos’ Category

New Video: MySQL and SQL Joins Part 1

Wednesday, March 10th, 2010

Database Image

Hi,

I just released the first of many videos on more advanced SQL and MySQL than we’ve covered before. From the courses description:

This course teaches you the very basics of MySQL, SQL then shows you how to use PHP with them. Once you have that under your belt, we jump into more advanced SQL and MySQL.

In this free sample video, we prepare our environment (MySQL) so we can start working with on SQL join queries:

There will be several other sample videos to come, but if you want them all NOW, (at the risk of being a shameless self promoter!) you can pick the entire 4hrs of the MySQL and SQL course in the killer video store.

Thanks,

Stefan Mischook
www.killerphp.com

New Screencasts: Use PHP, jQuery & AJAX to Load XML Data

Thursday, March 4th, 2010

video-icon

Hi,

I wanted to announce that we released a two part video screencast tutorial in our video tutorial subscription service on using PHP, jQuery and AJAX to load XML data.

… We built this script for our own sites, so that we could grab RSS feeds from our forums and display them on various home pages.

Learn not just one cool programming technique, but two, three or more!

This is a cool video tutorial, because it shows you not only how to use jQuery, but you also get to see how to combine jQuery with PHP to do something pretty useful.

For example, with what you learn in this video tutorial, you could create a news aggregator page that grabs RSS feeds from your favorite news sites … no need to surf around.

The source files are included with the video subscription service. You can find it in the Misc. PHP videos section of the library.

I may post part 1 here within the next few days – still thinking about it.

:)

Stefan Mischook (Nerd supreme around here!)
www.killerphp.com

Killersites University – Video Library

Wednesday, January 20th, 2010

killersites university logo

Hi,

I’ve been out of the picture for a little while, mainly because we’ve been busy with our new video tutorial subscription service.

Some PHP nerd details:

We built the web application from scratch using a basic MVC model with straightforward database work – no ORM was required for such a simple project.

The most time consuming aspect of this project was getting the UI to look good and work well – jQuery came in handy once again.

Anyway, you will find most of our PHP tutorials in there … and soon, a bunch of new video tutorials we are working on now.

The official announcement:

After a couple of months of hard work, we finally got the new video tutorial subscription system up and running.

About the University:

The Killersites University is a subscription based service that gives you total access to our GROWING collection of web design and web design related training videos. Not just a collection of tips and tricks videos, we provide complete video courses on popular subjects like:

* HTML
* CSS
* Dreamweaver
* PHP
* Javascript
* and much more

You can learn more about it here:

http://www.killersites.com/university/

What’s next?

Now that we have the University up and running, we will be able to focus a lot more time on new videos. Subscribe to the RSS feed or one of my newsletters to keep up-to-date.

Thanks,
Stefan Mischook
www.killersites.com

What are ORM Frameworks – the video!

Tuesday, December 15th, 2009

Hi,

I decided to create a video based on my recent article on ORM frameworks. I shot this in HD … so select the HD option if you got big pipes.

Let me know what you think.

Stefan Mischook

What are ORM Frameworks?

Tuesday, December 8th, 2009

Database Image

In the following article we will learn a few things about ORM frameworks:

  • What they are.
  • What they do.
  • When and why to use them.
  • And finally, what ORM options PHP’ers have.

Let’s start …

If you’re working with PHP, you will certainly find yourself working with relational databases (like MySQL) sooner or later. Anyone who has ever built a reasonably complex web application knows, that the SQL can get really hairy at times – especially when you consider all the data filtering that you have to deal with!

ORM frameworks to the rescue!

ORM is yet another nerd-acronym, it is short for Object Relational Mapping. In a nutshell, an ORM framework is written in an object oriented language (like PHP, Java, C# etc…) and it is designed to virtually wrap around a relational database. If you look at the name (ORM), it basically translates into: mapping objects to relational tables.

There are many different competing ORM frameworks out there, because many nerds have their own ideas as to how to best do things – nothing new here! But you know what, some of these nerds are right … not all ORM frameworks are created equal.

(more…)

Live Webinar on Google Wave and the Zend Framework

Monday, November 16th, 2009

Hi Guys,

My good buddy and right-hand-nerd, Jon is being flown down to do a live webinar for the Zend geeks at Intuit. It seems the accounting giant has recognized Jon’s ability to take the complex and make it seem simple.

Just in case you don’t know, Jon is the author of our crazy cool shopping cart tutorial and our new series on advanced PHP.

… Jon is starting to realize that my choice to go with the Zend Framework a few years ago made sense. Actually, it made dollars and cents!

:)

OK, bad nerd humor … I know. I’m just low on material that isn’t profanity laced.

If you want to know WHY, after looking at all the other PHP frameworks out there, that I thought the Zend Framework was the best choice long term (even back when Zend was still in Beta) .. you’re going to have to ask!

Anyway here is the official announcement:

Jon Lebensold, author of the popular PHP Shopping Cart and founder of Zendcasts.com will be writing a Google Wave Gadget in Boston at Intuit’s East coast office. Intuit is setting up a live webinar which you can attend by registering on the Zendcasts website.

Zendcasts.com began this year with the hope of assisting intermediate PHP developers further their Zend Framework skills. If you’re a PHP developer interested in building apps on Google Wave or want to watch someone build an AJAX application with web services like Google Wave and Intuit’s QuickBase, this free webinar will be worth spending a lunch hour at your desk.

The webinar takes place Wednesday, November 18 at 12:00 (noon) Eastern Standard Time (GMT -05:00).Register online now.

Here’s the banner:

qb-gwave-promo

Just in case you are not familiar with Quickbase … just click on the link.

That’s it for today. But coming soon, I will have some pretty big news … actually, the biggest thing to come to killerphp.com since we ordered that huge pizza! Ok, even bigger than that!!

;)

Stefan Mischook
www.killerphp.com

Getting into PHP6 and Advanced PHP Concepts Part 7

Friday, November 6th, 2009

Hi,

In our never ending quest for pure PHP nerdness, we continue our look at advanced PHP. This is video 7 of a series of videos where we explore PHP6 and other advanced PHP concepts, concepts often seen in PHP frameworks like Zend, PHP Cake and others.

The video:

More to come.

Stefan Mischook
www.killerphp.com

Getting into PHP6 and Advanced PHP Concepts Part 6

Sunday, November 1st, 2009

Hi,

They just keep on coming! This is video 6 of a series of videos where we explore PHP6 and other advanced PHP concepts, concepts often seen in PHP frameworks like Zend, PHP Cake and others.

The video:

Yes, I’m using Youtube … it saves me bandwidth! I’ve been pushing 250 GB a month just on Killerphp.com!

Many more to come,

Stefan Mischook
www.killerphp.com

Getting into PHP6 and Advanced PHP Concepts Part 5

Tuesday, October 27th, 2009

Hi,

As promised, this is video number FIVE of a series of videos where we explore PHP6 and other advanced PHP concepts, concepts often seen in PHP frameworks like Zend, PHP Cake and others.

You can expect this series to continue over the next several weeks.

Thanks for watching!

Stefan
www.killerphp.com

Getting into PHP6 and Advanced PHP Concepts Part 4

Friday, October 23rd, 2009

Hi,

As promised, this is the FOURTH video of a series of videos where we explore PHP6 and other advanced PHP concepts, concepts often seen in PHP frameworks like Zend, PHP Cake and others.

You can expect this series to continue over the next several weeks.

Thanks,

Stefan Mischook
www.killerphp.com

Getting into PHP6 and Advanced PHP Concepts Part 3

Wednesday, October 21st, 2009

boxshot-advphp

Hi,

As promised, this is the third video of a series of videos where we explore PHP6 and other advanced PHP concepts, concepts often seen in PHP frameworks like Zend, PHP Cake and others.

You can expect this series to continue over the next several weeks.

Thanks,

Stefan Mischook
www.killerphp.com

Getting into PHP6 and Advanced PHP Concepts Part 2

Tuesday, October 20th, 2009

boxshot-advphp

Hi everyone,

As promised, here is my second installment of our new PHP video tutorial course that covers more advanced PHP subjects including:

- PHP 6
- Advanced PHP architectures seen in PHP frameworks like Zend, CakePHP etc …
- Magic methods
- anonymous functions
- namespaces

Etc …

The second video:

Just in case you missed it, here is the link to the first part of Getting into PHP6.

Thanks for watching,

Stefan Mischook
www.killerphp.com

Getting into PHP6 and Advanced PHP Concepts Part 1

Friday, October 16th, 2009

boxshot-advphp

Hi everyone!

I’m back again (after my big move across town) and this time, I’ve got a new set of PHP video tutorials!

… Yes, people started to wonder why killerphp.com had a bunch of Javascript videos coming out; shouldn’t those videos belong on killerjavascript.com!?

;)

Anyway, I am happy to announce our new set of PHP videos that cover more advanced PHP subjects including:

- PHP 6
- Advanced PHP architectures seen in PHP frameworks like Zend, CakePHP etc …
- Magic methods
- anonymous functions
- namespaces

Etc …

The ultimate goal of these techniques is to learn how we can write more compact PHP code.

The first video:

That’s all for now.

… Now if only I can figure out why my new external drive is clicking?

Stefan Mischook
www.killerphp.com

JQUERY Video Tutorial Course.

Thursday, September 3rd, 2009

jquery-box-shot-medium

Hi,

I like to announce our new JQuery video tutorial course.

Though not strictly related to PHP, JQuery is a very popular Javascript library that many PHP programmers find themselves working with.

Besides straight JQuery videos, we do get into some PHP specific subjects:

  • PHP and Ajax
  • PHP and JSON

The table of contents:

* Getting jQuery: Part 1 – 8:22 minutes
* Getting jQuery: Part 2 – 8:57 minutes
* Events: Part 1 – 14:43 minutes
* Events: Part 2 – 13:23 minutes
* Dom manipulation – 10:39 minutes
* Ajax introduction – 10:16 minutes
* Ajax with PHP – 17:59 minutes
* Introduction to JSON – 14:47 minutes
* PHP classes with JSON – 21:21 minutes

-

This is not a one of my completely free courses but I released about 40 minutes of free videos from the course.

About the course:

jQuery is the predominate AJAX / Javascript library that is used by Adobe, Microsoft and many other companies and organizations.

Learning jQuery will make it easy for you to create all kinds of cool DOM and Ajax affects with very little effort. Beyond the canned menus and affects, jQuery also makes it easier for hard-core Javascript and AJAX programmers to get things done.

Thanks for reading,

Stefan Mischook
www.killersites.com

PHP Video: Controllers in MVC

Thursday, June 25th, 2009

php video

Hi,

In this video, I talk a little about the MVC design pattern with special attention to the middle layer in MVC: the ‘controller’.

A few points:

- MVC is short for Model View Controller
- The Controller is the part that brokers the communication between the View and the Model.
- The Controller is the throw-away part in MVC.

Watch the video for more details.

(more…)

PHP Video: Improve your PHP skills by learning ANOTHER programming language.

Sunday, June 21st, 2009

php video

In this video, I discuss how learning another programming language will make you a better PHP programmer. This may seem strange at first, but watch the video and you will see that I am not smoking anything …

Check out the video:

(more…)

PHP Video: Why Zend instead of other PHP Frameworks?

Sunday, June 14th, 2009

php video

Hi,

In response to my a recent podcast where I recommended that PHP programmers learn the Zend Framework, I was asked why I choose Zend, rather than other PHP frameworks.

The video:

(more…)

PHP Video: the Zend Framework and Web 2.0.

Tuesday, May 26th, 2009

php video
Hi,

I just released a new PHP video podcast where I answer a few questions put to me about php. I answer these questions:

1. Do you need to learn the Zend Framework?
2. Do you need a PHP certificate?
3. How does PHP fit into Web 2.0.

I am using a totally new format for this video and would appreciate your comments, good and bad about it.

Thanks,

Stefan Mischook

www.killerphp.com

New Wordpress Themes Video Tutorial

Wednesday, November 26th, 2008

video tutorial

Hi,

I just released a new video course on how to create a Wordpress theme/template from scratch.

About the video:

Video Synopsis – Building a Simple WordPress Theme

In these 12 videos, we will take someone with some beginner HTML and CSS skills through the steps needed to build a WordPress template from scratch. The videos use only a collection of freely downloadable tools that are available on Windows and Mac.

The goal of this set is to focus on the different files used in a functional WordPress template and how they all work together to build a unified design that is extensible and driven as much as possible from the WordPress blogging framework.

Included in this set is the construction of a dynamic top-level navigation, a widget-friendly sidebar, a customized search form and a specially-designed home page.

It is assumed that the viewer understands HTML and a bit of CSS. A basic understanding of PHP is helpful, but not required.

While its best to follow along, the project files are included in this video.

Those who know me, know that I am a big believer that both PHP programmers and web designers, should learn at least one CMS or blog software package. I jumped into the Wordpress camp a while back for a bunch of reasons:

- It’s popular.
- It’s easy to use.
- It’s easy to customize.

… And it is built with PHP.

Regardless, learning to create templates for Wordpress will help you with your PHP skills because you will learn about how PHP can be used to build a templating system.

Thanks for reading,

Stefan Mischook

www.killerphp.com
www.killersites.com

PHP Shopping Cart Video Tutorial Course – available for download.

Monday, September 22nd, 2008

video tutorial

Hi,

After teasing you guys for a week or so, I’ve released the entire video tutorial course on building a PHP based shopping cart.

There is a small charge ($19.99) to download the entire course, but it is more than worth it since you get 140 minutes of top notch nerd training … and we include the source code too.

The course outline:

PART 1: INTRODUCTION
Duration: 4:49

We’ll quickly go through what the end result our project is supposed to look like and some of the tools that will help us get there.

PART 2: TECHNOLOGY OVERVIEW
Duration: 10:42

A better look at the technologies as well as some of the tools we’re going to be used to build our PayPal shopping cart. We’ll also do a bit of refactoring and explain some of the benefits of using an IDE (integrated development environment).

PART 3: BUILDING AN XML CATALOG
Duration: 17:22

Using XML as our data storage format, we’re going to create a catalog of items for our shopping cart.

PART 4: BUILDING THE CATALOG PAGE
Duration: 15:30

We’re going to put some skin on that catalog and start making it look a little more like a page to buy items and a little less like the index of a phone book.

PART 5: FINISHING THE CATALOG TEMPLATE
Duration: 12:54

With our catalog completed, we’re going to tidy up – or refactor – our project and get ready to build the ShoppingCart object.

PART 6: MAKING AN “ADD TO CART” PAGE
Duration: 15:58

We’ll cover how we can use the $_SESSION array in PHP to store our customer’s order as they navigate our website and add items to the shopping cart. We’ll also start building the Shopping Cart class and look at some object-oriented programming concepts.

PART 7: BUILDING THE SHOPPING CART
Duration: 15:54

We will be adding the major functionality of our shopping cart class in this video and getting it ready for calculating subtotals and totals with shipping costs.

PART 8: CALCULATING COST
Duration: 7:37

We’ll be creating templates for our checkout page in order to have a proper line-item for each product with the necessary cost details.

PART 9: SHIPPING COST
Duration: 10:09

Now that we have the individual items lined up in our checkout page, we can add the shipping costs.

PART 10: FINISHING THE CART TEMPLATE
Duration: 8:38

We’re finally done writing our shopping cart class! Now we can put it to work with our newly created checkout page.

PART 11: SENDING DATA TO PAYPAL
Duration: 11:36

PayPal requires a collection of preset hidden form elements on form submission. These elements act as the glue between our shopping cart and their website, and we’re going to flush them out in this video.

PART 12: PAYPAL SANDBOX INTEGRATION
Duration: 12:31

We’re going to go through the steps needed to create a PayPal Sandbox account. This tool lets us complete transactions without having to pass money through PayPal.

PART 13: A QUICK LOOK AT PAYPAL’S IPN
Duration: 5:47

PayPal’s IPN (Instant Payment Notification) is a handy way of knowing when a transaction has been completed succesfully. We’ll quickly go over how we can pick up data collected by PayPal and how it can be used to track orders after they’ve been placed.

-

Should you have any questions or comments, please feel to post them.

PS: I will have more new FREE PHP and Dreamweaver CS4 videos coming out soon.

Thanks,

Stefan Mischook

Top of page  go to top of page