book

PHP and MySQL® For Dummies®, 4th Edition

Name: PHP and MySQL® For Dummies®, 4th Edition
Author: Janet Valade
ISBN: 9780470527580

by Janet Valade

December 2009

Beginner to intermediate

456 pages

9h 43m

English

For Dummies

Read now

Unlock full access

Copyright
About the Author
Author's Acknowledgments
Publisher's Acknowledgments
Introduction
About This BookConventions Used in This BookWhat You're Not To ReadFoolish AssumptionsHow This Book Is OrganizedPart I: Developing a Web Database Application Using PHP and MySQLPart II: MySQL DatabasePart III: PHPPart IV: ApplicationsPart V: The Part of TensPart VI: AppendixesIcons Used in This BookWhere to Go from Here
I. Developing a Web Database Application Using PHP and MySQL
1. Introduction to PHP and MySQL
1.1. What Is a Web Database Application?1.1.1. The database: Storing data1.1.2. The application: Moving data in and out of the database1.2. MySQL, My Database1.2.1. Advantages of MySQL1.2.2. How MySQL works1.2.3. Communicating with the MySQL server1.3. PHP, a Data Mover1.3.1. Advantages of PHP1.3.2. How PHP works1.4. MySQL and PHP, the Perfect Pair1.4.1. Advantages of the relationship1.4.2. How MySQL and PHP work together1.5. Keeping Up with PHP and MySQL Changes1.5.1. PHP versions1.5.2. MySQL versions
2. Setting Up Your Work Environment
2.1. Anatomy of a Web Site2.2. Building a Web Site2.3. Deciding Where to Publish Your Web Site2.3.1. Using a Web hosting company2.3.2. Using a company Web site2.3.3. Setting up your own server2.4. Deciding Where to Develop Your Web Site2.4.1. On your own computer2.4.2. On another computer2.5. Setting Up Your Web Site2.5.1. With a Web hosting company2.5.2. On a company Web site2.5.3. Information you need2.6. Setting Up Your Development Environment2.6.1. Your own computer2.6.1.1. Installing the Web development software2.6.1.2. Writing the files2.6.1.2.1. Programming editors2.6.1.2.2. Integrated development environment (IDE)2.6.1.3. Uploading your files to your Web site2.6.2. Web hosting company2.6.2.1. Keeping it private2.6.2.2. Keeping out the search engines2.6.3. A company computer2.7. Testing, Testing, 1,2,32.7.1. Understanding PHP/MySQL functions2.7.2. Testing PHP2.7.2.1. On your local computer2.7.2.2. On a Web hosting company2.7.3. Testing your local PHP configuration file2.7.4. Testing MySQL
3. Developing a Web Database Application
3.1. Planning Your Web Database Application3.1.1. Identifying what you want from the application3.1.2. Taking the user into consideration3.1.3. Making the site easy to use3.1.4. Leaving room for expansion3.1.5. Writing it down3.2. Presenting the Two Running Examples in This Book3.2.1. Stuff for Sale3.2.2. Members Only3.3. Designing the Database3.3.1. Choosing the data3.3.2. Organizing the data3.3.2.1. Organizing data in tables3.3.2.2. Creating relationships between tables3.4. Designing the Sample Databases3.4.1. Pet Catalog design process3.4.2. Members Only design process3.5. Types of Data3.5.1. Character data3.5.2. Numerical data3.5.3. Date and time data3.5.4. Enumeration data3.5.5. MySQL data type names3.5.6. Writing it down3.6. Taking a Look at the Sample Database Designs3.6.1. Stuff for Sale database tables3.6.2. Members Only database tables3.7. Developing the Application3.7.1. Building the database3.7.2. Writing the programs
II. MySQL Database

