book

PHP & MySQL®: Your visual blueprint™ for creating dynamic, database-driven Web sites

Name: PHP & MySQL®: Your visual blueprint™ for creating dynamic, database-driven Web sites
Author: Janet Valade
ISBN: 9780470048399

by Janet Valade

September 2006

Intermediate to advanced

319 pages

9h 24m

English

Visual

Read now

Unlock full access

Copyright
Praise For Visual Books ...
Credits
About the Author
Author's Acknowledgments
HOW TO USE THIS BOOK
Who Needs This BookBook OrganizationWhat You Need to Use This BookWindows RequirementsMac RequirementsLinux RequirementsThe Conventions in This BookWhat's on the Web Site
1. Setting Up Your Development Environment
1.1. Introducing Dynamic Web Sites1.1.1. PHP1.1.2. MySQL1.1.3. How PHP and MySQL Work Together1.1.4. Help for PHP and MySQL1.1.5. PHP and MySQL Version1.2. Set Up Your Development Environment1.2.1. Design Your Development Environment1.2.2. Select a Web Hosting Company1.2.3. Register a Domain Name1.2.4. Find Supporting Software1.2.5. Run a Dynamic Web Site on Your Own Computer1.3. Obtain Apache1.3.1. Obtain Apache1.4. Install Apache1.4.1. Install Apache1.5. Obtain MySQL1.5.1. Obtain MySQL1.6. Install MySQL1.6.1. Install MySQL1.7. Configure MySQL1.7.1. Configure MySQL1.8. Install MySQL Administration Programs1.8.1. Install MySQL Administration Programs1.8.1.1. DOWNLOAD AN ADMINISTRATION PROGRAM1.8.1.2. INSTALL THE PROGRAM1.9. Create MySQL Accounts for Use in PHP Scripts1.9.1. Create MySQL Accounts for Use in PHP Scripts1.10. Obtain PHP1.10.1. Obtain PHP1.11. Install PHP1.11.1. Install PHP1.12. Configure Apache to Process PHP Code1.12.1. Configure Apache to Process PHP Code1.13. Configure PHP1.13.1. Configure PHP1.14. Test Your Development Environment1.14.1. Test Your Development Environment
2. Learning PHP Basics
2.1. How PHP Works2.1.1. How the World Wide Web Works2.1.2. Adding PHP Code to a Web Site2.1.3. How the Web Server Processes PHP Files2.2. Add PHP Code to a Web Page File2.2.1. Add PHP Code to a Web Page File2.3. Using PHP Statements2.3.1. Using PHP Statements2.4. Understanding PHP Output Statements2.4.1. Understanding PHP Output Statements2.5. Using PHP Variables2.5.1. Using PHP Variables2.6. Using PHP Constants2.6.1. Using PHP Constants2.7. Work with Numbers2.7.1. Work with Numbers2.8. Work with Character Strings2.8.1. Work with Character Strings2.9. Work with Dates and Times2.9.1. Work with Dates and Times2.10. Modify or Remove Variables2.10.1. Modify or Remove Variables2.11. Using Variable Variables2.11.1. Using Variable Variables2.12. Understanding Error Messages2.12.1. Understanding Error Messages2.13. Add Comments to a Script2.13.1. Add Comments to a Script
3. Using Arrays
3.1. Create an Array3.1.1. Create an Array3.2. Modify or Remove an Array3.2.1. Modify or Remove an Array3.3. Get Information about an Array3.3.1. Get Information about an Array3.4. Sort an Array3.4.1. Sort an Array3.4.1.1. NUMERIC VERSUS STRING KEYS3.4.1.2. SORTING BY VALUES VERSUS SORTING BY KEYS3.5. Walk through an Array with foreach3.5.1. Walk through an Array with foreach3.6. Walk through an Array Manually3.6.1. Walk through an Array Manually3.7. Find Values in an Array3.7.1. Find Values in an Array3.8. Compare Arrays3.8.1. Compare Arrays3.9. Split and Merge Arrays3.9.1. Split and Merge Arrays3.10. Convert an Array into a String and Vice Versa3.10.1. Convert an Array into a String and Vice Versa3.11. Store a Set of Variables in an Array3.11.1. Store a Set of Variables in an Array3.12. Store Array Elements in Separate Variables3.12.1. Store Array Elements in Separate Variables3.13. Create a Multidimensional Array3.13.1. Create a Multidimensional Array3.13.1.1. CREATE ARRAYS3.13.1.2. MODIFY AND REMOVE ARRAYS3.14. Walk through a Multidimensional Array3.14.1. Walk through a Multidimensional Array3.15. Using Built-in PHP Arrays3.15.1. PHP Arrays3.15.2. Using PHP Arrays3.15.3. Form Variables3.15.4. $_SERVER and $_ENV3.15.5. Built-in Arrays in Older PHP Versions
4. Controlling the Flow of the Script
4.1. Change the Order of Statement Execution4.1.1. Conditional Statements4.1.2. Loops4.1.3. Conditions4.1.4. Infinite Loops4.2. Check the Contents of a Variable4.2.1. Check the Contents of a Variable4.3. Set up Conditions with Comparison Operators4.3.1. Set Up Conditions with Comparison Operators4.4. Introducing Regular Expressions4.4.1. Special Characters4.4.2. Building Regular Expressions4.4.3. Using Regular Expressions4.4.4. Types of Regular Expressions4.5. Match Character Strings to Patterns Using Regular Expressions4.5.1. Match Character Strings to Patterns Using Regular Expressions4.6. Join Multiple Comparisons with Logical Operators4.6.1. Join Multiple Comparisons with Logical Operators4.7. Using an if Statement4.7.1. Using an if Statement4.8. Using a switch Statement4.8.1. Using a switch Statement4.9. Using a for Loop4.9.1. Using a for Loop4.9.1.1. CREATE A BASIC LOOP4.9.1.2. USING MULTIPLE COUNTERS4.10. Using a while Loop4.10.1. Using a while Loop4.11. Using a do-while Loop4.11.1. Using a do-while Loop4.12. Avoid an Infinite Loop4.12.1. Avoid an Infinite Loop4.13. Break Out of a Loop4.13.1. Break Out of a Loop4.13.1.1. BREAK VERSUS CONTINUE4.13.1.2. BREAK OUT OF NESTED LOOPS

