Download PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide fb2

First the good: This book is able to explain the key concepts in PHP and MySQL in a very simple, easy-to-understand manner. By following along with the example scripts, I imagine anyone could learn how to accomplish the most important tasks in building a decent backend for a website. I started the book with years of programming experience already in hand as well as some limited exposure to PHP and MySQL. In particular, I was looking for a book which would give me a more organized education on these two languages, especially relating to how the two work together in implementing a functional server-side system for dynamic web pages. It succeeded in this regard. Each chapter is organized so that you will have the requisite knowledge needed to understand the proceeding chapters. Furthermore, the review pages at the end of each chapter are quite useful in determining whether the information has actually been learned and highlighting gaps in knowledge that need to be filled before moving on.

Next the not-so-good: One gripe I had with the structure of the book was the redundant code interspersed among the explanatory text, although this is more of a personal preference. Frames are placed separate from the main text with the actual script that the text is discussing; however, large pieces of this code are also copied into the text surrounded by instructions for recreating the script. I found this to be tedious and distracting, considering that the exact same code is already shown in the adjacent frames. It can be especially frustrating when the identical boilerplate HTML DOCTYPE and meta tags are repeated over and over for each script. This seems to just be page-filling material, but it gets annoying after the first few times. Disregarding these two tags, I can at least see how some of the redundant code could be useful for complete beginners of web development, so I didn't take any stars off for it. That said, I don't think it would be wise to learn PHP and MySQL before learning enough HTML and CSS to not need the repetition, anyway.

Additionally, I'm a bit wary of how late in the book security measures are discussed. These days, security is incredibly important when writing a website backend, so I would have preferred if it was discussed in bits and pieces throughout the book and also explored in greater depth in a later chapter. At the very least, the sections with PHP code for handling HTML forms need to include proper character escaping of posted text, even if the reason behind it isn't explained in detail at the time. Unless someone only reads the first 12 chapters of the book before deciding to create a web server accessible from outside his or her LAN, this probably won't be much of a problem. Still, it's better to get beginners in the habit of using good security techniques from the start, rather than wait until later.

Finally, the bad: The fourth (and, as of this review, current) edition of this book was published in 2012. Since then, HTML5, PHP 7, and MySQL 5.7 have been released, making this edition fairly outdated. Concerning HTML5 in particular, several instances of example HTML code shown in the book have been rendered obsolete, and in many cases are now considered bad practice. Ironically, the same boilerplate DOCTYPE and meta tag code that permeates book has either been simplified or completely thrown out of the HTML5 standard, perhaps explaining some of my frustration with it. I suspect another edition covering the newer versions is in the works, but then again, the author does write in the book that he "wouldn't be surprised if HTML5 is still not released by the time [he] starts the fifth edition of this book." In the meantime, I have to take off a star for the partially antiquated example scripts.

Additionally, I have to take off another star for a potentially more limited problem. My printing of the book was missing approximately 50 pages from the end of Chapter 5 and the beginning of Chapter 6, which cover the Introduction to MySQL and Database Design. Instead, pages 151-198 have been replaced by a duplicate of pages 103-150. Again, the repetition in this book is killing me (joke). I have no idea how many copies were printed with this error, but for beginners, the missing pages contain some very important information on databases, MySQL data manipulation, and MySQL functions. At best, this error would require the reader to find this information elsewhere (or exchange/return the book); at worst, it demonstrates the poor quality control at Peachpit Press.

Ultimately, I'd recommend this book, albeit to a small extent, for beginners of web development and programming in general. Although this book is far from perfect, it is one of the better available guides for those new to programming and backend development. For people like myself, who already have experience with programming, scripting, and/or web design, this book is better utilized as a supplement to other materials. All things considered, this book will provide a decent background into PHP and MySQL, but its use of outdated code, potential quality control issues, and lack of security measures in early chapters hinder its ability to serve as a singular, comprehensive source for getting started in dynamic website design.

A glaring editing problem is shown in the attached screenshots. This is in chapter 1, while discussing the fundamentals of how the language works. Whoever is in charge of preparing the electronic version of this book didn't bother to copy-edit it. The screenshot of the books are from the Kindle Cloud Reader and Peachpit's own "Web Edition" platform. So it's not a problem with Amazon or their reader. It appears Peachpit didn't bother to hand it to someone for checks even once before pushing the "publish" button on their website and Amazon. If they did have it checked by someone, that person should be fired because that person is not doing their job. A set of " , , , " should have jumped out at anyone performing a cursory review of the document.

If you want to learn how to develop dynamic web sites using PHP and MySQL (database) then this is an excellent first starter. I'm using my Java NetBeans IDE (integrated development environment) with PHP built in; however, you can use any editor and the author covers this well. The book, early on, will send you to the appendix where you'll learn how to install your web server, MySQL, Tomcat, and a mail server using XAMPP (I'd never heard of this before but it does install all). It also covers how to resolve issues such as having multiple 'running' copies of MySQL or code not running at all because the programmer place the code in the wrong location to be read by the browser.

The book does have errors. Some of the errors (in code) were caught by the author and others and the errata sheet was updated. Some, however, have not. For example, the book shows a multiline comment as /
some text
/
when in fact it should be /* and end with */. If you read his tips, you'll see the correct way (this is also how C++ does multiline commenting). In addition to downloading the errata sheet, you can download the code used in the book.

While I haven't completed the book yet, what I have gone through is clear, concise and works. The tips are good ones (especially regarding commenting). I believe this to be a good book for beginners or anyone who wants to learn PHP and interface into the MySQL database. If you already have knowledge in other programming languages then you'll move along quicker.

Nick.