PHP and MySQL (Video Training) Book

Lesson 1: Installation of MySQL, Apache, and PHP 1

Windows 1

Mac / Unix 2

Lesson 2: Your First Web Application 7

Getting Started 7

Entering PHP Scripts 8

Variables 11

Variables 11

Working with Multiple Pages 13

Lesson 3: Language Basics 15

Arrays 15

Testing Variables 15

Simple Variable Substitution 16

Arithmetic Operators 16

Type Conversions 17

NULL 18

The if Statement 18

Comparison Operators: Equality and Identity 18

Lesson 4: More Language Features 21

Script Lifetime 21

Strings, Newlines, and the Web Browser 21

Constants 22

More Comparison Operators 22

Logical Operators 22

The switch Statement 23

Lesson 5: Functions and Loops 25

Loops 25

Functions 26

Byval and Byref Parameters 27

Scoping 28

Lesson 6: Text and Strings 29

Review of Strings in PHP 29

More on Variable Expansion 30

String Operators 30

Common Operations and Functions for Strings 31

Sending Data via GET Parameters 33

PHP and Unicode 33

Lesson 7: Arrays, File Organization 35

Review of Array Basics 35

Multidimensional Arrays 36

Counting Array Elements 36

Removing and Deleting 36

Iterating over Array Contents — foreach Loops 36

Common Array Operations 37

File Inclusion 38

Lesson 8: Object-Oriented Programming I 39

Declaring New Types 39

Constructors 41

Access Levels 41

Lesson 9: Object-Oriented Programming II 43

Better Code Reuse with Inheritance 43

Further Refining Our Objects 44

Lesson 10: Object-Oriented Programming III 47

Class Constants 47

Static Class Data 48

Static Methods 48

Operations on Objects 48

Structured Exception Handling 50

Lesson 11: Learning about the Web Server 53

More FORM Elements 53

POST vs. GET 54

The $_SERVER superglobal 56

FORM Security 58

More on Processing Forms 58

Serializing Objects 60

Lesson 12: Getting Started with the Database 61

Getting to MySQL 61

Creating Our Database 62

Creating a Database User 62

Creating the First Table 62

Inserting Data into Tables 64

Wrecking Things 64

Working with MySQL from within PHP 64

Securing User Data 65

Lesson 13: Fetching Data from the Database 67

Retrieving Data 67

More on Query Expressions: Functions 68

Sorting Result Sets 69

Fetching Subsets of the Result Sets 69

Modifying a Table 69

Lesson 14: Modifying Data in the Database 71

Modifying Rows in Our Tables 71

Deleting Rows from a Table 71

FULLTEXT Indexes 72

Joining Fetches 72

Transacting Queries 73

Using Hidden Fields on Forms 74

Lesson 15: Remembering Things: Cookies and Sessions 77

Carrying Information across Page Requests: Cookies 77

Sessions 79

FULLTEXT Searching in MySQL 81

Lesson 16: Files and File Uploads 83

Uploading User Files 83

File Functions 87

Browsing Directories 89

Lesson 17: Formatted Output, Output Buffering, and Security 91

Formatting Strings with printf and sprintf 91

Date and Time Functions 93

Output Buffering 96

Lesson 18: When Things Go Wrong 99

Errors in PHP 99

Handling Errors 100

Debugging with Xdebug 101