


This article mainly introduces the implementation method of thinkPHP multi-table query and paging function, and analyzes the related implementation techniques of thinkPHP multi-table query and paging display of query results based on specific examples. Friends in need can refer to the following
The details are as follows:
The business logic of the project is: the teacher uploads the test paper, sets the answer sheet, and publishes the answer sheet to the relevant class or group. Only after the answer sheet associated with the test paper is released, can the test paper be included in the system test paper After searching, other teachers can also collect it. In the front-end collection module, there is a business that provides an input box to provide search functions to users. However, in the pre-designed search table, only one test paper ID is associated with the test paper table. What if the user searches for the test paper title? Instead of querying two tables, the method I thought of at first was to add an extra field to the collection table, that is, add the fields of the test paper questions to the collection table, and the business is completed. Today when I was dealing with the logic of question bank sharing, I discovered this problem again. I saw that the sharing table designed by my colleague only had one question bank ID, so I called my colleague over to "correct it", but I still wanted to hear my colleague's design ideas beforehand. , my colleague said that it is a table query, let me check it out, it seems that I am used to using a table query, I did not expect this situation, and was despised, so I faced my mistake squarely, of course, the premise is to talk about my own The idea is not quite right now that I think about it, so I will give the relevant TP code below.
// 异步请求试卷夹下某一个试卷夹的列表 public function ajaxLists() { extract($_GET); $page = intval($_GET['p']); $prefix = C('DB_PREFIX'); $collect = $prefix . 'collect'; $resource = $prefix . 'resource'; if ($keyword) { $arr = preg_split('/ /', $keyword); // 搜索标签 foreach ($arr as $value) { $id = A('Home/Papers')->trunWordToId(array($value)); if ($id) { $where['resource.rta_id'][] = array('LIKE', '%,' . $id . ',%'); } $where['resource.re_title'][] = array('LIKE', '%' . $value . '%'); } if ($where['resource.rta_id']) { $where['resource.rta_id'][] = 'AND'; } if ($where['resource.re_title']) { $where['resource.re_title'][] = 'OR'; } if ($where['resource.re_title'] && $where['resource.rta_id']) { $where['_logic'] = 'OR'; } } if ($where) { $map['_complex'] = $where; } $map['collect.a_id'] = $this->authInfo['a_id']; $map['_string'] = 'collect.col_object_id = resource.re_id'; // 总数 $count = M()->table("$collect collect, $resource resource")->where($map)->count(); // 总页数 $regNum = ceil($count/6); // 验证当前请求页码是否大于总页数 $page = $page > $regNum ? $regNum : $page; // 引入ajax分页库 import("@.ORG.Util.AjaxPage"); $Page = new AjaxPage($count, 6); $list['page'] = trim($Page->show()); $list['list'] = M()->table("$collect collect, $resource resource")->where($map)->order('col_id DESC')->limit($Page->firstRow . ',' . $Page->listRows)->field('collect.col_id,collect.col_object_id,resource.re_id,resource.re_title,resource.re_created,resource.re_collect_count,resource.re_score_count,resource.re_score_num,resource.rta_id')->select(); // 获取试卷的标签 $wheree['rta_id'] = array('IN', trim(str_replace(',,', ',', implode('', getValueByField($list['list'], 'rta_id'))), ',')); $tag = setArrayByField(M('ResourceTag')->where($wheree)->field('rta_id,rta_title')->select(), 'rta_id'); // 把标签和试卷对应 foreach ($list['list'] as $key => &$value) { $str = ''; foreach ($tag as $k => $v) { if (strpos($value['rta_id'], ',' . $k . ',') !== FALSE) { $str .= ' | ' . $v['rta_title']; } $value['rta_title'] = trim($str, ' |'); } if ($keyword) { foreach ($arr as $vv) { if (strpos($value['re_title'], $vv) !== FALSE) { $value['re_title'] = str_replace($vv, '<font color=\'red\'>' . $vv . '</font>', $value['re_title']); } if (strpos($value['rta_title'], $vv) !== FALSE) { $value['rta_title'] = str_replace($vv, '<font color=\'red\'>' . $vv . '</font>', $value['rta_title']); } } } $value['re_created'] = date('Y-m-d', $value['re_created']); } echo json_encode($list); }
Related recommendations:
Constraints and Multi-table queries in MySQLAnd detailed examples of subqueries
python flask multi-pairMultiple table queriesDetailed examples of examples
The above is the detailed content of ThinkPHP's method of implementing multi-table query and paging functions. For more information, please follow other related articles on the PHP Chinese website!

thinkphp是国产框架。ThinkPHP是一个快速、兼容而且简单的轻量级国产PHP开发框架,是为了简化企业级应用开发和敏捷WEB应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。

本篇文章给大家带来了关于thinkphp的相关知识,其中主要介绍了关于使用think-queue来实现普通队列和延迟队列的相关内容,think-queue是thinkphp官方提供的一个消息队列服务,下面一起来看一下,希望对大家有帮助。

thinkphp基于的mvc分别是指:1、m是model的缩写,表示模型,用于数据处理;2、v是view的缩写,表示视图,由View类和模板文件组成;3、c是controller的缩写,表示控制器,用于逻辑处理。mvc设计模式是一种编程思想,是一种将应用程序的逻辑层和表现层进行分离的方法。

本篇文章给大家带来了关于thinkphp的相关知识,其中主要介绍了使用jwt认证的问题,下面一起来看一下,希望对大家有帮助。

thinkphp查询库是否存在的方法:1、打开相应的tp文件;2、通过“ $isTable=db()->query('SHOW TABLES LIKE '."'".$data['table_name']."'");if($isTable){...}else{...}”方式验证表是否存在即可。

thinkphp扩展有:1、think-migration,是一种数据库迁移工具;2、think-orm,是一种ORM类库扩展;3、think-oracle,是一种Oracle驱动扩展;4、think-mongo,一种MongoDb扩展;5、think-soar,一种SQL语句优化扩展;6、porter,一种数据库管理工具;7、tp-jwt-auth,一个jwt身份验证扩展包。

本篇文章给大家带来了关于ThinkPHP的相关知识,其中主要整理了使用think-queue实现redis消息队列的相关问题,下面一起来看一下,希望对大家有帮助。

在thinkphp3.2中,可以利用define关闭调试模式,该标签用于变量和常量的定义,将入口文件中定义调试模式设为FALSE即可,语法为“define('APP_DEBUG', false);”;开启调试模式将参数值设置为true即可。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

WebStorm Mac version
Useful JavaScript development tools

SublimeText3 Linux new version
SublimeText3 Linux latest version

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SublimeText3 Mac version
God-level code editing software (SublimeText3)

SublimeText3 English version
Recommended: Win version, supports code prompts!
