Han Shunping PHP+mysql basic video tutorial source code courseware

"Han Shunping's 2016 PHP+MySQL Basics Video Tutorial" tells everyone about the comprehensive application of PHP+MySQL. It demonstrates how to apply PHP and MySQL through examples. Students can reach the following levels:

Recommended related mysql video tutorials: "mysql tutorial"

Get a preliminary understanding of the process of developing dynamic websites through actual projects, and master how to obtain and display the Mysql database on the front page Records in

The content of this course specifically includes: functional analysis of message boards, creation of tables, adding, displaying and modifying posts, paging display of message information, and analysis and implementation of user login functions.

The biggest highlight of this set of PHP basic video courses is: applying the PHP basics and various grammars learned previously to a small project, deepening the understanding and use of each knowledge point, and preparing for the subsequent development of medium-sized projects and lay a good foundation for large-scale projects.

Course playback address: http://www.php.cn/course/450.html

The teacher’s teaching style:

The teacher’s lectures are vivid, witty, witty, and touching. A vivid metaphor is like the finishing touch, opening the door to wisdom for students; an appropriate humor brings a knowing smile to students, like drinking a glass of mellow wine, giving people aftertaste and nostalgia; a philosopher's aphorisms, cultural references Proverbs are interspersed from time to time in the narration, giving people thinking and warning.

The more difficult point in this video is the message board - paging:

1) Paging principle:

The so-called paging is to divide the result set of the database Display paragraph by paragraph

(2)Required conditions:

How to segment, what paragraph is it currently on (how many items per page, what page is it currently on)

The first 10 records: select * from table limit 0,10

The 11th to 20th records: select * from table limit 10,10

The 21st to 30th records: select * from table limit 20,10

(3) Get the formula

(current page number - 1) X number of items per page, number of items per page

   Select * from table limit ($Page- 1) * $PageSize, $PageSize

Here we also recommend downloading source code resources: http://www.php.cn/xiazai/learn/2119

The resources share video courseware and source code for you

The above is the detailed content of Han Shunping PHP+mysql basic video tutorial source code courseware. For more information, please follow other related articles on the PHP Chinese website!