Beginning PHP and MySQL 5: From Novice to Professional, Second Edition (Beginning: from Novice to Professional)

  Author:    W. Jason Gilmore
  ISBN:    1590595521
  Sales Rank:    142923
  Published:    2006-01-23
  Publisher:    Apress
  # Pages:    952
  Binding:    Paperback
  Avg. Rating:    4.0 based on 100 reviews
  Used Offers:    23 from $14.55
  Amazon Price:    $28.78
  (Data above last updated:  2008-11-29 06:17:21 EST)
  
  
Sort customer reviews by:
  
Show All Reviews on Page      Hide All Reviews on Page
   
  
Beginning PHP and MySQL 5: From Novice to Professional, Second Edition (Beginning: from Novice to Professional)
  
  • Written for the budding web developer searching for a powerful, low-cost solution for building flexible, dynamic web sites.
  • Essentially three books in one: provides thorough introductions to the PHP language and the MySQL database, and shows you how these two technologies can be effectively integrated to build powerful websites.
  • Provides over 500 code examples, including real-world tasks such as creating an auto-login feature, sending HTML-formatted e-mail, testing password guessability, and uploading files via a web interface.
  • Updated for MySQL 5, includes new chapters introducing triggers, stored procedures, and views.

From the Back Cover

Interested in becoming a master of the PHP language and MySQL database but don't know where to begin? This best-selling book ranks among the most thorough and practical guides in print, covering all of the key concepts and features, and showing you how to effectively integrate PHP and MySQL to build powerful web sites.

The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.

Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5&emdash;specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.

What You Will Learn from This Book

  • Install and configure Apache, PHP, and MySQL on both Windows and Linux.
  • Accept and process information submitted via HTML forms.
  • Authenticate users and track user preferences and data using PHP's session-handling capabilities.
  • Process web-based file uploads using the HTTP_Upload PEAR package.
  • Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.
  • Use both command-line and graphical MySQL clients to effectively manage your data.
  • Secure the MySQL server, creating roles and restricting access even at very granular levels.
  • Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.

Beginning PHP 5 and MYSQL: From Novice to Professional offers a comprehensive introduction to two of the most popular Web application building technologies on the planet: the scripting language PHP and the MySQL database server. This book will not only expose you to the core aspects of both technologies, but will provide valuable insight into how they are used in unison to create dynamic data-driven Web applications.

Beginning PHP 5 and MYSQL explains the new features of the latest releases of the world's most popular Open Source Web development technologies: MySQL 4 database server and PHP 5 scripting language. This book explores the benefits, extensive new features, and advantages of the object-oriented PHP 5, and how it can be used in conjunction with MySQL 4 to create powerful dynamic Web sites.

This is the perfect book for the Web designer, programmer, hobbyist, or novice that wants to learn how to create applications with PHP 5 and MySQL 4, and is a great entrance point for Apress's extensive spectrum of PHP books planned for 2004.

                  Reader Reviews 1 - 50 of 62            Next
  
  
Review
Date
Review
Rating(5 High)
Review
Helpful
to:
Customer Review Reviewer
Info
Permanent
Link
Reader Reviews Below Sorted by Newest First
11-08-08 1 0\1
(Hide Review...)  Not much recommended
Reviewer Permalink
The book is more a glossary of terms that are in the php manuals. I could not benefit from any effort (except on a couple of occasions where something is described in full) that could have been devoted to trying to translate theory into the things you really need to know when actually doing anything you want, such as a search form that contains several select lists that are linked and that you want to pass the selected values to a database to retrieve results etc. You are not going to find an answer for that at all.
Besides I am coming to pages such as 450 that contain php code which does not exist as function (as of 8th nov 08) , for example: session.use_cookies
If you go to the php website you will be told that that function does not exist.

"Sorry, but the function session.use_cookies is not in the online manual. Perhaps you misspelled.."

and it continues Perhaps you were looking for one of these:

session_set_cookie_params

I do believe that the author does know a lot of programming to expert level in many languages, but in this book I have not seen that knowledge translated into something that really helps me do my website. I have made my site by a time consuming consulting on practical pages and advices I have seen on the web and how other people have solved common things, like the one I have mentioned above.
So, I would welcome another book from the author that would take the time to think what we need to do for what, and put his great knowledge into useful tips. I dont mean to lend us intelligence, but by seeing it in praxis, then we can easily build upon.
(Review Data Last Updated: 2008-11-30 07:15:34 EST)
10-29-08 5 (NA)
(Hide Review...)  One of the bestcomputers books
Reviewer Permalink
When i purchased this book, I was expecting a Computer book. To my surprise
the book i purchased contained all the information that i was interested in learning(PHP, MySQL, database) as well as provided a great reading experience.

This book is very interactive and fun to read. The author makes you feel part of the learning process and guides you through learning effectively not only about PHP,MySQL and many tricks of the trade, but also about a lot of other stuff that you most likely did not expect to learn. This will make it this much easier to learn to work with a different platform(Oracle etc.)

Not only do i recommend this book, I urge you to read it as it's a lot more than what the Product Description assumes. This is one of the best computer books that i have ever read, and it's sample code is fantastic.


Congratulations W. Jason Gilmore

And Thank you for allowing me to learn while having fun

Best Regards

J.B

(Review Data Last Updated: 2008-11-09 05:48:59 EST)
10-16-08 3 (NA)
(Hide Review...)  Reads like reference, not very interesting, too long for not much.
Reviewer Permalink
I have first started off programming PHP since 2002 and have built small websites here and there and mostly just 'web tools'. Since it has been some time since I really coded in PHP I decided to get a start from scratch book again, although knowing I still have the basics down. I believe this book is a drag-on, taking up more pages than it should, wasting time in many cases and it reads like a reference book, explaining function after function and in the later chapters PEAR classes/packages, all of which could have just been a URL link in the book to the most up-to-date and online reference for the pertainent resource.

