PHP and MySQL: Create - Modify - Reuse [Paperback]

Timothy Boronczyk (Author), Martin E. Psinas (Contributor)

Book Description

ISBN-10: 0470192429 | ISBN-13: 978-0470192429 | Publication Date: May 5, 2008

Learn everything about the dynamic power of PHP and MySQL in real-world applications with the practical information and step-by-step instructions in PHP and MySQL: Create - Modify – Reuse. The authors, experts in tune with common web development tasks, will guide you through several projects that are complete, tested, and ready to be implemented, so that you can understand by doing. Understand all aspects of design, such as portability, design flow, and integration, and become proficient at solving problems that developers face in everyday circumstances.

Editorial Reviews

From the Back Cover

PHP and MySQL: Create - Modify - Reuse

Written by an experienced PHP expert who is in sync with the most common uses of PHP and MySQL, this tutorial presents basic code for twelve functional projects that exemplify the basic concepts and syntax of PHP and MySQL that are used to develop web-based applications.

As you walk through the detailed steps of each project, you'll learn the many aspects of design as well as how to properly secure your applications for real-world implementation. While some projects build upon previous projects, others stand alone. Whether you are looking for guidance in how to program different applications, seeking inspiration to write projects of your own, or planning to modify and reapply the featured projects, you can look forward to expanding your skill set with these projects.

What you will learn from this book

• How to create a basic user registration system

• How to expand on a user registration system to create a community forum with user privileges and threaded posts

• How to create a mailing list with control address and digest mailings

• How to build a custom search engine for your own site

• How to write a personal calendar utility to keep yourself organized

• How to create an AJAX-influenced file upload and directory viewer

• How to create a file-based image gallery

• How to write a categorized shopping cart

• How to log site traffic and collect information about site visitors

• How to build a news or blog system with comments and RSS feed

• How to write and run management scripts

• How to deal with security issues

Who this book is for
This book is for anyone who is familiar with the fundamentals of programming in PHP and MySQL and is interested in programming a variety of applications.

Create - Modify - Reuse guides are packed with unique, ready-to-use projects that are perfect for the busy programmer. The projects are created with minimal set-up and can be modified, enhanced, and reused in real-world situations.

About the Author

Timothy Boronczyk is a native of Syracuse, NY, where he works as a freelance developer, programmer and technical editor. He has been involved in web design since 1998 and over the years has written several articles and tutorials on PHP programming. Timothy holds a degree in software application programming and recently started his first business venture, Salt City Tech ( www.saltcitytech.com ). In his spare time, he enjoys photography, hanging out with friends, and sleeping with his feet hanging off the end of his bed. He ’ s easily distracted by shiny objects.

Martin E. Psinas is a recognized security expert and valued member of the open - source community. He has been contracted as a technical editor, code auditor, and is a published author with Pearson Education as well as the #1 PHP magazine, PHP|Architect . In his free time, he maintains his personal web site and is a volunteer administrator/contributor at codewalkers.com — a resource for PHP & MySQL developers. Martin interacts frequently with the leaders of the PHP project as well as PHP User ’ s Groups.

Product Details

• Paperback: 341 pages
• Publisher: Wrox (May 5, 2008)
• Language: English
• ISBN-10: 0470192429
• ISBN-13: 978-0470192429
• Product Dimensions: 9.2 x 7.4 x 0.9 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #1,071,640 in Books (See Top 100 in Books)
  • #20 in Books > Computers & Technology > Programming > Software Design, Testing & Engineering > Software Reuse
  • #83 in Books > Computers & Technology > Databases > Database Design

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

3 of 3 people found the following review helpful:

4.0 out of 5 stars Like the book but it's half-baked., November 10, 2009

By 

J. Guthrie (Memphis, TN USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: PHP and MySQL: Create - Modify - Reuse (Paperback)

Definitely not for beginners, the book has complete PHP coding examples for common web programming projects. The author seems to know his stuff and many of his solutions are thorough and elegant. That said, however, the code being offered has errors, with the code in the book being more correct than the downloadable version. Beware that if you use the code in this book as a basis for your projects, you will hit a brick wall or two until you work through the errors. After using the code in Chapter 1, I felt the book was "rushed" to publication because of the errors I found. Since many of the errors were in the downloadable version of the code, you would think somebody would correct this, so that new owners of the book would stop downloading buggy code.

The WROX website has user forums for their books. Check the one for this book and you will get a taste of what's to come. ([...])

I like the book and used the login scripts in Chapter 1 as a basis for the admin login for my website. I would think that a 2nd edition would be an opportunity to correct the errors and add addtional PHP code examples.

7 of 9 people found the following review helpful:

4.0 out of 5 stars devoted to web applications, June 20, 2008

By 

W Boudville (Terra, Sol 3) - See all my reviews
(VINE VOICE)    (TOP 1000 REVIEWER)    (HALL OF FAME REVIEWER)    (REAL NAME)   

This review is from: PHP and MySQL: Create - Modify - Reuse (Paperback)

Someone new to both PHP and MySQL might ask, why this combination? Why should I learn both in tandem? Because, as the authors explain, in many practical situations this duo is used by programmers; especially for web applications. This is really an implicit subtitle for the book. What you learn here is that PHP and MySQL live for the web.

The chapters are characterised by application examples all devoted to the web. As in writing web pages for a community forum. The pages are coded in PHP, and the data created by users is then stored in a MySQL backend database. This overall method is followed in other examples. The PHP code samples seem easy to understand. The language has been found, or more accurately, it has been revved into its current version, such that much code is indeed easy to write and understand, and not just the text's examples.

To be sure, the book is not about the theory of relational databases. Only the simplest of tables is used within MySQL. Yes, there is discussion about the tables used in each example. But it is really limited, to anyone who knows the subject. For a comprehensive usage of MySQL, you do need to look elsewhere.

One chapter, on shopping cart code, complements a recent book on e-commerce, Wiley Pathways E-Business (Wiley Pathways). It spoke to non-programmers about the travails of starting an e-commerce website. A requirement was for a shopping cart. One way is to hire a programmer. Expensive. But if you are that programmer, consider looking at the extended example offered in the current text. It is extensive enough that it could be used as a code base for your task.

3 of 4 people found the following review helpful:

4.0 out of 5 stars I finally got into PHP and what start, August 5, 2008

By 

E. Leon (The Bronx, NY USA) - See all my reviews
(REAL NAME)   

This review is from: PHP and MySQL: Create - Modify - Reuse (Paperback)

The samples are so clean clear that makes PHP easy to follow, if you are new to PHP this a must have after reading any beginners PHP book