Archives For MySQL

A reader of my “Effortless E-commerce with PHP and MySQL” book took the time to recreate the first example in the book, called “Knowledge is Power”, using frameworks.

Continue Reading...

An article I wrote, titled “How to Store and Retrieve Binary Data Using PHP and MySQL“, was just published online by Peachpit Press. In the article, I explain how you store and retrive binary data using PHP and MySQL (it’s a clever title that way). I also explain why you might want to do this, which is equally important.

This is the first of four new advanced PHP articles that will be published online over the next couple of months.

I’m very happy to say that on Wednesday, December 12, 2012, I’ll be speaking to the BostonPHP group in Cambridge, Massachusetts. The title of my speech is “How To Be A Web Developer”. In the speech, I’ll provide a blueprint for how one becomes a Web developer considering the current standards, technologies, and business environment of 2012 and going into 2013. The overarching discussion is on the specific technologies you’ll need to learn and in what order. The role that each technology plays in Web development will be explained, as will some of the issues to watch out for. You’ll also be introduced to some of the applications and other tools that you would be expected to know and use. Towards the end of the presentation, extra time will be given to my favorite PHP framework–Yii–as well as how to get experience and jobs in the Web development field.
For more information, and to indicate your attendance, see this post.

Continue Reading...

Rob Allen, an active Zend Framework developer and writer, recently explained how to setup PHP and MySQL on the latest version of Mac OS X, 10.8 (aka Mountain Lion). The article does assume some comfort with using the Terminal application (i.e., working with the command line), but goes through everything you need to know, including installing and enabling several common needs. If you’re using Mountain Lion and don’t want to go the MAMP route (I’ve stopped using MAMP and other all-in-one packages myself), this article should be everything you need.

There are two goals for the book. The first is to help readers understand why you do things in certain ways. In other words, I want the reader to fully understand what’s going on behind the scenes so that he or she appreciates the context for whatever bit of code. This big picture approach is what I think is missing among the current documentation. The second goal is to demonstrate common tasks using real-world examples.

Continue Reading...