It can get your up to speed with PHP no dobut about that but be prepared for a longer than anticipated read if you do go through this book from cover to cover.

The examples could have been more interesting so the knowledge would stick, and withhold an enthiusiasm on the learner. All of the examples in this book was a bit boring (atleast to me). This book may have been better if you constantly built upon a project, and at the end of the book you would have made something useful by piecing parts together to make a complete working web app. That way you can appreciate, apply and retain the information absorbed so much better. For such reasons I believe the PHP By Example series from another publisher are much better, as those were the books I used in the earlier days.

The author seems to peper advanced topics every now and then in some chapters which would only confuse the beginner. I believe such topics should have been saved for the last few chapters, such that the beginning will be here's how you do it, and in the end this is how you fool-proof it. That way, you get to appreciate the added knowledge rather than the ah-ok and forget it method.

As a word of advice dont judge a book by the number of pages it contains, but you could say in this instance that this book does have alot of information in it if you are primarily testing and developing offline.
(Review Data Last Updated: 2008-10-30 05:51:16 EST)
10-12-08 5 (NA)
(Hide Review...)  A great reference for any web designer!
Reviewer Permalink
This is a great book for any web designer no matter what your experience level. It is a great reference and I was able to teach myself what was needed using this book!
(Review Data Last Updated: 2008-10-17 07:33:17 EST)
09-14-08 5 (NA)
(Hide Review...)  Excellent Book
Reviewer Permalink
I own several PHP/Mysql reference books, and this one is the most comprehensive of all of them. Just the right balance and written descriptions/explanations and practical applications/examples. I wouldn't necessarily say this book is for beginners, but anyone that's a novice to professional would love this book. I highly recommend the 3rd addition for any PHP/MySQL developer that is looking for a great reference.
(Review Data Last Updated: 2008-10-13 07:01:58 EST)
09-08-08 1 0\1
(Hide Review...)  This book is a reference manual at best...
Reviewer Permalink
If you are new to PHP, DO NOT buy this book. I can't believe all the good reviews here. There are no practical examples, and very little useful information. It is, at best, a reference manual. If you're new to PHP, check out David Powers' books.
(Review Data Last Updated: 2008-09-15 07:39:37 EST)
07-10-08 3 2\2
(Hide Review...)  Just a reference book
Reviewer Permalink
Hello there,

I begin learning PHP in 2003. I havn't progressed much since then. I learned the basics of PHP from "PHP and MySQL Web Development" by Luke Welling and Laura Thomson. I know how to interact with the database, create sessions, I can even go furder if I'm interested and I read some tutorials over the internet, however I wanted to have a book that I can read in bed.

So I took this book based on reviews and because it also covers a bit of PHP6 All I wanted is to remind me on some stuff I read some time ago and learn some new things, tactics I could use.

So I started to read. I rememberd some old stuff about Arrays, Strings. I still can't get OOP but I havn't tried to much. Now I will defenetly use PEAR because the examples in the book weare helpful, HOWEVER...

As other people say, this book is more as a reference book. I didn't got so much information. I'm on chapter 21. I will soon start to read about MySQL and I can't really say I have learned something. Yes, I know some things but still, this isn't good for a beginner.

The book "PHP and MySQL Web Development" starts MySQL in chapter 2. This means you start from the begining on actualy doing someting useful. Here you just read chapters after chapters but you don't actualy have good examples. Yes, you have examples and how to use some functions but no big examples.

I first got my disapointment when I was on SESSION HADLING chapter where I really wanted to see some COOKIE examples. All I found was some COOKIE FUNCTIONS and some explinations that I could have got from PHP Manual. From PHP Manual I could have even found some examples, here nothign. Then I found some simple details about $_SESSION. TO little covered in this important chapter.

Then I finally got it. All this book does it present to you some functions. Explain them. You see a small example and you move on.

No actualy practice! I really wanted a BIG BOOK from where I can learn more stuff.
(Review Data Last Updated: 2008-09-08 06:05:24 EST)
05-29-08 4 (NA)
(Hide Review...)  [Third Edition Review] Broad coverage except in XML manipulation
Reviewer Permalink
This books is written for someone who is familiar with other programming languages and databases and now wants to use PHP and MySQL. It is not written for somebody completely new to programming. For example, if you came from Perl or ASP, and you wanted to know how arrays, loops, and objects in PHP, this book will cover that.

The topic coverage is broad but not deep. The book has a feel of "semi-reference" in that each topic stands on its own. This is not a cookbook or "learn by example" book. There is enough information to get you started, but if you have a complex/niche problem, this book will not help you. For more information, you will have to consult books that specialize on the topic you are interested.

I have one major gripe with this book. There is not any significant coverage of XML manipulation or XSL/XSLT aspects of PHP. When you look at the table of contents or index, there is no mention of XSL/XSLT and only a brief mention of XML (and RSS) in the Web Services chapter. For a book that covers a lot of subjects, this is a weak area.
(Review Data Last Updated: 2008-07-11 17:28:26 EST)
05-29-08 3 (NA)
(Hide Review...)  Not for beginning programmers
Reviewer Permalink
This book does have a lot of information, making it a great reference book. However, after 10 chapters I still do not know how to use any of the information to "build dynamic, database-driven web sites..." as the subtitle states. If you're a beginning programmer, as I am, try to find a true beginner's book (wish I could give a recommendation).
(Review Data Last Updated: 2008-07-11 17:28:26 EST)
05-14-08 5 1\2
(Hide Review...)  Great book on PHP and MySQL
Reviewer Permalink
I have recently bought this book and have to say it is execellent, it does help if you have a little prior knowledge as some new readers could find it a little difficult to understand. But if you have an interest in PHP and MySQL it is a great book to get your hands on. I highly recommend it.
(Review Data Last Updated: 2008-05-29 04:32:01 EST)
05-06-08 2 1\1
(Hide Review...)  Not for the novice!
Reviewer Permalink
Despite the title, this book is not for the novice. Even the introductory first 100 pages or so assume that you are above a novice level. The examples lead to more questions (for me, the novice) than they answer.

