PHP+MySQL basic introductory course-Free online video tutorial-php.cn

Community Learn Tools Library Leisure

English

PHP+MySQL basic introductory course

Starting from zero foundation, you can solve conventional business logic, operate MySQL with PHP to add, delete, modify and query, display dynamic website data, deeply understand the MVC framework, and achieve learning and flexible mastery of various knowledge points involved in PHP development.

Elementary

php

40082 person learning

113class hour

01 days 12 hours 10 minutes 15 secondsTotal course duration

2023-11-06update

PHP中文网

Gold lecturer

A total of 51 courses Student5296 Lecturer rating5.2

认证高级PHP讲师More>>

Course Introduction Course Outline Data Download Other Courses

You will learn：

Starting from zero foundation, you can solve conventional business logic, operate MySQL with PHP to add, delete, modify and query, display dynamic website data, deeply understand the MVC framework, and achieve learning and flexibly mastering various knowledge points involved in PHP development.

PHP+MySQL basic introductory course

Chapter1 What is php and how it workstry and see
expand retract

Section1 Use WampServer to quickly build a website
duration： 09 minutes 24 seconds

Section2 wampserver project initialization
duration： 04 minutes 43 seconds

Section3 The difference between text-html and text-plain
duration： 08 minutes 13 seconds

Section4 Start your first line of php code
duration： 04 minutes 11 seconds

Section5 What is PHP
duration： 06 minutes 31 seconds

Section6 PHP operating principle
duration： 10 minutes 06 seconds

Section7 php variable--scalar type
duration： 08 minutes 35 seconds

Section8 PHP composite variables--arrays and objects
duration： 09 minutes 18 seconds
Chapter2 PHP array traversal and functions
expand retract

Section1 PHP arrays and array traversal 01
duration： 20 minutes 30 seconds

Section2 PHP arrays and array traversal 02
duration： 20 minutes 21 seconds

Section3 PHP arrays and array traversal 03
duration： 20 minutes 08 seconds

Section4 PHP arrays and array traversal 04
duration： 15 minutes 54 seconds

Section5 php function 01
duration： 19 minutes 04 seconds

Section6 php function 02
duration： 18 minutes 21 seconds
Chapter3 Anonymous functions and callback functions
expand retract

Section1 Function parameters and return value 01
duration： 24 minutes 32 seconds

Section2 Function parameters and return values 02
duration： 21 minutes 08 seconds

Section3 Function parameters and return values 03
duration： 22 minutes 17 seconds

Section4 Anonymous function (closure)
duration： 23 minutes 17 seconds

Section5 Analyzing php callback functions 01
duration： 19 minutes 28 seconds

Section6 Analyzing php callback functions 02
duration： 18 minutes 01 seconds
Chapter4 First experience with recursive functions and mysql
expand retract

Section1 Variable reference is passed to participate in the callback function 01
duration： 21 minutes 18 seconds

Section2 Variable reference is passed to participate in the callback function 02
duration： 22 minutes 23 seconds

Section3 Recursive function 01
duration： 23 minutes 24 seconds

Section4 Recursive function 02
duration： 22 minutes 22 seconds

Section5 mysql connection and data table query 01
duration： 14 minutes 45 seconds

Section6 mysql connection and data table query 02
duration： 14 minutes 50 seconds
Chapter5 mysql and pdo preprocessing
expand retract

Section1 mysql and pdo preprocessing 01
duration： 21 minutes 15 seconds

Section2 mysql and pdo preprocessing 02
duration： 23 minutes 19 seconds

Section3 mysql and pdo preprocessing 03
duration： 22 minutes 37 seconds

Section4 mysql and pdo preprocessing 04
duration： 21 minutes 30 seconds

Section5 mysql and pdo preprocessing 05
duration： 19 minutes 38 seconds

Section6 mysql and pdo preprocessing 06
duration： 22 minutes 17 seconds
Chapter6 Mysql data types and session control
expand retract

Section1 Mysql data type 01
duration： 21 minutes 25 seconds

Section2 Mysql data type 02
duration： 20 minutes 06 seconds

Section3 PDO login practice 01
duration： 24 minutes 59 seconds

