Design of blog system based on PHP7+MVC

• Chapter1 Operating MySQL in CMD mode
• 1-1 Steps to operate MySQL in CMD mode (1)
• 1-2 Steps to operate MySQL in CMD mode (2)
• 1-3 Import backup data using phpMyAdmin
• 1-4 PHP connects to MySQL server (1)
• 1-5 PHP connects to MySQL server (2)
• 1-6 PHP connects to MySQL server (3)
• 1-7 Select database
• 1-8 Set client character set
• 1-9 Execute SQL statement
• 1-10 Release the result set object
• 1-11 Get a row of data from the result set (1)
• 1-12 Get a row of data from the result set (2)
• 1-13 Get a row of data from the result set (3)
• 1-14 Get multiple rows of data from result set
• 1-15 Get the number of records queried
• 1-16 Get the number of affected rows
• 1-17 Student data table structure
• Chapter2 Comprehensive case
• 2-1 Show student information (1)
• 2-2 Public files connected to the database
• 2-3 Show student information (2)
• 2-4 Delete student information (1)
• 2-5 Delete student information (2)
• 2-6 Add student(1)
• 2-7 Add student(2)
• 2-8 Add student(3)
• 2-9 Summary after class
• Chapter3 Directory operations
• 3-1 Checkbox handling
• 3-2 Yesterday's review
• 3-3 Directory Operations Overview
• 3-4 Create a directory
• 3-5 Determine whether it is a directory
• 3-6 Determine whether the file exists
• 3-7 delete directory
• 3-8 Change directory permissions
• 3-9 Get file permission value
• 3-10 Directory rename or move
• 3-11 open Directory
• 3-12 Read directory entry
• 3-13 Character set conversion
• 3-14 Close directory
• 3-15 Summary of directory operations
• Chapter4 recursive instance
• 4-1 recursive thinking
• 4-2 Recursively traverse the phpMyAdmin directory (1)
• 4-3 Recursively traverse the phpMyAdmin directory (2)
• 4-4 open a file
• 4-5 close file
• 4-6 Read the contents of a file of a specified size
• 4-7 Read a row of data
• 4-8 Read file contents into array
• 4-9 Read file contents into string
• 4-10 Example: Read student information from Notepad
• 4-11 Save file contents as
• 4-12 Write file contents
• 4-13 Copy files
• 4-14 Delete Files
• 4-15 Recursively delete directories
• 4-16 Summary after class
• Chapter5 Data paging
• 5-1 Yesterday's review
• 5-2 Show student list data
• 5-3 Paging principle
• 5-4 Read paginated data
• 5-5 Pagination code (1)
• 5-6 Pagination code (2)
• Chapter6 HTTP protocol
• 6-1 HTTP protocol overview
• 6-2 BS network structure
• 6-3 HTTP protocol overview (2)
• 6-4 Characteristics of HTTP protocol
• 6-5 HTTP protocol URL (1)
• 6-6 HTTP protocol URL (2)
• 6-7 The composition of an HTTP request
• 6-8 Packet capture tool
• 6-9 The composition of the request line
• 6-10 The meaning of the request header part
• 6-11 HTTP request body
• 6-12 How many requests have been sent to the requested web page?
• 6-13 The composition of HTTP response
• 6-14 Common status codes
• 6-15 Status code 302 temporary jump demonstration
• 6-16 Status code 304 no change demo
• 6-17 Status code 403 forbidden access to demo
• 6-18 Status code 404 Demo not found
• 6-19 Refresh and jump
• 6-20 Example: Download file (1)
• 6-21 Example: Download file (2)
• 6-22 Summary after class
• Chapter7 Image Processing
• 7-1 Enable GD2 image processing extensions
• 7-2 Check whether the image extension GD2 is turned on
• 7-3 Drawing steps and coordinate systems
• 7-4 Create an empty canvas
• 7-5 Create a canvas from a known image
• 7-6 Destroy image resources
• 7-7 Export image or save image
• 7-8 Assign a color to the canvas
• 7-9 Write a line of string horizontally
• 7-10 Draw a line of centered string
• 7-11 Write a line of TTF string
• 7-12 Image verification code(1)
• 7-13 Image verification code (2)
• 7-14 Image verification code (3)
• 7-15 Image watermark effect
• 7-16 Image thumbnail
• 7-17 Image processing summary
• Chapter8 File Upload
• 8-1 File upload principle
• 8-2 superglobal variable array
• 8-3 Upload file error code
• 8-4 Check the location of uploaded temporary files
• 8-5 Move uploaded temporary files to a permanent directory
• 8-6 Upload file related configuration
• 8-7 Single file upload(1)
• 8-8 Single file upload (2)
• 8-9 Multiple file upload
• 8-10 Summary after class
• Chapter9 Cookie
• 9-1 Yesterday's review
• 9-2 Cookies and Session Overview
• 9-3 View cookie data in IE browser
• 9-4 What are cookies
• 9-5 Benefits of Cookies
• 9-6 How cookies work
• 9-7 Add cookie data
• 9-8 Read cookie data
• 9-9 Cookie validity period: immediacy setting
• 9-10 Cookie validity period: set expiration time
• 9-11 Cookie path validity
• 9-12 Cookie domain name validity
• 9-13 Whether cookies can only be sent over https
• 9-14 Whether cookies can be sent to the server using cookies
• 9-15 Delete cookie data
• 9-16 Cookie Summary
• Chapter10 Session
• 10-1 What is Session
• 10-2 Session working principle
• 10-3 Open Session session
• 10-4 Add session data
• 10-5 Read session data
• 10-6 Delete session data
• 10-7 Destroy Session file
• 10-8 Session corresponding cookie configuration
• 10-9 Session garbage collection mechanism
• 10-10 Summary after class
• Chapter11 User login
• 11-1 Preparation
• 11-2 Create database
• 11-3 Create user table user
• 11-4 Add a piece of user data
• 11-5 Create photo album data table photos
• 11-6 User login flow chart
• 11-7 Login form page
• 11-8 Public files connected to the database
• 11-9 Handling user login procedures (1)
• 11-10 Handling user login procedures (2)
• 11-11 Create verification code
• 11-12 Add verification code to login page
• 11-13 Determine whether the two verification codes are consistent
• Chapter12 Show photo list
• 12-1 Create a form to add a photo album
• 12-2 Upload Photo Processor (1)
• 12-3 Determine file content type
• 12-4 Upload Photo Processor (2)
• 12-5 Upload Photo Processor (3)
• 12-6 Show album list
• 12-7 Show album list (pagination)
• 12-8 Show photo details
• 12-9 Update photo views
• 12-10 Summary after class
• Chapter13 object-oriented
• 13-1 Process-oriented programming ideas
• 13-2 Object-oriented programming ideas
• 13-3 The relationship between classes and objects
• 13-4 Class definition syntax format
• 13-5 Class definition syntax format 2
• 13-6 Introduction to member attributes
• 13-7 Introduction to permission modifiers
• 13-8 Member attribute definition
• 13-9 member method definition
• 13-10 Create object of class
• 13-11 Course summary
• 13-12 How to access the properties and methods of an object
• 13-13 Object property operations
• 13-14 Member method operations
• 13-15 $this keyword usage
• 13-16 Introduction to class constants
• 13-17 Class constant definition
• 13-18 Examples of class constants
• 13-19 What is a constructor method
• 13-20 Construction method
• 13-21 What is destructor method
• 13-22 When is the object destroyed?
• 13-23 Summary after class
• 13-24 Course review
• 13-25 Static properties and static methods
• 13-26 Static properties and static methods 2
• 13-27 self keyword
• 13-28 Example: Design student class
• 13-29 Example: Design Student Class (2)
• 13-30 Why can I only see the object properties when printing an object?
• 13-31 Memory allocation in OOP
• 13-32 Pass by value
• 13-33 pass by reference
• 13-34 Pass by value becomes pass by reference
• 13-35 What is class encapsulation
• 13-36 Example: Encapsulation of classes
• 13-37 class inheritance
• 13-38 Class inheritance 2
• 13-39 Integrated syntax format
• 13-40 Single inheritance and multiple inheritance
• 13-41 Simple demonstration of single inheritance
• 13-42 parent keyword
• 13-43 What is class polymorphism
• 13-44 Method overriding requirements
• 13-45 Example: Commodity category (1)
• 13-46 Example: Commodity category (2)
• 13-47 Example: Commodity category (3)
• 13-48 Example: Commodity category (4)
• 13-49 Example: Commodity category (5)
• 13-50 Summary after class
• 13-51 Course review
• 13-52 final class and final method
• 13-53 Abstract method of abstract class
• 13-54 Abstract classes and abstract methods (2)
• 13-55 Basic concepts of interface
• 13-56 Basic concepts of interface 2
• 13-57 Interface instance
• 13-58 Why do you need automatic loading of classes?
• 13-59 Class file naming convention
• 13-60 When is the autoload function called?
• 13-61 spl_autoload_register() function syntax
• 13-62 Automatic loading of classes: using named functions
• 13-63 Automatic loading of classes: using anonymous functions
• 13-64 What is object cloning
• 13-65 Clone method_clone()
• 13-66 foreach basic syntax
• 13-67 Use foreach to traverse object properties
• 13-68 Magic method_toString()
• 13-69 Magic method_invoke()
• 13-70 What are design patterns
• 13-71 Singleton design core code
• 13-72 Example: Single instance database tool class
• 13-73 Summary after class
• Chapter14 Object-oriented development process
• 14-1 Object-oriented development process
• 14-2 Singleton design pattern
• 14-3 Database tools (1)
• 14-4 Database tools (2)
• 14-5 Database tools (3)
• 14-6 Database tools (4)
• 14-7 Database tools (5)
• 14-8 Database tools (6)
• 14-9 Public files connected to the database
• 14-10 Create a displayed table page
• 14-11 Show student information list
• 14-12 Delete student information
• 14-13 Create paging class
• 14-14 Data paging
• 14-15 What is Factory Design Pattern
• 14-16 Factory design pattern requirements
• 14-17 Factory instance (1)
• 14-18 Factory instance (2)
• 14-19 Factory model summary
• 14-20 What is PHP reloading
• 14-21 Magic method_get application
• 14-22 magic method_set application
• 14-23 Magic method_isset application
• 14-24 Magic method_unset application
• 14-25 Magic method_call application
• 14-26 Magic method_callStatic application
• Chapter15 Serialization
• 15-1 What is variable serialization
• 15-2 Array variable serialization
• 15-3 Array variable deserialization
• 15-4 Object serialization
• 15-5 Object deserialization
• 15-6 Summary after class
• Chapter16 Namespaces
• 16-1 static delay binding
• 16-2 What is a namespace
• 16-3 Define a single namespace
• 16-4 Define subnamespace
• 16-5 How to access files in the file system
• 16-6 How to access elements in a space
• 16-7 namespace keyword
• 16-8 Import elements in the space and alias them
• 16-9 space summary
• Chapter17 PDO
• 17-1 Introduction to PDO
• 17-2 Enable PDO extension
• 17-3 Create an object of PDO class
• 17-4 PDO object exec method
• 17-5 PDO object query method
• 17-6 PDO object lastInsertId method
• 17-7 setAttribute method of PDO object
• 17-8 PDOStatement object fetch method
• 17-9 PDOStatement object fetchAll method
• 17-10 PDOStatement object rowCount method
• Chapter18 error mode
• 18-1 silent mode
• 18-2 warning mode
• 18-3 abnormal mode
• Chapter19 SQL statement preprocessing
• 19-1 SQL statement processing process
• 19-2 SQL statement preprocessing steps
• 19-3 Make SQL statements with the same structure
• 19-4 SQL statement preprocessing
• 19-5 Summary after class
• Chapter20 Smarty template engine
• 20-1 Yesterday’s course review
• 20-2 Achieve simple separation of HTML code and PHP code
• 20-3 Remove all PHP tags from view files
• 20-4 Commonly used PHP template engines
• 20-5 Introduction to Smarty
• 20-6 Smarty’s first case
• 20-7 Smarty configuration: left and right delimiters
• 20-8 Smarty configuration: modify the view directory
• 20-9 Smarty variables: ordinary variables
• 20-10 Smarty reserved variables: page request variables
• 20-11 Smarty saves variables: predefined constants
• 20-12 Smarty save variable: timestamp
• 20-13 Smarty configuration variables
• 20-14 review class
• 20-15 Smarty configuration variable grouping
• 20-16 Basic syntax of foreach loop
• 20-17 foreach outputs a one-dimensional array
• 20-18 foreach outputs a two-dimensional array
• 20-19 Common properties of foreach
• 20-20 Basic syntax of section loop
• 20-21 section outputs a one-dimensional enumeration array
• 20-22 section outputs a two-dimensional enumeration array
• 20-23 section controls the starting point and step value of the loop
• 20-24 Introduction to if operator
• 20-25 if example: Determination of soldier age
• 20-26 if example: table changes color every other row
• 20-27 Introduction to variable regulators
• 20-28 Commonly used variable regulators
• 20-29 Timestamp formatting
• 20-30 truncate intercepts string
• 20-31 Summary after class
• Chapter21 MVC framework thinking principle
• 21-1 MVC overview
• 21-2 The components of MVC
• 21-3 MVC schematic diagram
• 21-4 MVC simple demonstration
• 21-5 MVC example: display student information (1)
• 21-6 MVC example: display student information (2)
• 21-7 MVC example: display student information (3)
• 21-8 MVC Example: Delete Student(1)
• 21-9 MVC Example: Delete Student(2)
• 21-10 MVC Example: Delete Student(3)
• 21-11 MVC summary
• Chapter22 Various versions of MVC
• 22-1 MVC first version: integrating students and news modules (1)
• 22-2 MVC first version: integrating students and news modules (2)
• 22-3 MVC second version: implementing basic model classes
• 22-4 The third version of MVC: factory model class implementation
• 22-5 The fourth version of MVC: Implementation of the controller class (1)
• 22-6 The fourth version of MVC: Implementation of the controller class (2)
• 22-7 MVC fifth version: adding students (1)
• 22-8 MVC fifth version: adding students (2)
• 22-9 MVC sixth version: further optimization of the controller class
• 22-10 Summary after class
• 22-11 Course review
• 22-12 MVC eighth version: implementation of basic controller classes
• 22-13 MVC version 9: Modify students (1)
• 22-14 MVC version 9: Modify students (2)
• 22-15 MVC version 9: Modify students (3)
• 22-16 MVC version 9: Modify students (4)
• 22-17 MVC version 10: simple directory division (1)
• 22-18 MVC tenth version: simple directory division (2)
• 22-19 The eleventh version of MVC: front-end controller (index.php) (1)
• 22-20 The eleventh version of MVC: front-end controller (index.php) (2)
• 22-21 MVC twelfth version: introduction of platform concept (1)
• 22-22 MVC twelfth version: introduction of platform concept (2)
• 22-23 MVC twelfth version: introduction of platform concept (3)
• 22-24 The twelfth version of MVC: Introduction of the concept of adding (4)
• 22-25 MVC version 13: automatic loading of classes
• 22-26 MVC version 14: directory constant definition (1)
• 22-27 MVC version 14: directory constant definition (2)
• 22-28 MVC fifteenth version: configuration file
• 22-29 MVC fifteenth version: initial class (1)
• 22-30 MVC fifteenth version: initial class (2)
• 22-31 MVC fifteenth version: initial class (3)
• 22-32 MVC version 15: Modify the Db class
• 22-33 Summary after class
• Chapter23 Project development process
• 23-1 Course review
• 23-2 Project development process
• 23-3 Blog introduction
• 23-4 Import blog database
• 23-5 Run blog project
• 23-6 Blog project front and back functions
• 23-7 MVC directory structure
• 23-8 MVC Framework: Frontend Configuration File
• 23-9 MVC framework: front-end entry file
• 23-10 MVC Framework: Initial Class (1)
• 23-11 MVC Framework: Initial Class (2)
• 23-12 The test framework is running normally
• 23-13 Student information management (front desk)
• 23-14 Backend entry file
• 23-15 Student information management (backend)
• 23-16 Course Review (1)
• 23-17 Course Review (2)
• 23-18 Why encapsulate the PDOWrapper class
• 23-19 Encapsulated PDO class (1)
• 23-20 Encapsulated PDO class (2)
• 23-21 Encapsulated PDO class (3)
• 23-22 Encapsulated PDO class (4)
• 23-23 Packaged PDO class (5)
• 23-24 MVC introduces PDOWrapper class
• 23-25 Factory method to create model class objects
• 23-26 Encapsulate your own Smarty class
• 23-27 Create a basic controller and introduce the Smarty class
• 23-28 Smarty integrated with MVC
• 23-29 Summary after class
• Chapter24 Blog project backend
• 24-1 Backend home page - preparation work
• 24-2 Backend home page - HTML frame tag
• 24-3 Backend homepage - display the backend homepage
• 24-4 User management - create user data table
• 24-5 User Management - Preparation
• 24-6 User management - display user list
• 24-7 User management - display user list
• 24-8 User management - delete user records
• 24-9 User management - registered users
• 24-10 User management - modify users
• 24-11 User management - modify users
• 24-12 User login - preparation
• 24-13 User login - displays the login interface
• 24-14 User login - login flow chart
• 24-15 User login - login verification
• 24-16 User login - login verification
• 24-17 Create image captcha class
• 24-18 User login - introducing verification code
• 24-19 User access rights management
• 24-20 Modification of data related to the background homepage view
• 24-21 User exits
• 24-22 Friendly links - preparation work
• 24-23 Friendly links - create data tables
• 24-24 Friendly links - display list
• 24-25 Friendly links - add records
• 24-26 Friendly links - add records
• 24-27 Summary after class
• 24-28 Article Category - Preparation
• 24-29 Article Category - Create Data Table
• 24-30 Article Category - Create a Category Controller
• 24-31 Article Category—Infinitus Classification Table Structure
• 24-32 Article Category—Infinitus Classification Principle
• 24-33 Article Category—Infinitus Classification Code
• 24-34 Article Category—Infinitus Classification Code
• 24-35 Article categories - display category list
• 24-36 Article Category - Add Category (1)
• 24-37 Article Category - Add Category (2)
• 24-38 Article Category—Delete Category
• 24-39 Article Management - Preparation
• 24-40 Article management - create data tables
• 24-41 Article management - display article list (1)
• 24-42 Article management - display article list (2)
• 24-43 Article management - display article list (3)
• 24-44 Article management - add articles (1)
• 24-45 Article management - introduction of online HTML editor
• 24-46 Article management - add articles (2)
• 24-47 Create paging class files
• 24-48 Article data pagination
• 24-49 Article search criteria
• 24-50 Article search pagination effect
• 24-51 Course review
• Chapter25 Blog project front desk
• 25-1 Front-end introduction
• 25-2 Front desk home page - preparation work
• 25-3 Frontend configuration file
• 25-4 Add index() method to homepage controller
• 25-5 Get friendly link data
• 25-6 Get article classification data (1)
• 25-7 Get article classification data (2)
• 25-8 Get article archive data (1)
• 25-9 Get article archive data (2)
• 25-10 Get data from article query
• 25-11 Home page paging function
• 25-12 Home search function
• 25-13 List page management - background login address modification
• 25-14 List page management - read the article list and paginate it
• 25-15 Content page management - add content method
• 25-16 Get data from join table query based on ID
• 25-17 Baidu share button
• 25-18 Update article reading count
• 25-19 Implementation of previous and next articles
• 25-20 Update the number of likes (1)
• 25-21 Update the number of likes (2)
• 25-22 Summary after class