Having said that, this book has a tremendous amount of information in it and, as other reviews mention, it will work well as a reference. Now, I hope to find a true beginning PHP book to provide the basis to use this book!

(Review Data Last Updated: 2008-05-17 05:32:21 EST)
05-02-08 5 1\1
(Hide Review...)  This was my first PHP/MySQL book
Reviewer Permalink
I purchased this book because I needed to use PHP and MySQL for a project at work. I never had any exposure to either before reading this book. By using this book and the w3schools website I was able to successful build a meager database and have a fully functioning php front end. It was very pleasing to see the project come to fruition and I have this book to thank for that. I used it mainly as a reference book. For example, I knew exactly what I wanted to do so I would search this book for an example of that and adapt the code to my situation. I didn't use this book to "learn PHP." I think you need to have a project to do in order to best use this book.
(Review Data Last Updated: 2008-05-17 05:32:21 EST)
04-11-08 5 1\1
(Hide Review...)  The Ultimate Bible for Web Programming!
Reviewer Permalink
First off let me address a common review, that the book is too advanced for beginners. Plain and simple, it is not beginning programming, it's beginning PHP and MySQL. To even know what these applications are, you should have some programming background anyhow.

That said, even if you don't have any prior experience, the book does a great job of introducing you to the key concepts, and is flooded with examples, the best way to learn.

This book has become my programming bible, but it maintains a great balance. It has everything you could ever wish to look up later (and you will), but still follows a nice rhetoric and flow for someone looking for a tutorial-esque book. Some of the examples he wrote are key frameworks in my website! I actually used his book as my main source to build my website from the ground up. Even if it doesn't have something, it arms you with enough knowledge to know the right questions to ask. Which leads me to the greatest part of all... he backs his product!

I battled a bug for over 4 months that I was unable to solve from searching anywhere on the Internet. It's then I remembered that he listed his E-Mail address in the book and challenged readers to contact him if they needed help! Not expecting a response, I was shocked when he speedily replied that day, and solved my problem finally to boot!

To sum up: Not necessarily for beginners period, great for programmers beginning PHP and MySQL, the only book you should have to buy, and a very supportive author.
(Review Data Last Updated: 2008-05-03 07:40:55 EST)
03-06-08 4 1\1
(Hide Review...)  Great amount of depth, not so much context
Reviewer Permalink
This is a great reference book. It delves very deep into both PHP and MySQL. One thing I found lacking was some context. Practical examples so that I can see what I've learned being implemented in real world applications.

Other books that do not get so deep often include these types of exercises and I find them extremely helpful to gain a true understanding of the material.

In my opinion, if this book included excerises, case studies, etc.. it would be perfect.
(Review Data Last Updated: 2008-04-13 07:48:05 EST)
02-26-08 5 (NA)
(Hide Review...)  Definitive text on the subject
Reviewer Permalink
There are a good many texts on this subject, but not definitive like this one. A lot of technical writers have a tendency to get so bogged down with details they leave the readers behind and frustrated. What Jason does is present the material in a fresh and CONCISE fashion. He doesn't spend paragraph after paragraph beating a subject to death or flinging out stale descriptors; he simply breaks it down into the basic components and tags on "nuggets of wisdom" that help you avoid pitfalls as he builds on the material. Right from the beginning, he engages us with the why and what of programming PHP against a MySQL backend, and then he's off and running. No long-winded chapters, just straightforward information. This is what all technical books should strive to achieve.
(Review Data Last Updated: 2008-03-07 07:47:59 EST)
01-19-08 3 (NA)
(Hide Review...)  Not good, Not Bad.
Reviewer Permalink
it's thick really. And can't blame the accuracy as technology changes . There are errors i found , and couldn't resolve. If only he has a support forum , it'll be better . This book expects you to have some knowledge in PHP. And like some say, it's implementation to a website and turorial is little or near to zero.Should include more samples of cases. you have to figure out your own. it's more like a textbook than a self-learn book. It's good for reference. I suggest who is really new ,in PHP - look for other that is easier to read ,and more novice-like.This book should help in your advance to professional stage.
(Review Data Last Updated: 2008-02-24 22:10:04 EST)
01-18-08 3 1\1
(Hide Review...)  Not good, Not Bad.
Reviewer Permalink
it's thick really. And can't blame the accuracy as technology changes . There are errors i found , and couldn't resolve. If only he has a support forum , it'll be better . This book expects you to have some knowledge in PHP. And like some say, it's implementation to a website and turorial is little or near to zero.Should include more samples of cases. you have to figure out your own. it's more like a textbook than a self-learn book. It's good for reference. I suggest who is really new ,in PHP - look for other that is easier to read ,and more novice-like.This book should help in your advance to professional stage.
(Review Data Last Updated: 2008-02-27 07:41:54 EST)
12-21-07 2 0\3
(Hide Review...)  Probably not your best option
Reviewer Permalink
I bought this book because I need a more advanced book on PHP/MySQL - specifically in the use of mysqli, PDO and stored procedures. I found this book to be quite lacking in these areas. I have the MySQL Stored Procedure Programming book by Oreilly and it covers these subjects in better detail but even it doesn't go as in-depth as I would like.

I think there is some good material in this book but it didn't satisfy my immediate need and for that I am disappointed.
(Review Data Last Updated: 2008-02-13 02:50:36 EST)
11-29-07 3 0\2
(Hide Review...)  Hit or miss
Reviewer Permalink
Some sections of this book have been very helpful, while others seem to have been slapped together for "completeness" but without much thought or care. For example the section on session handling I thought was quite good. The section covering the newer object based MySQL interface was hard to understand and lacked enough information to do anything beyond the very basic example given. Then again most books on the shelves right now don't cover it at all.

