Product Overview

Curious To Know What's Inside Your Copy Of "Build Your Own Database Driven Website Using PHP & MySQL?"

- Here's a look at the table of contents:

Table of Contents

Introduction

  • Who Should Read This Book
  • What's In This Book
  • The Book's Web Site
  • The Code Archive
  • Updates and Errata
  • The SitePoint Forums
  • The SitePoint Tech Times
  • Your Feedback

1 ) Installation

  • Welcome to the Show
  • Windows Installation
  • Installing MySQL
  • Installing PHP
  • Linux Installation
  • Installing MySQL
  • Installing PHP
  • Mac OS X Installation
  • Installing MySQL
  • Installing PHP
  • Mac OS X and Unix
  • Post-Installation Setup Tasks
  • If Your Web Host Provides PHP and MySQL
  • Your First PHP Script
  • Summary

2 )Getting Started with MySQL

  • An Introduction to Databases
  • 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

3 ) Getting Started with PHP

  • Introducing PHP
  • Basic Syntax and Commands
  • Variables and Operators
  • Arrays
  • User Interaction and Forms
  • Control Structures
  • Multipurpose Pages
  • Summary

4 )Publishing MySQL Data on the Web

  • A Look Back at First Principles
  • Connecting to MySQL with PHP
  • Sending SQL Queries with PHP
  • Handling SELECT Result Sets
  • Inserting Data into the Database
  • A Challenge
  • Summary
  • "Homework" Solution

5 ) Relational Database Design

  • Giving Credit where Credit is Due
  • Rule of Thumb: Keep Things Separate
  • Dealing with Multiple Tables
  • Simple Data Relationships
  • Many-to-Many Relationships
  • Summary

6 ) A Content Management System

  • The Front Page
  • Managing Authors
  • Deleting Authors
  • Adding Authors
  • Editing Authors
  • Magic Quotes
  • Managing Categories
  • Managing Jokes
  • Searching for Jokes
  • Adding Jokes
  • Editing and Deleting Jokes
  • Summary

7 ) Content Formatting and Submission

  • Out with the Old
  • Regular Expressions
  • String Replacement with Regular Expressions
  • Boldface and Italic Text
  • Paragraphs
  • Hyperlinks
  • Matching Tags
  • Splitting Text into Pages
  • Putting it all Together
  • Automatic Content Submission
  • Summary

8 ) MySQL Administration

  • Backing up MySQL Databases
  • Standard Backups Aren't Enough
  • Database Backups using mysqldump
  • Incremental Backups using Update Logs
  • MySQL Access Control
  • Using GRANT
  • Using REVOKE
  • Access Control Tips
  • Locked Out?
  • Checking and Repairing MySQL Data Files
  • Summary

9 ) Advanced SQL

  • Sorting SELECT Query Results
  • Setting LIMITs
  • LOCKing TABLES
  • Column and Table Name Aliases
  • GROUPing SELECT Results
  • LEFT JOINs
  • Limiting Results with HAVING
  • Summary

10 ) Advanced PHP

  • Sorting SELECT Query Results
  • Setting LIMITs
  • LOCKing TABLES
  • Column and Table Name Aliases
  • GROUPing SELECT Results
  • LEFT JOINs
  • Limiting Results with HAVING
  • Summary
  • Email in PHP
  • Summary

11 ) Storing Binary Data in MySQL

  • Binary Column Types
  • Storing Files
  • Viewing Stored Files
  • The Complete Script
  • Advanced Considerations
  • MySQL Packet Size
  • PHP Script Timeout
  • Summary

12 ) Cookies and Sessions in PHP

  • Cookies
  • 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 Joins
  • SET
  • SHOW
  • UPDATE
  • USE

Appendix B: MySQL Functions

  • Control Flow 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_name
  • mysql_field_len
  • 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

Now that you realize this book can advance you … how can you possibly go wrong investing $34.95 on something that can dramatically change the course of your career?

 Back to Main Page >Click Here to Order Now 


Print

Fun, practical and easy-to-understand books for Web Professionals

SitePoint Books

  • advocate best practice techniques
  • lead you through practical examples
  • provide working code for your web site
  • make learning easy and fun

100% Money Back Guarantee