Next Section: 多表操作-了解2441 plays

5 秒后自动播放下一节
  Watch Again

PHP database programming from zero to proficient

Introduction >
ChapterCourseware
Chapter1PHP database programming from zero to proficient

Database - basic understanding

11 minutes03 seconds

Database-relational database concepts

07 minutes31 seconds

SQL understanding.

05 minutes58 seconds

Basic understanding of MySQL

08 minutes00 seconds

MySQL server operation management

03 minutes39 seconds

Client login and exit MySQL system

08 minutes29 seconds

Basic operations of MySQL database-SQL learning preface

02 minutes21 seconds

MySQL database basic operations-SQL syntax rules

08 minutes04 seconds

View database

08 minutes32 seconds

Create database

09 minutes24 seconds

-Modify database character set

02 minutes53 seconds

Delete database

04 minutes54 seconds

SQL table (field) operation-create data table

15 minutes56 seconds

View datasheet

07 minutes58 seconds

Update data table

13 minutes24 seconds

Delete data table

04 minutes49 seconds

SQL data operations-new

07 minutes00 seconds

Query data

04 minutes46 seconds

update data

04 minutes06 seconds

delete data

03 minutes12 seconds

Character set concept

08 minutes48 seconds

Detailed explanation of MySQL character set

15 minutes02 seconds

Proofreading set concept

04 minutes17 seconds

Proofreading set settings

06 minutes46 seconds

Proofreading set application

05 minutes08 seconds

MySQL database fields-basic understanding

01 minutes13 seconds

MySQL database fields-basic classification

02 minutes14 seconds

MySQL database field-integer

07 minutes59 seconds

MySQL database field-display width

07 minutes17 seconds

MySQL database field-decimal type (floating point number

09 minutes08 seconds

MySQL database field - decimal type (fixed point number).

05 minutes29 seconds

MySQL database field-time date type

11 minutes48 seconds

MySQL database field-string (char and varchar

10 minutes49 seconds

MySQL database field - string (text string)

04 minutes25 seconds

MySQL database field - string (enumeration)

05 minutes58 seconds

MySQL database field-string (collection) + summary

08 minutes23 seconds

MySQL database field properties - understanding

02 minutes28 seconds

MySQL database field properties-non-empty properties

06 minutes03 seconds

MySQL database field properties-DEFAULT property

05 minutes59 seconds

MySQL database field properties-PRIMARYKEY property

14 minutes44 seconds

MySQL database field properties-AUTO_INCREMENT property

13 minutes20 seconds

MySQL database field properties-UNIQUE property

13 minutes39 seconds

MySQL database field properties-COMMENT property

03 minutes29 seconds

MySQL advanced operations-basic understanding

01 minutes32 seconds

MySQL Advanced Operations-New-Worm Replication

06 minutes30 seconds

MySQL advanced operations-new-replace replacement

06 minutes00 seconds

MySQL advanced operations-query-select options

04 minutes43 seconds

MySQL advanced operations-query-alias

05 minutes45 seconds

MySQL advanced operations-query-data source.

07 minutes22 seconds

MySQL advanced operations-query-where clause

10 minutes32 seconds

MySQL advanced operations-query-GROUPBY clause

19 minutes36 seconds

MySQL advanced operations-query-HAVING clause

04 minutes33 seconds

MySQL advanced operations-query-ORDERBY clause

05 minutes48 seconds

MySQL advanced operations-query-LIMIT clause

04 minutes54 seconds

MySQL Advanced Operation-Query-Summary

02 minutes00 seconds

MySQL Advanced Operations-Update-Restrict Updates

02 minutes27 seconds

MySQL Advanced Operation-Delete-Restrict Delete

01 minutes00 seconds

MySQL advanced operations-delete-clear data

03 minutes21 seconds

Database design specifications - understanding

03 minutes29 seconds

Database Design Specification-Norm-1NF

03 minutes10 seconds

Database design specification-normal form-2NF

05 minutes04 seconds

Database design specifications-normal form-3NF

05 minutes12 seconds

Database design specifications - normalization - denormalization

03 minutes31 seconds

Database design specifications-table relationships-one-to-one

04 minutes21 seconds

Database design specifications-table relationships-one-to-many

04 minutes54 seconds

Database design specifications-table relationships-many-to-many

05 minutes11 seconds

Multi-table operation - understanding

01 minutes30 seconds

Multi-table operation-joint query

13 minutes06 seconds

Multi-table operation-join query-understand

02 minutes07 seconds

Multi-table operation-join query-cross join

04 minutes44 seconds

Multi-table operation-join query-inner join

10 minutes45 seconds

Multi-table operation-join query-outer join

11 minutes33 seconds

Multi-table operation-join query-natural join

07 minutes46 seconds

subquery-understand

02 minutes17 seconds

Subquery - scalar subquery

03 minutes21 seconds

Subquery-column subquery

06 minutes53 seconds

Subquery-row subquery

03 minutes47 seconds

Subquery - table subquery

07 minutes44 seconds

MySQL Security Management-Understanding

02 minutes03 seconds

MySQL Security Management-Data Backup and Restore-Learn

03 minutes07 seconds

MySQL Security Management-Data Backup and Restore-File Backup and Restore

06 minutes24 seconds

MySQL security management-data backup and restore-whole database backup and restore

08 minutes47 seconds

MySQL Security Management-Foreign Key-Result Management

06 minutes24 seconds

MySQL security management-foreign key-foreign key constraints

12 minutes29 seconds

MySQL security management-transaction security

18 minutes03 seconds

MySQL Security Management-View-Basic Operations

05 minutes59 seconds

MySQL Security Management-View-Data Operation

05 minutes03 seconds

MySQL Security Management-View-Algorithm

08 minutes00 seconds

MySQL security management-user rights management

11 minutes25 seconds

PHP operates MySQL-understand

02 minutes37 seconds

PHP operation MySQL-load mysqli extension

07 minutes57 seconds

PHP operates MySQL-add, delete, modify and query

30 minutes26 seconds

HTTP protocol - understanding

01 minutes33 seconds

HTTP protocol - understanding

07 minutes09 seconds

HTTP protocol-HTTP request

05 minutes57 seconds

HTTP protocol-HTTP response

19 minutes08 seconds

Conversational Technology - Understanding

02 minutes29 seconds

Session technology-cookie technology-principle.

04 minutes34 seconds

Session technology-cookie technology-implementation

09 minutes43 seconds

Session technology-cookie technology-advanced applications

17 minutes21 seconds

Session technology-session technology-principle.

03 minutes11 seconds

Session technology-session technology-technical implementation

16 minutes10 seconds

Session technology-session technology-session configuration

06 minutes00 seconds

Session technology - comparison between session and cookie

02 minutes51 seconds

GD Image Processing-Understanding

01 minutes04 seconds

GD image processing-getting to know the GD library

05 minutes32 seconds

GD image processing-verification code production

15 minutes10 seconds

GD image processing-verification code function

17 minutes59 seconds

GD image processing-watermark production

10 minutes43 seconds

GD image processing-watermark function

11 minutes42 seconds

GD image processing-thumbnail production

11 minutes37 seconds

GD image processing-thumbnail function

22 minutes52 seconds
  • CancelreplySending
  • Cancelpost a noteSending