I found numerous errors in the examples, but that seems to be standard fare for most rushed-to-print books of this type. A larger problem is that the text is often unclear, and the examples don't do a good job of helping. Also where there are multiple approaches given to a problem the examples seem to stick to one approach and other approaches, while mentioned, are not shown.

It's easy to accept these shortcomings as it seems to be the norm for this type of book, except that after spending some time looking through other books on the subject I did find one that does a much better job on all fronts. No surprise it's an O'Reilly release - "Web Database Applications with PHP and MySQL 2nd Edition."

As to whether I'd recommend this book...not as a sole source of information. It does have some good sections that are worth having access to, but trying to use it by itself to learn with and as a reference has been an exercise in frustration.
(Review Data Last Updated: 2008-02-13 02:50:36 EST)
11-04-07 4 1\1
(Hide Review...)  good book
Reviewer Permalink
is a good book for reference, if you already have programimng knowledge is great, it has a lot of information so you can skip some parts, if you are new to php you have to read it from the start.
it was a good buy
(Review Data Last Updated: 2008-02-13 02:50:36 EST)
10-02-07 2 1\3
(Hide Review...)  Definitely not for begginers
Reviewer Permalink
I never got around to finishing this book because halfway through it I noticed I had not even written a single line of code.The author does not propose any excercises for you to try out what your learned through the book.All he does is list all the functions available in PHP but no examples on how to use them.
I can see this book being useful as a reference after you have programmed PHP for a while, but for beginners that want to get started in PHP for the very firt time I would not recommend it.
(Review Data Last Updated: 2008-02-13 02:50:36 EST)
09-15-07 1 3\7
(Hide Review...)  Far too many typos, syntax errors, and gaps in explinations
Reviewer Permalink
I bought this book on recommendation. I have a background in programming, and I just needed a book to cement together all the concepts I had picked up in developing PHP apps. Less then 2 chapters in the errors became so frequent in the code that the author no longer holds my confidence. Its hard to be confident of his explanation if it lacks the care to make sure its correct.

The writing and explanations, though following a clear format, are at times wildly inconstant in explaining the parts of various functions. Do not recommend.
(Review Data Last Updated: 2008-02-13 02:50:36 EST)
08-07-07 4 (NA)
(Hide Review...)  Full of value
Reviewer Permalink
I haven't programmed in almost 10 years, but wanted to jump into PHP and MySQL generated web content. I was able to pick and chose throughout this book to bring myself up to speed and have a functional website in a matter of 2 weeks. I was easily able to adapt examples in the book to fit my needs.

This book was really worth the money. I will be referencing to it for a long time to come.
(Review Data Last Updated: 2007-09-16 07:41:46 EST)
07-06-07 5 1\1
(Hide Review...)  Great reference for all
Reviewer Permalink
I am a semi-experienced programmer, majoring in CS and currently in my third year. I needed to buy a book to learn PHP for a job and originally went for O'Reilley's _Learning PHP and MySQL_. I quickly realized that was a bad choice, however, because it was way too simple and short and didn't really cover SQL at all. Even as a reference book it just did not suffice compared to Gilmore's _PHP5 and MySQL_ which I borrowed from a friend. PHP and MySQL is covered in great depth, and a thorough index makes this nearly-exhaustive text a great reference book.

**This is likely not a book for someone who has never programmed before** as it uses typical programming language terminology without previous definition. Still, abundant examples and side notes allows anyone with reasonable programming experience to breeze through the book. Reading this cover-to-cover would definitely not be the correct approach, but skimming over the chapters and getting acquainted with the PHP language is something this book makes easy to do when you can simply slow down and go over the examples when you feel you need to, or quickly reach the next section thanks to good organization and text formatting.

If you are looking for a reference book for PHP and MySQL just short of a bible, this is definitely for you. But if you are a complete novice to programming, you would probably be better off coming back to this later or buying it on the side for once you have more experience.
(Review Data Last Updated: 2007-08-08 08:00:13 EST)
06-22-07 5 (NA)
(Hide Review...)  Great starter guide
Reviewer Permalink
this guide speaks in laymens terms and teached using simple examples. I would recomend this book for grandmothers and professional web admins collections
(Review Data Last Updated: 2007-07-10 21:36:57 EST)
06-15-07 5 (NA)
(Hide Review...)  Excellent Standalone Learning Material!
Reviewer Permalink
I recently purchased "Beginning PHP & MySQL: From Novice to Professional" to
help me in my summer project of expanding my knowledge of web design. As it
turns out, the book has been more than a help! It's practically all I've
needed.
(Review Data Last Updated: 2007-07-10 21:36:57 EST)
06-11-07 5 (NA)
(Hide Review...)  Excellent Book
Reviewer Permalink
Only through the beginning of this book, but so far so good. Excellent explanations and the other reviewers are on the money when they say that this is a good book. Highly recommended.
(Review Data Last Updated: 2007-07-09 19:49:09 EST)
06-10-07 1 0\2
(Hide Review...)  Not for novice...
Reviewer Permalink
This book shouldn't be advertised as "from novice to professional", since it start assuming that you have pretty complex knowledge of C++, HTML, etc. The book doesn't even have an ordered structure: when you are in the first chapters, it start using functions that will be explained later, just as if you should know them before.

Sometimes very complex, other times it just seems like a big appendix of functions descriptions instead as a guide to use them in real program environment.

After reading the whole book, and having it at sight, I tried to create a simple program and it was just impossible, because I learned useless and too complex functions but I couldn't make the simplest program without looking for help at php forums.

