in lessons, im going to compleet thees subjects
Introduction
rough introduction
What is PHP?
What Are Dynamic Web Sites?
How PHP works?
Chapter 1:Introduction to PHP 1
Basic Syntax
Sending Data to the Web Browser
Writing Comments
What Are Variables?
Introducing Strings
Concatenating Strings
Introducing Numbers
Introducing Constants
Single vs.Double Quotation Marks
Chapter 2 : rogramming with PHP
Creating an HTML Form
Handling an HTML Form
Conditionals and Operators
Validating Form Data
Introducing Arrays For and While Loops
Chapter 3:Creating Dynamic Web Sites
Including Multiple Files
Handling HTML Forms,Revisited
Making Sticky Forms
Creating Your Own Functions
Chapter 4:Introduction to MySQL
Naming Database Elements
Choosing Your Column Types
Choosing Other Column Properties
Accessing MySQL
Chapter 5:Introduction to SQL
Creating Databases and Tables
Inserting Records
Selecting Data
Using Conditionals
Using LIKE and NOT LIKE
Sorting Query Results
Limiting Query Results
Updating Data
Deleting Data
Using Functions
Chapter 6:Advanced SQL and MySQL
Database Design
Performing Joins
Grouping Selected Results
Creating Indexes
Using Different Table Types
Performing FULLTEXT Searches
Performing Transactions
Chapter 7:Error Handling and Debugging
Error Types and Basic Debugging
Displaying PHP Errors
Adjusting Error Reporting in PHP
Creating Custom Error Handlers
PHP Debugging Techniques
SQL and MySQL Debugging Techniques
Chapter 8:Using PHP with MySQL
Modifying the Template
Connecting to MySQL
Executing Simple Queries
Retrieving Query Results
Ensuring Secure SQL
Counting Returned Records
Updating Records with PHP
Chapter 9:Common Programming Techniques
Sending Values to a Script
Using Hidden Form Inputs
Editing Existing Records
Paginating Query Results
Making Sortable Displays
Chapter 10:Web Application Development
Sending Email
Date and Time Functions
Handling File Uploads
PHP and JavaScript
Understanding HTTP Headers
Chapter 11:Cookies and Sessions
Making a Login Page
Making the Login Functions
Using Cookies
Using Sessions
Improving Session Security
Chapter 12:Security Methods
Preventing Spam
Validating Data by Type
Preventing XSS Attacks
Preventing SQL Injection Attacks
Database Encryption
Chapter 13 : erl-Compatible
Regular Expressions
Creating a Test Script
Defining Simple Patterns
Using Quantifiers
Using Character Classes
Finding All Matches
Using Modifiers
Matching and Replacing Patterns
Chapter 14:Making Universal Sites
Character Sets and Encoding
Creating Multilingual Web Pages
Unicode in PHP
Collation in PHP
Transliteration in PHP
Languages and MySQL
Time Zones and MySQL
Working with Locales
Chapter 15:Example —Message Board
Making the Database
Writing the Templates
Creating the Index Page
Creating the Forum Page
Creating the Thread Page
Posting Messages
Chapter 16:Example —User Registration
Creating the Templates
Writing the Configuration Scripts
Creating the Home Page
Registration
Activating an Account
Logging In and Logging Out
Password Management
Chapter 17:Example —E-Commerce
Creating the Database
The Administrative Side
Creating the Public Template
The Product Catalog
The Shopping Cart
Recording the Orders
Introduction
rough introduction
What is PHP?
What Are Dynamic Web Sites?
How PHP works?
Chapter 1:Introduction to PHP 1
Basic Syntax
Sending Data to the Web Browser
Writing Comments
What Are Variables?
Introducing Strings
Concatenating Strings
Introducing Numbers
Introducing Constants
Single vs.Double Quotation Marks
Chapter 2 : rogramming with PHP
Creating an HTML Form
Handling an HTML Form
Conditionals and Operators
Validating Form Data
Introducing Arrays For and While Loops
Chapter 3:Creating Dynamic Web Sites
Including Multiple Files
Handling HTML Forms,Revisited
Making Sticky Forms
Creating Your Own Functions
Chapter 4:Introduction to MySQL
Naming Database Elements
Choosing Your Column Types
Choosing Other Column Properties
Accessing MySQL
Chapter 5:Introduction to SQL
Creating Databases and Tables
Inserting Records
Selecting Data
Using Conditionals
Using LIKE and NOT LIKE
Sorting Query Results
Limiting Query Results
Updating Data
Deleting Data
Using Functions
Chapter 6:Advanced SQL and MySQL
Database Design
Performing Joins
Grouping Selected Results
Creating Indexes
Using Different Table Types
Performing FULLTEXT Searches
Performing Transactions
Chapter 7:Error Handling and Debugging
Error Types and Basic Debugging
Displaying PHP Errors
Adjusting Error Reporting in PHP
Creating Custom Error Handlers
PHP Debugging Techniques
SQL and MySQL Debugging Techniques
Chapter 8:Using PHP with MySQL
Modifying the Template
Connecting to MySQL
Executing Simple Queries
Retrieving Query Results
Ensuring Secure SQL
Counting Returned Records
Updating Records with PHP
Chapter 9:Common Programming Techniques
Sending Values to a Script
Using Hidden Form Inputs
Editing Existing Records
Paginating Query Results
Making Sortable Displays
Chapter 10:Web Application Development
Sending Email
Date and Time Functions
Handling File Uploads
PHP and JavaScript
Understanding HTTP Headers
Chapter 11:Cookies and Sessions
Making a Login Page
Making the Login Functions
Using Cookies
Using Sessions
Improving Session Security
Chapter 12:Security Methods
Preventing Spam
Validating Data by Type
Preventing XSS Attacks
Preventing SQL Injection Attacks
Database Encryption
Chapter 13 : erl-Compatible
Regular Expressions
Creating a Test Script
Defining Simple Patterns
Using Quantifiers
Using Character Classes
Finding All Matches
Using Modifiers
Matching and Replacing Patterns
Chapter 14:Making Universal Sites
Character Sets and Encoding
Creating Multilingual Web Pages
Unicode in PHP
Collation in PHP
Transliteration in PHP
Languages and MySQL
Time Zones and MySQL
Working with Locales
Chapter 15:Example —Message Board
Making the Database
Writing the Templates
Creating the Index Page
Creating the Forum Page
Creating the Thread Page
Posting Messages
Chapter 16:Example —User Registration
Creating the Templates
Writing the Configuration Scripts
Creating the Home Page
Registration
Activating an Account
Logging In and Logging Out
Password Management
Chapter 17:Example —E-Commerce
Creating the Database
The Administrative Side
Creating the Public Template
The Product Catalog
The Shopping Cart
Recording the Orders
Last edited:
