Book description
The PHP scripting language and MySQL open source database are quite effective independently, but together they make a simply unbeatable team. When working hand-in-hand, they serve as the standard for the rapid development of dynamic, database-driven websites. This combination is so popular, in fact, that it's attracting manyprogramming newbies who come from a web or graphic design background and whose first language is HTML. If you fall into this ever-expanding category, then this book is for you.
Learning PHP and MySQL starts with the very basics of the PHP language, including strings and arrays, pattern matching and a detailed discussion of the variances in different PHP versions. Next, it explains how to work with MySQL, covering information on SQL data access for language and data fundamentals like tables and statements.Finally, after it's sure that you've mastered these separate concepts, the book shows you how to put them together to generate dynamic content. In the process, you'll also learn about error handling, security, HTTP authentication, and more.
If you're a hobbyist who is intimidated by thick, complex computer books, then this guide definitely belongs on your shelf. Learning PHP and MySQL explains everything--from basic concepts to the nuts and bolts of performing specific tasks--in plain English.
Part of O'Reilly's bestselling Learning series, the book is an easy-to-use resource designed specifically for newcomers. It's also a launching pad for future learning, providing you with a solid foundation for more advanced development.
Publisher resources
Table of contents
- Preface
- 1. Dynamic Content and the Web
- 2. Installation
- 3. Exploring PHP
- 4. PHP Decision Making
-
5. Functions
- 5.1. Calling Functions
- 5.2. Defining Functions
- 5.3. Object-Oriented Programming
- 5.4. Chapter 5 Questions
- 6. Arrays
-
7. Database Basics
- 7.1. Database Design
- 7.2. Structured Query Language
- 7.3. Chapter 7 Questions
-
8. Using MySQL
- 8.1. MySQL Database
- 8.2. Managing the Database
- 8.3. Backing Up and Restoring Data
-
8.4. Advanced SQL
- 8.4.1. Indexes
- 8.4.2. Selecting Using the LEFT JOIN ON Clause
-
8.4.3. Using Database Functions
-
8.4.3.1. String functions
- 8.4.3.1.1. Concatenation
- 8.4.3.1.2. Concatenation with a predefined separator
- 8.4.3.1.3. Calculate a string length
- 8.4.3.1.4. Changing strings to upper- or lowercase
- 8.4.3.1.5. Trimming and padding strings
- 8.4.3.1.6. String location and position
- 8.4.3.1.7. Cutting up strings
- 8.4.3.1.8. Search and replace function
- 8.4.3.2. Date and time functions
-
8.4.3.1. String functions
- 8.5. Chapter 8 Questions
-
9. Getting PHP to Talk to MySQL
- 9.1. The Process
- 9.2. Querying the Database with PHP Functions
- 9.3. Using PEAR
- 9.4. Chapter 9 Questions
-
10. Working with Forms
- 10.1. Building a Form
- 10.2. Templates
- 10.3. Chapter 10 Questions
- 11. Practical PHP
- 12. Modifying MySQL Objects and PHP Data
- 13. Cookies, Sessions, and Access Control
- 14. Security
- 15. Validation and Error Handling
- 16. Sample Applications
- 17. Finishing Your Journey
- A. Answers to Chapter Questions
- About the Authors
- Colophon
- Copyright
Product information
- Title: Learning PHP and MySQL
- Author(s):
- Release date: June 2006
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596101107
You might also like
book
PHP and MySQL Web Development: A Beginner’s Guide
Essential Skills—Made Easy! PHP and MySQL Web Development: A Beginner's Guide takes you from building static …
book
Mastering The Faster Web with PHP, MySQL, and JavaScript
Make web applications run faster by using advanced PHP, SQL and JavaScript techniques Key Features Use …
book
Beginning PHP and MySQL: From Novice to Professional
Get started with PHP and MySQL programming: no experience necessary. This fifth edition of a classic …
book
Web Database Applications with PHP and MySQL, 2nd Edition
There are many reasons for serving up dynamic content from a web site: to offer an …