It may be a good option for not-novice, but if you're looking for a novice book, DON'T buy this book.
(Review Data Last Updated: 2007-07-09 19:49:09 EST)
06-08-07 4 (NA)
(Hide Review...)  Great Book
Reviewer Permalink
I really enjoyed reading through the book. It's not only good for someone just learning PHP, but it serves as a great reference material as well. I'd highly recommend this book to anyone getting started with PHP.
(Review Data Last Updated: 2007-07-09 19:49:09 EST)
05-07-07 5 1\1
(Hide Review...)  Excellent book for those new to PHP and MySQL
Reviewer Permalink
First, let me say this book DOES NOT teach programming. So, if you are unfamiliar with general programming constructs and how they work, this book may not be for you.

This is my first book on PHP and MySQL. I have read many other books ranging from simple web development to game programming with OpenGL and C++. For anyone with some understanding of programming this is an excellent book. It is one of the easiest reads for a technical book that one can find.

The book is full of short examples. The book does not unnecessarily spend a long time on particular commands and gets straight to the point. For example, the chapter on arrays does not go over what an array is and how it operates, but discusses a huge plethora of array functions. This makes the book a great reference, as the chapters are independent and well organized. This also means the 913 pages are packed with a wealth of information; especially since, there is not an appendix.

The author is also very approachable, and he has responded to my e-mail. He also has a new site for the book that I recommend you visit before making your decision. [...]
This book is definitely a good choice if you are looking for a book to learn PHP and use it with the MySQL database.
(Review Data Last Updated: 2007-07-01 08:01:45 EST)
04-21-07 5 (NA)
(Hide Review...)  Outstanding guide for experienced programmers
Reviewer Permalink
I found this to be a very helpful guide in getting into the intense details of configuration, performance tuning and eventually programming PHP web applications. It spends a lot of time on the settings and config, and eventually gets into data access and DB progrmaming. if you're moving over from another platform (like I did), you'll find this very helpful.
(Review Data Last Updated: 2007-05-08 09:10:33 EST)
04-13-07 5 2\2
(Hide Review...)  I'm a PHP beginner
Reviewer Permalink
I picked up about three different books on the subject, and this one was by far the best. It moved at a fairly rapid pace, but each example was explained fairly thoroughly. The past couple of years I haven't had much luck with computer books; some were either a little too slow (PHP Visual Blueprint-- but at least the examples worked) and/or extremely sloppy (Designing with Javascript from O'Reilly is a prime example-- demo files from the website either didn't work or were missing entirely-- and the errata page didn't even begin to address these problems) or presented haphazardly (Elizabeth Castro's Peachpit book on Perl). I was really glad to find this book when I did. I was about to give up on computers entirely and turn to some disreputable vocation like war profiteering.
(Review Data Last Updated: 2007-04-21 08:57:44 EST)
03-29-07 3 1\2
(Hide Review...)  Fairly well written, but needs work
Reviewer Permalink
I'm a semi-newbie when it comes to PHP. I've done some simple PHP previously, and for a project at work I needed to ramp up my knowledge of using PHP together with MySQL. Due to the ratings for this book, I ordered it.

It's fairly well written, but the code snippets themselves occasionally have syntax errors. This extends to the source code that you can download from their site. I can understand syntax or other errors in a book, but I can't forgive errors in a file that is easy to update online. In fact, it got so bad that I had to look online through some tutorials to get the syntax correct for my project, defeating the purpose of me purchasing this book.

While providing a solid understanding (If somewhat terse at times) of the workings and background of both software packages, error checking needs to come into play.
(Review Data Last Updated: 2007-04-13 09:29:43 EST)
03-28-07 3 1\2
(Hide Review...)  Fairly well written, but needs work
Reviewer Permalink
I'm a semi-newbie when it comes to PHP. I've done some simple PHP previously, and for a project at work I needed to ramp up my knowledge of using PHP together with MySQL. Due to the ratings for this book, I ordered it.

It's fairly well written, but the code snippets themselves occasionally have syntax errors. This extends to the source code that you can download from their site. I can understand syntax or other errors in a book, but I can't forgive errors in a file that is easy to update online. In fact, it got so bad that I had to look online through some tutorials to get the syntax correct for my project, defeating the purpose of me purchasing this book.

While providing a solid understanding (If somewhat terse at times) of the workings and background of both software packages, error checking needs to come into play.
(Review Data Last Updated: 2007-04-11 09:06:08 EST)
03-26-07 4 (NA)
(Hide Review...)  Very good resource
Reviewer Permalink
I bought this book because I had a project that required me to set up a dynamic website driven by MySQL and PHP. Using what I learned in the book and a few free online tutorials I was able to finish the project 1 month early.

This book assumes some prior programming experience, so if you've never programmed getting an intro to programming book would be a good idea first. There are many examples of code in the book which cover many things you might like to do with a website driven by these two technologies. Not a terribly difficult read with lots of info.
(Review Data Last Updated: 2007-03-29 09:03:52 EST)
12-20-06 3 12\13
(Hide Review...)  Frustrating
Reviewer Permalink
I'm not new to programming or web programming, but I was new to PHP. This book is much better as a reference than an intro to PHP, however, even there it has its limitations.

I bought this book, read the first 5 chapters (130 pages), and then stopped reading it because I was learning too slowly (ie, reading too many pages and picking up too little usability). As an introductory text, I would rather this book moved at a greater breadth but less depth -- it goes through dozens of specific functions, making it feel like a dictionary. There is also little attention brought to the functions you will be using soon over the ones you will not use for awhile yet. In that sense, it was very frustrating to spend a lot of time reading several chapters and still not feeling like I was getting anywhere or able to use much of the power of PHP.

In my frustration, I decided to revisit w3schools . com, and I found their tutorial immensely useful as an introduction to both PHP and MySQL (I needed both and I needed them quickly). That choice allowed me to start writing some PHP code within an hour and start working with databases quickly as well (nothing is mentioned about MySQL until Chapter 24 of this book).

So now, instead of use this PHP/MySQL book as a learning tool, I use it as a reference. The index isn't ideal*, so it still isn't a great reference, and the MySQL layout has not been helpful. I will be buying some PHP cookbooks to get a better feel for the capabilities of PHP and how to use its functions properly, and I will report back in this review after I find a better reference to recommend over this one (hopefully by mid-January).
*The index is HUGE, but I still have a difficult time finding things I need since I look for a lay-word over the word that is listed. If I already knew the word that is listed in the index, I may not even need to look in the index.

This book was written for new programmers that want a programming introduction to PHP and was not written for web programmers new to PHP. Although I program, I want features of a web programming book when I buy a web programming book.

What I consider a feature of a (good) web programming book: Chapters are split into a quick intro to the most commonly used fuctions of the chapter's topic (5-10 pages) and a longer part for use as a reference (15-20 pages). The book's format has good eye catching sections so readers do not waste time finding what is important if we just want to skim things so we can get into doing some web programming quickly. Commonly used functions are not buried in a bunch of uncommonly used functions.
(Review Data Last Updated: 2007-03-26 09:09:43 EST)
12-13-06 5 4\5
(Hide Review...)  excellent coverage of essential 'need to know'
Reviewer Permalink
Although the title says 'From Novice to Professional' be aware that you won't go from novice to *expert* with this book. It will, however, bring you to a decent functional level (hence professional). Also, it is true that the book assumes a basic understanding of programming. So if you're new to programming, get an 'Intro to Programming' book before or follow some general programming tutorials to bring you up to the basics.

This is a great introductory book to PHP that can as well serve as a reference. It covers many areas, not always in depth, but most times enough to give you some solid bases and get you to actually 'do stuff'. The good thing about this is that at least 95% percent of the stuff covered matter. What that means for you is that you are veered to the right choice of technologies and concepts from the beginning, ready to expand your knowledge in any of the areas.

The book assumes that you want to work with Apache (which you should ;) ) and explains how to set things up in both unix and windows environment. However, even with a book these installations seldom go without problems, so I would strongly recommend to search for a bundle installation like wampserver, xampp or any other that group the 3 applications (apache, mysql, php).