5. Reusing PHP Code
5.1. Include a Code File5.1.1. Include a Code File5.1.1.1. CREATE AN INCLUDE FILE5.1.1.2. CREATE A SET OF INCLUDE FILES5.1.1.3. CREATE THE SCRIPT5.2. Configure the Path to the include Files5.2.1. Configure the Path to the include Files5.3. Include Files Automatically5.3.1. Include Files Automatically5.4. Store include Files Securely5.4.1. Store include Files Securely5.4.1.1. SET THE INCLUDE DIRECTORY5.4.1.2. USE AN INCLUDE FILE5.5. Define and Use a Function5.5.1. Define and Use a Function5.6. Using Variables in a Function5.6.1. Using Variables in a Function5.7. Pass Values to a Function5.7.1. Pass Values to a Function5.8. Return Values from a Function5.8.1. Return Values from a Function
6. Some Useful PHP Built-In Functions
6.1. Format a Number6.1.1. Format a Number6.2. Round a Number6.2.1. Round a Number6.3. Find the Largest or Smallest Number6.3.1. Find the Largest or Smallest Number6.4. Remove Leading and Trailing Blank Spaces6.4.1. Remove Leading and Trailing Blank Spaces6.5. Change the Case of a String6.5.1. Change the Case of a String6.6. Format a String6.6.1. Format a String6.7. Count the Characters or Substrings in a String6.7.1. Count the Characters or Substrings in a String6.8. Locate a Substring in a String6.8.1. Locate a Substring in a String6.9. Get a Substring6.9.1. Get a Substring6.10. Find and Replace Substrings6.10.1. Find and Replace Substrings6.11. Add a Substring to a String6.11.1. Add a Substring to a String6.12. Using Regular Expressions to Replace Text6.12.1. Using Regular Expressions to Replace Text6.13. Pad or Repeat a String6.13.1. Pad or Repeat a String6.14. Convert a Character to and from an ASCII Value6.14.1. Convert a Character to and from an ASCII Value6.15. Compare Strings6.15.1. Compare Strings6.16. Convert a String into an Array6.16.1. Convert a String into an Array6.17. Send an Email Message6.17.1. Send an Email Message6.18. Send an HTTP Header6.18.1. Send an HTTP Header6.19. Read Configuration Settings6.19.1. Read Configuration Settings6.20. Set a Local PHP Configuration Option6.20.1. Set a Local PHP Configuration Option
7. Using MySQL Databases
7.1. How a MySQL Database Works7.1.1. Communicating with the MySQL Server7.1.2. The Database Structure7.1.3. The SQL Language7.1.4. Sending a Query to the MySQL Server7.1.5. Database Security7.1.6. MySQL Versions7.2. Send a Query with the mysql Client7.2.1. Send a Query with the mysql Client7.3. Send a Query with the MySQL Query Browser7.3.1. Send a Query with the MySQL Query Browser7.4. Create, Select, or Remove a MySQL Database7.4.1. Create, Select, or Remove a MySQL Database7.4.1.1. LIST THE DATABASES7.4.1.2. CREATE AN ERROR7.4.1.3. CREATE A DATABASE7.4.1.4. SELECT A DATABASE7.4.1.5. REMOVE A DATABASE7.5. Define a MySQL Table7.5.1. Table and Column Names7.5.2. Data Types7.5.3. The Primary Key7.5.4. Auto-Increment Columns7.5.5. Negative Numbers7.5.6. Defaults7.5.7. Empty Columns7.5.8. Relationships between Tables7.6. Create and Remove a MySQL Table7.6.1. Create and Remove a MySQL Table7.6.1.1. CREATE A TABLE7.6.1.2. REMOVE A TABLE7.7. Modify the MySQL Table Structure7.7.1. Modify the MySQL Table Structure7.8. Add a Row of Data to a Database7.8.1. Add a Row of Data to a Database7.9. Add Data from a Text File to a Database7.9.1. Add Data from a Text File to a Database7.10. Store Incremental Values in a Column7.10.1. Store Incremental Values in a Column7.11. Retrieve Data from a Database7.11.1. Retrieve Data from a Database7.12. Limit Query Execution to Specific Rows with a WHERE Clause7.12.1. Limit Query Execution to Specific Rows with a WHERE Clause7.13. Retrieve Data from Multiple Tables with UNION7.13.1. Retrieve Data from Multiple Tables with UNION7.14. Retrieve Data from Multiple Tables by Joining Tables7.14.1. Retrieve Data from Multiple Tables by Joining Tables7.15. Update Data in a Database7.15.1. Update Data in a Database7.16. Remove Data from a Database7.16.1. Remove Data from a Database7.17. Query a MySQL Database from a PHP Script7.17.1. Query a MySQL Database from a PHP Script7.18. Display Database Data on a Web Page in a PHP Script7.18.1. Display Database Data on a Web Page in a PHP Script7.19. Handle MySQL Errors7.19.1. Handle MySQL Errors
8. Administering MySQL Databases
8.1. Understanding MySQL Accounts8.1.1. The Account Name and Host8.1.2. Passwords8.1.3. Account Privileges8.1.4. The Account Information Database8.1.5. Default Accounts8.1.6. Managing Databases8.1.7. The Access Process8.2. View Existing Accounts8.2.1. View Existing Accounts8.2.1.1. USING SQL QUERIES8.2.1.2. USING MYSQL ADMINISTRATOR8.3. Create a MySQL Account8.3.1. Create a MySQL Account8.4. Change the Password of a MySQL Account8.4.1. Change the Password of a MySQL Account8.5. Add and Remove Privileges8.5.1. Add and Remove Privileges8.5.1.1. ADD PRIVILEGES8.5.1.2. REMOVE PRIVILEGES8.6. Change the Name of a MySQL Account8.6.1. Change the Name of a MySQL Account8.7. Remove a MySQL Account8.7.1. Remove a MySQL Account8.8. Stop and Start the MySQL Server8.8.1. Stop and Start the MySQL Server8.9. Using MySQL Logs8.9.1. Using MySQL Logs8.10. Back Up Data8.10.1. Back Up Data8.11. Restore Data8.11.1. Restore Data8.12. Upgrade MySQL8.12.1. Skipping Versions8.12.2. Previous Versions8.12.3. Changes to Tables8.12.4. Types of Tables8.12.5. Change Documentation
9. Adding HTML forms to a Web Page
9.1. Display an HTML Form9.1.1. Display an HTML Form9.2. Add a Text Field9.2.1. Add a Text Field9.3. Add a Multiline Text Area9.3.1. Add a Multiline Text Area9.4. Add a Hidden Field9.4.1. Add a Hidden Field9.5. Add a Dynamic Selection List to a Form9.5.1. Add a Dynamic Selection List to a Form9.6. Add a Date Selection List9.6.1. Add a Date Selection List9.7. Add Dynamic Radio Buttons9.7.1. Add Dynamic Radio Buttons9.8. Add Dynamic Check Boxes9.8.1. Add Dynamic Check Boxes9.9. Create One or More Submit Buttons9.9.1. Create One or More Submit Buttons9.10. Choose the POST or GET Method for a Form9.10.1. Choose the POST or GET Method for a Form9.10.1.1. THE POST METHOD9.10.1.2. THE GET METHOD9.11. Create a Form That Uploads a File9.11.1. Create a Form That Uploads a File
10. Processing Data from Forms
10.1. Process Information from a Form10.1.1. The Superglobal Arrays10.1.2. The Long Built-in Arrays10.1.3. Converting the Arrays to Variables10.1.4. Checking Form Information10.1.5. Trimming the Data10.1.6. Handling HTML Tags in Form Fields10.2. Display Data from a Form10.2.1. Display Data from a Form10.3. Display and Process a Form in One Script10.3.1. Display and Process a Form in One Script10.4. Check for Blank Fields10.4.1. Check for Blank Fields10.5. Verify Form Data10.5.1. Verify Form Data10.6. Clean Form Data10.6.1. Clean Form Data10.7. Add Form Data to a Database10.7.1. Building a Query10.7.2. Protecting against SQL Injection10.7.3. SQL Injection10.7.4. Automatic Escaping (Magic Quotes)10.7.5. Escaping Form Data with PHP Functions10.8. Insert Form Data into a Database10.8.1. Insert Form Data into a Database10.9. Update or Remove Database Data10.9.1. Update or Remove Database Data10.10. Process an Uploaded File10.10.1. Process an Uploaded File
11. Managing User Sessions
11.1. Understanding User Sessions11.1.1. Moving from One Web Page to the Next11.1.2. Statelessness11.2. Send a New Web Page to the Browser11.2.1. Send a New Web Page to the Browser11.3. Add Information to a URL11.3.1. Add Information to a URL11.4. Store Information in Cookies11.4.1. Store Information in Cookies11.5. Store Information in a PHP Session11.5.1. Store Information in a PHP Session11.6. Using PHP Sessions without Cookies11.6.1. Using PHP Sessions without Cookies11.6.1.1. WITH TRANS_SID TURNED ON11.6.1.2. WITH TRANS_SID TURNED OFF11.6.1.3. ACCESS THE SESSION VARIABLE
12. Object-Oriented Programming in PHP
12.1. Understanding Object-Oriented Programming12.1.1. Object-Oriented Programming12.1.2. Objects12.1.3. Classes12.1.4. Properties12.1.5. Methods12.1.6. Abstraction12.1.7. Constructor12.1.8. Inheritance12.1.9. Exceptions12.2. Create and Use an Object12.2.1. Create and Use an Object12.3. Set Properties in a Class12.3.1. Set Properties in a Class12.4. Add Methods to a Class12.4.1. Add Methods to a Class12.5. Write a Constructor or a Destructor Method12.5.1. Write a Constructor or a Destructor Method12.6. Using PHP Magic Methods to Get or Set Properties12.6.1. Using PHP Magic Methods to Get or Set Properties12.7. Using Inheritance in a Class12.7.1. Using Inheritance in a Class12.8. Using Exceptions12.8.1. Using Exceptions12.9. Copy and Compare Objects12.9.1. Copy and Compare Objects12.10. Get Information about Objects and Classes12.10.1. Get Information about Objects and Classes12.11. Using Abstract Classes12.11.1. Using Abstract Classes12.12. Using Interfaces12.12.1. Using Interfaces
A. Programming Editors and IDEs for PHP
A.1. Programming EditorsA.2. Integrated Development Environments
B. Troubleshooting Tips
B.1. Understanding Error MessagesB.2. Common Errors

Content preview from PHP & MySQL®: Your visual blueprint™ for creating dynamic, database-driven Web sites

Chapter 7. Using MySQL Databases

How a MySQL Database Works

MySQL is a relational database management system (RDBMS) — a system that organizes data into tables that are related to each other. The MySQL software consists of the MySQL server, several utility programs, and some supporting software. The MySQL server is the database manager. It runs all the time, in the background, waiting for instructions. The database is a set of files that contain the data. You can create new databases, add data to databases, and retrieve data from a database by communicating with the server — sending messages that the server executes.

Communicating with the MySQL Server

You can manage your database, retrieve data from it, or add data to it by sending messages to the ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

Publisher Resources

ISBN: 9780470048399Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design