Join Books.org — it's free

PHP and MySQL Web Development by Luke Welling — book cover
SQL, General Web Site Design/Development, Scripting Languages, Web Site Design, Web Programming

PHP and MySQL Web Development

by Luke Welling, Laura Thomson
Available on Bookshop Write a review

Books.org participates in affiliate programs including Bookshop.org and the Amazon Services LLC Associates Program. We may earn a commission from qualifying purchases made through links on this page, at no additional cost to you.

Log in to track your reading progress.

Overview

"PHP and MySQL Web Development shows how 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, managing content, and connecting to Web services using XML." The third edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to include coverage of PHP 5 - including its new object model, better exception handling, and SimpleXML - as well as features introduced in MySQL 5, such as stored procedures.

An intermediate to advanced guide to PHP and MySQL, the free, open-sourced Web development products. Offers coverage of object-oriented Web programming, creating services using SSL and authentication, and other applications. The CD-ROM includes full versions of PHP, MySQL, and Apache for Windows and Linux/Unix systems, several graphics libraries, files containing the code listings in the book, and the entire book in PDF format.

About the Author, Luke Welling

Lead Authors


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.


Contributing Authors


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.

Reviews

There are no reviews yet. Log in to write one.

Editorials

From Barnes & Noble

The Barnes & Noble Review
Thousands of web developers have found all the database help they need in PHP and MySQL Web Development. In their new Third Edition, Luke Welling and Laura Thomson update their classic to reflect new enhancements ranging from PHP5’s new object model to MySQL 5’s long-awaited stored procedures.

As before, you’ll find loads of practical sample code (all of it on the accompanying CD-ROM). The authors begin with a crash course on PHP itself: basic syntax, storing and retrieving data from flat file databases, using arrays; working with strings and regular expressions; functions; code reuse; and finally, object-oriented PHP.

One crucial PHP5 enhancement is exception handling: a unified, extensible, object-oriented solution for handling errors. Welling and Thompson cover PHP5 error handling in detail, from basic concepts and control structures through user-defined exceptions.

Next, you’ll master MySQL from the web developer’s point of view. Welling and Thompson introduce mysqli, PHP5’s new library for connecting with MySQL with either object-oriented or procedural syntax. Along the way, you’ll learn how to use MySQL's privilege system to secure your databases more effectively, and how to address the performance issues that arise in web database applications.

You'll find chapter-length coverage of networking, session control, interactions with filesystems and servers, managing dates and times, generating images, debugging, and more. The book’s highlight: seven start-to-finish projects, ranging from content management to email, generating on-the-fly PDFs to connecting with web services. Follow along with these case studies, and you should be ready to write just about anything. Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2003 and Upgrading & Fixing Networks for Dummies, Second Edition.

Booknews

Shows how to combine the PHP scripting language with the MySQL database to produce interactive web sites. The guide provides examples that demonstrate tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, and managing content. Significant attention is paid to the importance of security. The CD-ROM contains PHP 4, MySQL, and Apache source code and binaries. Annotation c. Book News, Inc., Portland, OR (booknews.com)

From the Publisher

“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.”
–Paul Robichaux

“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.”
–Tim Luoma,TnTLuoma.com

Book Details

Published
October 13, 2013
Publisher
Addison-Wesley
Pages
1008
Format
Paperback
ISBN
9780321833891

More by Luke Welling

Similar books