TweetFollow Us on Twitter

Book Review: PHP and MySQL Web Development

Volume Number: 19 (2003)
Issue Number: 10
Column Tag: Programming

Book Review: PHP and MySQL Web Development

by Ron Davis

It used to be you were an HTML "programmer" if you understood what <B> was. I've never really thought there was any such thing as a HTML "programmer." HTML is a mark-up language. It's data, not instructions. I'm not going to get into my personal feelings on scripting verses programming, but I've done a bit of one and a lot of the latter. The day came when my personal website needed to be able to generate content on the fly and I went looking for a language to make it do so.

At first what I wanted was C/C++ but that really isn't what you want to do web work in. Remember you are mostly manipulating text, which C/C++ isn't really all that good at. Also you are generally working with a machine you can't compile on. You can upload files though, and those files can be executed, so you need a scripting language.

Perl is the language everyone associates with UNIX, but after attempting to remove my cerebellum through my eye sockets during early Perl sessions I went looking for another language to write in. That's when I found PHP. Here was a C like scripting language made to generate web pages - one that integrated with databases, for even more interesting possibilities.

There are a lot of good online tutorials on the web for PHP. It is a very popular language. This is partially because it is free and partially because it doesn't induce suicidal tendencies when you try to code in it.

While there is no real link between PHP and MySQL they always seem to go together. This is mainly because they are both free and offered as part of Linux, the dominant platform for web hosting companies. So everyone with a web site gets PHP and MySQL for free.

When it comes time to get serious about learning to use these two technologies, you should pick up the book PHP and MySQL Web Development by Luke Welling and Laura Thomson. It is both a great introduction and reference for PHP.

Personally I like books that teach you by doing. I want examples that will provide real world use. Even when a book does an example a chapter, I will often change the example to something I need as I read. PHP and MySQL Web Development does this well. After the required introductory chapter, each chapter introduces a new concept with a relevant example. In the end you have a complete web site with lots of different functionality.

To use the book you are going to have install PHP and MySQL. If you are using a non-server version of MacOS X you will have to install MySQL. There is downloadable package to do this with instructions at Marc Liyanage's site:

http://www.entropy.ch/software/macosx/mysql/

If you want to run PHP code on your local machine using the built in Apache server, you will need to do some configuration. Apple provides some instructions on how to do this.

http://developer.apple.com/internet/macosx/php.html

Once this is done you should have no trouble doing any of the examples in the book. I found no platform-specific problems while using the book.

The first part of the book teaches you the basics of PHP, including how you put PHP code inside your HTML file. It goes on to discuss the various features of the language includeing manipulating strings with regular expressions, reading and writing files, and arrays. After you get a basic understanding of PHP, it switches to talking about MySQL.

This first section on MySQL deals only with designing and creating databases. You work on the command line with MySQL.

After you have learned to use MySQL, you'll learn how to talk to MySQL with PHP. There are two chapters in the MySQL section showing basic and advanced interaction. In reality talking to other databases is accomplished almost exactly the same way. I had a site I built on my local machine using MySQL and then moved to a server and used it with MSSQL by changing the prefix on the calling routines.

Part three of the book is the meat of learning to use these technologies. The authors step you through a complete e-comerce system built with PHP and MySQL. By the time you get to this point in the book you understand the language and MySQL enough you can just start pulling the sections of this program you need out and use them. If you skip around you will occasionally have to go back to a previous chapter to figure out how the database is set up or what some variables mean. But if you need a user system, refer to chapter 24 "Building User Authorization and Personalization." Shopping cart? Chapter 25. Content management system? Chapter 27.

Appendix A on installing PHP and MySQL is largely useless to the Mac user. The index is good, letting you use the book as a general PHP/SQL reference. When you want more depth you can check out the PHP manual online at:

http://www.php.net/docs.php

Appendix B also gives an extensive list of web resources.

This book sits on my bookshelf with little post it notes sticking out at relevant pages. The only real complaint I have about the book is its size with over 800 pages. But it does cover a lot of stuff. Also since it is example based, it is somewhat hard to find a specific PHP function. I have little bookmarks for the date command and the SQL Alter table command.

If you are looking for a good book to cover all of the things about PHP and MySQL you need to do most common web tasks, this book is it.


Ron Davis is a long time Macintosh Software Engineer, having worked for companies like Apple and Metrowerks on a variety of products from development tools to anti-virus software. His day job is working for Alsoft, and his evening job is R.A.D. Productions, makers of Suck It Down and FinderEye.

 

