book

PHP and MySQL® 24-Hour Trainer

Name: PHP and MySQL® 24-Hour Trainer
Author: Andrea Tarr
ISBN: 9781118066881

by Andrea Tarr

November 2011

Beginner

504 pages

11h 30m

English

Wrox

Read now

Unlock full access

Cover
Introduction
Section I: Getting Started with PHP
Lesson 1: Setting Up Your Workspace
Installing XAMPPInstalling Your EditorConfiguring Your Workspace
Lesson 2: Adding PHP to a Web Page
Writing Your First PHP PageIntroducing the Case StudyUsing echo and include
Lesson 3: Learning PHP Syntax
Picking a Formatting StyleLearning PHP SyntaxEntering CommentsUsing Best Practices
Lesson 4: Working with Variables
Introduction to VariablesWorking with TextUnderstanding Different Types of NumbersWorking with NumbersChanging between Text and Numbers
Lesson 5: Debugging Code
Troubleshooting TechniquesUsing Xdebug
Lesson 6: Working with Complex Data
Working with ArraysWorking with Logical VariablesWorking with ConstantsWorking with DatesWorking with Built-in FunctionsWorking with Objects
Section II: Working with PHP Controls, Functions, and Forms

Lesson 7: Making Decisions
If/ElseLogical OperatorsSwitch StatementsAlternative Syntax
Lesson 8: Repeating Program Steps
While LoopsDo/While LoopsFor LoopsForeach LoopsContinue/Break
Lesson 9: Learning about Scope
Learning about Local VariablesLearning about Global Variables
Lesson 10: Reusing Code with Functions
Defining FunctionsPassing ParametersGetting Values from FunctionsUsing FunctionsIncluding Other Files
Lesson 11: Creating Forms
Setting Up FormsProcessing FormsRedirecting with Headers
Section III: Objects and Classes
Lesson 12: Introducing Object-Oriented Programming
Understanding the Reasons for Using OOPIntroducing OOP ConceptsLearning Variations in Different PHP Releases
Lesson 13: Defining Classes
Defining Class Variables (Properties)Defining Class Functions (Methods)
Lesson 14: Using Classes
Instantiating the ClassUsing Objects
Lesson 15: Using Advanced Techniques
Initializing the ClassUnderstanding ScopeUnderstanding InheritanceUnderstanding Static Methods and Properties
Section IV: Preventing Problems
Lesson 16: Handling Errors
Testing for ErrorsUsing Try/Catch
Lesson 17: Writing Secure Code
Understanding Common ThreatsUsing Proper Coding Techniques
Section V: Using a Database
Lesson 18: Introducing Databases
What Is a Database?Gathering Information to Define Your DatabaseDesigning Your TablesSetting Up Relationships between TablesInstituting the Business RulesNormalizing the Tables
Lesson 19: Introducing MySQL
Using phpMyAdminLearning the Syntax
Lesson 20: Creating and Connecting to the Database
Connecting with mysql/mysqliConnecting with PDOCreating the Database
Lesson 21: Creating Tables
Understanding Data TypesUsing AUTO_INCREMENTUnderstanding DefaultsCreating Tables in phpMyAdminUsing .sql Script FilesAdding MySQL Tables to PHP
Lesson 22: Entering Data
Understanding the INSERT CommandExecuting MySQL Commands in PHPProcessing Data Entry Forms in PHP
Lesson 23: Selecting Data
Using the SELECT CommandUsing WHERESelecting Data in PHP
Lesson 24: Using Multiple Tables
Using the JOIN ClauseUsing Subqueries
Lesson 25: Changing Data
Using the UPDATE CommandUpdating Data in PHPUsing Prepared Statements
Lesson 26: Deleting Data
Using the DELETE CommandDeleting Data in PHP
Lesson 27: Preventing Database Security Issues
Understanding Security IssuesUsing Best PracticesFiltering Data
Section VI: Putting It All Together
Lesson 28: Creating User Logins
Understanding Access ControlProtecting PasswordsUsing Cookies and SessionsPutting Logins to Work
Lesson 29: Turn the Case Study into a Content Management System
Designing and Creating the TableCreating the ClassCreating the Maintenance PagesCreating the Display Page
Lesson 30: Creating a Dynamic Menu
Setting up the Menu TableAdding the Menu to the Website
Lesson 31: Next Steps

Content preview from PHP and MySQL® 24-Hour Trainer

Section V

Using a Database

Lesson 18: Introducing Databases
Lesson 19: Introducing MySQL
Lesson 20: Creating and Connecting to the Database
Lesson 21: Creating Tables
Lesson 22: Entering Data
Lesson 23: Selecting Data
Lesson 24: Using Multiple Tables
Lesson 25: Changing Data
Lesson 26: Deleting Data
Lesson 27: Preventing Database Security Issues

Variables in PHP hold information, but only for the length of the program. You can fill in a form to get information, but you need to store it somewhere. You need a place to hold your data that is still there after the program ends. This section introduces you to what databases are and how to design a database. You learn how to create a MySQL database, how to set up the appropriate tables, and how to use the MySQL scripting language within PHP to create, update, query, and delete information.

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

Publisher Resources

ISBN: 9781118066881Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

PHP and MySQL® 24-Hour Trainer

by Andrea Tarr

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.