Build your own database driven website using PHP & MySQL Book

	Preface	ix
	Who Should Read This Book	x
	What's In This Book	x
	The Book's Website	xiii
	The Code Archive	xiii
	Updates and Errata	xiii
	The SitePoint Forums	xiv
	The SitePoint Newsletters	xiv
	Your Feedback	xiv
1	Installation	1
	Windows Installation	2
	Installing MySQL	2
	Installing PHP	6
	Linux Installation	12
	Removing Packaged Software	13
	Installing MySQL	14
	Installing PHP	17
	Mac OS X Installation	20
	Installing MySQL	20
	Installing PHP	22
	Mac OS X and Linux	22
	Post-Installation Setup Tasks	22
	If Your Web Host Provides PHP and MySQL	25
	Your First PHP Script	26
	Summary	28
2	Getting Started with MySQL	29
	An Introduction to Databases	29
	Logging On to MySQL	31
	So, What's SQL?	34
	Creating a Database	34
	Creating a Table	35
	Inserting Data into a Table	37
	Viewing Stored Data	38
	Modifying Stored Data	40
	Deleting Stored Data	41
	Summary	41
3	Getting Started with PHP	43
	Introducing PHP	43
	Basic Syntax and Commands	45
	Variables and Operators	47
	Arrays	48
	User Interaction and Forms	50
	Control Structures	56
	Multipurpose Pages	61
	Summary	66
4	Publishing MySQL Data on the Web	67
	A Look Back at First Principles	67
	Connecting to MySQL with PHP	69
	Sending SQL Queries with PHP	71
	Handling SELECT Result Sets	72
	Inserting Data into the Database	75
	A Challenge	80
	Summary	80
	"Homework" Solution	80
5	Relational Database Design	85
	Giving Credit where Credit is Due	85
	Rule of Thumb: Keep Things Separate	87
	Dealing with Multiple Tables	90
	Simple Relationships	94
	Many-to-Many Relationships	96
	Summary	99
6	A Content Management System	101
	The Front Page	102
	Managing Authors	105
	Deleting Authors	107
	Adding Authors	110
	Editing Authors	112
	Magic Quotes	115
	Managing Categories	117
	Managing Jokes	123
	Searching for Jokes	123
	Adding Jokes	129
	Editing and Deleting Jokes	137
	Summary	142
7	Content Formatting and Submission	143
	Out with the Old	144
	Regular Expressions	145
	String Replacement with Regular Expressions	148
	Boldface and Italic Text	149
	Paragraphs	149
	Hyperlinks	150
	Matching Tags	152
	Splitting Text into Pages	155
	Putting it all Together	157
	Automatic Content Submission	162
	Summary	163
8	MySQL Administration	165
	Backing up MySQL Databases	166
	Database Backups using mysqldump	167
	Incremental Backups using Update Logs	168
	MySQL Access Control	170
	Using GRANT	171
	Using REVOKE	174
	Access Control Tips	174
	Locked Out?	177
	Checking and Repairing MySQL Data Files	178
	Summary	181
9	Advanced SQL Queries	183
	Sorting SELECT Query Results	183
	Setting LIMITs	186
	LOCKing TABLES	187
	Column and Table Name Aliases	189
	GROUPing SELECT Results	192
	LEFT JOINs	194
	Limiting Results with HAVING	197
	Summary	198
10	Binary Data	199
	Semi-Dynamic Pages	199
	Handling File Uploads	204
	Assigning Unique File Names	206
	Recording Uploaded Files in the Database	208
	Binary Column Types	209
	Storing Files	210
	Viewing Stored Files	212
	The Complete Script	215
	Large File Considerations	220
	MySQL Packet Size	220
	PHP Script Timeout	220
	Summary	220
11	Cookies and Sessions in PHP	221
	Cookies	221
	PHP Sessions	225
	A Simple Shopping Cart	228
	Summary	234
12	Structured PHP Programming	235
	What is Structured Code?	235
	The Need for Structured Code	236
	Include Files	238
	Types of Includes	242
	Including HTML Content	244
	Locating Include Files	246
	Returning from Includes	249
	Custom Functions and Function Libraries	253
	Variable Scope and Global Access	257
	Optional and Unlimited Arguments	261
	Constants	263
	Structure In Practice: Access Control	265
	Summary	274
A	MySQL Syntax	277
	ALTER TABLE	277
	ANALYZE TABLE	280
	CREATE DATABASE	280
	CREATE INDEX	281
	CREATE TABLE	281
	DELETE	283
	DESCRIBE	284
	DROP DATABASE	285
	DROP INDEX	285
	DROP TABLE	285
	EXPLAIN	285
	GRANT	286
	INSERT	286
	LOAD DATA INFILE	287
	LOCK/UNLOCK TABLES	288
	OPTIMIZE TABLE	289
	RENAME TABLE	289
	REPLACE	290
	REVOKE	290
	SELECT	291
	Joins	295
	Unions	297
	SET	297
	SHOW	298
	UNLOCK TABLES	299
	UPDATE	299
	USE	300
B	MySQL Functions	301
	Control Flow Functions	301
	Mathematical Functions	301
	String Functions	305
	Date and Time Functions	309
	Miscellaneous Functions	315
	Functions for Use with GROUP BY Clauses	318
C	MySQL Column Types	321
	Numerical Types	322
	Character Types	324
	Date/Time Types	327
D	PHP Functions for Working with MySQL	331
	mysql_affected_rows	331
	mysql_client_encoding	331
	mysql_close	332
	mysql_connect	332
	mysql_create_db	333
	mysql_data_seek	333
	mysql_db_name	333
	mysql_db_query	333
	mysql_drop_db	334
	mysql_errno	334
	mysql_error	334
	mysql_escape_string	334
	mysql_fetch_array	335
	mysql_fetch_assoc	335
	mysql_fetch_field	335
	mysql_fetch_lengths	336
	mysql_fetch_object	336
	mysql_fetch_row	337
	mysql_field_flags	337
	mysql_field_len	337
	mysql_field_name	337
	mysql_field_seek	337
	mysql_field_table	338
	mysql_field_type	338
	mysql_free_result	338
	mysql_get_client_info	338
	mysql_get_host_info	339
	mysql_get_proto_info	339
	mysql_get_server_info	339
	mysql_info	339
	mysql_insert_id	339
	mysql_list_dbs	340
	mysql_list_fields	340
	mysql_list_processes	340
	mysql_list_tables	340
	mysql_num_fields	341
	mysql_num_rows	341
	mysql_pconnect	341
	mysql_ping	341
	mysql_query	342
	mysql_real_escape_string	342
	mysql_result	342
	mysql_select_db	343
	mysql_stat	343
	mysql_tablename	343
	mysql_thread_id	343
	mysql_unbuffered_query	343
	Index	345