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

Viber 11.9.1 - Send messages and make fr...
Viber lets you send free messages and make free calls to other Viber users, on any device and network, in any country! Viber syncs your contacts, messages and call history with your mobile device, so... Read more
Vallum 3.3.2 - $15.00
Vallum is a little tool that helps you monitor and block apps connections and throttle apps bandwidth. It is able to intercept connections at the application layer, and hold them while you decide... Read more
Microsoft OneNote 16.31 - Free digital n...
OneNote is your very own digital notebook. With OneNote, you can capture that flash of genius, that moment of inspiration, or that list of errands that's too important to forget. Whether you're at... Read more
Apple Pages 8.2.1 - Apple's word pr...
Apple Pages is a powerful word processor that gives you everything you need to create documents that look beautiful. And read beautifully. It lets you work seamlessly between Mac and iOS devices, and... Read more
Numbers 6.2.1 - Apple's spreadsheet...
With Apple Numbers, sophisticated spreadsheets are just the start. The whole sheet is your canvas. Just add dramatic interactive charts, tables, and images that paint a revealing picture of your data... Read more
f.lux 39.9873 - Adjusts the color of you...
f.lux makes the color of your computer's display adapt to the time of day, warm at night and like sunlight during the day. Ever notice how people texting at night have that eerie blue glow? Or wake... Read more
Deeper 2.5.0 - Enable hidden features in...
Deeper is a personalization utility for macOS which allows you to enable and disable the hidden functions of the Finder, Dock, QuickTime, Safari, iTunes, login window, Spotlight, and many of Apple's... Read more
NTFS 15.5.71 - Provides full read and wr...
NTFS breaks down the barriers between Windows and macOS. Paragon NTFS effectively solves the communication problems between the Mac system and NTFS. Write, edit, copy, move, delete files on NTFS... Read more
MTR 5.3.0.0 - The Mac's oldest and...
MTR (was MacTheRipper)--the Mac's oldest and smartest DVD-backup app. MTR - the complete toolbox, not a one-trick, point-and-click extractor. MTR is intended for making fair-use, backup copies of... Read more
Keynote 9.2.1 - Apple's presentatio...
Easily create gorgeous presentations with the all-new Keynote, featuring powerful yet easy-to-use tools and dazzling effects that will make you a very hard act to follow. The Theme Chooser lets you... Read more

Latest Forum Discussions

See All

Black Desert Mobile gets an official rel...
Pearl Abyss has just announced that its highly-anticipated MMO, Black Desert Mobile, will launch globally for iOS and Android on December 11th. [Read more] | Read more »
Another Eden receives new a episode, cha...
Another Eden, WFS' popular RPG, has received another update that brings new story content to the game alongside a few new heroes to discover. [Read more] | Read more »
Overdox guide - Tips and tricks for begi...
Overdox is a clever battle royale that changes things up by adding MOBA mechanics and melee combat to the mix. This new hybrid game can be quite a bit to take in at first, so we’ve put together a list of tips to help you get a leg up on the... | Read more »
Roterra Extreme - Great Escape is a pers...
Roterra Extreme – Great Escape has been described by developers Dig-It Games as a mini-sequel to their acclaimed title Roterra: Flip the Fairytale. It continues that game's tradition of messing with which way is up, tasking you with solving... | Read more »
Hearthstone: Battlegrounds open beta lau...
Remember earlier this year when auto battlers were the latest hotness? We had Auto Chess, DOTA Underlords, Chess Rush, and more all gunning for our attention. They all had their own reasons to play, but, at least from where I'm standing, most... | Read more »
The House of Da Vinci 2 gets a new gamep...
The House of Da Vinci launched all the way back in 2017. Now, developer Blue Brain Games is gearing up to deliver a second dose of The Room-inspired puzzling. Some fresh details have now emerged, alongside the game's first official trailer. [Read... | Read more »
Shoot 'em up action awaits in Battl...
BattleBrew Productions has just introduced another entry into its award winning, barrelpunk inspired, BattleSky Brigade series. Whilst its previous title BattleSky Brigade TapTap provided fans with idle town building gameplay, this time the... | Read more »
Arcade classic R-Type Dimensions EX blas...
If you're a long time fan of shmups and have been looking for something to play lately, Tozai Games may have just released an ideal game for you on iOS. R-Type Dimensions EX brings the first R-Type and its sequel to iOS devices. [Read more] | Read more »
Intense VR first-person shooter Colonicl...
Our latest VR obsession is Colonicle, an intense VR FPS, recently released on Oculus and Google Play, courtesy of From Fake Eyes and Goboogie Games. It's a pulse-pounding multiplayer shooter which should appeal to genre fanatics and newcomers alike... | Read more »
PUBG Mobile's incoming update bring...
PUGB Mobile's newest Royale Pass season they're calling Fury of the Wasteland arrives tomorrow and with it comes a fair chunk of new content to the game. We'll be seeing a new map, weapon and even a companion system. [Read more] | Read more »

