Japan Interface - Computer bookshelf

20 items found in PHP.
Displaying page 2 out of 4.

Regular Expression Pocket Reference

Tony Stubblebine

O'Reilly, 2003

book coverThis is a very slim volume (less than small 100 pages), and literally does slip into your pocket. On the basis of cost per word, it works out as quite expensive, but I've found it invaluable. That said, it's definitely not for everyone. Like all O'Reilly pocket references, it's designed for people who already know a fair bit about the subject, but need the bare essentials at hand.

Anybody attempting to learn Regular Expressions (not the easiest of subjects) from this book would be totally lost. At the moment, the unsurpassed source for that is Jeffrey Friedl's "Mastering Regular Expressions" (also published by O'Reilly and reviewed separately). In fact, the two books are designed to go together. The pocket reference tells you where to find a more detailed explanation of many issues by giving the page number in Friedl's book.

What I find particularly useful about the pocket reference is that it is divided into sections covering Perl 5.8, Java, .Net and C#, Python, PCRE Lib, PHP, vi Editor, JavaScript and Shell tools. For each one, it gives a full listing of the metacharacters supported and a brief description of functions associated with regular expressions. When switching from JavaScript to PHP and vice-versa, I find this essential, as each implementation of RegEx has its own peculiarities.

You could probably find similar information online and simply print it off, but I find the book format much more convenient. And it is something I've slipped in my pocket to read in spare moments.

The Dreamweaver Developer's Instant Troubleshooter

Rachel Andrew, Gareth Downes-Powell et al

Apress, 2003

book coverThis is a book I never thought would see the light of day. It was just about to go to the printers when the original publisher, Glasshaus, collapsed. Apress came to the rescue, and now this book can come to the rescue of anyone struggling with Dreamweaver. First of all, a disclaimer, I'm partially biased about this book because you'll find my name among the credits as a technical reviewer.

What this book sets out to do - and to a large extent succeeds - is try to answer as many as possible of the questions that frequently frustrate users of Dreamweaver, particularly when making the transition to building dynamic websites. You could argue that you can get similar help by going to the Dreamweaver forum or by doing a Google search. You could, but would you get the answers from real experts - people like Rachel Andrew and Drew McLellan, both members of the Web Standards Project, or Gareth Downes-Powell, one of the most lucid writers on PHP and MySQL? Together with Nancy Gill and Kevin Marshall, they look at getting ASP, ASP.NET, ColdFusion and PHP up and running on both Windows and Linux machines. They walk you through the installation procedures for IIS, Apache and MySQL, catering for whatever your preferences or setup may be. And this is where the book really scores - they tell you what to do when things don't work the way you expected. They anticipate most of the common problems - and some not so common ones, too.

With two of the authors active in promoting web standards, there's a strong emphasis on making the best use of Dreamweaver's improved CSS capabilities, and creating sites that are valid and flexible, including advice on how to switch to creating XHTML documents. Once you start creating dynamic websites, you'll find yourself turning to the later chapters, which offer a series of instant "recipes" for some of the most frequently asked questions about ASP, ASP.NET and PHP (but not ColdFusion, for some reason) - for example, how to create a random password in PHP, tables with striped rows in ASP, working with Server Control and Code-Behind in ASP.NET. If I have a serious criticism about this book, it's a pity that the final section was left to the individual authors' choice of questions. Although some issues (such as the notorious "Headers already sent" gotcha in PHP) are exclusive to a particular technology, it would have been nice to see answers to all the layout questions provided for each one.

The user level is described on the back of the book as "Intermediate - Advanced". I would describe it as more "frustrated intermediate, aspiring to advanced". Everything is based on Dreamweaver MX, but is 99.9% applicable to MX 2004.

Google Hacks

Tara Calishain & Rael Dornfest

O'Reilly, 2003

book coverGoogle is already so easy to use, and so much part of my daily life, I was sceptical that anybody could write a book making it easier. I was wrong. Not only does it make things easier, Google Hacks opens up a whole new perspective on what you can do with this massive online index to the world's web pages.

This is not the sort of book that you sit down and read from cover to cover. As the subtitle '100 Industrial-Strength Tips & Tools' suggests, it's designed for you to dip in and find the answer to a particular problem. Still, I found myself being drawn to read more and more, thinking: 'Wow, I'd no idea you could do that.' Things such as how to use Google to find a telephone number in the United States, or how to narrow down your search to a particular site (say, for instance, you want to look for an old article in the site of a specific newspaper or magazine).

The first quarter of the book is filled with simple, but useful tips like this, but then it gets into more advanced territory - specialist searches, getting Google by email, and building a form to conduct searches within a specific date range. Most of the second half of the book is devoted to the Google API, which enables web developers to build their own customized search applications with Perl, PHP, XML and other programming languages. Unless you're familiar with programming, this section of the book will be less helpful, although it's still fascinating to read what can be done.

The final eight tips look at Google from the point of view of a web designer - how to get that all-important position close to the top of Google's search results. It has to be pointed out that these are only educated guesses - Google does not reveal its secrets to outsiders - but they have a strong ring of truth about them. There's also advice on how to get back into Google's good books after being banned, and how to get Google to remove material you don't want the rest of the world to see.

Even if you use only a handful of the tips contained in Google Hacks, I think you'll find it an entertaining and illuminating read.

The Web Programming CD Bookshelf

Various

O'Reilly, 2003

