PHP and MySQL: Create - Modify - Reuse (Paperback)

~ Timothy Boronczyk (Author), Martin E. Psinas (Contributor)
Key Phrases: community forum, shell scripts, personal calendar, Shopping Cart, Ajax File Manager, Search Engine (more...)

Editorial Reviews

Product Description

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.

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.

See all Editorial Reviews

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.3 out of 5 stars  See all reviews (3 customer reviews)
• Amazon.com Sales Rank: #463,436 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #12 in	Books > Computers & Internet > Programming > Software Design, Testing & Engineering > Software Reuse
  #95 in	Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL

Customer Reviews

Most Helpful Customer Reviews

6 of 7 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 (TOP 10 REVIEWER)    (REAL NAME)

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.

2 of 3 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)

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

2.0 out of 5 stars Read this, October 17, 2009

By	Ahmad Fuad "ardmad" (Malaysia) - See all my reviews (REAL NAME)

Don't buy this book if you're not a pro or should
I say; somebody who's using PHP like comfortably
driving a car.(know his/ her way around). This is another
book written by somebody who have drive far, far and
reach his destination but 70% forgot (or didn't know?)
how to lead (teach) people to where he's at.