4. Building the Database
4.1. Communicating with MySQL4.1.1. Building SQL queries4.1.2. Sending SQL queries4.1.2.1. Using phpMyAdmin4.1.2.1.1. Sending your own SQL queries using the phpMyAdmin query sender4.1.2.1.2. Using the phpMyAdmin interface4.1.2.2. Using PHP scripts4.2. Building a Database4.2.1. Creating a new database4.2.1.1. On your local computer4.2.1.2. On your Web hosting account4.2.2. Viewing the databases4.2.3. Deleting a database4.2.4. Adding tables to a database4.2.4.1. Using the phpMyAdmin interface4.2.4.2. Writing an SQL query4.2.5. Changing the database structure4.2.5.1. Using phpMyAdmin4.2.5.2. Writing your own SQL query4.3. Moving Data Into and Out of the Database4.3.1. Adding information4.3.1.1. Adding one row at a time with an SQL query4.3.1.2. Adding one row at a time with phpMyAdmin4.3.1.3. Adding a bunch of data4.3.2. Viewing information4.3.3. Retrieving information4.3.3.1. Retrieving specific information4.3.3.2. Retrieving data in a specific order4.3.3.3. Retrieving data from a specific source4.3.4. Combining information from tables4.3.4.1. UNION4.3.4.2. Join4.3.5. Updating information4.3.6. Removing information
5. Protecting Your Data
5.1. Controlling Access to Your Data5.1.1. Understanding account names and hostnames5.1.2. Finding out about passwords5.1.3. Taking a look at account privileges5.2. Setting Up MySQL Accounts5.2.1. Adding accounts5.2.2. Allowing access to a database5.2.3. Changing privileges5.2.4. Adding and changing passwords5.2.5. Removing accounts5.3. Backing Up Your Data5.3.1. Exporting your data with phpMyAdmin5.3.2. Viewing the Export file5.4. Restoring Your Data
III. PHP
6. General PHP
6.1. Adding a PHP Section to an HTML Page6.2. Writing PHP Statements6.3. Using PHP Variables6.3.1. Naming a variable6.3.2. Creating and assigning values to variables6.3.3. Dealing with notices6.4. Using PHP Constants6.5. Working with Numbers6.6. Working with Character Strings6.6.1. Single-quoted strings versus double-quoted strings6.6.2. Joining strings6.7. Working with Dates and Times6.7.1. Setting local time6.7.2. Formatting a date6.7.3. Storing a timestamp in a variable6.7.4. Using dates with MySQL6.8. Comparing Values6.8.1. Making simple comparisons6.8.2. Matching character strings to patterns6.9. Joining Comparisons with and/or/xor6.10. Adding Comments to Your Program
7. PHP Building Blocks for Programs
7.1. Useful Simple Statements7.1.1. Using echo statements7.1.2. Using assignment statements7.1.3. Using increment statements7.1.4. Using exit7.1.5. Using function calls7.2. Using PHP Arrays7.2.1. Creating arrays7.2.2. Viewing arrays7.2.3. Removing values from arrays7.2.4. Sorting arrays7.2.5. Getting values from arrays7.2.6. Walking through an array7.2.6.1. Manually walking through an array7.2.6.2. Using foreach to walk through an array7.2.7. Multidimensional arrays7.3. Useful Conditional Statements7.3.1. Using if statements7.3.2. Using switch statements7.4. Using Loops7.4.1. Using for loops7.4.2. Using while loops7.4.3. Using do..while loops7.4.4. Infinite loops7.4.5. Breaking out of a loop7.5. Using Functions7.5.1. Using variables in functions7.5.2. Passing values between a function and the main program7.5.2.1. Passing values to a function7.5.2.2. Getting a value from a function7.5.3. Using built-in functions
8. Data In, Data Out
8.1. PHP and MySQL Functions8.2. Making a Connection8.2.1. Connecting to the MySQL server8.2.2. Selecting the right database8.2.3. Sending SQL queries8.3. Getting Information from a Database8.3.1. Sending a SELECT query8.3.2. Getting and using the data8.3.2.1. Getting one row of data8.3.2.2. Using a loop to get all the rows of data8.3.3. Using functions to get data8.4. Getting Information from the User8.4.1. Using HTML forms8.4.2. Making forms dynamic8.4.2.1. Displaying dynamic information in form fields8.4.2.2. Building selection lists8.4.2.3. Building lists of radio buttons8.4.2.4. Building lists of check boxes8.4.3. Using the information from the form8.4.4. Checking the information8.4.4.1. Checking for empty fields8.4.4.2. Checking the format of the information8.4.5. Giving users a choice with multiple submit buttons8.5. Putting Information into a Database8.5.1. Preparing the data8.5.1.1. Putting the data into variables8.5.1.2. Using the correct format8.5.1.3. Cleaning the data8.5.1.4. Escaping the data8.5.2. Adding new information8.5.3. Updating existing information8.6. Getting Information in Files8.6.1. Using a form to upload the file8.6.2. Processing the uploaded file8.6.3. Putting it all together
9. Moving Information from One Web Page to the Next
9.1. Moving Your User from One Page to Another9.2. Moving Information from Page to Page9.2.1. Adding information to the URL9.2.2. Storing information via cookies9.2.3. Passing information with HTML forms9.3. Using PHP Sessions9.3.1. Understanding how PHP sessions work9.3.2. Opening sessions9.3.3. Using PHP session variables9.3.4. Sessions without cookies9.3.4.1. Sessions with trans-sid turned on9.3.4.2. Sessions without trans-sid turned on9.3.5. Making sessions private9.3.6. Closing PHP sessions
IV. Applications
10. Putting It All Together
10.1. Organizing the Application10.1.1. Organizing at the application level10.1.2. Organizing at the program level10.1.2.1. Using include statements10.1.2.2. Storing include files10.1.2.3. Protecting include files10.1.2.4. Using functions10.2. Keeping It Private10.2.1. Ensure the security of the computer10.2.2. Don't let the Web server display filenames10.2.3. Hide things10.2.4. Don't trust information from users10.2.5. Use a secure Web server10.3. Completing Your Documentation
11. Building an Online Catalog
11.1. Designing the Application11.1.1. Showing pets to the customers11.1.2. Adding pets to the catalog11.2. Building the Database11.2.1. Building the Pet table11.2.2. Building the PetType table11.2.3. Building the Color table11.2.4. Adding data to the database11.3. Designing the Look and Feel11.3.1. Showing pets to the customers11.3.1.1. Storefront page11.3.1.2. Pet type page11.3.1.3. Pets page11.3.2. Adding pets to the catalog11.3.2.1. Get pet type page11.3.2.2. Get pet information page11.3.2.3. Feedback page11.3.2.4. Get missing information page11.4. Writing the Programs11.4.1. Showing pets to the customers11.4.1.1. Showing the storefront11.4.1.2. Showing the pet types11.4.1.3. Showing the pets11.4.2. Adding pets to the catalog11.4.2.1. Writing ChoosePetCat11.4.2.2. Writing ChoosePetName11.4.2.3. Writing AddPet
12. Building a Members Only Web Site
12.1. Designing the Application12.2. Building the Database12.2.1. Building the Member table12.2.2. Building the Login table12.2.3. Adding data to the database12.3. Designing the Look and Feel12.3.1. Storefront page12.3.2. Login page12.3.3. New Member Welcome page12.3.4. Members Only section12.4. Writing the Programs12.4.1. Writing PetShopFront12.4.2. Writing Login12.4.3. Writing New_member12.4.4. Writing the Members Only section12.5. Planning for Growth
V. The Part of Tens
13. Ten Things You Might Want to Do Using PHP Functions
13.1. Communicate with MySQL13.2. Send E-Mail13.3. Use PHP Sessions13.4. Stop Your Program13.5. Handle Arrays13.6. Check for Variables13.7. Format Values13.8. Compare Strings to Patterns13.9. Find Out about Strings13.10. Change the Case of Strings
14. Ten PHP Gotchas
14.1. Missing Semicolons14.2. Not Enough Equal Signs14.3. Misspelled Variable Names14.4. Missing Dollar Signs14.5. Troubling Quotes14.6. Invisible Output14.7. Numbered Arrays14.8. Including PHP Statements14.9. Missing Mates14.10. Confusing Parentheses and Brackets
VI. Appendixes
A. Installing PHP, MySQL, and Apache from XAMPP
A.1. Installing XAMPP on WindowsA.2. Installing XAMPP on MacA.3. Using XAMPP
B. Configuring PHP
B.1. Changing Settings in php.iniB.1.1. In the general php.ini fileB.1.2. In a php.ini file on your Web siteB.2. Changing Settings with an .htaccess FileB.3. Changing Settings with PHP Statements