If you're strong headed like me and like to hurt yourself you can decide to go through the pain and install each individually. The tradeoff is that you have a better understanding of the overall environment. My best advice if you choose this route is to RTFM (read the 'fine' manuals). My second best advice is Google.

Chapter 1 and 2 will serve you better as reference later on in your journey as you become profecient enough to actually care about tweaking your environment for features and performance.

Once all is installed and working, the book really starts with chapter 3. There's an extensive coverage of basic language features such as variables, arrays, functions, scope, comments, escapes, selection and repetition structures, etc.

You will gain some solid notions of intermediate level stuff with chapters on file handling, file uploads, session handling, data insertion and retrieval, authentication.

Some chapters bring you to a productive level with more advanced features like object oriented programming, templating (which with OOP offer good precursors to the concepts behind the MVC when you will learn about design patterns in more advanced texts), web services, regular expressions, error handling.

MySQL as well is covered to a workable level, I particularly liked that Jason Gilmore walks you through the creation of a database class to encapsulate your connection and access needs. It well illustrates some of the practical application of OO Programming in the real world. Most serious developers use similar classes in their day to day development.

There are other chapters in the book that may be of interest to some (networking with php, ldap, SQLite).

This is probably not the last php book that you'll need, but it's a great first step to prep you for more advanced subjects. Overall for the beginner this is a great bang for the buck.
(Review Data Last Updated: 2007-03-24 15:19:48 EST)
12-13-06 5 (NA)
(Hide Review...)  excellent coverage of essential 'need to know'
Reviewer Permalink
Although the title says 'From Novice to Professional' be aware that you won't go from novice to *expert* with this book. It will, however, bring you to a decent functional level (hence professional). Also, it is true that the book assumes a basic understanding of programming. So if you're new to programming, get an 'Intro to Programming' book before or follow some tutorials to bring you up to the basics.

This is a great introductory book to PHP that can as well serve as a reference. It covers many areas, maybe not in depth, but enough to give you some solid bases and get you to actually 'do stuff'. The good thing about this is that at least 95% percent of the stuff covered matter. What that means for you is that you are veered to the right choice of technologies and concepts from the beginning, ready to expand your knowledge in any of the areas.

The book assumes that you want to work with Apache (which you should ;) ) and explains how to set things up in both unix and windows environment.

There's an extensive coverage of basic language features such as variables, arrays, functions, scope, comments, escapes, selection and repetition structures, etc.

You will gain some solid notions of intermediate level stuff with chapters on file handling, file uploads, session handling, data insertion and retrieval, authentication.

Some chapters bring you to a productive level with more advanced features like object oriented programming, templating (which with OOP offer good precursors to the concepts behind the MVC when you will learn about design patterns in more advanced texts), web services, regular expressions, error handling.

MySQL as well is covered to a workable level, I particularly liked that Jason Gilmore walks you through the creation of a database class to encapsulate your connection and access needs. It well illustrates some of the advantages of OO Programming. Most serious developers use similar classes in their day to day development.

There are other stuffs in the book that may be of interest to other people (networking with php, ldap, SQLite). Overall for the beginner this is a great bang for the buck.
(Review Data Last Updated: 2006-12-13 14:28:19 EST)
12-01-06 4 2\3
(Hide Review...)  This book covers plenty territory well, and no problem with excess!
Reviewer Permalink
This has been a great book for me. I've been using & tweaking PHP applications for a few years, and recently had occasion to build one. The fact that this book could also refresh my MySQL skills peaked my interest.
I was impressed with the nice examples, long enough to show the main idea, yet other reviewers are right, there is not much here in the way of fullout precanned applications.

I like that this book seems to be organized so that rather than just read it from cover to cover you can dive in and learn from any particular section. The examples can can be downloaded from the Apress site. At times, when printed examples left details out it would be nice if those details would be included in the down-loadable examples (.css files are used in the HTML_Table demos, but never shown or down-loadable).

After browsing the MySQL sections I was able to create and manipulate the db I wanted in no time.