Section4 PDO login practice 02
duration： 24 minutes 07 seconds

Section5 Practical session control 01
duration： 23 minutes 04 seconds

Section6 Practical session control 02
duration： 23 minutes 56 seconds
Chapter7 OOP object-oriented programming
expand retract

Section1 Session control practice--login, registration and logout 01
duration： 18 minutes 29 seconds

Section2 Session control practice--login, registration and logout 02
duration： 18 minutes 25 seconds

Section3 Classes and Objects 01
duration： 20 minutes 07 seconds

Section4 Classes and Objects 02
duration： 19 minutes 47 seconds

Section5 Class autoloader
duration： 17 minutes 15 seconds

Section6 Class inheritance-1
duration： 19 minutes 41 seconds
Chapter8 OOP class inheritance and namespace
expand retract

Section1 Class inheritance 01
duration： 19 minutes 07 seconds

Section2 Class inheritance 02
duration： 15 minutes 20 seconds

Section3 Static members of class 01
duration： 19 minutes 13 seconds

Section4 Static members of class 02
duration： 19 minutes 26 seconds

Section5 Automatic loading of classes under namespace 01
duration： 19 minutes 21 seconds

Section6 Automatic loading of classes under namespace 02
duration： 20 minutes 44 seconds

Section7 Automatic loading of classes under namespace 03
duration： 20 minutes 07 seconds
Chapter9 Composer common commands and OOP interface technology
expand retract

Section1 Composer principles and common commands 01
duration： 18 minutes 18 seconds

Section2 Composer principles and common commands 02
duration： 17 minutes 54 seconds

Section3 Composer principles and common commands 03
duration： 18 minutes 04 seconds

Section4 Composer automatic loading mechanism of classes
duration： 21 minutes 32 seconds

Section5 Interface and abstract class 01
duration： 21 minutes 32 seconds

Section6 Interface and abstract class 02
duration： 21 minutes 54 seconds
Chapter10 Late static binding and oop overloading
expand retract

Section1 Principle of late static binding
duration： 19 minutes 29 seconds

Section2 Late static binding principle 2
duration： 23 minutes 43 seconds

Section3 Singleton mode to connect to database 1
duration： 18 minutes 27 seconds

Section4 Singleton mode to connect to database 2
duration： 22 minutes 09 seconds

Section5 oop overload--attribute interceptor 1
duration： 20 minutes 02 seconds

Section6 oop overload--attribute interceptor 02
duration： 20 minutes 39 seconds
Chapter11 Query constructor implementation and file upload
expand retract

Section1 Event delegation--database query constructor 01
duration： 18 minutes 01 seconds

Section2 Event delegation--database query constructor 02
duration： 18 minutes 54 seconds

Section3 Event delegation--database query constructor 03
duration： 16 minutes 03 seconds

Section4 Native paging principle and layui paging 01
duration： 19 minutes 17 seconds

Section5 Native paging principle and layui paging 02
duration： 15 minutes 28 seconds

Section6 PHP file upload 01
duration： 16 minutes 20 seconds

Section7 PHP file upload 02
duration： 21 minutes 30 seconds
Chapter12 Multiple file upload and mvc principle
expand retract

Section1 File upload backend interception 01
duration： 19 minutes 02 seconds

Section2 File upload backend interception 02
duration： 19 minutes 48 seconds

Section3 File upload backend interception 03
duration： 19 minutes 20 seconds

Section4 Operating principle of mvc architecture pattern
duration： 28 minutes 06 seconds

Section5 Dependency injection and service container 01
duration： 18 minutes 47 seconds

Section6 Dependency injection and service container 02
duration： 18 minutes 38 seconds

Section7 Facade - static takeover 01
duration： 18 minutes 29 seconds

Section8 Facade - static takeover 02
duration： 18 minutes 10 seconds

Section9 Facade - static takeover 03
duration： 19 minutes 25 seconds
Chapter13 api interface programming
expand retract

Section1 The composition and encoding method of url01
duration： 19 minutes 43 seconds

Section2 The composition and encoding method of url02
duration： 19 minutes 22 seconds

Section3 mvc pathinfo routing analysis principle
duration： 25 minutes 30 seconds
Chapter14 curl server communication and self-mvc framework
expand retract

