PHP with Mysql
Click to download the <Exercise Files >.
0 - Introduction
0-1 Introduction 0-2 Using the exercise files
1 - PHP Overview
1-1 What is PHP 1-2 History
1-3 Why choose PHP 1-4 Installation overview
2 - Mac Installation
02_01_macinstall 02_02_macconfig
02_03_mactexteditor 02_04_phpmyadmin
3 - Windows Installation
3-1 Installing 3-2 Configuring
3-3 The text editor
4 - First Steps
4-1 Viewing PHP configuration information
4-2 Embedding PHP 4-3 Hello World
4-4 The operational trail 4-5 Inserting comments
5 - Exploring Data Types
5-1 Variables 5-2 Strings
5-3 String fluctuations 5-4 Numbers Part 1 - Integers
5-5 Numbers Part 2 - Floating Points 5-6 Arrays
5-7 Array functions 5-8 Booleans and NULL
5-9 Type switching and casting 5-10 Constants
6 - Control Structures Pt. 1 Logical Expressions
6-1 If statements 6-2 Else and elseif statements
6-3 Logical operators 6-4 Switch statements
7 - Control Structures Pt. 2 Loops
7-1 While loops 7-2 For loops
7-3 Foreach loops 7-4 Continue
7-5 Break 7-6 Understanding array pointers
8 - User-Defined Functions
8-1 Defining functions 8-2 Using functions
8-3 Returning values from a function 8-4 Setting global variables
8-5 Setting default variables
9 - Debugging
9-1 Debugging and troubleshooting
10 - Building Web Pages
10-1 Links and URLs 10-2 Using GET values
10-3 Encoding GET values 10-4 Encoding for HTMLs
10-5 Building forms 10-6 Setting cookies
10-7 Establishing session 10-8 Headers and page redirection
10-9 Including and requiring page
11 - MySQL Basics
11-1 MySQL introduction 11-2 Creating a database in MySQL
11-3 Populating a MySQL database 11-4 phpMyAdmin
11-5 Connecting to MySQL with PHP 11-6 Accessing data in MySQL with PHP
12 - Building a Content Management System
12-1 Blueprinting your application 12-2 Building the CMS database
12-3 Understanding relational databases 12-4 Establishing your work area
12-5 Creating your first page 12-6 Making page assets reusable
12-7 Connecting your site to a database 12-8 Building dynamic navigation
12-9 Refactoring the navigation 12-10 Adding links to your navigation
12-11 Determining which page is selected 12-12 Displaying HTML based on the selection
13 - Application CRUD
13-1 Finding a subject in the database 13-2 Finding a page in the database
13-3 Creating a page for a new subject 13-4 Creating a subject entry form
13-5 Adding subjects 13-6 Escaping values for MySQL
13-7 Form validation 13-8 Additional form validation
13-9 Editing a subject 13-10 Using single-page submission
13-11 Updating a subject in the database 13-12 Sending form results as messages
13-13 Deleting a subject 13-14 CRUD review and assignment
13-15 CRUD assignment results
14 - Building the Public Area
14-1 The public appearance 14-2 Navigation in the public context
14-3 Functions in the public context 14-4 Creating a default subject behavior
14-5 Text encoding and transforming
15 - Regulating Page Access
15-1 User access overview 15-2 Encryption
15-3 Creating a login system 15-4 Checking authorization
15-5 Using sessions to maintain login status
15-6 Creating a logout page
Conclusion
Goodbye
Subscribe to:
Post Comments (Atom)
0 comments