This book covers lots of ground, I was impressed with the completeness of PHP topics, including things you might not expect, like Smarty templates and the Data abstraction of PDO.

Contrary to other reviews, this book is still not a complete PHP reference manual, it's not meant to be. But if you have this book and a link to a PHP reference website you'll be fine!
(Review Data Last Updated: 2007-03-24 15:19:48 EST)
10-21-06 1 6\26
(Hide Review...)  This is not a book to learn php, its just a dictionary of functions
Reviewer Permalink
If you plan to learn php from this book, i suggest you start looking for another, this is just a dictionary about all terminolgy and commands regards php, but with no excercices!!! well.. there are a few lazy excercises. Its only a description of the methods i mean.. if you are reading about the function echo() you will read something like. "ok, you should use echo in this way "echo "this book sucks", echo is for show you some info on screen, or if you are reading about loops, like for.. "ok. for is for looping! like 1 to 10".. that's it! now you are an php expert!!!.. if there was a posibility to rate this as -5 i would.
(Review Data Last Updated: 2007-03-24 15:19:48 EST)
10-01-06 4 9\11
(Hide Review...)  A really good PHP introduction book
Reviewer Permalink
First off, this book is completely useless to you if you have do not have adequate OOP programming background. It jumps around different topics and does not really explain why things are arranged a certain way. This book pretty much assumes you have knowledge of either C, C#, Java techniques - which makes PHP extremely easy to understand. If HTML is all you have under your belt, this is probably a terrible book to buy.

Coming from an adequate background, this book introduces plenty of useful features of PHP and offers a good guide for reference and parameters. Since the book is titled PHP and MySQL, it is expected that the reader should know basic SQL syntax to understand how PHP works with a database.

Overall, this is a good starter book on a very broad topic and it has gotten me started on writing my own scripts.
(Review Data Last Updated: 2007-03-24 15:19:48 EST)
09-01-06 5 7\9
(Hide Review...)  37 Chapters, 3 Books in one, and a must have desktop reference.
Reviewer Permalink
This is as it states for the Novice to the Professional and that is completely true.
If you are new to PHP or if you know PHP well this book is for you. Great for beginners
and a reference for the professional to turn to again and again.
The foundation of the web is simple database back ends and interactive web page front ends.
MySQL is an Internet standard back end database and it's ease of use combined with the power of PHP
make the 2 a great combination to construct web databases easily and powerfully.
Gilmore guides the reader step by step from installation to basic functions, and finally to practical uses
for PHP and MySQL.
But wait a minute, Gilmore adds two more things. He sneaks small chapters in the middle of his book on
SqlLite and PDO. For those thinking that MySQL is a bit too much for their small project then turn to SqLite.
Gilmore explains how to install and use SqLite quickly. If you are a programmer and are familuar with using
Microsoft's ADO for database connections, then you can turn to PDO (PHP Dataobjects). PDO provides the
power and simplicity to connect to various databases that you may have at your disposal.
One of the great sections in the book is Gilmore's explanation of how to do Object Orientated Programing
in PHP. Starting with PHP 5 you can harness the power of PHP to deal with you program objectively. Object
Orientated Programming is mentally the way to go as you can plan, organize, and assemble your code logically.
Other chapters of interest include how to effectively use Arrays, Authentication, File Uploads, PHP and LDAP,
Secure PHP, Securing MySQL, Practical Database Queries, and Importing and Exporting data.

If you do any work with PHP at all, be sure to check out this book. It will pay for itself in full.

(Review Data Last Updated: 2007-03-24 15:19:48 EST)
08-28-06 5 4\4
(Hide Review...)  The only PHP and MYSQL book you'll need!
Reviewer Permalink
This book is geared for three types of readers I believe (a rarity among books). First are people who have no experience in programming or web development whatsoever, the second are people who have worked in other languages whether be on the desktop or the web, the third type are people who already have some basic PHP and/or MYSQL experience and want to further their knowledge into intermediate topics. How can a book accommodate so many types of readers? Well, being slightly over 800 pages helps and also this book is very well written and organized and focuses on all the important topics.

It's basically split into three parts (even though it does not say it specifically). The first part comprises of basic PHP skills (installing, syntax basics, functions, OOP and regular expressions), the second part are intermediate to advanced topics (PEAR, authentication, networking, web services, SQLite and PDO) and the third part covers the basics and some intermediate topics of MYSQL (installing, data types, MYSQL and mysqli extensions, stored procedures, triggers, views and transactions).

The book basically covers everything you need to know about PHP and MYSQL for most of your needs. Unless your going to be writing large, enterprise applications on a daily basis (most of us will not be), it really is the only book you should need.

If you're a novice, don't be scared of the size of the book or how many topics it covers. The author assumes no prior knowledge and starts you from the very beginning with easy to understand examples that step you through everything you need to get going. It covers the latest version of PHP (version 5.1) which includes PDO (PHP Data Objects) which provides a data abstraction layer to help connect to other database other than MYSQL (DB2, SQL Server, ORACLE, etc.) , and built-in functions for database commands.

This is a book I highly recommend and should be in your library if you want to learn PHP and MYSQL effectively.
(Review Data Last Updated: 2006-09-24 09:32:54 EST)
08-09-06 3 1\1
(Hide Review...)  Developing a little project from scratch is missing
Reviewer Permalink
It is a good book, but I was looking for a chapter were the author would developed a simple project (including the teachings of all the other chapters). For the next release, if the author includes more practical examples and -overall- a simple but comprehensive project, the book will deserve 5 stars.
(Review Data Last Updated: 2006-09-24 09:32:54 EST)
06-20-06 5 8\9
(Hide Review...)  Great bit of technical writing. Very useful
Reviewer Permalink
I think everyone knows that computer language books usually lean towards one of two extremes; either 1) the author cuts-and-pastes his doctoral thesis into Adobe, leaving everyone more confused than if they hadn't read the book at all, or 2) the book is apparently geared towards six-year-olds and the elderly, leaving you with 3 useful pages out of 800. (Also the books that somehow do both by covering basic variables on page 3, and polymorphing classes on page 5).

