Case Study of Data Operations in ThinkPHP _ php instance

This article mainly introduces the data operation methods in ThinkPHP, analyzes instances, and summarizes the ThinkPHP database operations experience, which has some reference value, for more information about how to operate ThinkPHP data, see the examples in this article. Share it with you for your reference. The details are as follows:

Using Functions in the template, I believe most TPer knows that they have also been used.

Case:

How to get the user name

Function get_username ($ uid) {$ row = M ('user')-> getbyUid ($ uid); return $ row ['username'];}

Display the user name in the template using uid

 
  {$ Row. uid} {$ row. uid | get_username}

 

I believe everyone should use this method frequently? There are two disadvantages to this usage:

1. Excessive database operations;
2. The data operation location is unreasonable and the database connection is too long.

Optimization solution:

1. Operate the database that can be merged as much as possible;
2. Data operations should be kept at the data layer to avoid database operations in the view as much as possible. We recommend that you execute mysql_close () before the view starts to disconnect the database.

I hope this article will help you with ThinkPHP-based php programming.