
BUY THIS BOOK! It's worth 50 STARS (if not more!)This book is, to say the very least, the finest computer book I have read in a very, very long time. I have spent the last three months trying to learn how to use PHP and MySQL to build a website with a simple content management system, however, due to the grossly unethical practice that publishing companies have of releasing books that are filled with editing and other errors, along with authors who are completely unable to write even a simple complete sentence that may be understood by their readers, I had nearly given up. Specifically, I have already WASTED money on the following books:
Creating Interactive Websites with PHP and Web Services by Eric Rosebrock - this book crashes around page 100 - it COULD have been a good book but is filled with errors that make it unusable. The publisher, Sybex, refuses to publish a real errata sheet and the book is NOT supported on the author's web site. Isn't that nice?
PHP MySQL Website Programming: Problem - Design - Solution by Chris Lea, Mike Buzzard, Jessey White-Cinis, and Dilip Thomas. Good luck if you can get past page 30! Considering this book has been out for some time, there is NO REAL support or errata sheet for it. The "sample site" that one is allegedly able to build by working through this book is filled with questions such as "Has anyone made it all the way to the end of this book?" Need I say more? What a joke.
MySQL/PHP Database Applications, SECOND EDITION. Gosh, considering this is the SECOND edition of this book, one might think an errata sheet and other help might be available. Forget that though - Wiley gets your money, you get plastered with errors so you can't get through the book.
PHP and MySQL Web Development by Luke Welling and Laura - Another USELESS second edition. Not only does the code in this book NOT WORK but the examples that you can download doesn't match what's in the book! Not only that but, as to be expected, there is no errata sheet and the authors web site that is allegedly there to "support" this book has nothing but an advertisement for it with the promise that the "site is under development." Wonder if it will ever be "developed."
As noted, ALL of the books above are USELESS. On a fluke, I decide to try one more - Larry Ullman's PHP and MySQL for Dynamic Web Sites by Peachpit Press. While a second edition is allegedly going to be released soon: I have the first edition. To be honest, I was ABSOLUTELY AMAZED that:
1. The code in this book WORKS!
2. The book is SUPPORTED by both the publisher and the author. The author's support site for the book actually contains an extensive list of errata for the very minor errors in it (unlike ALL of the books listed above which DON'T have an errata list). Furthermore, I haven't needed to check the errata because the errors in this book are so minor.
3. The author actually ANSWERS questions to problems on his site.
4. The author is capable of explaining everything, very clearly, and yet conveys a LOT of great information.
5. This book is CHEAPER than all of the ones listed above (and yet it is the ONLY one worth spending your money on).
I have been completely feed up with the incompetent and unethical practices of so many book publishers that I was beginning to wonder if there were ANY books that really taught you how to create a dynamic website. Well, there's one - Peachpit Press. No, I don't work for them and don't know the author - I'm merely a DISGUSTED customer who is tired of spending money on useless books.
RUN, don't walk to buy this book. You will be very, very glad you did.
Good TutorialI'm a newbie to both PHP and MySQL on Mac OS X. I'm learning from this book and from the PHP/MySQL for Dummies. This is the better book. It has lots of good information, clear writing, and easy to follow tutorials. The graphic display of PHP code is very easy to follow: as the author modifies scripts to teach new concepts, the new code is presented in red in the code listings. In just a few days I've gone from knowing nothing about PHP and MySQL to writing my own PHP code. If you're trying to learn how to use PHP and MySQL this is the book to get (along with the MySQL users manual).
New Edition is AvailableAs the author of the book, I regret having to do this (submit a review) but it seems to be the most immediate and effective way to correct a misunderstanding. The first edition of the book is based upon PHP 4 and came out in 2003. The second edition came out in 2005 and covers PHP 5. So, the book HAS been updated, despite what other reviews incorrectly state. Just click on "All Editions" under "Product Details" to find the most recent edition of this (or any) book.
[...]
Thanks,
Larry
Excellent book!!This is an excellent book. This book teaches what it claims to teach amazingly well. Well done Mr. Larry.
And u know what? Larry Ullman also answers all your questions on the book's website. If u get stuck even on your first PHP script, Larry will personally help you in the forums. Now this is not what we normally get. A great book and FREE support on the website by the AUTHOR himself!!! WOW!!
Amazon should give him Book of the Year award along with Julie Meloni's "PHP Essentials".
If you are completely new to programming and you only know HTML and CSS and want to learn PHP (along with MySQL), "PHP Essentials" by Julie Meloni is the best book.
If you have some basic programming experience like JavaScript or C or any similar language, then Larry's "PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide" IS THE BOOK FOR YOU!!!.
This book does not teaches you the very basics of programming so if you are inexperienced in programming, get Julie's book... If u know a little programming, get Larry's book.
Just excellent book.
Author answers questions on his forumI've never met an author who actually answered queries to his website but Larry Ullman gave me one suggestion after another while I struggled with a problem. It took about ten replies from him before I finally got it solved. His replies were so timely the problem was resolved within a week.
As a novice PHP writer I've tried several books, most of them more expensive, but this is one of the best.
Two criticisms: there is too much detail. I'd like to fool around with one or two lines of code at a time, building it up gradually into something that really works. Ullman breaks it down pretty well, but his bites are still a bit too big for me.
The other criticism is in design. Examples of code from the book are reproduced in about four-point text, so keep your magnifying glass at the ready.
Still, if you want to make web pags like the one you're reading, you'll be able to do most of it with this book.
Just greatLet me add my kudos to Larry Ullman and his PHP/MySQL Guide. This is a beginner's book, as others have pointed out, and Mr. Ullman is one of the very few programming writers who grasps how to write for the novice.
How many times in your life have you tried to learn something about programming, or the internet, and within 5 pages wondered "what in the h--- is he talking about?" Or had some very simple term or concept left unexplained (or insufficiently explained)? Or had some simple little practical procedure that took you hours to figure out, when all it would have taken is a single sentence? When I first started building webpages, I was utterly frustrated because I didn't know that I needed to save notepad files as "all files" to get a .html extension on them -- just the kind of thing that drives you nuts, and is totally unnecessary.
Mr. Ullman does not make this mistake. He knows exactly how to "hold your hand" so you don't lose hours doing something stupid.
This attention to detail, and attitude of user-friendliness, extends into every part of the operation. Nothing is left half-finished. The programs he gives have been scrupulously edited to insure that they actually work. The associated website is rich and well-maintained for excellent customer support. The text is well-spaced, the paper good quality, and there are more examples than you really need.
Nevertheless, he manages to get you through all the basics of PHP and MySQL in 490 pages of large half-column text. There is a certain amount of irreduceable difficulty learning any mid-level programming language, but Ullman makes it as painless as humanly possible, and even better, when you finish a chapter you actually know what you are supposed to know.
This book gets an A+ from me.
Edit, several months later.
I have finished Ullman's book and have gone on to do a lot of PHP programming. I had little trouble putting together a comprehensive CMS when I was through.
However, I have to change my rating to "four stars" after finishing the book. The section on MySQL is not nearly as good as the PHP sections, and a number of times I found I had use Google and find an online MySQL tutorial, in order to understand something.
This seems pretty silly, as MySQL is a LOT easier than PHP, especially if you have the phpMyAdmin graphic interface. The chapters on combining the two, however -- i.e., using php with MySQL -- go back to the "five star" level. I wouldn't call it "easy", but he makes it logical and understandable on a patient, step-by-step basis. The later chapters on miscellaneous subjects, such as security, are very helpful.
So, this get five stars for a php beginner and two stars for the introduction to MySQL. I would still recommend it but would also recommend an inexpensive MySQL book to go with it.
Good book for beginners but not for professionalI bought this book 3 months ago and really enjoyed it. The book does teach you the basic of how to build dynamic pages, connect to a database, and security. However, i would not recommend it to professionals simply because it doesn't use the stands that everyone else is using such as object oriented programming (OOP).
After reading this, i turned to the online community for extra info but found myself trapped as most tutorials and examples use OOP (which is the core of php).
If you're a beginner looking to build your first SIMPLE dynamic website, this book is for you but if you're a professional looking to enhance your site, i would skip this book.
The Most Used and Beat Up Book I Own Right HereI bought this book when I first wanted to learn PHP. That was 4 months ago. I am now developing commercial applications in PHP.
Not kidding.
This book does start you off at square 1, but is still a great book for the more advanced programmers. It doesn't cover everything. Nothing can. But it is by far the most referenced book I have. Today it looks so beat up from use that it appears to have been dragged through the kitchen (I literally ate dinner while reading this many times) and looks like I have been sleeping with it for some kind of teddy bear. (Ok, maybe I have.)
The point I am trying to drive home: Buy This Book.
If you want to learn PHP, buy this book. If you want a good reference on how to do XYZ in PHP or MYSQL, buy this book. If you are developing web sites based on PHP, buy this book.
That being said, also buy a MYSQL book while you are at it so you can have access to a reference to expand you query possibilities. The book covers a lot of common SQL queries, but like I said, the book doesn't cover everything. (Any claim to such would be unrealistic.)
Final note: The books says it covers PHP 3 and 4, but don't let that stop you. Everything covered here works in PHP 5 as well. Until Larry here revises this book to include PHP 5, that's right, buy this book.
a best intro book ?Not having read all of them, I can't say, unequivocally, that this is the best PHP/mySQL intro book ... but, I suspect that it is.
After reading these programming tomes for 10 years, three types of writers come to mind:
1. a developer, who took time to write a book (often characterized by weak writing skills ... and foo-bar examples, illustrating nothing more than a lack of pragmatic imagination)
2. the constant writer, who rarely (never?) develops (e.g Hello World! demos) How unimaginative?
3. a true teacher, who has taken time to gather thoughts and put effort into the presentation i.e. TEACH
Larry Ullman strikes me as "a teacher". There are lots of well-conceived, nice touches in this book ... from the example code on SAME page as the walk-through explanations ... to the bold (often red ink) type, highlighting the subject lesson ... to the paper, itself (nice for writing notes and marking it up), a lifelong habit.
This book is a much easier read than its competitor, the Welling/Thomson book ... and about 1/3 less price, too - a nice bargain. I completed it in about a week and feel much more comfortable (dare I say confident?) with PHP, now. Thank you, Larry Ullman.
I don't recall a perfect book, though this one's shortcomings are slight. I was salivating, getting to the last chapter, "eCommerce", only to be disappointed when, 10 pages from the end of the book, the author declared that he wouldn't cover order processing, advising the reader to search the internet for examples. `sorry, but I don't buy books to be told to go search the internet. After wading through what seemed like a dizzying dozen variations on login forms, I would have gladly traded a half dozen login examples for more than a ... let's wrap this book up, quickly, coverage of shopping carts and I-commerce, the meat of the matter (... to my mind). Another indication of last chapter rush: not distinguishing between orders and order items (tables).
That said, don't let my slight disappointment dissuade you from acquiring this gem ... and diving into the facinating realm of LAMP. This book is carefully conceived and executed ... and, probably "best in class" ... a GREAT value, too.
GET IT !!!
Exactly what I needed to get started, and then someI took this book out of the bookshop in the same bag as what looked like its obvious competitor on the shelf, 'PHP and MySQL for Dummies'. It is Larry Ullman's book that I am going through seriously, dipping into 'Dummies' (which is a good book) for an alternative explanation here and there. Whereas 'Dummies' starts with MySQL, Larry begins with some PHP basics before delving into the database, and this made more intuitive sense to me, since there were many things I wanted to do on my site (such as make an emailing form and add a readers' comments facility) with PHP before starting to think about what I could do with a MySQL database.
Notwithstanding the comments of one or two other reviewers, I have no experience of programming in any language, and yet I found this book started in the right place for me. What really made it valuable is that every concept is demonstrated right away in a real example that you can try out yourself and invent variants on to see the difference. This helps to sort out all the stupid questions and confusions that an expert probably can't even imagine your having.
Apart from Unix commands in the appendix on installation, there is not a single example in the book of something that has to be typed in 'on faith' (not quite true of the 'Dummies' book, though almost). In every chapter you are told what to type, what it does and why. Larry does move fast, and I had to puzzle over his explanation of database design and normalisation, along with his initial explanation of getting data output from the database in PHP. But this is only another strength of the book. He doesn't cut corners but he does ask you to think and not skip over too much.
Like some other people here, I have been to the book's website and forum and asked a question, and like them, I got a useful answer straight from the author. I will definitely choose his books again, and have a good feeling about Peachpit's Visual QuickPro/QuickStart books in general.
The design is equally well done. The fact that every script is shown both as an illustration and as annotated text makes the book much thicker than it might have been, but it is useful to see the script on its own and explanations (even if sidenotes to the script would have achieved both purposes, surely). The Comic sanserif used to show code is far better for long-distance reading than the monospaced font used in 'Dummies', and colour is used very effectively. I feel lucky I found this book!
Lots of pages, low on advanced content.This is a huge book, approximately 665 pages, however it is quite hard to find anything of help in it. It's great if you are going to go through and do all of the examples, I'm sure you would learn something from it, but it's terrible when you want a quick answer, or you really need to know the details on something. I frequently find myself searching the net instead of this book because it is huge and there is no good way to find the answers. Additionally, when you do find the answers it is just a continuation of a previous example and does not explain in depth on how to use the various functions and such.
In conclusion, it's probably just fine if you are a student and want to go page by page and read the book and learn by examples. But it's terrible as a quick reference, and for more advanced users needing in-depth information you should look elsewhere.
The BEST value for your dollarFirst let me state that my comments refer to the Second Edition (June 2005).
I would agree with many of the other reviewers of this fine book in saying, look no further if you are looking for a completely accessible introductory text on PHP and MySQL.
I teach Internet Programming at the college level and have read through many PHP/MySQL books. I feel very confident in stating that you will not find a better value in an introductory PHP/MySQL text anywhere.
The author manages to take you from an absolute introduction to some fairly advanced topics. Even after teaching from this book I have no complaints or negative comments. The writing is clear and concise, the code examples are wonderful (all work and are available from the companion website), and the organization (and selection) of the topics covered is excellent (see the Table of Contents link above). The students in my class unanimously agreed this was a great text/reference.
My real motivation for writing this review is to, in some small way, thank the author, Larry Ullman, for writing this perfect textbook for my class. So, thank you Larry Ullman!
If you are shopping for beginner-to-intermediate book look no further, you will be VERY happy with this book.
Quality content that's easy to understandI ordered this book in a time of need: what was supposed to be someone else's project was left hanging when they transferred away, and I happened to be the next best candidate, despite knowing very little about PHP and SQL. So, I checked around, and this book was brought up on a number of occasions as a quality source of information for beginners. A few days later it was sitting on my desk, and I began thumbing through it to get a feel for it.
First of all, I was very impressed by the style of the book. The author uses visual cues to great effect, showing you how your code and the finished result should look. This promotes writing pretty, manageable code, and ensures that you get the right results (or, when you're getting an example of a common pitfall, that you messed things up properly). The author starts you off on what could be real project, and builds useful skills that you're likely to use in a variety of projects. Layers of complexity are added to this same project, with detailed and clear explanations of what you did and how it works. The introduction of SQL is done well, and ensures you've got a solid foundation in the principles of how it works before you add it to your script.
Much, much more is covered by the 'tutorial' bit of the book, and there's also a number of case-study-style projects after it. A number of common projects are built up on the assumption you've read the rest of the book and know what you're doing, and the code itself (downloadable from the author's webpage) is very useful as a starting point for your own projects. Ullman's webpage is also an exceptionally useful resource, far surpassing any other I've seen. There are regular giveaways of new books, all the code samples are collected there, there's detailed errata collected by the author himself, and most useful of all, there's a forum where the author and other readers of the book can help you with your coding struggles. I asked a few questions there and got a quick, detailed, useful response, and a good explanation of where I'd gone wrong. Help like that will normally run you $75/hr.
After reading through the book (and referring to it as necessary), I was ready to go. Over the span of three months and starting with essentially zero knowledge, I wrote two fairly large and complex scripts with the help of this book. My stumbling points were few, and the work impressed everyone who saw or used it. If you need a crash course in PHP/SQL site development, or are simply interested in a comprehensive book that'll bring you to a solid intermediate level in your PHP scripting with an SQL backend, this is an excellent choice.
Really worth the 5 stars (and more).I am a seasoned computer programmer that was looking for a good introduction to PHP and MySQL development. Essentially I needed to create a database driven website where I could also accept credit card payments and do shopping cart stuff. This would be my first foray into Internet Programming (or is it scripting).
Firstly you'll want some prior programming experience to get the most out of this book. Therefore if you need ultra detailed explanations, then this book isn't really for you. If you have programming experience, then the book moves along at a good pace without getting burdened on lengthy explanations.
Chapter 1 starts off with a good introduction to PHP and variable types. Chapter 2 and you're creating forms and handling the submitted data. MySQL is covered from Chapter 4, and before you know it you're covering topics like Sessions and Cookies, Regular Expressions and debugging techniques. What I really like about the book is that Larry shows a couple of different ways to accomplish a particular task. E.G. In the earlier chapters, Larry uses hard-coded values for the