Hanshunping php+mysql Basic Video Tutorial Source Courseware

"Hanshunping 2016 php+mysql basic video tutorial" To everyone is about the comprehensive use of php+mysql, as an example of how to apply PHP and MySQL, students can achieve the following levels:

Understand the process of developing dynamic website through actual project, master the foreground page how to get and display the records in MySQL database

This course content includes: the function analysis of the message board, the creation of the table, the addition of the post, display and modification, the page display message information, the user login function analysis and implementation.

The biggest highlight of this set of basic PHP video courses is: The previously learned PHP Foundation and a variety of grammar applied to a small project, deepen the understanding of the various knowledge points and use, for the development of medium-sized and large-scale projects behind to lay a good foundation.

Course Play Address: http://www.php.cn/course/450.html

The teacher's lecture style:

The teacher lively image, witty witty, witty, touching. A vivid image of the metaphor, like the finishing touch, to the students to open the door of wisdom, a proper sense of humor, attracting students to smile, such as drinking a cup of glycol wine, to the aftertaste and nostalgia, the philosopher's motto, culture of the proverbs from time and again interspersed in the middle, give people to think and alert.

In this video, the more difficult is the message board-pagination:

1) Paging principle:

Paging is the result set of the database is displayed in a paragraph

(2) The required conditions:

How to segment, current in the first paragraph (there are several pages per page, the current second page)

Top 10 Records: SELECT * FROM table limit 0,10

11th to 20th record: SELECT * FROM table limit 10,10

21st to 30th Record: SELECT * FROM table limit 20,10

(3) Get the formula

(Current page-1) X number of pages per page, number of articles per page

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

Here also recommend the source of resources to download: http://www.php.cn/xiazai/learn/2119

Resources for everyone to share the video courseware and source code