Contents -- introduction -- CHAPTER 1 Exploring the PHP Environment -- Introducing the "Tip of the Day" Program -- Programming on the Web Server -- Building Basic HTML Pages -- Creating the HTML "Hello" Page -- Basic Tags -- More HTML Tags -- Tables -- Using CSS to Enhance Your Pages -- Creating a Local Style -- Page-Level Styles -- External Style Sheets -- Using Form Elements -- The Text-Based Elements -- Creating the Selection Elements -- Adding Buttons to Your Programs -- Adding PHP to Your Pages -- Ensuring That Your Server Supports PHP -- Adding PHP Commands to an HTML Page -- Examining the Results -- Creating the "Tip of the Day" Program -- Summary -- CHAPTER 2 Using Variables and Input -- Introducing the Story Program -- Using Variables in Your Scripts -- Introducing the "Hi Jacob" program -- Creating a String Variable -- Printing the Value of a Variable -- Using the Semicolon to End a Line -- Using Variables for More Complex Pages -- Building the "Row Your Boat" Page -- Creating Multi-Line Strings -- Working with Numeric Variables -- Making the ThreePlusFive Program -- Assigning Numeric Values -- Using Mathematical Operators -- Creating a Form to Ask a Question -- Building an HTML Page with a Form -- Setting the Action Attribute to a Script File -- Writing a Script to Retrieve the Data -- Sending Data without a Form -- Understanding the get Method -- Using a URL to Embed Form Data -- Working with Multiple Field Queries -- Reading Input from Other Form Elements -- Introducing the borderMaker program -- Building the borderMaker.html Page -- Reading the Form Elements -- Returning to the Story Program -- Designing the Story -- Building the HTML Page -- Checking the Form -- Building the Final Story -- Summary -- CHAPTER 3 Controlling Your Code with Conditions and Functions -- Examining the "Petals Around the Rose" Game.

Creating a Random Number -- Viewing the "Roll 'em" Program -- Printing a Corresponding Image -- Using the if Statement to Control Program Flow -- Introducing the Ace Program -- Creating a Condition -- Exploring Comparison Operators -- Creating an if Statement -- Working with Negative Results -- Demonstrating the Ace or Not Program -- Using the else Clause -- Working with Multiple Values -- Writing the Binary Dice Program -- Using Multiple else if Clauses -- Using the switch Structure to Simplify Programming -- Building the Switch Dice Program -- Using the switch Structure -- Combining a Form and Its Results -- Using Functions to Encapsulate Parts of the Program -- Examining the This Old Man Program -- Creating New Functions -- Using Parameters and Function Values -- Examining the Param.php Program -- Looking at Encapsulation in the Main Code Body -- Returning a Value: The chorus() Function -- Accepting a Parameter in the verse() Function -- Managing Variable Scope -- Looking at the Scope Demo -- Returning to the Petals Game -- Starting HTML -- Main Body Code -- The printGreeting() Function -- The printDice() Function -- The showDie() Function -- The calcNumPetals Function -- The printForm() Function -- The Ending HTML Code -- Summary -- CHAPTER 4 Loops and Arrays: The Poker Dice Game -- Introducing the Poker Dice Program -- Counting with the for Loop -- Initializing a Sentry Variable -- Setting a Condition to Finish the Loop -- Changing the Sentry Variable -- Building the Loop -- Modifying the for Loop -- Counting by Fives -- Counting Backwards -- Using a while Loop -- Repeating Code with a while Loop -- Recognizing Endless Loops -- Building a Well-Behaved Loop -- Working with Basic Arrays -- Generating a Basic Array -- Using a Loop to Examine an Array's Contents -- Using the array() Function to Pre-Load an Array -- Detecting the Size of an Array.

