- Paperback: 648 pages
- Publisher: Peachpit Press; 1 edition (December 29, 2007)
- Language: English
- ISBN-10: 032152599X
- ISBN-13: 978-0321525994
- Product Dimensions: 7.1 x 1.3 x 8.9 inches
- Shipping Weight: 2.1 pounds (View shipping rates and policies)
- Average Customer Review: 66 customer reviews
- Amazon Best Sellers Rank: #1,174,174 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
There is a newer edition of this item:
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who bought this item also bought
From the Author
The book teaches everything you need to know to create real-world Web applications, from the fundamentals of PHP, SQL, and MySQL, to more complex uses of all three technologies. The book does not assume previous experience with any of these, although you should already be comfortable with HTML. I will say that this book, considering all the content involved, goes at a fairly quick pace. If you have less computer, Web development, or programming experience, you may be better served by my "PHP for the Web: Visual QuickStart Guide" book, which goes more deliberately and explains things in smaller chunks.
When I wrote the book, PHP 6 was about half-way complete, so I was able to use a beta version of PHP 6. For somewhat complicated reasons, PHP 6 has since died and its status is still uncertain. Still, I can recommend the book in good conscience, as only a few pages of one chapter require PHP 6, and that content is clearly marked (actually, most of that content can be replicated in PHP 5, just using different code). As with all my books, if you ever have problems with or questions about any code, you can always get a direct answer from me via email or, preferably, using my online support forums.
In March of 2011, I begin writing the fourth edition of this book, due out in August 2011.
Thanks for your interest in the book. It is appreciated. And if you purchase it, I hope you like it and find it to be useful and informative.
From the Back Cover
Visual QuickPro Guide--the fast, efficient way to learn!
- Easy visual approach uses pictures to guide you through PHP 6 and MySQL 5 and show you what to do.
- Concise steps and explanations let you get up and running in no time.
- Page for page, the best content and value around.
- Companion Web site at contains complete source code for examples in the book, online resources, extra scripts, updates, a reader forum, and more.
Browse award-winning titles. See more
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
So here is the review of this book. The PHP commands in this book are more of a fast pace than the previous book (the first 3 chapters) that makes the book more interesting and not redundant that provides fresh material with new scripts. The only complex ideas to grasp were passing and returning values from functions especially when nesting multiple brackets within each other. Also, each chapter introduces a new concept and every script after that will build upon what you learned within the chapter. Also database JOINs were a bit difficult.
I'm a newbie when it comes to databases and only know that major internet sites (like Facebook) rely heavily on databases to store their massive amounts of data. The mySQL sections are very well written with one chapter dedicated to just introducing the limitless possibilities and variations to [my]SQL variables (Chapter 4). This chapter does not dwell into any PHP code to be typed out (like the previous chapters). It also goes into how to plan your database and things to consider when making your column attributes. The next chapter (Chapter 5) actually goes into using phpMyAdmin (or a mysql terminal window on a local server) step by step at a good introductory pace showing the 'behind-the-scenes' of database management. The book goes into creating the database, tables, columns etc and even has a zip file you can download to populate an example database for demonstration purposes to save your fingers from all the typing. Chapter 6 gets a bit more tricky with command line mySQL commands (no PHP) especially when discussing JOINs. I recommend reading Chapter 6 twice and then go and do a few searches on the internet on using JOINs. The author went a bit too fast on this subject and wish code was explained more (maybe with some pictures) on this subject.
Chapter 8 ties PHP code with MySQL where you can select and update records in the database all within a PHP script (not using a command line client). Good chapter once you grasp the basics of the previous chapter topics.
Throughout the book, more and more is built upon what was previously said. I find chapter 12 interesting as it goes into the security aspect of things. The one thing that was hard to grasp was that database encryption salt topic. It goes over it but said that it is to be explained in more detail in a different book.
Chapter 13 talks about Perl Regular Expressions. I just skimmed over this chapter but it does show you how to verify a 5 digit (plus the 4 digit extension) of a zip code. Also it shows you how to match email addresses within an input. Otherwise, for myself, regular expressions will be over my head.
Chapter 14 goes into Unicode/UTF-8, introducing you to making Universal websites (with characters other than the the English ABCs). You absolutely have to have PHP 6 installed for these scripts to work on the PHP side. I'm running PHP 5.3x on a hosted godaddy server, and none of these scripts work (and I found it extremely hard to install a working copy of PHP and MySQL on Mac OS X following the directions in the Appendix). Grant it, this book's title is PHP 6 and MySQL 5 for Dynamic Websites, but every script before this chapter worked even when it was noted that it was a new feature of PHP6. This is not a gig against the author but keep this in mind. If you're in the same situation as myself, don't stress; this chapter just shows you how Unicode characters vary in byte size and when using the PHP function of counting and 'transliterating' differ from PHP 5 and 6. For example, clearly a 4 character word in Chinese will be counted as 4 characters in PHP6 while it may be counted as 9 characters in PHP5 because Unicode characters may be longer in byte size. The SQL part actually works as long as your running MySQL 5+ (which most host are nowadays). One thing to take away from this chapter is if running PHP 5, then the MySQL side of time zones do work (UTC) so if your future site will be time dependent, then you're in luck. Also I suggest downloading the scripts from the website and copy/paste the code directly into your IDE, which will save you some time trying to find all these crazy characters in your OS's keyboard viewer. This chapter is defiantly an eye opener as people do not realize how cross language sites can be a daunting task.
Chapter 15 goes into making a simple forum that can be viewed in multiple languages. I really don't care for multiple languages but I read the chapter and went through the code anyway. This is a complicated chapter as the scripts will include or refer to other scripts and when debugging, it was very hard to find the typo. Once I read the entire chapter, I just uploaded the provided scripts from the book's site and most of it worked except for the language part. It would only display in English. I have PHP 5.3 installed on my server (as trying to run a PHP 6 installation in a Linux VM ware was a no go). Good chapter but if you have a working PHP6 installation, you may have to read this chapter twice. Now a thing about PHP6, this book was published around 2007/2008, and on PHP's website, the latest release is 5.4+ in 2013! I understand it takes awhile to debug and program PHP6, but 5 years? I wouldn't hold your breath on them releasing PHP6 anytime soon.
Chapter 16 is really interesting and the most helpful chapter so far. This goes into how to administer a forums users by registration, password reset, password change, etc. This chapter pulls everything you learned from the previous chapters into this one. The one thing I'm glad was missing was the Unicode support as I can't support this now. Also the database is only one table, which breaks it down real simple without all the use for the complicated JOINS. Don't get me wrong, this isn't some fully functional forum, but it shows you some behind the scenes in forum user management.
Chapter 17 goes into e-commerce and is helpful in showing you how to set up a administrator page to add products and a public side to show products to the consumer. It has one of the most complicated scripts thats 200 lines long and for some reason when I typed it out, it wouldn't work right. So I just downloaded the provided code from the author's site and it worked perfectly. The one thing that could be improved on is the complicated mysql queries with the joins. Even though there is an entire chapter dedicated to this, it just seemed that the author didn't explain the queries fully (with a brief mention of joins, even though there was no JOIN clause in the query, maybe some graphics or a flow chart). Also, another thing to improve on is the behind the scenes of how these scripts work. For example, this chapter sells "Art Prints" where images can be uploaded to a folder. It may be common sense to some people, but showing the uploads folder contents on the web server and the database end result after an print is added would be nice to debug your script or ensure it's working properly. I've already purchase the next kindle book dedicated to e-commerce and (Effortless E-Commerce) which I'm sure will go into a more detailed shopping site. The last script checkout.php seemed not to work for me. I've browsed the errata sheet on the author's site, ensure one line was uncommented and it still seemed not to work. I've uploaded the authors code with no difference. So I deleted every file, uploaded all of the author's code in EVERY script, ensured all the proper directories and mysql database file was created, emptied the tables in the DB and still same resulting error. I'm not worried about it as I can take some good concepts from this chapter and even found no correction on the websites forum.
Overall this book is 5 stars and some of the constructive criticism could help future books. The support for this book is amazing as there is a live forum where the author (Larry) among others would personally try to help people out with their own code.
In my review of the previous book, I've set up multiple desktops on Mac OS X to switch between to maximize my coding time. You can download the scripts from the publishers website, but I recommend typing out the code. I've recently changed my setup to have:
[DESKTOP 1] Dreamweaver on Code View on the right side of my screen with this book on the Kindle App on the left side of my screen so I don't have to swipe between desktops and could type without distraction (besides changing pages in the Kindle App). Dreamweaver will also highlight any typos on the line number to inform you of any mistakes (although Dreamweaver CS6 is very unhelpful when recommending what is wrong). I use the four finger swipe or the COMMAND + TAB key to switch between my desktops.
[DESKTOP 2] Safari with my remote test server or phpmyadmin for SQL queries to test my scripts.
Larry accomplishes the difficult task of keeping a complete novice from getting frustrated because his examples and style of writing is easy to follow and learn. He does an excellent job balancing of the technicals details and fully explaining them in a way that makes sense and is not confusing. Larry explains every line of code in great detail. If you need an advanced treatment of certain subjects buy his PHP5 Advanced book.
Another GREAT and VALUED benefit that will keep me buying Larry's books and recommending them is that he personally responds to my forum posts and has helped me through several difficult problems dealing with my Netbeans and Zend PHP editor and MySQL Workbench editor as well as my MAMP configuration. All of these applications and configurations were somewhat unique to my MAC OSX but his depth of knowledge is so extensive that he easily helped me through some very frustrating configuration settings that had NOTHING to do with his book but which allowed me to continue the exercises.
Don't be fooled by other books on this topic because they are larger or "appear"to have more code/examples.
If you don't have a domain name, along with the domain services offered by domain server entities, you will need to do that first before giving this book a try. I know that you can install Apache and MySQL on your local machine, but it's just not the same. There are certain things that this book will not tell you, simply because of the different ways that technical issues and procedures are set up in the different domain services out there.