Rendering: 
1.sql script
-- phpMyAdmin SQL Dump -- version 4.4.15.5 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: 2016-07-12 23:05:40 -- 服务器版本： 5.7.12-log -- PHP Version: 7.0.7 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `thinkphp5` -- -- -------------------------------------------------------- -- -- 表的结构 `think_user` -- CREATE TABLE IF NOT EXISTS `think_user` ( `user_id` int(11) NOT NULL, `user_name` varchar(255) NOT NULL, `user_sex` int(11) DEFAULT NULL, `user_tel` varchar(255) DEFAULT NULL, `user_email` varchar(255) DEFAULT NULL, `user_address` varchar(255) DEFAULT NULL, `user_birth` varchar(255) DEFAULT NULL, `user_jointime` varchar(255) DEFAULT NULL, `user_passwd` varchar(255) DEFAULT NULL, `user_signature` varchar(255) DEFAULT NULL, `user_hobby` varchar(255) DEFAULT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `think_user` -- INSERT INTO `think_user` (`user_id`, `user_name`, `user_sex`, `user_tel`, `user_email`, `user_address`, `user_birth`, `user_jointime`, `user_passwd`, `user_signature`, `user_hobby`, `status`) VALUES (1, 'thinkphp', 1, '15700000000', 'emial@email.com', '山东省济南市****路', '1111111', '111111', 'qqq', NULL, NULL, 1), (2, 'pangPython', 1, '15700000000', 'email@emial.com', '山东省济南市', '201607096', NULL, '123456', 'nihao', '上速度速度', 1), (3, 'test', 0, '15722222222', 'pangPython@163.com', '北京中关村', '19931212', '12999922', '21232f297a57a5a743894a0e4a801fc3', '这个人特别懒，什么都没写', '抽烟喝酒烫头', 1), (4, '你是什么鬼', 0, '15888889999', 'admin@haha.com', '美国硅谷', '19801002', '213123', '63a9f0ea7bb98050796b649e85481845', '个性前景', '啪啪啪', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `think_user` -- ALTER TABLE `think_user` ADD PRIMARY KEY (`user_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `think_user` -- ALTER TABLE `think_user` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2 .WriteController
user\controller\Members.php
<?phpnamespace app\user\controller;use app\index\model\User;use think\View;class Members{
public function index(){
//查询出用户列表
$list = User::all(function($query){
$query->where('status',1)->limit(5)->order('user_id','asc');
}); $view = new View; //设置变量输出
$view->assign('list',$list); return $view->fetch('index');
}
}3 .WriteView
user\view \members\index.html
<!DOCTYPE html>
<html>
<head>
<title>成员</title>
<style>
dl{
text-align:center;
border:2px solid #00CC99;
margin-top:100px;
margin-bottom:100px;
margin-right:400px;
margin-left:400px;
}
</style>
</head>
<body>
<dl>
<h1 id="成员">成员</h1>
{volist name="list" id="vo"}
<dt><h3 id="vo-user-id-nbsp-姓名-vo-user-name">{$vo.user_id} 姓名：{$vo.user_name}</h3></dt>
{/volist}
</dl>
</body>
</html>General idea:
The front end submits a query request to the controller, the controller queries the data according to the conditions, replaces the variables into the view, and renders and returns...
The above is the detailed content of ThinkPHP5 development (4) query user list (picture and text). For more information, please follow other related articles on the PHP Chinese website!
宝塔部署thinkphp5报错怎么办Dec 19, 2022 am 11:04 AM宝塔部署thinkphp5报错的解决办法：1、打开宝塔服务器，安装php pathinfo扩展并启用；2、配置“.access”文件，内容为“RewriteRule ^(.*)$ index.php?s=/$1 [QSA,PT,L]”；3、在网站管理里面，启用thinkphp的伪静态即可。
thinkphp5 post得不到值怎么办Dec 06, 2022 am 09:29 AMthinkphp5 post得不到值是因为TP5是通过strpos函数在Header的content-type值中查找app/json字符串的，其解决办法就是设置Header的content-type值为app/json即可。
thinkphp5 url重写不行怎么办Dec 12, 2022 am 09:31 AMthinkphp5 url重写不行的解决办法：1、查看httpd.conf配置文件中是否加载了mod_rewrite.so模块；2、将AllowOverride None中的None改为All；3、修改Apache配置文件.htaccess为“RewriteRule ^(.*)$ index.php [L,E=PATH_INFO:$1]”保存即可。
thinkphp5怎么获取请求过来的网址Dec 20, 2022 am 09:48 AMthinkphp5获取请求网址的方法：1、使用“\think\Request”类的“$request = Request::instance();”方法获取当前的url信息；2、通过自带的助手函数“$request->url()”获取包含域名的完整URL地址。
怎么去除thinkphp5标题栏iconDec 20, 2022 am 09:24 AM去除thinkphp5标题栏icon的方法：1、找到thinkphp5框架public下的favicon.ico文件；2、删除该文件或者选择另一张图片命名改为favicon.ico，并替换原favicon.ico文件即可。
thinkphp5提示控制器不存在怎么办Dec 06, 2022 am 10:43 AMthinkphp5提示控制器不存在的解决办法：1、检查对应的控制器里面的命名空间是否写对，修改为正确的命名空间；2、打开相应的tp文件，修改类名即可。
ThinkPHP5怎么查询昨天的数据Dec 05, 2022 am 09:20 AMThinkPHP5查询昨天数据的方法：1、打开ThinkPHP5相关文件；2、通过表达式“db('table')->whereTime('c_time', 'yesterday')->select();”查询昨天的数据即可。
thinkphp5报错提示怎么设置Dec 07, 2022 am 10:31 AMthinkphp5设置报错提示的方法：1、进入项目根目录下的public文件夹，打开index.php入口文件；2、查看调试模式开关的注释；3、将“APP_DEBUG”常量的值调整为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
SublimeText3 Mac version
God-level code editing software (SublimeText3)
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment
mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
SublimeText3 English version
Recommended: Win version, supports code prompts!
