Hi,

In our continued aim to transform you web guys into full-fledged web programmers, we have yet another cool video tutorial series … this time on basic PHP and MySQL interaction, something the nerds refer to as CRUD.

Check out the second video from the screencast series:

More free samples from this course coming soon.

Stefan Mischook
www.killerphp.com

Hi,

In our continued aim to transform you web guys into full-fledged web programmers, we have yet another cool video tutorial series … this time on basic PHP and MySQL interaction, something the nerds refer to as CRUD.

Check out the first video from the screencast series:

More free samples from this course coming soon.

Stefan Mischook
www.killerphp.com

Hi,

We just released a new screencast on building a login system with PHP. Our official release notes:

This six part video series explains how to create a simple PHP login system using PHP, MySQLi, PHP sessions and a variation of the MVC pattern. This system allows authorized members to login, access a member’s only section, and log out, as well as showing how to create a form that adds new members to the database.

This video course, along with hundreds of other videos on PHP and web design, can be found in the Killersites University … our video tutorial subscription service.

I will be releasing free sample videos from this course very soon.

Stefan Mischook
www.killerphp.com

Hi,

Sometimes I post questions that are put to me by people. This is a beginners question, so you experienced nerds will want to move on. Nonetheless, I am sure there are a few debutant PHP programmers who will find this useful.

The question:

So in a nutshell, what is the difference between PHP 5 and CRUD?

PHP5 is just a version of PHP. Whereas CRUD is short for a series of PHP+MySQL operations/interactions:

- Create
- Read
- Update
- Delete

…These are the core operations that can be preformed on a database. CRUD is so important in fact, that we just released a mini video series on PHP CRUD that can now be found in the Killersites University … our video tutorial subscription service.

Stefan.

Hi,

In our continued efforts to make programming approachable (even for the non nerd,) I got my brother (Richard Mischook) to write a quick article/tutorial introducing iPhone and iPad development – he’s busy build an iPhone application as I write.

The goal of this article is to help you understand what you need to know and what tools you have available, when it comes to creating software/web apps for the iPhone and iPad.

Stefan Mischook

-

Introduction

The introduction of the iPhone by Apple a few years back caused a lot of excitement among both consumers and developers. The iPhone was arguably the first mobile device that made both mobile computing and web surfing practical. The iPad (which runs on iPhone OS) has been met with skepticism in some quarters. But so far it appears to be selling well and attracting a lot of interest from content creators.

Apple originally intended that the main source of third-party applications for the iPhone would be web applications, and there are of course many of these. But something funny happened when Apple released the iPhone SDK and an App Store to go with it – people came. Developers developed and consumers consumed.

Read the rest of this article on iPhone and iPad development.

Hi,

I just wanted to announce that we will be releasing a PHP log in system video tutorial within a few days.

Like all our videos, as you learn to build the project at hand, you will be secretly taught reusable PHP techniques and even some dreaded PHP nerd theory! Don’t worry though, the nerd theory will be woven into the videos, so you won’t even notice it seeping into your brain.

Many of the videos will be released on this blog for free, but the whole course (and source files) will only be available to Killersites University subscribers or as part of our upcoming complete web developer training package.

… Yes, a shameless plug but nerds need to eat too (and play video games) so we have so charge you guys a little sometimes!

Follow this blog to keep in touch.

Stefan Mischook
www.killerphp.com

Hi,

We just released a couple of new videos at Killersites University:

These two videos show how to modify the view.php file we created earlier in Part 1 of the ‘CRUD Basics with MySQLi & PHP‘ series to add basic pagination. This functionality is often required for large data sets, providing a better user experience by splitting up a long list of records into multiple pages. These videos briefly introduce the MySQLi data_seek() function, used to pull specific records from the database.

Free samples will be coming out soon.

Stefan Mischook
www.killerphp.com

Hi,

In our ongoing effort to provide top quality screencasts authored by working web designers and web programmers (that means practical training) … we just released a new set of videos on PHP CRUD.

The official summary:

This is a six part series that covers how to create a basic application that creates, reads, updates and deletes records (often called CRUD) from a MySQL database using MySQLi. MySQLi helps prevent SQL injection, a common security issue. Understanding how to use a MySQL database and work with database records is an essential skill for beginning web developers.

You can find these videos in our growing collection of video training tutorials at Killersites University.

I will be releasing several free samples from this (and other series) as soon as I can find the time – busy these days watching TV.

We have several other PHP and programming related video in Killersites University .. I just haven’t had time to blog about them. More to come soon.

Stefan Mischook
www.killersites.com

Hi,

We continue from where we left off in part 1 of our video on SQL joins. Still setting up things to do our SQL work, in this particular video, we continue to build our MySQL table.

The video:

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

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

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

Hi,

I haven’t been working on killerphp for a little while because of work on other websites in the killersites network … OK, and other things too.

… Xbox can take up a lot of time!!

What’s news?

Well, we have a whole slew of advanced MySQL videos coming out within a week. We will be covering some more advanced topics not covered in our PHP basics video course.

As usual, many of the videos will be posted here for free and many others will be available via our video tutorial subscription service and also as a complete stand-alone screencast course for download or on DVD.

Thanks,

Stefan Mischook
www.killerphp.com