book coverI don't have a copy of this myself, but I've got the print version of all but one of the books, so feel more than qualified to comment. First of all, what it contains: a copy of "Webmaster in a Nutshell" (3rd edition), plus electronic versions of the following O'Reilly books on a single CD-ROM:

  • Webmaster in a Nutshell
  • JavaScript: The Definitive Guide (4th ed)
  • Dynamic HTML: The Definitive Guide (2nd ed)
  • Web Database Applications with PHP and MySQL
  • Programming PHP
  • PHP Cookbook

The great attraction of the O'Reilly CD Bookshelf series is that you get a collection of top titles for much less than it would cost to buy the books individually. You can also search them rapidly, not just one at a time, but all together. In the case of the two "definitive guides" in this collection, that's a major plus. Together, they come to more than 2,250 pages - most of them reference material - so it should save a great deal of time when you need to look up JavaScript syntax. The downside is that you either have to fire up your CD-ROM or store it permanently on hard disk. An even bigger disadvantage from my viewpoint is that I don't really want to read 4,668 pages on my computer screen. With a different O'Reilly CD Bookshelf, I ended up buying the print editions of two of the books for the sheer convenience of flicking through physical pages.

What about the content, though? The only book I don't have is "Web Database Applications with PHP and MySQL", so I can't comment on it, although I believe it has a solid reputation. Of the rest, "Webmaster in a Nutshell" is the only book I found rather disappointing. It's designed as a desktop quick reference, so it's more of a memory-jogger than a book to find solutions to problems in. Also, it seems to fall between two stools - web design and web administration - so fails to address either in much depth.

The remaining four books are excellent, and reviewed individually on this site. I use "PHP Programming" and "PHP Cookbook" constantly, and would not be without them. The JavaScript and Dynamic HTML Definitive Guides are also both well written, and essential to anyone doing their own scripting. If space is at a premium or you like reading books on a computer screen, getting books bundled together like this certainly should save you money, but my preference would be to go for the individual books.

PHP and MySQL Web Development (2nd edition)

Luke Welling & Laura Thomson

Sams, 2003

book coverWith the publication of this 2nd edition, a great book just got better. When the first edition came out, it was an instant bestseller, and deservedly so. It moves at a fast pace, but is thoroughly practical in its approach. Instead of going through boring "Hello World" routines, everything you learn is something you can probably find an immediate use for.

The book begins with a "crash course in PHP", followed by the basics of MySQL. Then the rest of the book is devoted to a series of real projects - including building a user authentication system, a simple shopping cart, a mailing list manager, and a web forum. Most of the projects are unchanged from the first edition, but the code has been rewritten throughout to reflect the tightening up of PHP security by turning register_globals "off" by default. Two projects also make use of PEAR, the repository of PHP code and extensions that was integrated with the release of v4.3.0.

No previous knowledge of either PHP or MySQL is needed, although complete beginners will need to take the first six chapters quite slowly. But by the time you've worked through all the projects, you should have built up a sound and practical knowledge of dynamic data-driven websites, strong enough to take you on to the final chapter. This is a brand new project that goes beyond HTML into the rapidly developing area of Web Services using XML and SOAP. It uses live data from Amazon, but is readily adaptable to other sources of raw XML data. As proof positive that it really works, the chapter formed the basis for providing the pricing information on this site.

To save space, some of the scripts for the later projects are on the accompanying CD-ROM, so if you're tempted to buy the book second-hand, make sure it's not missing or damaged. The CD-ROM also contains the full text of the book in PDF format, making it easy to search. Highly recommended.

MySQL (2nd edition)

Paul DuBois

Sams, 2003

book coverThe subtitle of this new edition really says it all - "The definitive guide to using, programming and administering MySQL4". Whether you're a beginner or an advanced user, this book contains just about everything you need to know about running MySQL. Paul DuBois has a clear, engaging style that neither talks down to experts nor goes way over the head of novices. There's everything here from a beginner's tutorial to advanced joins and serious administration issues like database replication.

The reason for bringing out a second edition is because MySQL has undergone a major upgrade in version 4.0, which finally became the recommended production version in mid-March. The book details all the new features and illustrates them with working examples, including union joins, multiple table deletes and updates, transactions, and fulltext searches. Features planned for v4.1 are also covered, such as subselects and support for different languages in the same table (a major leap forward for anyone dealing with multilingual applications).

Initially I was disappointed that, like MySQL4 itself, this edition is an upgrade, not a completely new product. But the more I use it, the more I realize just how indispensible it is, and my well-thumbed first edition has now been retired to the back of the bookshelf. Make no mistake, there's a lot of new material in here, as evidenced by the fact the page count has increased by 500, although some of that is accounted for by a larger, clearer typeface (which makes things easier to find). For experienced users and beginners alike, this should definitely be first on your list of MySQL books.

This edition is 1,200 pages long - nearly half of it made up of useful reference sections devoted to SQL syntax, column types, operators and functions, as well as PHP and the Perl DBI. Because of the major changes to MySQL, Paul DuBois is careful to point out which version new features are available from, so there's no problem using it if you're still on MySQL 3.23. One minor gripe - it would have been much more user-friendly to put the version number right next to the sub-title for each feature, rather than at the end of the description. Still, that's a minor failing in a such a comprehensive and well-written book.

Publishing note: although originally planned for release under the New Riders imprint, it's now published by Sams in their Developer's Library that also includes the new edition of Welling and Thomson's first class "PHP and MySQL Web Development".

© 2002-5, Japan Interface. All rights reserved.