Beginning PHP, Apache, MySQL Web Development

Overview

PHP, Apache, and MySQL are the three key open source technologies that form the basis for most active Web servers. This book takes you step by step through understanding each -- using it and combining it with the other two on both Linux and Windows servers. This book will guide you through creating your own sites using the open source AMP model. You'll learn to install PHP, Apache, and MySQL. Then you'll create PHP Web pages, including database management and security. Finally, you'll discover how to integrate ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (15) from $1.99   
  • New (2) from $51.74   
  • Used (13) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$51.74
Seller since 2008

Feedback rating:

(167)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
0764557440 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$145.00
Seller since 2014

Feedback rating:

(113)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

PHP, Apache, and MySQL are the three key open source technologies that form the basis for most active Web servers. This book takes you step by step through understanding each -- using it and combining it with the other two on both Linux and Windows servers. This book will guide you through creating your own sites using the open source AMP model. You'll learn to install PHP, Apache, and MySQL. Then you'll create PHP Web pages, including database management and security. Finally, you'll discover how to integrate your work with e-commerce and other technologies. By building different types of Web sites, you will progress from setting up simple database tables to tapping the full potential of PHP, Apache, and MySQL. When you're finished, you will be able to create well-designed, dynamic Web sites using open source tools. This book is for beginners who are new to PHP and who need to learn quickly how to create Web sites using open source tools. Some basic HTML knowledge is helpful but not essential.
Read More Show Less

Product Details

  • ISBN-13: 9780764557446
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 3/1/2004
  • Edition number: 1
  • Pages: 720
  • Product dimensions: 7.40 (w) x 9.22 (h) x 1.53 (d)

Table of Contents

Introduction 1
Part I Getting Started
Chapter 1 Introduction and Installation Configuration 9
Installation Configuration 9
Brief Intro to PHP, Apache, MySQL, and Open Source 10
How the Pieces of the AMP Module Work Together 11
PHP5: The Future of PHP 14
Installation Configuration of Apache 14
Installation Configuration of PHP 17
Installation Configuration of MySQL 20
Where to Go for Help and Other Valuable Resources 28
Summary 29
Part II Movie Review Web Site
Chapter 2 Creating PHP Pages 33
Overview of PHP Structure and Syntax 34
Creating Your First Program 36
Using HTML to Spice Up Your Pages 38
Using Constants and Variables to Spice Up Your Pages 41
Using if/else Arguments 63
Using Includes for Efficient Code 65
Using Functions for Efficient Code 68
A Word About Arrays 73
While You're Here ... 79
Alternate Syntax for PHP 83
Summary 84
Exercises 85
Chapter 3 Using PHP with MySQL 87
Overview of MySQL Structure and Syntax 87
How PHP Fits with MySQL 94
Connecting to the MySQL Server 95
Looking at a Ready-Made Database 96
Querying the Database 101
Helpful Tips and Suggestions 109
Summary 110
Exercises 110
Chapter 4 Using Tables to Display Data 111
Creating a Table 111
Summary 133
Chapter 5 Form Elements: Letting the User Work with Data 135
Your First Form 136
Using Them All 152
Summary 161
Chapter 6 Letting the User Edit the Database 163
Preparing the Battlefield 163
Summary 190
Chapter 7 Validating User Input 191
Users Are Users Are Users ... 191
What Now? 192
Summary 214
Chapter 8 Handling and Avoiding Errors 215
How the Apache Web Server Deals with Errors 215
Summary 233
Exercises 233
Part III Comic Book Fan Site
Chapter 9 Building Databases 237
Getting Started 237
Designing Your Database 241
Creating a Database in MySQL 247
Creating the Comic Character Application 252
Summary 283
Chapter 10 E-mailing with PHP 285
Setting Up PHP to Use E-mail 285
Sending an E-mail 286
Dressing Up Your E-mails with HTML 291
Storing Images 297
Getting Confirmation 299
Summary 315
Chapter 11 User Logins, Profiles, and Personalization 317
The Easiest Way to Protect Your Files 317
Friendlier Logins Using PHP's Session and Cookie Functions 322
Using Database-Driven Information 325
Summary 357
Chapter 12 Building a Content Management System 359
Getting Your Users to Return 359
Getting Started 361
Summary 421
Chapter 13 Mailing Lists 423
First Things First 423
Mailing List Ethics 454
Summary 456
Chapter 14 Online Selling: A Quick Way to E-Commerce 457
Adding E-Commerce to the Comic Book Fan Site 458
E-Commerce, Any Way You Slice It 497
Summary 502
Exercises 502
Chapter 15 Creating a Bulletin Board System 503
History of the Computer Bulletin Board 503
Your Bulletin Board 504
Afterthoughts 568
Summary 568
Exercises 569
Part IV Advanced Users
Chapter 16 Using Log Files to Improve Your Site 573
What Is a Log? 574
Where Are These Logs? 574
Now That I Know What and Where They Are, What Do I Do with Them? 579
What Do the Reports Mean? 584
Summary 586
Chapter 17 Troubleshooting 587
Installation Troubleshooting 587
Parse Errors 588
Empty Variables 589
"Headers Already Sent" Error 590
General Debugging Tips 591
Where to Go for Help 593
Summary 594
Appendix A Answers to Exercises 595
Chapter 2 595
Chapter 3 598
Chapter 8 601
Chapter 14 602
Chapter 15 603
Appendix B PHP Quick Reference 605
PHP Syntax 605
Displaying to Browser 605
Setting a Value to a Variable 605
Passing Variables 606
Through a URL 606
Through Sessions 606
Through a Form 606
if Statements 606
else Statements 607
Nested if Statements 607
Including a File 607
Using Functions 607
Arrays 608
for 608
foreach 609
Appendix C PHP Functions 611
Apache/PHP Functions 611
Array Functions 612
Date/Time/Calendar Functions 616
Class/Object/Function Handling Functions 619
Directory and File Functions 620
Error Handling and Logging Functions 624
HTTP Functions 624
Image Functions 624
Mail Functions 629
Mathematical Functions 630
Miscellaneous Functions 631
MySQL Functions 632
Network Functions 634
Output Buffer Functions 636
PHP Configuration Information 636
Program Execution Functions 638
Spelling Functions 638
Session Functions 639
String Functions 640
URL Functions 645
Variable Functions 645
Appendix D MySQL Data Types 647
Appendix E MySQL Quick Reference 651
Database Manipulation Commands 651
Connecting to the Database 652
Accessing the Database 652
Retrieving Data from the Database 652
Condition Clauses 652
Selecting from Multiple Tables 653
Sorting the Results 653
Limiting the Results 653
Appendix F Comparison of Text Editors 655
Appendix G Choosing a Third-Party Host 657
Hosting Options 657
Supported Languages 658
Supported Databases 658
Server Control and Access 658
Administration GUIs 659
Bandwidth and Site Usage 659
Pricing 660
Making the Choice 660
Appendix H An Introduction to PEAR 661
What Is PEAR? 662
Requirements 662
The Packages 662
PEAR DB 663
Other PEAR Packages 666
HTML 666
Authentication 667
Payment 667
Mail 667
Appendix I AMP Installation 669
Installing with Windows 669
Install Apache 669
Install PHP 670
Install MySQL 671
Installing with Linux 672
Install MySQL 672
Install Apache 673
Install PHP 674
Index 677
Read More Show Less

