Beginning PHP and MySQL: From Novice to Professional (Expert's Voice in Web Development) [Paperback]

W. Jason Gilmore (Author)

Book Description

Publication Date: September 24, 2010 | ISBN-10: 1430231149 | ISBN-13: 978-1430231141 | Edition: 4

Beginning PHP and MySQL: From Novice to Professional, Fourth Edition is a major update of W. Jason Gilmore's authoritative book on PHP and MySQL. The fourth edition includes complete coverage of PHP 5.3 features, including namespacing, an update of AMP stack installation and configuration, updates to Zend Framework, coverage of MySQL Workbench, and much more.

You'll not only receive extensive introductions to the core features of PHP, MySQL, and related tools, but you'll also learn how to effectively integrate them in order to build robust data-driven applications. Gilmore has seven years of experience working with these technologies, and he has packed this book with practical examples and insight into the real-world challenges faced by developers. Accordingly, you will repeatedly return to this book as both a valuable instructional tool and reference guide.

What you’ll learn

• How to install and configure Apache, PHP 5.3, and MySQL
• PHP and object-oriented programming basics
• New PHP 5.3 features and how to use them
• How to move beyond basic PHP, including using the Zend Framework
• How to use MySQL to securely store your website's data
• How to use MySQL Workbench to manage your database

Who this book is for

Developers who want to harness PHP and MySQL to create powerful web applications

Table of Contents

1. Introducing PHP
2. Configuring Your Environment
3. PHP Basics
4. Functions
5. Arrays
6. Object-Oriented PHP
7. Advanced OOP Features
8. Error and Exception Handling
9. Strings and Regular Expressions
10. Working with the File and Operating System
11. PEAR
12. Date and Time
13. Forms
14. Authenticating Your Users
15. Handling File Uploads
16. Networking
17. PHP and LDAP
18. Session Handlers
19. Templating with Smarty
20. Web Services
21. Secure PHP Programming
22. Integrating jQuery and PHP
23. Building Web Sites for the World
24. MVC and the Zend Framework
25. Introducing MySQL
26. Installing and Configuring MySQL
27. The Many MySQL Clients
28. MySQL Storage Engines and Datatypes
29. Securing MySQL
30. Using PHP with MySQL
31. Introducing PDO
32. Stored Routines
33. MySQL Triggers
34. MySQL Views
35. Practical Database Queries
36. Indexes and Searching
37. Transactions
38. Importing and Exporting Data

Editorial Reviews

About the Author

 

W. Jason Gilmore is a web developer and business consultant with more than 15 years of experience helping companies large and small build amazing software solutions. He has been teaching developers from around the world about web development for over a decade, having written six books, including the bestselling “Beginning PHP and MySQL, Fourth Edition” and “Easy PHP Websites with the Zend Framework, Second Edition”.

Over the years Jason has been published more than 300 times within popular publications such as Developer.com, PHPBuilder.com, JSMag, and Linux Magazine, and instructed hundreds of students in the United States and Europe. He’s recently led the successful development and deployment of a 10,000+ product e-commerce project, and is currently working on a variety of new e-commerce initiatives. Jason is cofounder of the wildly popular CodeMash Conference, the largest multi-day developer event in the Midwest.

 

Product Details

• Paperback: 824 pages
• Publisher: Apress; 4 edition (September 24, 2010)
• Language: English
• ISBN-10: 1430231149
• ISBN-13: 978-1430231141
• Product Dimensions: 7.5 x 1.6 x 9.2 inches
• Shipping Weight: 2.6 pounds (View shipping rates and policies)
• Average Customer Review: 3.4 out of 5 stars  See all reviews (17 customer reviews)
• Amazon Best Sellers Rank: #173,232 in Books (See Top 100 in Books)
  • #40 in Books > Computers & Technology > Databases > MySQL
  • #44 in Books > Computers & Technology > Web Development & Design > Programming > PHP
  • #86 in Books > Computers & Technology > Databases > SQL

More About the Author

W. Jason Gilmore has been teaching developers from around the world about web development for over a decade, having written six books, including the bestselling "Beginning PHP and MySQL, Fourth Edition" and "Easy PHP Websites with the Zend Framework". He has published more than 300 articles within popular publications such as Developer.com, DevShed, JSMag, and Linux Magazine, and instructed hundreds of students in the United States and Europe.

Jason is cofounder of the popular CodeMash Conference, and was a member of the 2008 MySQL Conference speaker selection board.

Most Helpful Customer Reviews

3 of 3 people found the following review helpful

5.0 out of 5 stars Very nicely done... February 24, 2012

By R. J. Province

Format:Paperback|Amazon Verified Purchase

I've been a developer for over 24 years and I've been writing PHP applications for the DHS for over 10 years. I purchased this book as a desk reference and have found it very useful. It's well organized, so I can find what I'm looking for in a snap. I don't have time to read it from cover to cover, but what I have read has been very insightful and well worth the purchase price. I recommend this book over all others. I also purchased the PHP book, you know the one with the funny animals, and it was absolutely the worse book I ever read. It was not helpful at all. It was written by too many authors and left me confused. Yes, wording the same thing in 2 different ways becomes very confusing. I think I'll stick with the Experts from now on. Hope this helps.

3 of 3 people found the following review helpful

5.0 out of 5 stars Perfect for an experience software engineer new to PHP March 7, 2011

By Ali Julia #1 REVIEWER#1 HALL OF FAME

Format:Paperback

I am an experienced software engineer who never done any PHP coding until three weeks ago. I had a good idea of what I wanted to accomplish, but did not know exactly how to do it using PHP. This book was perfect for me.
This book did not cover the basics of software engineering, so when they say "novice" they refer to being a novice in PHP only.

The book is well organized, and I was able to find what I needed to do without reading the book cover to cover.
The sections on installing and configuring PHP and MySQL were very helpful to start with. Examples were clear and useful, and I was able to adapt them to my own needs easily.

I was able to complete my project in several weeks, much of it thanks to this reference.

2 of 2 people found the following review helpful

4.0 out of 5 stars A good book to start PHP November 30, 2011

By mart

Format:Paperback|Amazon Verified Purchase

Minor typing errors and code errors are there, but if you are an experienced code examiner, they pose no hinder for learning the interesting PHP language. PHP is changing rapidly, so I gathered much from this book, even if all the changes made to this language are not presented in this newest book. For the novice, though, a substantial basis to start learning!

1 of 1 people found the following review helpful

1.0 out of 5 stars Not practical December 22, 2012

By janusgj

Format:Kindle Edition|Amazon Verified Purchase

Most of the book is devoted to examples that have very little use for the capabilities that are most often needed. i.e. contact forms, inserting data into mysql from html forms via php. There are few examples of real life situations that can be applied directly.

1 of 1 people found the following review helpful

4.0 out of 5 stars Good Reference Material April 3, 2011

By El Cas

Format:Paperback|Amazon Verified Purchase

I provided a good quick reference guide to all the basic functions of PHP and MySQL. The book mostly focuses on the common and new functions for PHP. Though it mentions the legacy functions the new ones replace it does not provide a lot of detail on the legacy functions. So if you are planning on updating/optimizing your legacy PHP code, this book will definitely help. If you need a reference book for a legacy functions code you are better off using the docs on [...]

1 of 1 people found the following review helpful

5.0 out of 5 stars PHP Web development for all of us March 26, 2011

By Randall Hawkins

Format:Paperback

I needed a book to get me up to speed with modern web application development, database interactions and front-end-to-database shuttling, and this book fit the bill. As a rusty application developer with considerable experience on ~15 year old systems, I was delighted to find a resource that would describe modern PHP, it's object-oriented features, PEAR, Ajax/jQuery/DOM, MySQL, PDO and point me to more detailed references as needed. I downloaded the book from the iBooks store (1551 pages on an iPad) and found that whenever I needed more information, Jason Gilmore pointed the way, and iBooks' search facilities got me out to the appropriate resource with few clicks. I like Mr. Gilmore's balance of informal tone and rigorous specificity and his facility with juggling the needs of both novice and professional (I'm a bit of both). I also obtained the (787 page) book on PDF for my multitouch TabletPC and found both interfaces to have their advantages and disadvantages.
iBooks. Pros: 1) I can read and highlight it while on an elliptical machine--I'm clocking up more calories! My highlights passed automatically to all my iOS devices. 2) Instant-on, bookmarking, search (in the book and through Google/Wiki) are well integrated, even on iPhone.
Cons: 1) Formatting is a bit wonky. I gather that this book was not written with the iBooks interface in mind and though it exploited the form factor well, it could have been better edited for formatting and page-width effects. 2) iPhone (4582 pp.) loads slowly, but responds quickly once loaded.
PDF. Pros: 1) WYSIWYG. It looks like the real book (I guess). 2) Mature PDF form factor design. 3) By putting it in my Dropbox, I'm able to read it from any internet device.
Cons: 1) Going out to pear.php....net was considerably harder from the TabletPC/PDF than from the iPad. 2) The PDF did not allow commenting/highlighting. Rats.
In summary, I thought the book was great. I'm eager to get Mr. Gilmore's next book on Zend, ( [...] ) as I'm zeroing in on that as a likely dev environment, thanks to what I learned in this volume. (Too bad I can't find it on iBooks store yet.)
Randy Hawkins Read more ›

1 of 1 people found the following review helpful

5.0 out of 5 stars A powerful and very valuable tool for web design student December 11, 2010

By Midwest Book Review

Format:Paperback

In web development, two languages have taken a strong place in crafting today's most valuable websites. "Beginning PHP and MySQL: From Novice to Professional" is a complete and comprehensive guide to learning and understanding these two disciplines in web design and how to use them to craft a useful and excellent website. Using these features allow for more complete data bases, interactivity with users, W. Jason Gilmore also explores how to integrate these concepts with the basic web building language of HTML. "Beginning PHP and MySQL" is a powerful and very valuable tool for web design students.

1 of 1 people found the following review helpful

5.0 out of 5 stars Great Book! December 9, 2010

By Sribatsa Das

Format:Paperback

Beginning PHP and MySQL From Novice to Professional stands true to its name. This book is well written. Chapters progressively elaborate concepts with clear, concise, and easy to understand examples. This book aptly makes developers aware of ways to address security with PHP. I would like to thank the author for writing such a marvelous technical book. Two thumbs up!