Community Search:
MacTech Search:

Software Updates via MacUpdate

Tunnelblick 3.8.2a - GUI for OpenVPN.
Tunnelblick is a free, open source graphic user interface for OpenVPN on OS X. It provides easy control of OpenVPN client and/or server connections. It comes as a ready-to-use application with all... Read more
calibre 4.17.0 - Complete e-book library...
Calibre is a complete e-book library manager. Organize your collection, convert your books to multiple formats, and sync with all of your devices. Let Calibre be your multi-tasking digital librarian... Read more
MacPilot 11.1.4 - $15.96
MacPilot gives you the power of UNIX and the simplicity of Macintosh, which means a phenomenal amount of untapped power in your hands! Use MacPilot to unlock over 1,200 features, and access them all... Read more
Transmission 3.00 - Popular BitTorrent c...
Transmission is a fast, easy, and free multi-platform BitTorrent client. Transmission sets initial preferences so things "just work", while advanced features like watch directories, bad peer blocking... Read more
Doom 3 1.3.1 - First-person shooter acti...
A massive demonic invasion has overwhelmed the Union Aerospace Corporation's (UAC) Mars Research Facility, leaving only chaos and horror in its wake. As one of only a few survivors, you must fight... Read more
Box Sync 4.0.8004 - Online synchronizati...
Box Sync gives you a hard-drive in the Cloud for online storage. Note: You must first sign up to use Box. What if the files you need are on your laptop -- but you're on the road with your iPhone? No... Read more
LibreOffice 6.4.4.2 - Free, open-source...
LibreOffice is an office suite (word processor, spreadsheet, presentations, drawing tool) compatible with other major office suites. The Document Foundation is coordinating development and... Read more
Day One 4.14 - Maintain a daily journal.
Day One is an easy, great-looking way to use a journal / diary / text-logging application. Day One is well designed and extremely focused to encourage you to write more through quick Menu Bar entry,... Read more
MenuMeters 2.0.7 - CPU, memory, disk, an...
MenuMeters is a set of CPU, memory, disk, and network monitoring tools for Mac OS X. Although there are numerous other programs which do the same thing, none had quite the feature set I was looking... Read more
Doxie 2.12.2 - Scan, share, and store do...
Introducing Doxie, the new, modern paper scanner that's so simple, it'll revolutionize the way you think about sharing and storing docs and photos forever. Doxie is ultra-portable, fully automatic,... Read more

Latest Forum Discussions

See All

