Beginning PHP 5 and MySQL: From Novice to Professional offers a comprehensive introduction to two of the most popular open source technologies on the planet: the PHP scripting language and the MySQL database server. You are not only exposed to the core features of both technologies, but will also gain valuable insight into how they are used in unison to create dynamic data-driven web applications, not to mention learn about many of the undocumented features of the most recent versions.

The first part of the book is devoted to PHP’s foundational features, with special focus on those new to PHP 5, including the improved object-oriented support, exception handling, SQLite support, SimpleXML, and much more. But PHP 5-specific topics are only part of what’s covered; you’ll also learn about the language’s core capabilities, beginning with a survey of installation and configuration tasks. Early chapters are devoted to basic PHP programming concepts such as variables, datatypes, arrays, string manipulation, and user interaction. Later chapters cover session handling, LDAP integration, the Smarty templating engine, and Web Services support.

Next up is a broad overview of the powerful MySQL database server. Among other topics, you’ll learn about the installation and configuration process, datatypes, key security features, and various administration utilities. With this groundwork in pace, you’ll then learn about PHP’s assortment of MySQL functions, accompanied by dozens of examples depicting the creation and execution of queries. You’ll also learn how to perform searches, and manage database transactions.

Whether you’re a newcomer searching for a thorough introduction to these popular technologies, or a seasoned developer in need of a comprehensive reference, this book is for you.

Beginning PHP and MySQL 5: From Novice to Professional, Second Edition offers comprehensive information about two of the most prominent open source technologies on the planet: the PHP scripting language and the MySQL database server. Essentially three books in one, this second edition covers PHP 5, MySQL 5, and how these two popular open source technologies work together to create powerful websites. The book is packed with practical examples and insight into real-world challenges. It is based on the author’s 7 years of experience working with these technologies. You will repeatedly refer to this book as a valuable instructional tool and reference guide.

Jason Gilmore has been developing Web applications for five years, and is currently the Editorial Director for Web and Open Source Technologies at Apress. His writing has been featured within many of the most popular Open Source related publications, including Linux Magazine, Devshed, O’Reillynet, Webreview, and Zend.com. He holds a B.S. in Computer Information Science from The Ohio State University.

• 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--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.

• 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--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.

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--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.

About the Author

W. Jason Gilmore has been obsessing over all things open source-related for almost ten years, with a primary focus on web development technologies. He has been extensively published in publications such as Developer.com, TechTarget, and Linux Magazine, with his work adopted for use within United Nations and Ford Foundation educational programs. Jason is the author of four books, including most recently the best-selling "Beginning PHP and MySQL 5, Second Edition", published by Apress.

Jason spends his days running Apress’ open source program, and his evenings writing, coding, and consulting. He’s a board member of Code Mash, a non-profit organization dedicated to educating the development community. When not in front of the computer, Jason can typically be found dreaming up home remodeling projects, and making homemade pasta.

Book Description



Essentially three books in one: provides thorough introductions to the PHP language and 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--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.


Who This Book Is For

This book is for the budding web developer searching for a powerful and low-cost solution to building flexible, scalable web sites.

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.

Beginning PHP and MySQL 5: From Novice to Professional, Second Edition offers comprehensive information about two of the most prominent open source technologies on the planet: the PHP scripting language and the MySQL database server.

Essentially three books in one, this second edition covers PHP 5, MySQL 5, and how these two popular open source technologies work together to create powerful websites. The book is packed with practical examples and insight into real-world challenges. It is based on the author’s 7 years of experience working with these technologies. You will repeatedly refer to this book as a valuable instructional tool and reference guide.

Excellent Book
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.

This book is a reference manual at best...
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.

More of an advanced bible than a step-by-step starter
As I say in the title, after buying this book I feel satisfied with having it to refer to should I have a problem. I have a programming background - so I’m able to comprehend PHP and MySQL as a similar principle but with different syntax. However, if you’re a beginner to programming and/or PHP, then I’d probably suggest you’d be better off looking elsewhere.

My verdict - this is a great "bible" of examples and best practices for the novice programmer, but, if you’re just getting started, look for other alternatives :-)

Just a reference book
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.

Terrible Reference
I brought this book a while back when i had no knowledge of php and i found it almost impossible to work with. I then went and brought Larry Ullmans visual quick pro guide (which is brilliant btw), my skills are now fairly advanced at PHP and many other languages. I went back to read this book and although i understand what the author is going half the time, this is no way written for a novice. It nothing more then a bad reference book, in fact its just a terrible version of the PHP manual, it basically lists every function available, whilst giving rubbish examples for most of them, I strong advise you take a look at Larry Ullmans most recent book which is available on amazon here:

http://www.amazon.co.uk/PHP-MySQL-Dynamic-Web-Sites/dp/032152599X/ref=sr_1_1?ie=UTF8&s=books&qid=1214952570&sr=8-1

Before you waste any more of your time let alone you money contemplating whether to buy this poor excuse for a PHP guide.

[Third Edition Review] Broad coverage except in XML manipulation
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.

Not for beginning programmers
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).

Great book on PHP and MySQL
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.

Not for the novice!
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!

This was my first PHP/MySQL book
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.

The Ultimate Bible for Web Programming!
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.

Great amount of depth, not so much context
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.

Definitive text on the subject
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.

Not good, Not Bad.
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.

Probably not your best option
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.

Hit or miss
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.

good book
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

Definitely not for begginers
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.

Far too many typos, syntax errors, and gaps in explinations
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.

Full of value
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.

Too Simplistic
While the title suggests "novice to professional" for PHP and MySQL 5, it barely gets out of the novice. Few good examples about how to do things. MySQL not covered until well into the back part of the book, and then only superficially. It’s thickness (almost 4.5 cm) suggests a lot of value. It’s not.

Great reference for all
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.

Great starter guide
this guide speaks in laymens terms and teached using simple examples. I would recomend this book for grandmothers and professional web admins collections

Excellent Standalone Learning Material!
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.

Excellent Standalone Learning Material!
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.

Excellent Book
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.

Not for novice...
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.

Great Book
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.

Excellent book for those new to PHP and MySQL
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.

Outstanding guide for experienced programmers
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.

I’m a PHP beginner
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.

Fairly well written, but needs work
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.

Very good resource
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.

Not impressed
I’ve read a few excellent PHP and MySQL books a few years back, and bought this to get up to speed with version 5.

I have found a LOT of errors throughout the book including output not matching code snippets, cut and paste errors on whole sections, and not just in the beginner chapters. This makes working out what is going on if you are a beginner very difficult. Even some function names are wrong in the later chapters, so I wouldn’t even use it as a reference, as I just don’t trust what I’m reading. It doesn’t even cover GD.

Where was the technical editor for this book???

Frustrating
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.

excellent coverage of essential ’need to know’
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.

This book covers plenty territory well, and no problem with excess!
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!

This is not a book to learn php, its just a dictionary of functions
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.

A really good PHP introduction book
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.

Proably good if you get past the learning curve
As an experienced HTML’er, CSS’er and with some experience with Cold Fusion, I had hoped to move over to PHP and mySQL with this book, however it assumes that you have a fair amount of programming understanding, whizzing through the basics.

I would have liked to have seen more exercises during the first chapters to explain the fundamentals better.

37 Chapters, 3 Books in one, and a must have desktop reference.
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.