Content preview from PHP and MySQL® For Dummies®, 4th Edition

Publisher's Acknowledgments

We're proud of this book; please send us your comments at http://dummies.custhelp.com. For other comments, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.

Some of the people who helped bring this book to market include the following:

Acquisitions and Editorial

Project Editor: Rebecca Senninger (Previous Edition: Pat O'Brien)

Acquisitions Editor: Kyle Looper

Copy Editor: Virginia Sanders

Technical Editor: John Gosney

Editorial Manager: Leah Cameron

Editorial Assistant: Amanda Foxworth

Sr. Editorial Assistant: Cherie Case

Cartoons: Rich Tennant (www.the5thwave.com)

Composition Services

Project Coordinator: Kristie Rees

Layout and Graphics: Melissa K. Jester, Christine Williams

Proofreader: Toni Settle

Indexer: BIM Indexing & Proofreading

Publishing and Editorial for Technology Dummies

Richard Swadley, Vice President and Executive Group Publisher

Andy Cummings, Vice President and Publisher

Mary Bednarek, Executive Acquisitions Director

Mary C. Corder, Editorial Director

Publishing for Consumer Dummies

Diane Graves Steele, Vice President and Publisher

Composition Services

Debbie Stailey, Director of Composition Services

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 7: Real World Application Development

Publisher Resources

ISBN: 9780470527580Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

PHP and MySQL® For Dummies®, 4th Edition

by Janet Valade

Publisher's Acknowledgments

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.