PHP and MySQL Web Development, Fourth Edition
The definitive guide to building database-drive Web applications with PHP and MySQL
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.
PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server.
This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity.
The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.
TABLE OF CONTENTS
Part I: Using PHP
1 PHP Crash Course
2 Storing and Retrieving Data
3 Using Arrays
4 String Manipulation and Regular Expressions
5 Reusing Code and Writing Functions
6 Object-Oriented PHP
7 Error and Exception Handling
Part II: Using MySQL
8 Designing Your Web Database
9 Creating Your Web Database
10 Working with Your MySQL Database
11 Accessing Your MySQL Database from the Web with PHP
12 Advanced MySQL Administration
13 Advanced MySQL Programming
Part III: E-Commerce and Security
14 Running an E-Commerce Site
15 E-commerce Security Issues
16 Web Application Security
17 Implementing Authentication with PHP and MySQL
18 Implementing Secure Transactions with PHP and MySQL
Part IV: Advanced PHP Techniques
19 Interacting with the File System and the Server
20 Using Network and Protocol Functions
21 Managing the Date and Time
22 Generating Images
23 Using Session Control in PHP
24 Other Useful Features
Part V: Building Practical PHP and MySQL Projects
25 Using PHP and MySQL for Large Projects
27 Building User Authentication and Personalization
28 Building a Shopping Cart
29 Building a Web-Based Email Service
30 Building a Mailing List Manager
31 Building Web Forums
32 Generating Personalized PDF Documents
33 Connecting to Web Services with XML and SOAP
34 Building Web 2.0 Applications with Ajax
Part VI: Appendixes
Appendix A: Installing PHP and MySQL
Appendix B: Web Resources
- Amazon Sales Rank: #91197 in Books
- Published on: 2008-10-11
- Original language:
- Number of items: 1
- Dimensions: 8.90" h x
2.20" w x
- Binding: Paperback
- 1008 pages
- CD-ROM included with PDF version of text.
“This book by Welling & Thomson is the only one which I have found to be indispensable.The writing is clear and straightforward but never wastes my time.The book is extremely well laid out.The chapters are the right length and chapter titles quickly take you where you want to go.”
—Wright Sullivan, President,A&E
Engineering, Inc., Greer South Carolina
“There are several good introductory books on PHP, but Welling & Thomson is an excellent handbook for those who wish to build up complex and reliable systems. It’s obvious that the authors have a strong background in the development of professional applications and they teach not only the language itself, but also how to use it with good software engineering practices.”
—Javier Garcia, senior telecom engineer,
Telefonica R&D Labs, Madrid
“This book rocks! I am an experienced programmer, so I didn’t need a lot of help with PHP syntax; after all, it’s very close to C/C++. I don’t know a thing about databases, though, so when I wanted to develop a book review engine (among other projects) I wanted a solid reference to using MySQL with PHP. I have O’Reilly’s mSQL and MySQL book, and it’s probably a better pure-SQL reference, but this book has earned a place on my reference shelf…Highly recommended.”
“The true PHP/MySQL bible, PHP and MySQL Web Development by Luke Welling and Laura Thomson, made me realize that programming and databases are now available to the commoners. Again, I know 1/10000th of what there is to know, and already I’m enthralled.”
From the Back Cover
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications. "PHP and MySQL Web Development" shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server. This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity. The fourth edition of "PHP and MySQL Web Development" has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.
About the Author
Laura Thomson is a senior software engineer at Mozilla Corporation. She was formerly a principal at both OmniTI and Tangled Web Design, and she has worked for RMIT University and the Boston Consulting Group. She holds a Bachelor of Applied Science (Computer Science) degree and a Bachelor of Engineering (Computer Systems Engineering) degree with honors.
Luke Welling is a web architect at OmniTI and regularly speaks on open source and web development topics at conferences such as OSCON, ZendCon, MySQLUC, PHPCon, OSDC, and LinuxTag. Prior to joining OmniTI, he worked for the web analytics company Hitwise.com, at the database vendor MySQL AB, and as an independent consultant at Tangled Web Design. He has taught computer science at RMIT University in Melbourne, Australia, and holds a Bachelor of Applied Science (Computer Science) degree.
Julie C. Meloni has been developing web-based applications since the Web first saw the light of day and remembers the excitement surrounding the first GUI web browser. She has authored numerous books and articles on web-based programming languages and database topics, including the bestselling Sams Teach Yourself PHP, MySQL and Apache All in One.
Adam DeFields is a consultant specializing in web application development, project management, and instructional design. He lives in Grand Rapids, Michigan where he runs Emanation Systems, LLC, a company he founded in 2002. He has been involved with web development projects using several different technologies, but has developed a strong preference toward PHP/MySQL-based projects.
Marc Wandschneider is a freelance software developer, author, and speaker who travels the globe working on interesting projects. In recent years, a lot of his attention has been focused on writing robust and scalable web applications, and in 2005 he wrote a book called Core Web Application Programming with PHP and MySQL. He was was previously the main developer of the SWiK open source community site.
Most helpful customer reviews
30 of 31 people found the following review helpful.
Terrible formatting renders this useless
By Oscar Ramirez
I can't remember the last time I've written a review, but I feel like I must for the Kindle Edition of this book - it is atrocious. The code samples are not wrapped and are absolutely useless. I have attached a screenshot. I'm going to look at Amazon's return policy for Kindle books and get my money back or the pdf version immediately.
8 of 8 people found the following review helpful.
This is an excellent book on PHP!
By L. Morales
This was my textbook for an online "Web Scripting with PHP" college credited class I took. The book is broken up into logical sections, starting with a simple practical application: someone wants you to build a web app for them. The chapters continue building the users knowledge of php by introducing them to basic concepts using the simple customer web app, building on what was done previously. The topics are important and standard, (data types, variables, operators, loops, control structures, conditionals) and move into more advanced topics (file IO, MySQL database development, authentication, OOP development). At this point the user can look back and say, "Now I know how to do some pretty useful stuff". It doesn't stop there, however. The user is moved onto more advanced admin-like topics (building a shopping cart, php and mysql administration topics, PHP and AJAX, web app security, building a web forum, etc). By the time you go through this book, doing all of the projects, you can call yourself a php developer. What the book doesn't cover is any specific framework such as PEAR, or methodology such as AGILE or Design Patterns. I felt, However, that these omissions are a strength of the book rathar than a weakness since what it teaches is the core library, uses, and functionality of PHP/MySQL and didn't get side-tracked or distracted by anything else. I felt this was a great introduction (and well, WELL beyond) to PHP/MySQL web development and made learning this language very easy for me. The book is well laid out and follow a logical progression, the examples all work, the language is realistic, the projects are practical, and overall the book prepares the reader with the necessary knowledge to get hired and learn a specialization, use a design pattern, or work with a team of developers on a great project. I still use the book in my projects and will continue to do so for years to come, I would imagine. BTW, I got an A in the class!
2 of 2 people found the following review helpful.
See all 165 customer reviews...
4 stars because the Kindle version should be better formatted
I haven't gotten through enough of the book yet to be able to comment on its handling of the subject matter, but so far it seems like it will be great in that regard. I wanted to address a few of the negative comments about the Kindle version though. The formatting isn't very good as far as Kindle books on programming go, with some text running right into code snippets. Also, there's no electronic/hyperlinked Table of Contents, which makes it much more difficult to navigate through the book and really needs to be remedied in the next edition. Hopefully the release of the 5th Edition (which won't be released until this summer) will fix both of these issues in the Kindle version. As to other critiques about the source code being unavailable, that's just not true. Anyone who buys the Kindle version (and this is likely true of the print version as well) should flip to the front of the book and look for the "Reader Services" section located right before the Introduction. It comes shortly after the printed Table of Contents and Acknowledgements sections. That section contains all the information anyone should need on how to acquire the source code, which weighs in at around 725MB in size. Granted, this info is a little more difficult to find considering the substandard formatting and the fact that a newly-purchased book automatically opens to a point just past this blurb. Nevertheless, this isn't the only book to offer source code on a physical CD that (obviously) can't be included with an electronic copy of the book, so if you're interested in buying any Kindle books about coding, I'd recommend keeping a lookout for information like this near the front of these types of books.
All-in-all, this looks to be a great book that just needs a little more attention on the electronic copy.