Build Your Own DatabaseDriven Website Using PHP amp;amp; MySQL [Electronic resources]

Sitemap

Table of Contents

BackCover

Build Your Own Database Driven Website Using PHP & MySQL

Introduction

What''s In This Book

The Book''s Web Site

The SitePoint Forums

The SitePoint Tech Times

Your Feedback

Chapter 1: Installation

Windows Installation

Linux Installation

Mac OS X Installation

Post-Installation Setup Tasks

If Your Web Host Provides PHP and MySQL

Your First PHP Script

Summary

Chapter 2: Getting Started with MySQL

Logging On to MySQL

So what''s SQL?

Creating a Database

Creating a Table

Inserting Data into a Table

Viewing Stored Data

Modifying Stored Data

Deleting Stored Data

Summary

Chapter 3: Getting Started with PHP

Basic Syntax and Commands

Variables and Operators

Arrays

User Interaction and Forms

Control Structures

Multipurpose Pages

Summary

Chapter 4: Publishing MySQL Data on the Web

Connecting to MySQL with PHP

Sending SQL Queries with PHP

Handling SELECT Result Sets

Inserting Data into the Database

A Challenge

Summary

" Homework " Solution

Chapter 5: Relational Database Design

Rule of Thumb: Keep Things Separate

Dealing with Multiple Tables

Simple Data Relationships

Many-to-Many Relationships

Summary

Chapter 6: A Content Management System

The Front Page

Managing Authors

Deleting Authors

Adding Authors

Editing Authors

Managing Categories

Managing Jokes

Summary

Chapter 7: Content Formatting and Submission

Out with the Old

Regular Expressions

String Replacement with Regular Expressions

Splitting Text into Pages

Putting it all Together

Automatic Content Submission

Summary

Chapter 8: MySQL Administration

Backing up MySQL Databases

MySQL Access Control

Checking and Repairing MySQL Data Files

Summary

Chapter 9: Advanced SQL

Setting LIMITs

LOCKing TABLES

Column and Table Name Aliases

GROUPing SELECT Results

LEFT JOINs

Limiting Results with HAVING

Summary

Chapter 10: Advanced PHP

Server-Side Includes with PHP

Semi-Dynamic Pages

Chapter 11: Storing Binary Data in MySQL

Binary Column Types

Storing Files

Viewing Stored Files

The Complete Script

Advanced Considerations

Summary

Chapter 12: Cookies and Sessions in PHP

PHP Sessions

A Simple Shopping Cart

Summary

Appendix A: MySQL Syntax

ALTER TABLE

ANALYZE TABLE

CREATE DATABASE

CREATE INDEX

CREATE TABLE

DELETE

DESCRIBE

DROP DATABASE

DROP INDEX

DROP TABLE

EXPLAIN

GRANT

INSERT

LOAD DATA INFILE

LOCK/UNLOCK TABLES

OPTIMIZE TABLE

RENAME TABLE

REPLACE

REVOKE

SELECT

SET

SHOW

UPDATE

USE

Appendix B: MySQL Functions

Mathematical Functions

String Functions

Date and Time Functions

Miscellaneous Functions

Functions for Use with GROUP BY Clauses

Appendix C: MySQL Column Types

Numerical Types

Character Types

Date/Time Types

Appendix D: PHP Functions for Working with MySQL

mysql_affected_rows

mysql_close

mysql_connect

mysql_create_db

mysql_data_seek

mysql_db_name

mysql_db_query

mysql_drop_db

mysql_errno

mysql_error

mysql_escape_string

mysql_fetch_array

mysql_fetch_assoc

mysql_fetch_field

mysql_fetch_lengths

mysql_fetch_object

mysql_fetch_row

mysql_field_flags

mysql_field_len

mysql_field_name

mysql_field_seek

mysql_field_table

mysql_field_type

mysql_free_result

mysql_get_client_info

mysql_get_host_info

mysql_get_proto_info

mysql_get_server_info

mysql_insert_id

mysql_list_dbs

mysql_list_fields

mysql_list_tables

mysql_num_fields

mysql_num_rows

mysql_pconnect

mysql_query

mysql_result

mysql_select_db

mysql_tablename

mysql_unbuffered_query

Index

Index_A

Index_B-C

Index_D

Index_E

Index_F

Index_G-H

Index_I

Index_J-L

Index_M

Index_N-O

Index_P

Index_Q-R

Index_S

Index_T

Index_U

Index_V-Z

List of Figures

List of Tables

List of Sidebars