Php Programming with MySQL

by Gosselin, Don

• ISBN13: 9780619216870
• ISBN10: 0619216875
• Edition: 1st
• Format: Paperback
• Copyright: 2005-12-26
• Publisher: Course Technology

Summary

PHP Programming with MySQL, by Don Gosselin is the first true academic textbook in the market to combine PHP with MySQL. This book covers one of the fastest growing technology combinations for developing interactive Web sites. With growth attributed to its open-source nature and usability amongst non-programmers, this text is accessible to users with little programming or database experience and suits personal Web development projects, as well as small to medium business Web development needs.

Table of Contents

Preface	xix
Introduction to Web Development	1	(50)
The World Wide Web	2	(14)
HTML Documents	3	(1)
Basic HTML Syntax	4	(3)
Creating an HTML Document	7	(3)
Web Communication Protocols	10	(2)
Publishing Your Web Site	12	(4)
Working with Well-Formed Web Pages	16	(16)
XHTML Document Type Definitions (DTDs)	17	(3)
Writing Well-Formed Documents	20	(2)
Cascading Style Sheets	22	(7)
The Content-Type <meta> Element	29	(1)
Validating Web Pages	30	(2)
Understanding Web Development	32	(7)
Client/Server Architecture	32	(2)
JavaScript and Client-Side Scripting	34	(2)
Server-Side Scripting and PHP	36	(2)
Should You Use Client-Side or Server-Side Scripting?	38	(1)
Chapter Summary	39	(1)
Review Questions	40	(4)
Hands-On Projects	44	(5)
Case Projects	49	(2)
Getting Started with PHP	51	(56)
Building a Web Development Environment	52	(4)
Understanding Binary and Source Code Installations	53	(1)
Getting Help	54	(2)
Installing and Configuring a Web Server	56	(12)
Installing and Running Apache on UNIX and Linux	57	(1)
Installing and Running Apache on Windows	58	(2)
Installing and Running Internet Information Services on Windows	60	(1)
Testing Your Web Server	61	(3)
Configuring Apache	64	(2)
Configuring Internet Information Services	66	(2)
Installing PHP	68	(5)
Installing PHP on UNIX and Linux Systems Running Apache	69	(1)
Installing PHP on Windows Running Apache or IIS	70	(1)
Configuring Apache for PHP	71	(1)
Configuring PHP	72	(1)
Installing and Running MySQL	73	(6)
Installing and Running MySQL on UNIX and Linux	73	(3)
Installing MySQL on Windows	76	(2)
Testing the MySQL Server	78	(1)
Creating Basic PHP Scripts	79	(20)
Creating PHP Code Blocks	80	(8)
Understanding Functions	88	(1)
Displaying Script Results	89	(5)
Creating Multiple Code Declaration Blocks	94	(3)
Case Sensitivity in PHP	97	(1)
Adding Comments to a PHP Script	98	(1)
Chapter Summary	99	(1)
Review Questions	100	(2)
Hands-On Projects	102	(3)
Case Projects	105	(2)
Working with Data Types and Operators	107	(50)
Using Variables and Constants	108	(7)
Naming Variables	108	(1)
Declaring and Initializing Variables	108	(1)
Displaying Variables	109	(2)
Modifying Variables	111	(2)
Defining Constants	113	(2)
Working with Data Types	115	(10)
Numeric Data Types	117	(1)
Boolean Values	118	(1)
Arrays	119	(6)
Building Expressions	125	(19)
Arithmetic Operators	126	(8)
Assignment Operators	134	(3)
Comparison and Conditional Operators	137	(4)
Logical Operators	141	(3)
Special Operators	144	(1)
Type Casting	144	(3)
Understanding Operator Precedence	147	(1)
Chapter Summary	148	(1)
Review Questions	149	(3)
Hands-On Projects	152	(3)
Case Projects	155	(2)
Functions and Control Structures	157	(50)
Working with Functions	158	(4)
Defining Functions	158	(1)
Calling Functions	159	(1)
Returning Values	160	(2)
Understanding Variable Scope	162	(8)
The global Keyword	163	(1)
Using Autoglobals	164	(6)
Making Decisions	170	(13)
if Statements	171	(3)
if...else Statements	174	(2)
Nested if and if...else Statements	176	(3)
switch Statements	179	(4)
Repeating Code	183	(12)
while Statements	183	(5)
do...while Statements	188	(2)
for Statements	190	(3)
foreach Statements	193	(2)
Chapter Summary	195	(1)
Review Questions	196	(3)
Hands-On Projects	199	(5)
Case Projects	204	(3)
Manipulating Strings	207	(50)
Constructing Text Strings	208	(10)
Working with String Operators	212	(1)
Adding Escape Characters and Sequences	213	(3)
Simple and Complex String Syntax	216	(2)
Parsing Strings	218	(14)
Counting Characters and Words in a String	218	(2)
Finding and Extracting Characters and Substrings	220	(4)
Replacing Characters and Substrings	224	(2)
Dividing Strings into Smaller Pieces	226	(4)
Converting Between Strings and Arrays	230	(2)
Comparing Strings	232	(6)
String Comparison Functions	234	(3)
Determining the Similarity of Two Strings	237	(1)
Determining if Words Are Pronounced Similarly	237	(1)
Handling Form Submissions	238	(5)
Using a Single Script to Display and Process a Form	239	(1)
Validating Submitted Data	240	(3)
Chapter Summary	243	(1)
Review Questions	244	(2)
Hands-On Projects	246	(9)
Case Projects	255	(2)
Working with Files and Directories	257	(54)
Opening and Closing File Streams	258	(6)
Opening a File Stream	258	(5)
Closing a File Stream	263	(1)
Writing Data to Files	264	(14)
Writing an Entire File	265	(5)
Handling Magic Quotes	270	(3)
Writing Data Incrementally	273	(2)
Locking Files	275	(3)
Reading Data from Files	278	(8)
Reading an Entire File	278	(5)
Reading Data Incrementally	283	(3)
Managing Files and Directories	286	(12)
Working with Directories	286	(4)
Obtaining File and Directory Information	290	(4)
Copying and Moving Files	294	(2)
Renaming Files and Directories	296	(1)
Removing Files and Directories	296	(2)
Chapter Summary	298	(1)
Review Questions	299	(3)
Hands-On Projects	302	(6)
Case Projects	308	(3)
Manipulating Arrays	311	(52)
Manipulating Elements	312	(13)
Adding and Removing Elements from the Beginning of an Array	315	(2)
Adding and Removing Elements from the End of an Array	317	(2)
Adding and Removing Elements Within an Array	319	(3)
Removing Duplicate Elements	322	(3)
Declaring and Initializing Associative Arrays	325	(4)
Iterating Through an Array	329	(3)
Finding and Extracting Elements and Values	332	(5)
Determining if a Value Exists	332	(3)
Determining if a Key Exists	335	(1)
Returning a Portion of an Array	336	(1)
Manipulating Arrays	337	(9)
Sorting Arrays	337	(5)
Combining Arrays	342	(2)
Comparing Arrays	344	(2)
Understanding Multidimensional Arrays	346	(8)
Creating Two-Dimensional Indexed Arrays	346	(4)
Creating Two-Dimensional Associative Arrays	350	(1)
Creating Multidimensional Arrays with a Single Statement	351	(1)
Working with Additional Dimensions	352	(2)
Chapter Summary	354	(1)
Review Questions	355	(2)
Hands-On Projects	357	(4)
Case Projects	361	(2)
Working with Databases and MySQL	363	(54)
Introduction to Databases	364	(10)
Understanding Relational Databases	365	(4)
Working with Database Management Systems	369	(4)
Querying Databases with Structured Query Language	373	(1)
Getting Started with MySQL	374	(9)
Logging in to MySQL	375	(3)
Working with the MySQL Monitor	378	(2)
Understanding MySQL Identifiers	380	(1)
Getting Help with MySQL Commands	381	(2)
Working with MySQL Databases	383	(4)
Selecting a Database	383	(2)
Creating Databases	385	(1)
Deleting Databases	386	(1)
Managing User Accounts	387	(7)
Securing the Initial MySQL Accounts	387	(2)
Creating Users	389	(4)
Deleting Users	393	(1)
Defining Tables	394	(4)
Specifying Field Data Types	394	(1)
Creating Tables	395	(2)
Deleting Tables	397	(1)
Working with Records	398	(10)
Adding Records	398	(2)
Retrieving Records	400	(1)
Sorting Query Results	401	(3)
Filtering Query Results	404	(2)
Updating Records	406	(1)
Deleting Records	407	(1)
Chapter Summary	408	(1)
Review Questions	409	(3)
Hands-On Projects	412	(3)
Case Projects	415	(2)
Manipulating MySQL Databases with PHP	417	(60)
Connecting to MySQL with PHP	418	(6)
Enabling MySQL Support in PHP	418	(2)
Opening and Closing a MySQL Connection	420	(3)
Selecting a Database	423	(1)
Handling MySQL Errors	424	(10)
Suppressing Errors with the Error Control Operator	427	(1)
Terminating Script Execution	428	(2)
Reporting MySQL Errors	430	(4)
Executing SQL Statements	434	(9)
Working with Query Results	436	(5)
Accessing Query Result Information	441	(1)
Closing Query Results	442	(1)
Working with Databases and Tables	443	(8)
Creating and Deleting Databases	443	(4)
Creating and Deleting Tables	447	(4)
Manipulating Records	451	(14)
Adding, Deleting, and Updating Records	451	(11)
Returning Information on Affected Records	462	(3)
Chapter Summary	465	(1)
Review Questions	466	(3)
Hands-On Projects	469	(5)
Case Projects	474	(3)
Managing State Information	477	(48)
Understanding State Information	478	(6)
Using Hidden Form Fields to Save State Information	484	(6)
Using Query Strings to Save State Information	490	(2)
Using Cookies to Save State Information	492	(14)
Creating Cookies	492	(1)
The name and value Arguments	493	(4)
The expires Argument	497	(2)
The path Argument	499	(1)
The domain Argument	500	(1)
The secure Argument	500	(1)
Reading Cookies	500	(6)
Deleting Cookies	506	(1)
Using Sessions to Save State Information	506	(8)
Starting a Session	507	(1)
Working with Session Variables	508	(4)
Deleting a Session	512	(2)
Chapter Summary	514	(1)
Review Questions	515	(2)
Hands-On Projects	517	(6)
Case Projects	523	(2)
Developing Object-Oriented PHP	525	(54)
Introduction to Object-Oriented Programming	526	(5)
Understanding Encapsulation	527	(1)
Object-Oriented Programming and Classes	528	(3)
Using Objects in PHP Scripts	531	(16)
Working with Database Connections as Objects	533	(8)
Defining Custom PHP Classes	541	(5)
Collecting Garbage	546	(1)
Declaring Data Members	547	(5)
What Is Information Hiding?	547	(1)
Using Access Specifiers	548	(2)
Serializing Objects	550	(2)
Working with Member Functions	552	(14)
Initializing with Constructor Functions	553	(2)
Cleaning Up with Destructor Functions	555	(1)
Writing Accessor Functions	556	(4)
Serializing Functions	560	(6)
Chapter Summary	566	(1)
Review Questions	567	(2)
Hands-On Projects	569	(8)
Case Projects	577	(2)
Error Handling and Debugging	579	(48)
Understanding Logic and Debugging	580	(4)
Syntax Errors	582	(1)
Run-Time Errors	582	(1)
Logic Errors	583	(1)
Handling and Reporting Errors	584	(16)
Printing Errors to the Web Browser	590	(1)
Setting the Error Reporting Level	591	(1)
Logging Errors to a File	592	(2)
Implementing Custom Error Handling	594	(6)
Using Basic Debugging Techniques	600	(15)
Examining Your Code	600	(4)
Tracing Errors with echo ( ) Statements	604	(6)
Using Comments to Locate Bugs	610	(1)
Combining Debugging Techniques	611	(2)
Analyzing Logic	613	(2)
Chapter Summary	615	(1)
Review Questions	616	(3)
Hands-On Projects	619	(5)
Case Projects	624	(3)
APPENDIX A Working with Regular Expressions	627	(12)
Understanding Regular Expressions	627	(2)
Writing Regular Expression Patterns	629	(1)
Matching Any Character	630	(1)
Matching Characters at the Beginning or End of a String	631	(1)
Matching Special Characters	631	(1)
Specifying Quantity	632	(1)
Specifying Subexpressions	633	(1)
Defining Character Classes	634	(3)
Matching Multiple Pattern Choices	637	(2)
APPENDIX B Formatting Strings	639	(8)
Using the printf() and sprintf() Functions	639	(1)
Specifying Types	640	(1)
Determining Decimal Number Precision	641	(1)
Specifying Padding	642	(2)
Formatting Numbers	644	(1)
Formatting Alignment	645	(2)
APPENDIX C Processing XML	647	(16)
The Basics of XML	647	(1)
The XML Declaration	648	(1)
Parsing XML Documents	649	(1)
Writing Well-Formed Documents	650	(4)
All XML Documents Must Have a Root Element	650	(1)
XML Is Case Sensitive	651	(1)
All XML Elements Must Have Closing Tags	651	(1)
XML Elements Must Be Properly Nested	652	(1)
Attribute Values Must Appear Within Quotation Marks	653	(1)
Empty Elements Must Be Closed	654	(1)
Generating XML with PHP	654	(4)
Parsing XML with SimpleXML Functions	658	(5)
APPENDIX D Secure Coding with PHP	663	(1)
Understanding PHP Security Issues	663	(1)
Disabling the register_globals Directive	664	(1)
Validating Submitted Form Data	664	(1)
Using Sessions to Validate User Identities	665	(1)
Storing Code in External Files	665	(1)
Accessing Databases Through a Proxy User	666	(1)
Handling Magic Quotes	666	(1)
Reporting Errors	667