First Chapter

Beginning PHP, Apache, MySQL Web Development


By Michael K. Glass Yann Le Scouarnec Elizabeth Naramore Gary Mailer Jeremy Stolz Jason Gerner

John Wiley & Sons

ISBN: 0-7645-5744-0


Chapter One

Building Databases

In previous chapters, you created a very nice movie review Web site, but now the hand-holding is over, my friend. It's time for us to push you out of the nest. In this chapter, you will have the opportunity to create your own databases, and your own Web site.

We show you how to put together a comic book appreciation Web site, but you can certainly take the concepts we teach you and branch off to create that online auction or antique car site you have always dreamed about. We think the comic book appreciation Web site is cooler, but whatever. You do your thing.

In this chapter, we are going to cover the basics of creating your own database. Topics we discuss include:

* Planning the design of your database

* Database normalization

* Creating your database

* Creating and modifying tables in your database

* Building Web pages to access your data with PHP

Getting Started

You have a great idea for a site, right? Excellent. Open up your PHP editor and start coding! Believe it or not, many people approach the creation of a Web site in just this way. You may be tempted to yourself. It is not impossible to create a good site in this manner, but you are seriously handicapping your chances for greatness. Before you begin, you need a plan.

We're not going to tell you how to plan out an entire Web site, complete with charts and maps and business models. That's not what this book is all about. We are going to assume that you or somebody in your company has already done that by reading other great books on business models, attending seminars, reading great articles on the Web, and perhaps even hiring a business consultant who will help you with everything but building the site (because that's what we're going to teach you how to do).

So you have a great idea for a Web site and a plan. What do you suppose is the first step in creating a successful Web application using PHP, Apache, and MySQL? We'll give you a clue: Look at the title of this chapter.

We need to build the database this site will be based on. Don't worry-one of the great things about relational database design is that you don't have to create every table your site will use. You can start with a few, and build on it. As long as you follow the basic principles of good database design, your database should be quite scalable (that is, expandable to any size).