Section1 curl requests third-party resources 01
duration： 18 minutes 14 seconds

Section2 curl requests third-party resources 02
duration： 18 minutes 07 seconds

Section3 curl requests third-party resources 03
duration： 17 minutes 38 seconds

Section4 Implement template rendering using mvc framework 01
duration： 20 minutes 25 seconds

Section5 Implement template rendering using mvc framework 02
duration： 19 minutes 59 seconds

Section6 Implement template rendering using mvc framework 03
duration： 19 minutes 35 seconds

Section7 Implement template rendering using mvc framework 04
duration： 18 minutes 05 seconds
Chapter15 Multi-application middleware configuration and route registration
expand retract

Section1 tp multi-application mode routing access
duration： 27 minutes 08 seconds

Section2 Route registration and middleware usage 01
duration： 17 minutes 18 seconds

Section3 Route registration and middleware use 02
duration： 17 minutes 26 seconds

Section4 Practical combat: session middleware for login protection 01
duration： 17 minutes 19 seconds

Section5 Practical combat: session middleware for login protection 02
duration： 18 minutes 08 seconds

Section6 Problem analysis--too many middleware redirections
duration： 19 minutes 10 seconds
Chapter16 Routing group middleware and Infinitus classification in practice
expand retract

Section1 Login protection--routing group middleware 01
duration： 20 minutes 45 seconds

Section2 Login protection--routing group middleware 02
duration： 21 minutes 30 seconds

Section3 Model Query and Infinitus Classification Principle 01
duration： 24 minutes 54 seconds

Section4 Model Query and Infinitus Classification Principle 02
duration： 26 minutes 04 seconds

Section5 Data association query example 01
duration： 15 minutes 49 seconds

Section6 Data association query example 02
duration： 16 minutes 17 seconds
Chapter17 Background rectification and use of datatables
expand retract

Section1 Build a perfect backend homepage (iframe) 01
duration： 21 minutes 49 seconds

Section2 Build a perfect backend homepage (iframe) 02
duration： 19 minutes 34 seconds

Section3 Datatable front-end and back-end configuration practice 01
duration： 23 minutes 49 seconds

Section4 Datatable front-end and back-end configuration practice 02
duration： 21 minutes 48 seconds

Section5 Datatable front-end and back-end configuration practice 03
duration： 25 minutes 40 seconds

Section6 Datatable front-end and back-end configuration practice 04
duration： 24 minutes 44 seconds
Chapter18 Asynchronous operation and multi-language configuration of datatable data
expand retract

Section1 Asynchronous deletion and editing of single row data 01
duration： 20 minutes 20 seconds

Section2 Asynchronous deletion and editing of single row data 02
duration： 17 minutes 52 seconds

Section3 Asynchronous deletion and editing of single row data 03
duration： 17 minutes 41 seconds

Section4 Multi-language configuration (file and data table design) 01
duration： 23 minutes 10 seconds

Section5 Multi-language configuration (file and data table design) 02
duration： 23 minutes 53 seconds

Section6 Verification code verification explanation
duration： 04 minutes 09 seconds

Data Name operate
[must see]PHP+MySQL basic introductory course courseware Download

PHP中文网 Lecturer Other Courses

Elementaryhtml5 Chinese manual

5513
Collection
ElementaryCSS 2.0 Chinese Manual

6119
Collection
ElementaryCSS 3.0 Reference Manual

3773
Collection
AdvancedPlay with CSS Flexbox layout

25925
Collection
AdvancedMake layout as fast as 5G: CSS Grid grid layout

29770
Collection
ElementaryThe front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]

169795
Collection
ElementaryBootstrap3 reference manual

3339
Collection
ElementaryFoundation5 Manual

903
Collection
ElementaryJavaScript Reference Manual

9464
Collection
ElementaryjQuery1.11 Reference Manual

9118
Collection
ElementaryjQuery1.7 Chinese manual

5735
Collection
ElementaryjQuery_API_1.4.4 Manual

4226
Collection

Start Learning

This course includes：

01 days 12 hours 10 minutes 15 seconds Watch videos anytime

1 Download Resources

Popular courses Latest courses

More>