Welcome to the companion Web site for the fourth edition of the book PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, written by Larry Ullman and published by Peachpit Press. This page is specifically for the book’s fourth edition, published in August 2011 (ISBN 0-321-78407-3). The first edition was published in May 2003 (ISBN 0-321-18648-6). If you are using the first edition of the book, you should go to that page. The second edition was published in June 2005 (ISBN 0-321-33657-7). If you are using the second edition of the book, you should go to that page. The third edition was published in December 2008 (0-321-52599-x). If you are using the third edition of the book (PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide), you should go to that page.
Beside the handful of pages dedicated to this edition of this book, there’s plenty of other content on LarryUllman.com that you might be interested in. Use the “Post Categories” links above to browse by general topic.
You can download the code for the book using the link below. If you have any questions or problems, I’d recommend using the book’s corresponding support forum, where you’ll get the fastest answer.
Downloads
Every script in the text is available here to be downloaded. Some things you should know:
- Although these scripts are named or numbered as they are in the book, they do include any updates and changes as warranted by errors that were found after publication. Thus, if you are having problems with a particular script, download the most current version here or check the errata section.
- These are the scripts for the FOURTH EDITION of the book. If you are using a different edition, click the appropriate link above to find the correct page.
- These scripts have been formatted with line breaks that will work on most systems running most text editors. If you have difficulty opening a script, try:
- adjusting the way your text editor treats text files
- using a different text editor, if possible
- posting a message to the online forum, asking for help
Complete Set of Scripts and SQL Commands
phpmysql4_scripts.zip (131 KB, last modified 06/28/2011)
The extras mentioned in the book can be found in the appropriate chapter folders in the complete set of scripts and commands.
Hi Larry,
Fyi, the download link is not working.
Scott
Hi Larry,
Congratulation for your new book.
I can’t find sql commands after the download. Where can I find it?
Thanks, Sandy! Sorry about the missing SQL commands. I’ve added them to the complete set and reposted that. Let me know if there are still any problems. Thanks!
Thanks for the book…such great information and explained very well….I am learning so much!
BTW…where might I find Appendix A – INSTALLATION instructions?
It looks like the appendix and other bonus content just became available. Sorry for the delay. After registering with Peachpit, register your book. Then on your account page, click Registered Products. Next to the book, you’ll see a green link that says “Access Bonus Content”. As I write this today, the bonus content includes:
Video: Using the PHP Manual
Video: Basic Debugging
PDF: Appendix
Hey Larry,
I am very excited about the “PHP and MySQL for Dynamic Websites” 4thE and picking up my copy next week. I used “PHP for the Web” 4thE on one of my sites and was very happy with how thorough you were and how easy the book was to follow. I have looked at quite a few and that one was the best one for what I was working on. As a result, when I saw this book available, I ordered it right away! I look forward to this book and I want to thank you for your publications.
All the best,
Jay
Cinch Labs, Inc. (www.cinchlab.com)
Web Developer/Development Team Coordinator
Hi there,
Just downloaded the scripts file, but not seeing the SQL scripts for chap 6 (specifically, for populating the forum database). Am I missing something?
For the SQL scripts, look in the scripts folder for the file named sql.sql.
Ok, so the ISBN listed here for ” PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition)” is (ISBN 0-321-52599-x). However when I search this is comes up with the same ISBN as listed for the third addition (0-321-78407-3). If I go to the “Buy it ” link it is directing me to the Amazon link that SHOWS a 4th Edition but shows the 3rd addition ISBN number. Which is the correct book? Can I assume the Amazon book is correct and there is a typo on your page? I need this for a class so I have to make sure I get the right book.
As copied from Amazon:
Product Details
Paperback: 696 pages
Publisher: Peachpit Press; 4 edition (September 23, 2011)
Language: English
ISBN-10: 0321784073
ISBN-13: 978-0321784070
Hello Rodney. Sorry for the confusion and thanks for the interest in the book. The correct ISBN for the 4th edition (the most current one) is the 0-321-78407-3. I’ll fix the type.
Thanks for the code and I appreciate it.
You’re welcome. Thanks for the interest in the book.
I just started the PHP and MySQL for Dynamic Websites (4th) and I like your teaching method so far.
And pleased to note that you are a Richard Brautigan fan! (page 18)
Thank you very much, Dan, for the nice words. And, yes, I’m a Brautigan fan. First read “Confederate General…” in college and was instantly enamored. An undervalued writer, in my opinion!
Dan, I taught myself basic HTML back in the 90′s but have since run into giant brick walls when it comes to getting my head around the concept of CSS, PHP and MySQL. After buying your book around a month ago I really do believe I’m finally beginning to get it. I think the main problem was the thought of MySQL waiting at the end of the tunnel once I started getting comfortable with CSS and PHP, so I went straight to the Introduction to MySQL and it all seemed pretty simple, so much so that earlier today I not only accessed my first MySQL database but even set up the Users table.
OK, so maybe I’m patting myself on the back a little prematurely seeing as I’m actually here at your site to grab script 2.1 so I can actually enter some data into from a web page (and I even read the bit about putting the actual connection script in a lower directory so nobody can see the login info
Anyway, well done so far Larry – I don’t know how you did it but you did!!
Thanks, Paul, for the nice words. Not sure how I did it, either, but I’m glad it seems to be working for people!
Don’t know why I called you Dan btw Larry. If it’s any consolation I called Ray Harryhausen “Harry” when I called a radio show he was appearing on.
I’m onto Database Design now btw and it continues to make sense – amazing!
No problem, Paul. Thanks again for the nice words!
Hl Larry. Thanks for this book. It has been a great help and is so easy to understand. I’ll keep a good look out for your other titles. Thanks Andy
Thanks, Andy. Glad the book was useful and it’s nice of you to say.
Hi,
I appreciate your book and it’s clarity.
Just a problem I can’t find the way to Appendix A that is exlusively “on line”
Yours.
P Millet
Sorry I have finally found the way to Appendix A (in the peachpit site)
Friendly
P Millet
Sorry about the confusion. There are explicit instructions here: http://www.larryullman.com/2011/12/20/finding-book-bonus-content/