Nam et Ipsa Scientia Potestas Est!

That is, knowledge is power. Very profound words, coming from a man who wore a big, ruffled collar. Francis Bacon coined the phrase 400 years ago, and it still holds true today.

Of course, information is the foundation of knowledge. Knowledge consists of having information available to you and knowing what to do with it. Data is the building blocks-the facts and figures-that we piece together to create useful sets of information.

We must be sure to store this data in an easily accessible place and in a way that allows us to relate that data to any other data fairly easily. We also want to be able to modify or remove each piece of data quickly and efficiently, without disturbing other data. With proper database design, all of this is possible.

Sound like a daunting task? Don't worry. You see, we know a secret that has been kept hidden like the magician's code: Efficient database design is easy. No, really, we promise! You see, most of us computer geeks like to seem invaluable and very intelligent, and it sounds quite impressive to most interviewers to see on a resume "Designed a comprehensive Web site utilizing an RDBMS backend." When you are done with this chapter, you will be able to put that on your resume as well!

What Is a Relational Database?

Let's first cover a few basics of database design. The relational database is a concept first conceived by E. F. Codd of IBM, in 1970. It is a collection of data organized in tables that can be used to create, retrieve, delete, and update that data in many different ways. This can be done without having to reorganize the tables themselves, especially if the data is organized efficiently.

Take a look at the first table that follows. You can see that we have a very simple collection of data consisting of superheroes' aliases and real names, and their superhero ID. Nothing too amazing, of course, but notice how we relate it to the league table that follows it. Each superhero user has a League_ID that corresponds to an ID in the league table. Through this link, or relationship, you can see that Average Man is a member of the Dynamic Dudes League because the ID in the league table matches his League_ID in the superhero table.

At first glance, it may seem silly to create a table with one data column and an ID. Why not just put the league name in the superhero table? Imagine that you had a database of 10,000 superheroes, and 250 of them were in the Dynamic Dudes league. Now imagine that the Superhero Consortium decided to do a reorganization and "Dynamic Dudes" was changed to the "Incredible Team." If the league name were in the superhero table, you would have to edit 250 records to change the value. With the leagues in a separate, related table, you have to change the name in only one place.

That is the key to a relational database. And speaking of keys ...

Keys

A key is a column that identifies a row of data. In the superhero table, the first column is a key called "ID," as it is in the league table. In both cases, because they are unique, and in the table of the data they represent, they are called primary keys.

Most of the time, the primary key is a single column, but it is not uncommon to use more than one column to make up a primary key. The important distinction is that for each row, the primary key must be unique. Because of that characteristic, we can use the key to identify a specific row of data.

The primary key must contain the following characteristics:

* They cannot be empty (null).

* They will never change in value. Therefore, a primary key cannot contain information that might change, such as part of a last name (for example, smith807).

* They must be unique. In other words, no two rows can contain the same primary key.

The League_ID column in the superhero table is also a key. It matches the primary key of the league table, but it is in a different, or foreign, table. For this reason, it is called a foreign key. Although not a requirement, many programmers will give the foreign key a name that identifies what table it refers to ("League"), and some identifier that marks it as a key ("_ID"). This, along with the fact that keys are usually numeric, makes it fairly clear which column is the foreign key, if one exists in the table at all.

Keys do not have to be purely numeric. Other common values used as primary keys include Social Security numbers (which contain dashes), e-mail addresses, and ZIP Codes. Any value is valid as a primary key as long as it is guaranteed to be unique for each individual record in the table, and will not change over time.

Keys can enable your tables to be recursive. You might, for example, have a sidekick_ID column in the superhero table that we could link to the ID column in the same table. Sidekicks are heroes, too, you know ...

Relationships

In order to be related, the two tables need a column they can use to tie them together. The superhero and league tables are related to each other by the League_ID column in the superhero table, and the ID field in the league table. There is no explicit link created in the database; rather, you create the relationship by linking them with a SQL statement:

SELECT * FROM superhero s, league l WHERE s.League_ID = l.ID

In plain English, this statement tells the MySQL server to "select all records from the superhero table (call it 's') and the league table (call it 'l'), and link the two tables by the superhero League_ID column and the league ID column."

There are three types of relationships: one-to-one (1:1), one-to-many (1:M), and many-to-many (M:N). Our previous example is a one-to-many relationship. To figure out what type of relationship the tables have, ask yourself how many superheroes you can have in a league. The answer is more than one, or "many." How many leagues can a superhero belong to? The answer is "one." That is a one-to-many relationship. (Of course, in some universes, a superhero might belong to more than one league. But for our example, our superheroes exhibit league loyalty.)