Price Scanner via MacPrices.net

New 2019 16″ MacBook Pros on sale for $100 of...
Apple Authorized Reseller Adorama has new 2019 16″ MacBook Pros on sale today for $100 off Apple’s MSRP, each including free shipping. In addition, Adorama charges sales tax for NY & NJ residents... Read more
Apple Watch Series 3 GPS models on sale for l...
Amazon has Apple Watch Series 3 GPS models on sale starting at only $179. There prices are the lowest we’ve ever seen for these models from any Apple reseller. Choose Amazon as the seller rather than... Read more
iOS Bug In Facebook News Feed Lets Device Ca...
NEWS: 11.15.19- Users of the Facebook social media platform’s mobile app running on iOS devices won’t, like, this piece of news one bit in where a bug in the News Feed gave access to the camera... Read more
16″ MacBook Pros on sale! Preorder at Amazon...
Apple’s new 16″ MacBook Pros were only introduced yesterday, but Amazon is already offering a $100 discount on preorders. Prices for the base 6-Core 16″ MacBook Pros start at $2299: – 2019 16″ 2.6GHz... Read more
Use our exclusive MacBook Price Trackers to f...
Our Apple award-winning MacBook price trackers are the best place to look for the best sales & lowest prices on new and clearance MacBook Airs and MacBook Pros–including Apple’s new 16″ MacBook... Read more
New November Verizon iPhone deal: Get an iPho...
Verizon has the 64GB iPhone Xr on sale for 50% off for a limited time, plus they will include a free $200 prepaid MasterCard and a free Amazon Echo Dot. That reduces their price for the 64GB iPhone... Read more
Apple cuts prices on clearance, refurbished 2...
Apple has clearance 2018 15″ 6-Core Touch Bar MacBook Pros, Certified Refurbished, now available starting at only $1829. Each model features a new outer case, shipping is free, and an Apple 1-year... Read more
Up to $450 price drop on clearance 15″ MacBoo...
B&H Photo has dropped prices Apple’s 2019 15″ 6-Core and 8-Core MacBook Pros by $400-$450 off original MSRP, starting at $1999, with free overnight shipping available to many addresses in the US... Read more
Here’s how to save $200 on Apple’s new 16″ Ma...
Apple has released details of their Education discount associated with the new 2019 16″ 6-Core and 8-Core MacBook Pros. Take $200 off the price of the new 8-Core model (now $2599) and $200 off the 16... Read more
Price drop! 2019 15″ 2.6GHz 6-Core MacBook Pr...
Focus Camera has dropped their price for clearance 2019 15″ 2.6GHz 6-Core Space Gray MacBook Pros by $400 to $1999 shipped. Apple’s original MSRP for this model was $2399. Focus charges sales tax for... Read more

Jobs Board

Best Buy *Apple* Computing Master - Best Bu...
**746655BR** **Job Title:** Best Buy Apple Computing Master **Job Category:** Sales **Store NUmber or Department:** 002518-Atlantic Center-Store **Job Description:** Read more
*Apple* Mobility Pro - Best Buy (United Stat...
**744973BR** **Job Title:** Apple Mobility Pro **Job Category:** Store Associates **Store NUmber or Department:** 000949-Rochester Hills-Store **Job Description:** Read more
AV Systems Engineer at *Apple* - Theorem, L...
Job Summary Apple Retail Technology is looking for an Audio Visual Systems Engineer to design and implement scalable, next-generation A/V solutions for Apple ?s Read more
Nurse Practitioner - Field Based (San Bernard...
Nurse Practitioner - Field Based (San Bernardino, CA, Apple Valley, Hesperia) **Location:** **United States** **New** **Requisition #:** PS30312 **Post Date:** 3 Read more
Best Buy *Apple* Computing Master - Best Bu...
**746510BR** **Job Title:** Best Buy Apple Computing Master **Job Category:** Store Associates **Store NUmber or Department:** 001407-Milford-Store **Job Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.