SINoALICE, Yoko Taro and Pokelabo's...
Yoko Taro and developer Pokelabo's SINoALICE has now opened for pre-registration over on the App Store. It's already amassed 1.5 million Android pre-registrations, and it's currently slated to launch on July 1st. [Read more] | Read more »
Masketeers: Idle Has Fallen's lates...
Masketeers: Idle Has Fallen is the latest endeavour from Appxplore, the folks behind Crab War, Thor: War of Tapnarok and Light A Way. It's an idle RPG that's currently available for Android in Early Access and will head to iOS at a later date. [... | Read more »
Evil Hunter Tycoon celebrates 2 million...
Evil Hunter Tycoon has proved to be quite the hit since launching back in March, with its most recent milestone being 2 million downloads. To celebrate the achievement, developer Super Planet has released a new updated called Darkness' Front Yard... | Read more »
Peak's Edge is an intriguing roguel...
Peak's Edge is an upcoming roguelike puzzle game from developer Kenny Sun that's heading for both iOS and Android on June 4th as a free-to-play title. It will see players rolling a pyramid shape through a variety of different levels. [Read more] | Read more »
Clash Royale: The Road to Legendary Aren...
Supercell recently celebrated its 10th anniversary and their best title, Clash Royale, is as good as it's ever been. Even for lapsed players, returning to the game is as easy as can be. If you want to join us in picking the game back up, we've put... | Read more »
The Magic Gladiator class arrives in MU...
The Magic Gladiator class is now available in MU Origin 2 following the most recent patch. It also marks the start of Abyss Season 11 and the introduction of Couple Skills and Couple Dungeons. [Read more] | Read more »
The 5 Best Racing Games
With KartRider Rush+ making a splash this past week, we figured it was high time we updated our list of the best mobile racing games out there. From realistic racing sims to futuristic arcade racers (and even racing management games!), check out... | Read more »
KartRider Rush+ Guide - Tips for new rac...
KartRider Rush+ continues to be a surprisingly refreshing and fun kart racer that's entirely free-to-play. The main reason for this is just how high its skill ceiling is. Check out the video above if you're curious to know what top level play looks... | Read more »
KartRider Rush+ might be good, actually?
It's hard to find good racing games on mobile. Most of them are free-to-play, and free-to-play racers generally suck. Even Nintendo couldn't put together a competent Mario Kart game, opting instead for a weird score chaser that resembles--but feels... | Read more »
LifeAfter, NetEase's popular surviv...
A new map will be making its way into NetEase's popular survival game LifeAfter. The map is set to arrive on May 28th and will introduce a volcano that's teetering on the verge of eruption, bringing a host of added challenges to the game. [Read... | Read more »

Price Scanner via MacPrices.net

Memorial Day Weekend Sale: Take $300 off thes...
Apple resellers are offering $300 discounts on select 16″ MacBook Pros as part of their Memorial Day Weekend 2020 sales. Prices start at $2099: – 16″ 2.6GHz 6-Core Space Gray MacBook Pro: $2099 at... Read more
Best Memorial Day Weekend 2020 Apple AirPods...
Apple resellers are offering discounts ranging up to $50 off MSRP on AirPods as part of their Memorial Day Weekend 2020 sales. These are the best deals today on various AirPods models. See our... Read more
Memorial Day Weekend Sale: 10″ Apple iPads fo...
Amazon is offering new 10.2″ iPads for $80-$100 off Apple’s MSRP as part of their Memorial Day Weekend 2020 sale, with prices starting at only $249. These are the same iPads sold by Apple in their... Read more
Memorial Day Weekend Sale: 2020 Apple iPhone...
Sprint is offering Apple’s new 2020 64GB iPhone SE for $0 per month for 18 months as part of their Memorial Day Weekend 2020 sale. New line of service and trade-in required. Offer is valid from 5/22/... Read more
Amazon’s popular $100 Apple Watch Series 5 di...
Amazon has Apple Watch Series 5 GPS + Cellular models on sale for up to $100 off Apple’s MSRP today. Shipping is free. These are the same Apple Watch models sold by Apple in their retail and online... Read more
2020 13″ 4-Core MacBook Air on sale for $949,...
Apple reseller Adorama has the new 2020 13″ 1.1GHz 4-Core Space Gray MacBook Air on sale today for $949 shipped. Their price is $50 off Apple’s MSRP, and it’s the lowest price currently available for... Read more
Apple Retail Chief Announces Staggered Reopen...
NEWS: 05.20.20 – In the midst of a global pandemic, after its retail outlets were shuttered temporarily in mid-March as a mitigation measure enacted by Apple during the peak of the spread of COVID-19... Read more
Apple’s Pro Display XDR models in stock today...
Abt Electronics has Apple’s new 32″ Pro Display XDR models in stock and on sale today for up to $305 off MSRP. Shipping is free. Their prices are currently the lowest available for these new models... Read more
Apple restocks refurbished iPhone 8 for $339
Apple has restocked Apple Certified Refurbished 64GB iPhone 8 models for only $339. Apple dropped their price on this phone last month by $160, from $499 to $339. Each refurbished iPhone comes with a... Read more
New at AT&T: 50% off iPhone 11 for new cu...
AT&T is offering a 50% off the 64GB iPhone 11 for new customers who switch to AT&T and open a new line of service. Discount applied over a 30 month period The fine print: “iPhone 11 64GB for... Read more

Jobs Board

Cub Foods - *Apple* Valley - Now Hiring Par...
Cub Foods - Apple Valley - Now Hiring Part Time! United States of America, Minnesota, Apple Valley New Retail Operations Post Date 5 days ago Requisition # Read more
Senior Data Engineer - *Apple* - Theorem, L...
Job Summary Apple is seeking an experienced, detail-minded data engineeringconsultant to join our worldwide business development and strategy team. If you are Read more
Cub Foods - *Apple* Valley - Now Hiring Par...
Cub Foods - Apple Valley - Now Hiring Part Time! United States of America, Minnesota, Apple Valley New Retail Operations Post Date 4 days ago Requisition # Read more
Medical Screener - *Apple* Hill - Evenings...
Medical Screener - Apple Hill - Evenings Tracking Code D-MS-AH-E Job Description Medical Screener - Temporary We Are Hiring: WellSpan Health has a temporary Medical Read more
*Apple* Systems Administrator - Solidus Tech...
Solidus is searching for an Apple Systems Engineer. The engineer will be responsible for desktop and server infrastructure. This includes support for operating Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.