I am proud to announce that PHP with MySQL Beyond the Basics has been released on the lynda.com Online Training Library. It is the sequel to my previous video title, PHP with MySQL Essential Training. It’s almost 11 hours of video training; with the previous title, that makes a total of 21 hours of PHP training!

While the first training was an introduction to PHP and MySQL, in this title I focus on “intermediate PHP” and PHP’s object-oriented features. Objects make it easier to organize and maintain your code, make code modular and reusable, and (most importantly) add clarity by reducing complex interactions to simple behaviors. Once you understand the fundamentals of PHP, you’ll want to learn to harness the power Object-Oriented Programming provides.

PHP with MySQL Beyond the Basics is available online as streaming video to subscribers of the lynda.com Online Training Library ($25/month, $250/year, $375/year with exercise files included). It is will also be available as a CD-ROM soon both through lynda.com and Amazon.com.

Here’s the official description:

In PHP with MySQL Beyond the Basics, expert instructor Kevin Skoglund introduces powerful PHP programming techniques using object-oriented programming (OOP). Both novice and experienced PHP developers will benefit from the efficient, well-organized, reusable, and easy-to-understand code that OOP offers. Kevin shows how OOP techniques can streamline database queries, help manage sessions, and simplify user logins. While building a real-world web application, Kevin also includes practical advice on topics ranging from structuring code to logging user actions. Exercise files accompany the course.

If you are already using PHP but not objects or if you use objects but don’t understand them as well as you’d like, give this training a try and let me know what you think!

A student sent me email to ask: “In a general sense, when writing code, is there a sequence of steps or a pattern to the logic when writing the code?”

It’s a good question. Experienced computer programmers have learned these steps—either through intuition or experience—but beginning programmers are often mystified. Once you learn the language syntax, how exactly do you use it to approach a programming problem? Especially if you want to try to use good programming techniques and to solve the problem in a smart and efficient way.

The answer to the question “Are there steps to writing code?” is “Yes”. After the jump, I’ll give three ways to develop the logic necessary to write good code.

(more…)

It’s been a while since my last post. I’ve been busy on a few projects with upcoming deadlines. Harder still, I am working on both a Ruby on Rails and a PHP project at the same time and switching mindsets is challenging. (I can’t count the number of times I type self when I mean $this and vice versa.) It is like traveling between two foreign countries several times a day. I speak French to the German baker and German to the French butcher. (Or, most often, I am speechless in both cases!)

For the PHP project, I need to work with fractions of an inch in a few places. Not as decimals, but as fractions (1/5, 5/12, 3/64, etc.). Fractions are not an uncommon problem for developers. Since there seem to be very few discussions online about the subject, I thought it would be worthwhile to review some of the options. My example code will be in PHP since that’s the “country” I’m in right now, but the Ruby code is easy to extrapolate.

(more…)

I recently upgraded to Mac OS X Leopard. After the upgrade, MySQL was still working but PHP was not working at all. (The MySQL preference pane doesn’t work but I usually start and stop it from the command line anyway.) I discovered that there are three problems. I will briefly describe how to resolve them in case you have the same problem.

(more…)

I’ve been lax about blogging over the last few weeks. September is always a busy month. Everything that was put on hold during August vacations suddenly shifts into high gear. My back log of blog-worthy posts is intimidating, so I’ve decided to handle it expeditiously and keep posts short and sweet until I’m caught back up.

php|works 2007 was two weeks ago in Atlanta. Below are some of the session notes and online reviews I’ve collected.

Session Notes

• Testing with PHPUnit and Selenium
• Advanced PHPUnit Topics
• Designing RESTful Web Applications

Reviews and Commentary

• http://benramsey.com/archives/phpworks-2007-day-2/
• http://benramsey.com/archives/phpworks-2007-day-3/
• http://blogs.oracle.com/opal/discuss/msgReader$170
• http://blogs.oracle.com/opal/discuss/msgReader$203
• http://blog.libssh2.org/index.php?/archives/74-phpworks,-Session-Day-1-aka-Conf-day-2.html
• http://blog.libssh2.org/index.php?/archives/75-phpworks-2007,-Session-Day-2-aka-Conf-day-3.html
• http://www.surripui.net/2007/09/15/phpworks-is-now-over-back-to-work/
• http://shiflett.org/blog/2007/sep/php-works-recap
• http://devzone.zend.com/article/2557-phpworks-Wrap-Up

Let me know if you find more and I’ll add them to the list.

Here’s some of the exciting things I didn’t blog about while I was on vacation last week.

