Expert PHP and MySQL

Author: Marc Rochkind
Publisher: Apress
Pages: 340
ISBN: 978-1430260073
Aimed at: PHP developers who want to develop commercial apps
Rating: 5
Reviewed by: Kay Ewbank

This book aims to take someone who knows the basics of PHP programming, and show them not just how to create PHP and MySQL projects, but how to build commercial-grade projects. Does it succeed?

Marc Rochkind, is probably best known for his book on advanced UNIX programming. His technical background is impressive, and that shows through in this well-written book.

Banner

The difference in attitude to many authors shows with where Rochkind starts – not with installing PHP and MySQL, but with a chapter on project organization covering topics such as creating a development team, setting the schedule, why projects fail, legalities such as having a written contract, intellectual rights, invoicing and getting the money. Now that’s the mark of a true contract developer!

Chapter 2 moves on to requirements in terms of the requirements document, setting the project scope, how to deal with requirements changing, and agile requirements. Again, all of this is general to all software projects, but interesting reading all the same.

Chapter 3 looks at the platform and tools, covering the server platform and LAMP stack, client platform, development platform and tools, and hosting options. Rochkind then looks at the database. There’s some history and general SQL coverage, a good section on E-R modeling, and useful explanations of normalization, constraints, and database security. All this is written using a nice mix of theory, code, and screenshots with step-by-step instructions.

 

 

Application structure comes next, covering how you access MySQL from PHP, interacting with the browser, sessions, and page frameworks. The explanations are clear and Rochkind makes a good case for why it’s best to use PHP Data Objects as your API of choice.

Security, forms and error handling are the next topic. Rochkind is strong on security, with useful outlines of the main methods hackers attempt to attack, and how to defend against them to illustrate why hashed passwords, two-factor authentication, and techniques such as submitting requests with POST instead of GET to make life tougher for the would-be attacker. The chapter wouldn’t turn you into a security expert, but it does make the issues and solutions nice and clear.

There’s a nice section on creating forms with code showing how to create and interact with text, check boxes, buttons, foreign keys, radio buttons etc. However, I got the impression that Rochkind thinks the user interface is simple enough to pick up as you go along concentrating on the really important stuff; like handling the user table and password management, handling forgotten passwords, interacting with Yubikeys, and error handling.

Reports and other outputs get a chapter showing how to use SQL queries as the basis of reports; the report class and when to use HTML and CSV output; and role based access control. There’s a good section on how to generate PDFs from PHP, and the benefits of the different PDF libraries. Rochkind is a fan of the free PDF library, FPDF, and shows how to use this.

The final chapter looks at data conversion, and how to get your existing data into MySQL and your PHP app.

Overall, this is an excellent book. Rochkind keeps things practical and uses clear examples and plenty of code, but he doesn’t ignore the theory behind the practice. The result is enjoyable and useful.

 

Banner


Rise of the Robots: Technology and the Threat of a Jobless Future

Author: Martin Ford
Publisher: Basic Books
Pages: 352
ISBN: 978-0465059997
Print: 0465097537
Kindle: B00PWX7RPG

Audience: Everyone
Rating: 4.5
Reviewer: Ian Stirk

This New York Times bestseller discusses the impact of automation on jobs and the economy in the near future. What me [ ... ]



JavaScript Cookbook (2nd Ed)

Author: Shelley Powers
Publisher: O'Reilly, 2015
Pages: 634
ISBN: 978-1491901885
Print: 1491901888
Kindle: B00SS9G9DC
Audience: Intermediate JavaScript programmers
Rating: 4.5
Reviewed by: Ian Elliot 

A cookbook for the more advanced programmer? Is this a good idea?


More Reviews

 

Last Updated ( Wednesday, 11 June 2014 )