PHP & MySQL Novice to Ninja, 5th Edition
Curious to see what we’ve got in store for you?
Good, because there’s plenty of meaty technique to get your teeth into along with lots of tips and tricks. Have a look through the table of contents to see what’s covered.
Table of Contents
About the Author
Preface
- Who Should Read This Book
- What's in This Book
- Where to Find Help
- The SitePoint Newsletters
- Your Feedback
- Conventions Used in This Book
1. Installation
- Your Own Web Server
- Windows Installation
- Mac OS X Installation
- Linux Installation
- What to Ask Your Web Host
- Your First PHP Script
- Full Toolbox, Dirty Hands
2. Introducing MySQL
- An Introduction to Databases
- Using phpMyAdmin to Run SQL Queries
- Structured Query Language
- Creating a Database
- Creating a Table
- Inserting Data into a Table
- Viewing Stored Data
- Modifying Stored Data
- Deleting Stored Data
- Let PHP Do the Typing
3. Introducing PHP
- Basic Syntax and Statements
- Variables, Operators, and Comments
- Arrays
- User Interaction and Forms
- Control Structures
- Hiding the Seams
- Bring on the Database
4. Publishing MySQL Data on the Web
- The Big Picture
- Creating a MySQL User Account
- Connecting to MySQL with PHP
- Sending SQL Queries with PHP
- Handling
SELECTResult Sets - Inserting Data into the Database
- Deleting Data from the Database
- Mission Accomplished
5. Relational Database Design
- Giving Credit Where Credit Is Due
- Rule of Thumb: Keep Entities Separate
SELECTwith Multiple Tables- Simple Relationships
- Many-to-many Relationships
- One for Many, and Many for One
6. Structured PHP Programming
- Include Files
- Custom Functions and Function Libraries
- Structure in Practice: Template Helpers
- The Best Way
7. A Content Management System
- The Front Page
- Managing Authors
- Managing Categories
- Managing Jokes
- Summary
8. Content Formatting with Regular
- Expressions
- Regular Expressions
- String Replacement with Regular Expressions
- Real World Content Submission
9. Cookies, Sessions, and Access Control
- Cookies
- PHP Sessions
- Access Control
- The Sky's the Limit
10. MySQL Administration
- Backing Up MySQL Databases
- MySQL Access Control Tips
- Indexes
- Foreign Keys
- Better Safe than Sorry
11. Advanced SQL Queries
- Sorting
SELECTQuery Results - Setting
LIMITs - Database Transactions
- Column and Table Name Aliases
GROUPingSELECTResultsLEFT JOINs- Limiting Results with
HAVING - Further Reading
- Sorting
12. Binary Data
- Semidynamic Pages
- Handling File Uploads
- Recording Uploaded Files in the Database
- Putting It All Together
- Large File Considerations
- The End
A. Manual Installation Instructions
- Windows
- OS X
- Linux
B. MySQL Syntax Reference
- SQL Statements Implemented in MySQL
C. MySQL Functions
- Control Flow Functions
- Mathematical Functions
- String Functions
- Date and Time Functions
- Miscellaneous Functions
- Functions for Use with
GROUP BYClauses
D. MySQL Column Types
- Numerical Types
- Character Types
- Date/Time Types
- Index
More Information
More Details
Author Notes
Just as PHP and MySQL have grown from the young upstarts of the web development world into mature, stable platforms for billion-dollar businesses, this book that I’ve been writing again and again for over a decade has grown up.
It’s time to write PHP like the big kids do…
Kevin Yank
Author
kevinyank.com
What’s New in the Fifth Edition?
- Up-to-date: updated for Windows 7, Mac OS X Lion, and the latest versions of PHP, MySQL, and phpMyAdmin
- Now even easier to get started: using all-in-one installation packages like XAMPP and MAMP
- No command prompt required: phpMyAdmin is used for all database administration tasks, and for sending SQL commands to MySQL
- Best practice database code: this edition uses the robust and portable PHP Data Objects (PDO) API and prepared statements to work with MySQL.
- HTML5 markup: easy-to-read HTML5 markup that all the cool kids are using these days.
Customer Reviews
Live, unmoderated reviews from our customers, typos and all.
Kevin Yank does a great job bringing cutting edge principles to the beginers mind. His examples and explainations are easy to follow.
Joey Katnich, USA 
Awesome design very good explanation of the code and how it works makes it so easy to learn anyone with or without code experience can use it.
James Ledbetter, USA
A easy read, very easy to understand and would be great for everyone; no matter how much you do or don't know about PHP and MySQL.
Jared Coggins, USA