PHP and MySQL 24 Hour Trainer 1st Edition by Andrea Tarr ISBN 111806688X 9781118066881

PHP and MySQL 24 Hour Trainer 1st Edition by Andrea Tarr – Ebook PDF Instant Download/Delivery: 111806688X, 9781118066881
Full download PHP and MySQL 24 Hour Trainer 1st Edition after payment

Product details:

ISBN 10: 111806688X 
ISBN 13: 9781118066881
Author: Andrea Tarr

Assuming no previous experience with PHP or MySQL, this book-and-video package is ideal reading for anyone who wants to go beyond HTML/CSS in order to provide clients with the most dynamic web sites possible. The approachable tone breaks down the basics of programming and PHP and MySQL in individual lessons starting with the installation of the programs necessary to run PHP. You begin with a static web site and then watch and learn as PHP functionality is added as you work through the lessons.

When working with databases, the MySQL database is introduced with demonstrations that show how to interact with it. The accompanying videos enhance your learning experience, as each lesson in the book is portrayed in the video exercises.

Lessons include:
* Getting started with PHP
* Setting up your workspace
* Adding PHP to a web page
* Learning PHP syntax 
* Working with variables
* Debugging code 
* Working with complex data
* Making decisions
* Repeating program steps
* Learning about scope
* Reusing code with functions
* Creating forms
* Introducing object-oriented programming
* Defining classes
* Using classes
* Using advanced techniques
* Handling errors
* Writing secure code
* Introducing databases
* Introducing MySQL
* Creating and connecting to the
* Creating tables
* Entering data
* Selecting data
* Using multiple tables
* Changing data
* Deleting data
* Preventing database security issues
* Creating user logins
* Turn the case study into a content management system

PHP and MySQL 24 Hour Trainer 1st Table of contents:

Section I: Getting Started with PHP
Lesson 1: Setting up your Workspace
Installing XAMPP
Installing XAMPP on a Windows PC
Installing XAMPP on Mac OS X
Troubleshooting Your XAMPP Installation
Configuring XAMPP
Installing Your Editor
Configuring Your Workspace
Preparing a Place to Put Your Files
Using Eclipse for the First Time
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 2: Adding PHP to a web Page
Writing Your First PHP Page
Introducing the Case Study
Using echo and include
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 3: Learning PHP Syntax
Picking a Formatting Style
Learning PHP Syntax
Entering Comments
Using Best Practices
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 4: Working with Variables
Introduction to Variables
Working with Text
Working with the Concatenation Operator
Working with String Functions
Understanding Different Types of Numbers
Working with Numbers
Changing between Text and Numbers
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 5: Debugging Code
Troubleshooting Techniques
Display Errors while Developing
Common Issues
Seeing What’s What
Using Xdebug
Configuring Xdebug
Using Xdebug
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 6: Working with Complex Data
Working with Arrays
Working with Logical Variables
Working with Constants
Working with Dates
Time Zone Functions
Date/Time Functions
Working with Built-in Functions
$_GET
$_POST
Cookies
filter_var()
Working with Objects
Try It
Lesson Requirements
Hints
Step-by-Step
Section II: Working with PHP Controls, Functions, and Forms
Lesson 7: Making Decisions
If/Else
Basic If Statements
Comparison Operators for If/Else Statements
If/Else with Ternary Operator
Logical Operators
Switch Statements
Alternative Syntax
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 8: Repeating Program Steps
While Loops
Do/While Loops
For Loops
Foreach Loops
Continue/Break
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 9: Learning About Scope
Learning about Local Variables
Learning about Global Variables
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 10: Reusing Code with Functions
Defining Functions
Passing Parameters
Getting Values from Functions
Using Functions
Including Other Files
Try It
Lesson Requirements
Step-by-Step
Lesson 11: Creating Forms
Setting Up Forms
Processing Forms
Redirecting with Headers
Try It
Lesson Requirements
Hints
Step-by-Step
Section III: Objects and Classes
Lesson 12: Introducing Object-Oriented Programming
Understanding the Reasons for Using OOP
Introducing OOP Concepts
Objects and Classes
Extending Classes
Learning Variations in Different PHP Releases
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 13: Defining Classes
Defining Class Variables (Properties)
Defining Class Functions (Methods)
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 14: Using Classes
Instantiating the Class
Using Objects
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 15: Using Advanced Techniques
Initializing the Class
Understanding Scope
Properties
Methods
Classes
Understanding Inheritance
Understanding Static Methods and Properties
Try It
Lesson Requirements
Hints
Step-by-Step
Section IV: Preventing Problems
Lesson 16: Handling Errors
Testing for Errors
Using Try/Catch
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 17: Writing Secure Code
Understanding Common Threats
Using Proper Coding Techniques
Try It
Lesson Requirements
Hints
Step-by-Step
Section V: Using a Database
Lesson 18: Introducing Databases
What Is a Database?
Gathering Information to Define Your Database
Designing Your Tables
Setting up Relationships between Tables
Instituting the Business Rules
Normalizing the Tables
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 19: Introducing MySQL
Using PHPMYADMIN
Creating Databases
Defining Tables and Columns
Entering Data
Backing Up and Restoring
Learning the Syntax
Literal Values
Identifiers
Comments
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 20: Creating and Connecting to the Database
Connecting with mysql/mysqli
Connecting with PDO
Creating the Database
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 21: Creating Tables
Understanding Data Types
Strings
Numeric
Date and Time
Other Data Types
Using AUTO_INCREMENT
Understanding Defaults
Creating Tables in PHPMYADMIN
Using .sql Script Files
Adding MySQL Tables to PHP
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 22: Entering Data
Understanding the INSERT Command
Executing MySQL Commands in PHP
Processing Data Entry Forms in PHP
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 23: Selecting Data
Using the SELECT Command
Using WHERE
Selecting Data in PHP
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 24: Using Multiple Tables
Using the JOIN Clause
Using Subqueries
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 25: Changing Data
Using the UPDATE Command
Updating Data in PHP
Using Prepared Statements
MYSQLI
PHP Data Objects (PDO)
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 26: Deleting Data
Using the DELETE Command
Deleting Data in PHP
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 27: Preventing Database Security Issues
Understanding Security Issues
Using Best Practices
Filtering Data
Try It
Lesson Requirements
Hints
Step-by-Step
Section VI: Putting it all Together
Lesson 28: Creating User Logins
Understanding Access Control
Protecting Passwords
Using Cookies and Sessions
Putting Logins to Work
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 29: Turn the Case Study Into a Content Management System
Designing and Creating the Table
Creating the Class
Properties
Methods
Creating the Maintenance Pages
Creating the Display Page
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 30: Creating a Dynamic Menu
Setting up the Menu Table
Adding the Menu to the Website
Try It
Lesson Requirements
Hints
Step-by-Step
Lesson 31: Next Steps
Appendix : What’s on the DVD?

People also search for PHP and MySQL 24 Hour Trainer 1st:

php and mysql in easy steps
    
php and mysql 24-hour trainer pdf
    
php & mysql novice to ninja
    
php train the trainers 2022
    
php programming with mysql 2nd edition reinforcement exercises answers

Tags: Andrea Tarr, PHP, MySQL