This article mainly introduces the usage of cache() in the coherent operation of the thinkPHP5 framework database. It analyzes the application scenarios of the cache in thinkPHP5 in the form of examples and the operation skills of cache setting, updating, deletion and other operations in the coherent operation. Friends in need can refer to it. Next, I hope it can help everyone.
Introduction
The cache system that comes with TP5 is a File type cache. That is, file type cache. The storage address is: root directory\..\runtime\cache (the root directory refers to public).
Compared with redis, memcached of this caching system definitely has limitations, and there are differences in the complexity of automatic updates and cached data. But it is very helpful for some simple queries. For example, articles and other content are good to use.
cache can be used for select, find, value and column methods, as well as their derivative methods. After using the cache method, the database query operation will not be performed again within the cache validity period, but the data in the cache will be obtained directly. , please refer to the cache section for the types and settings of data cache.
Storage cache
1. Simple storage
//查询news表中id=10的新闻存储于cache中,写true默认读取配置的中缓存时间,db():助手函数 db('news')->cache(true)->find(10); //你也可以自定义时间,60秒表示 db('news')->cache(true,60)->find(10);
2. Specify Cache ID
//缓存标识可以理解为键,就是当你想要去取出缓存中的某条数据的令牌,id=15的存进cache并且给定下标为key db('news')->cache('key')->find(15); //当你想要去取出id=15的这条数据时候 $data = \think\Cahce::get('key');
You can read this data in any place, which is similar to session()
3. The cache method supports setting Cache tag
db('news')->cache('key',60,'tagName')->find(15);
Update cache
Now it looks like there is a problem when your project is running After a period of time, a lot of cache files will be generated, and there will be more and more files. The time wasted every time you request to find the cache file may be slower than directly querying the database. How to do it?
TP5 has a cache automatic update method. That is, when the same data is deleted or updated, the old cache file will be automatically deleted.
//查询id=328的存进cache $list = db('news')->cache(true)->find(328); //现在进行测试下,你手动去数据库修改id=328的某个字段的值,然后再次进行第一次的查询请求发现数据库修改的字段没变,这时候就是读取的缓存,然后 db('news')->update(['id'=>328,'title'=>'测试']); //这时候你再次请求会发现获取的数据改变了 ,这时候不再是读取的缓存,因为你做了更新操作,重新写进缓存了,当然,以上说的这种情况前提是使用的主键查询的
Related recommendations:
Detailed explanation of the use of php clearstatcache() function
Recommended articles about php clearstatcache() function
ThinkPHP3.1 Quick Start (4) Consecutive Operations
The above is the detailed content of thinkPHP5 framework database cache() usage. For more information, please follow other related articles on the PHP Chinese website!