One-to-many is the most common database relationship. Such 1:1 relationships don't happen often, and a many-to-many relationship is actually two one-to-many relationships joined together with a linking table. We explore that further later in the chapter.

Although they are more rare, here's an example of a one-to-one (1:1) relationship just so you know. Say you have a link between a company and its main office address. Only one company can have that exact address. In many applications, however, the main office address is included in the company table, so no relationship is needed. That's one of the great things about relational database design. If it works for your needs, then there is no "wrong" way to do it.

Referential Integrity

The concept of referential integrity may be a little lofty for a beginner book like this, but we think it is important to touch on this briefly. If your application has referential integrity, then when a record in a table refers to a record in another table (as the previous example did), the latter table will contain the corresponding record. If the record is missing, you have lost referential integrity.

In many cases, this is not disastrous. You might have an article written by an author whose name no longer exists in the author table. You still want to keep the article, so losing the referential integrity between authors and articles is okay. However, if you have an order in your database that can't be related to a customer because the customer was deleted, then you might be hard pressed to figure out where to send the product, and who to charge for it!

There are ways to enforce referential integrity in a MySQL database. However, these concepts and procedures are beyond the scope of this book. If you are interested in obtaining more information about referential integrity and foreign keys, visit mysql.com/doc/en/InnoDB_foreign_key_constraints.html.

Normalization

"Database normalization" is one of those big fancy terms that database administrators like to throw around, along with "Boyce-Codd Normal Form," "trivial functional dependency," and "Heisenberg compensator." They aren't really important terms to know to be able to design a good database, but we'll touch on normalization here.

For our purposes, we will simply define normalization as the process of modifying your database table structure so that dependencies make sense, and there is no redundant data. In a moment, we are going to go through this process. The best way to learn is to do!

Designing Your Database

It's time to design your application. This will be a relatively simple application, but it will help you learn important concepts such as normalization and expose you to various SQL commands.

Typically, this is where we would take you through a "Try It Out" section and tell you How It Works. When first designing a database, however, you do not need your computer. All you need is a pad of paper and a pencil. So, go get a pad of paper and a pencil. We'll wait.

Let's draw some tables.

The application you are going to design is a comic book character database. You will store a little bit of information about various characters, such as their alter ego's alias, their real names, the powers they possess, and the location of their lair. (Yes, that's right. I said "lair.")

Creating the First Table

Before we open MySQL and start mucking around with tables, we need to figure out how we are going to store all of the data. For simplicity, let's create one big table with all of the relevant data. You can draw it out on your piece of paper, or if you just can't stay away from your computer, use your favorite spreadsheet program. Copy the information you see in the table that follows.

We'll call that table "zero," because we're not even at the first step yet, and that data is just ugly (from a relational database standpoint).

The first thing you should notice is that there are multiple power columns. What would you do if you had to add a character with more than three powers? You would have to create a new column, and that's not good. Instead, let's combine all the powers into one column, and then separate each power into its own separate row. The other columns are duplicated in these additional rows (so, Clean Freak would have three rows instead of one, each row including a different power in the power column, but the name, address, and so on would remain identical among the three listings). This concept is called atomicity. Each value (cell) is atomic, or has only one item of data.

Let's also create a unique primary key for each character. Yes, you could use the character's name, but remember that a primary key should never be something that could change, and it must be unique. To handle this requirement we'll create an ID column.

Because in this pass we have multiple rows with the same character and the multiple rows are a result of the existence of multiple powers, we'll combine the ID column with the power column to create the primary key. When more than one column makes up the primary key, it is called a composite primary key. We'll mark the primary key columns with an asterisk (*) to highlight them for you.

Your table should look like the one that follows. We'll call this table "one" because it's our first pass at normalizing. (Yes, you are in the middle of a normalization process. We told you it wasn't difficult.)

Looking better, but there is still repeated data in there. In fact, the power column is what is causing the duplicate data. Let's separate out the power column and use a foreign key to relate it to the original table. We will also further normalize the power table so that we get rid of duplicate data. This is pass number "two." See the three tables that follow.

As you can see, we have much less repeated data than we did before. The powers have been separated out, and a link table has been created to link each power to each appropriate character.

It may seem a bit nitpicky, but you still have some duplicate data that you can take care of in the character table. It is quite possible for more than one character to be in the same lair, as is the case with Clean Freak and Soap Stud. Let's create a lair table, and link it to the character table with keys.

Continues...


Excerpted from Beginning PHP, Apache, MySQL Web Development by Michael K. Glass Yann Le Scouarnec Elizabeth Naramore Gary Mailer Jeremy Stolz Jason Gerner Excerpted by permission.
All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.
Excerpts are provided by Dial-A-Book Inc. solely for the personal use of visitors to this web site.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)