This book really does a good job of finding the middle ground. The content is extremely useful and it's well organized. The transitions between sections have a gentle slope, so you can read the book front-to-back, or pick out specific chapters without feeling lost (This will definitely be a reference book for me.) It's also written with personality, making it (I'm embarrassed to admit) decent late-night reading for the technically obsessed.

When I was researching the book for myself, I noticed some people commented that this book was too advanced to be called a beginner book. I agree with that, but only if you don't have any previous experience with programming in general. If this is your first time writing code, you should look for a general programming book first (but THEN get this one), but if you have any kind of programming experience, this book is a no-brainer!
(Review Data Last Updated: 2006-09-24 09:32:54 EST)
06-09-06 2 10\15
(Hide Review...)  Not a good beginning book
Reviewer Permalink
I really don't get the high praise for this book; other than the fact that most of the reviewers have programming experience already. I really think that book is way overated and, despite the claims of the title, is not suited for the beginner or the novice.

This book includes example code snipets about the use of individual functions, but does not have larger projects or exercices demonstrating how to bring things together.

Once I realized this, I thought, "well at least I can use it as a reference." And it does succeed at this to some extent. However, even in this capacity it seems a little shollow. Further, one gets the impression that it is basically a rewording of the existing documentation that is already available with PHP and MySQL.

To give just one example of all the above... Chapter 2 talks about configuration options in the php.ini file - PHP basics aren't even covered until Chapter3. Anyhow, let me open randomly to one of the excepts from the book and compare it to the .ini file:
-----------
register_long_arrays(On, Off)
Scope: PHP_INI_SYSTEM; Default value: off
This directive determines whether to continue registering the various input arrays (ENVIRONMENT, GET, POST, COOKIE, SYSTEM) using the deprecated syntax, such as HTTP_*_VARS. Disabling this directive is recommended for performance reasons.

-----------
And a cut and paste from the .ini:

Whether or not to register the old-style input arrays, HTTP_GET_VARS and friends. If you're not using them, it's recommended to turn them off,for performance reasons.
register_long_arrays = On

-----------

Again, at this pointt in the book (Chap2) a beginner/novice is still coming to grips with PHP basics (Chap3), let alone Arrays (Chap 5). Even after which, this is cryptic at best. How is this remotely geared towards either the 'beginner' or the 'novice'?! I could go on and on with examples from all parts of the book.

The sections on MySQL and the integration between it and PHP is thick, but lite. I consider this book mainly a rehash of the vendor documentation and lacking in real tutorials that are often crutial for novices to learn new skills. And, again, i think that the the book is completely mistitled.

Normally, I really like the Apress books; however, in this case I am benefiting much more from Wrox and Sams.

I might have given it a 3... but so many others scored it to high - even those who remarked on some of the same things.

-My 2 cents
(Review Data Last Updated: 2006-09-24 09:32:54 EST)
05-31-06 1 1\4
(Hide Review...)  Don't buy it
Reviewer Permalink
I guess if you only want to be able to hack together some PHP pages (nothing complicated) this book might help. But if you get confused or something goes wrong, this book will only confuse you more.

For example, almost every sentence in the section on the cast operator is false.

His explanation of format directives is not correct. But once again, the few examples he gives work and if that's enough for you to hack together a page then good luck. But if something goes wrong, this book will only make things worse.

At one point he says that the echo function "returns 0". Of course, the echo function never returns anything. But even if we understand that he must have meant that it "prints 0" in this case, in the context he does not explain the *rules* behind why the argument he gave to the echo function would have the value 0.

This is typical of the book. He will explain things incorrectly, or incompletely then give a few (very few) working examples.

With the understanding obtained from this book, I don't doubt that you could hack together some decent pages, but I wouldn't trust code written by someone with such a poor understanding of the language.

I believe that a person should go to college and learn about programming languages (not just take a course, but *learn*) before presuming to write a book about one. And I hope you will do yourself a favor and buy a PHP book written by someone who understands programming languages... in other words, not this book.
(Review Data Last Updated: 2006-06-06 13:22:16 EST)
05-18-06 5 3\9
(Hide Review...)  Great!
Reviewer Permalink
Jason wrote this book with the idea in mind of the real developer. By covering subjects such as security and alternative methods where it is needed and recommended, true applications can be developed using PHP and MySQL.
(Review Data Last Updated: 2006-09-24 09:32:54 EST)
05-15-06 5 5\7
(Hide Review...)  Couldn't find a better book
Reviewer Permalink
Had a few bumps with the installation, actuall contacted the author through email and he took the time to help and point me in the right direction. A very knowledgable man and wrote an excellent book!! Would recommend this to anyone looking to get started in PHP!
(Review Data Last Updated: 2006-07-07 11:48:43 EST)
04-03-06 5 2\2
(Hide Review...)  Excellent learning tool
Reviewer Permalink
I have a background in Visual Basic which definitely helped. The Chapter about setting up the Linux server I just skipped over but the rest of the book has been very good so far. I would recommend this book to anyone who has some programming experience (any, really) and would like to get into web database programming.

It will also be valuable as a reference later on.
(Review Data Last Updated: 2006-07-07 11:48:43 EST)
  
                  Reader Reviews 1 - 50 of 62            Next
  
  
  
  
  
  

Because the data used to generate this site come from outside sources, VeryWellSaid.com cannot guarantee the completeness or accuracy of the data.
Search VeryWellSaid™
Google
Web VeryWellSaid™
New subjects are added every week.
View Subjects Below by:
* Top Selling
 (click category name, left)
* Top-Rated Top Sellers
 (click 'Top Rated', right)
In the news...  
Dubai\UAE Top Rated
Influenza\Bird Flu Top Rated<