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


Artificial Intelligence and Expert Systems (Mercury Learning)

Authors: I. Gupta & G. Nagpa
Publisher: Mercury Learning
Pages: 412
ISBN: 978-1683925071
Print: 1683925076
Kindle: B087785GZM
Audience: Technically able readers
Rating: 4
Reviewer: Mike James
Expert Systems, anyone?



WebAssembly in Action

Author: Gerard Gallant
Publisher: Manning
Date: November 2019
Pages: 448
ISBN: 978-1617295744
Print: 1617295744
Audience: Developers interested in WebAssembly
Rating: 5
Reviewer: Ian Elliot

WebAssembly is a hot topic is this the book to read?


More Reviews

 

Last Updated ( Wednesday, 11 June 2014 )