Improving "This Old Man" with Arrays and Loops -- Building the Place Array -- Writing Out the Lyrics -- Keeping Persistent Data -- Counting with Form Fields -- Storing Data in the Text Box -- Using a Hidden Field for Persistence -- Writing the Poker Dice Program -- Setting up the HTML -- Building the Main Code Body -- Making the rollDice() Function -- Creating the evaluate() Function -- Printing Out the Results -- Summary -- CHAPTER 5 Better Arrays and String Handling -- Introducing the Word Search Creator -- Using the foreach loop to Work with an Array -- Introducing the foreach.php Program -- Creating an Associative Array -- Examining the assoc.php Program -- Building an Associative Array -- Building an Associative Array with the array() Function -- Using foreach with Associative Arrays -- Using Built-In Associative Arrays -- Introducing the formReader.php Program -- Reading the _REQUEST Array -- Creating a Multi-Dimensional Array -- Building the HTML for the Basic Multi-Dimensional Array -- Responding to the Distance Query -- Making a Two-Dimensional Associative Array -- Building the HTML for the Associative Array -- Responding to the Query -- Building the Two-Dimensional Associative Array -- Getting Data from the Two-Dimensional Associative Array -- Manipulating String Values -- Demonstrating String Manipulation with the Pig Latin Translator -- Building the Form -- Using the Split Function to Break a String into an Array -- Trimming a String with rtrim() -- Finding a Substring with substr() -- Using strstr() to Search for One String Inside Another -- Using the Concatenation Operator -- Finishing Up the Pig Latin Program -- Translating Between Characters and ASCII Values -- Returning to the Word Search Creator -- Getting the Puzzle Data from the User -- Setting up the Response Page -- Working with the Empty Data Set.

Building the Main Logic for the Program -- Parsing the Word List -- Clearing the Board -- Filling the Board -- Adding a Word -- Making a Puzzle Board -- Adding the Foil Letters -- Printing Out the Puzzle -- Printing Out the Answer Key -- Summary -- CHAPTER 6 Working with Files -- Previewing the Quiz Machine -- Entering the Quiz Machine System -- Editing a Quiz -- Taking a Quiz -- Seeing the Results -- Viewing the Quiz Log -- Saving a File to the File System -- Introducing the saveSonnet.php Program -- Opening a File with fopen() -- Creating a File Handle -- Examining File Access Modifiers -- Writing to a File -- Closing a File -- Loading a File from the Drive System -- Introducing the loadSonnet.php Program -- Using CSS to Beautify the Output -- Using the "r" Access Modifier -- Checking for the End of the File with feof() -- Reading Data from the File with fgets() -- Reading a File into an Array -- Introducing the cartoonifier.php Program -- Loading the File into an Array with file() -- Using str_replace() to Modify File Contents -- Working with Directory Information -- Introducing the imageIndex.php Program -- Creating a Directory Handle with openDir() -- Getting a List of Files with readdir() -- Selecting Particular Files with preg_grep() -- Using Basic Regular Expressions -- Storing the Output -- Working with Formatted Text -- Introducing the mailMerge.php Program -- Determining a Data Format -- Examining the mailMerge.php Code -- Loading the Data with the file() Command -- Splitting a Line into an Array to Scalar Values -- Creating the Quiz Machine Program -- Building the QuizMachine.php Control Page -- Editing a Test -- Writing the Test -- Taking a Quiz -- Grading the Quiz -- Viewing the Log -- Summary -- CHAPTER 7 Using MySQL to Create Databases -- Introducing the Adventure Generator Program -- Using a Database Management System.

Working with MySQL -- Installing MySQL -- Using the MySQL Executable -- Creating a Database -- Creating a Table -- Inserting Values -- Selecting Results -- Writing a Script to Build a Table -- Creating Comments in SQL -- Dropping a Table -- Running a Script with SOURCE -- Working with a Database in SQLyog -- Connecting to a Server -- Creating and Modifying a Table -- Editing Table Data -- Exporting a Table -- Creating More Powerful Queries -- Limiting Columns -- Limiting Rows with the WHERE Clause -- Changing the Data with the UPDATE Statement -- Returning to the Adventure Game -- Designing the Data Structure -- Summary -- CHAPTER 8 Connecting to Databases Within PHP -- Connecting to the Hero Database -- Getting a Connection -- Choosing a Database -- Creating a Query -- Getting the Field Names -- Parsing the Result Set -- Returning to the Adventure Game Program -- Connecting to the Adventure Database -- Displaying One Segment -- Viewing and Selecting Records -- Editing the Record -- Committing Changes to the Database -- Summary -- CHAPTER 9 Data Normalization -- Introducing the Spy Database -- The badSpy Database -- Inconsistent Data Problems -- Problem with the Operation Information -- Problems with Listed Fields -- Designing a Better Data Structure -- Defining Rules for a Good Data Design -- Normalizing Your Data -- Defining Types of Relationships -- Building Your Data Tables -- Setting Up the System -- Creating the agent Table -- Building the operation Table -- Using a Join to Connect Tables -- Creating Useful Joins -- Examining a Join Without a WHERE Clause -- Adding a WHERE Clause to Make a Proper Join -- Adding a Condition to a Joined Query -- Building a Link Table for Many-Many Relationships -- Enhancing the ER Diagram -- Creating the specialty Table -- Interpreting the agent_specialty Table with a Query.

Creating Queries That Use Link Tables.