• PHP 5.2.4 has been released. The improvements are mostly related to stability and security.
• The first release candidate of Prototype 1.6.0 was announced.
• dev_mode_performance_fixes is a Ruby on Rails plugin to improve development-mode performance by only reloading files that have changed.
• Eric Meyer’s CSS Sculptor, a Dreamweaver extension for generating CSS, was released.
• A List Apart posted “CSS @ Ten: The Next Big Thing” by HÃ¥kon Wium Lie. Though the title doesn’t say so, it’s a call to action to get full font support into CSS.
• A List Apart posted “Put Your Content in My Pocket“, by Craig Hockenberry, which has tips on designing web pages for Apple’s iPhone.
• The Ruby East Conference will be September 28, 2007 at Penn State, Great Valley Campus, PA (just west of Philadelphia). Tickets are $100 and limited to 300 people.
• Dmitry Stogov’s PHP namespace implementation has support for constants and David Coallier provides a usage example.

I already announced the online release of PHP with MySQL Essential Training. I’m really happy that it’s been getting tons positive user feedback. It seems to be helping a lot of people understand PHP as well as web development in general and that’s very gratifying.

Now you can also purchase the CD-ROM version. It’s $149.95 for 10.75 hours of training on 2 CDs. You can purchase it from lynda.com’s store or from Amazon.com.

The nice thing about the online version is that you can access it anytime, anywhere and you’ll also get access to all the other great lynda.com titles (including my Ruby on Rails Essential Training).

Why might the CD-ROM be right for you? A few reasons come to mind: No internet connection is required so you can watch offline or even when you travel. You’ll have speedier access to higher-quality video and sound. It includes the tutorial files so you can work along with me. You’ll have it on your shelf to refer to anytime, even if you don’t maintain your lynda.com subscription (but why wouldn’t you want do that?). You can share copies around your office or school. For large organizations, lynda.com can work out multiple-copy, site license deals too. And some people like having both the offline and online versions—one for the office, one for home or on the road.

If you’ve already watched either the PHP or Ruby on Rails training found it helpful, I hope you’ll consider taking a minute to write a review on Amazon.com with your opinion. Amazon.com shoppers don’t always know Lynda.com’s great reputation and your review will help them trust that the training can be helpful to them too.

Considering how old and popular PHP is, it’s hard to believe that this issue hasn’t been addressed before now…

Gregory Szorc just noticed that one of the changes to PHP 5.2.4 is that PHP errors, which used to result in an unhelpful blank page with an HTTP 200 status code, will now send an HTTP 500 status code instead. Then your web server can handle the 500 error with a default “Sorry, a server error occured” page. It’s not only much cleaner but it is the way HTTP status codes are meant to be used.

PHP 5.2.4 isn’t out just yet, but should be very soon. It’s currently being tested as a final release candidate.

Back in July, I wrote that the PHP internals team was discussing implementing namespaces in PHP 6. Though still subject to change, the results have been commited to the official version.

Dmitry Stogov and Stanislav Malyshev’s idea is still the leading candidate (because they stepped up and fully implemented it) and but there’s been some discussion over a) whether it’s the right way to go, b) whether it is a “namespace” or actually a “package”. I don’t want to walk into the firing line of either discussion, but as I noted before I’ll cast my vote for any implementation that allows namespaces to envelope blocks of code with curly-braces. (Theirs doesn’t currently.)

If you want to better understand where namespaces may be headed there are two blog posts that can help. The first is “PHP Namespaces (Part 1: Basic usage & gotchas)” by David Coallier. The second is “Namespaces FAQ” by Stanislav Malyshev himself. I suggest reading Coallier’s first to get the basic idea.

The Zend/PHP Conference & Expo is October 8-11 in San Francisco. Both Stogov and Malyshev will be speaking. Even though there isn’t a session about it, I’d expect namespaces to be a major and lively topic of discussion at the event. Maybe a consensus and resolution will come out of it.

If you haven’t heard already, a few pages of PHP source code for Facebook were leaked online. The site wasn’t hacked so much as a back door was left open.

Here’s what Facebook had to say:

“A small fraction of the code that displays Facebook web pages was exposed to a small number of users due to a single misconfigured web server that was fixed immediately. It was not a security breach and did not compromise user data in any way. Because the code that was released only powers the Facebook user interface, it offers no useful insight into the inner workings of Facebook. The reprinting of this code violates several laws and we ask that people not distribute it further.”

Some geeks were elated, some horrified, and some just shrugged. I fall into the third category.

It did offer a glimpse behind the wall of one of the most hyped companies of the moment and it’s always interesting to see how the industry leaders are doing things. While the code could provide details that might compromise the security of their other servers and pages, I’m guessing they are already re-engineering their setup to make any clues useless.

But this leak doesn’t mean that PHP is flawed. It doesn’t mean that any server hardware/software choice was to blame. It was misconfigured. It was human error. (“This sort of thing has cropped up before and it has always been due to human error.”)

Instead it is a cautionary tale about being thorough and vigilant. It should remind web developers and users not to assume sites are secure just because the code is good or the company is reputable. A website is only as secure as it’s weakest link. You can only take a limited amount of security for granted.

If you want to try to improve some of those weak links on your site… Nik Cubrilovic offers four tips to help prevent your server from doing the same thing. (Though a lot of people have blasted his assertion that PHP is known to sometimes return source code…) Vidyut Luther lists three more tips that can help.