DEDECMS织梦系统的会员调用方法详细介绍

没素质的傻子 發表於 2023-9-4 00:00:00

DEDECMS织梦系统的会员调用方法详细介绍

调用12个企业会员按注册时间排序 
<div class="msgheader" style='margin: 3px auto 0px; padding: 0px 3px; outline: none; line-height: 21.6px; clear: both; border-width: 1px; border-style: solid; border-color: rgb(0, 153, 204); background: rgb(246, 251, 255); overflow: hidden; font-family: tahoma, arial, "Microsoft YaHei";'>

复制代码

代码如下:
</div>
<p class="msgborder" style='margin: 0px auto 3px; padding: 0px 3px; outline: none; line-height: 25.2px; font-size: 14px; clear: both; border-right: 1px solid rgb(0, 153, 204); background: rgb(221, 237, 251); overflow: hidden; border-left: 1px solid rgb(0, 153, 204); word-break: break-all; border-bottom: 1px solid rgb(0, 153, 204); word-wrap: break-word; font-family: tahoma, arial, "Microsoft YaHei";'>
 
{dede:sql sql='select * from dede_member where mtype="企业" order by mid limit 0,12'} 
<a href=../member/index.php?uid= target='_blank'></a> 
{/dede:sql} 

 调用12个个人会员按注册时间排序 
<div class="msgheader" style='margin: 3px auto 0px; padding: 0px 3px; outline: none; line-height: 21.6px; clear: both; border-width: 1px; border-style: solid; border-color: rgb(0, 153, 204); background: rgb(246, 251, 255); overflow: hidden; font-family: tahoma, arial, "Microsoft YaHei";'>

复制代码

代码如下:
</div>
<p class="msgborder" style='margin: 0px auto 3px; padding: 0px 3px; outline: none; line-height: 25.2px; font-size: 14px; clear: both; border-right: 1px solid rgb(0, 153, 204); background: rgb(221, 237, 251); overflow: hidden; border-left: 1px solid rgb(0, 153, 204); word-break: break-all; border-bottom: 1px solid rgb(0, 153, 204); word-wrap: break-word; font-family: tahoma, arial, "Microsoft YaHei";'>
 
{dede:sql sql='select * from dede_member where mtype="个人" order by mid limit 0,12'} 
<a href=../member/index.php?uid= target='_blank'></a> 
{/dede:sql} 

 详解 使用dede的sql标签 sql语句 
select * from dede_member where mtype="个人" order by mid limit 0,12 
mtype="个人" 判断是否为个人类型 
order by mid 按mid(注册的ID编号) 排列 
limit 0,12 从第0条数据开始读取读取12条后返回 相关调用 调取所有会员中的12个 
<div class="msgheader" style='margin: 3px auto 0px; padding: 0px 3px; outline: none; line-height: 21.6px; clear: both; border-width: 1px; border-style: solid; border-color: rgb(0, 153, 204); background: rgb(246, 251, 255); overflow: hidden; font-family: tahoma, arial, "Microsoft YaHei";'>

复制代码

代码如下:
</div>
<p class="msgborder" style='margin: 0px auto 3px; padding: 0px 3px; outline: none; line-height: 25.2px; font-size: 14px; clear: both; border-right: 1px solid rgb(0, 153, 204); background: rgb(221, 237, 251); overflow: hidden; border-left: 1px solid rgb(0, 153, 204); word-break: break-all; border-bottom: 1px solid rgb(0, 153, 204); word-wrap: break-word; font-family: tahoma, arial, "Microsoft YaHei";'>
 
{dede:sql sql='select * from dede_member order by mid limit 0,12'} 
<a href=../member/index.php?uid= target='_blank'></a> 
{/dede:sql} 

 调取所有会员中的12个按最后登录时间排序 
<div class="msgheader" style='margin: 3px auto 0px; padding: 0px 3px; outline: none; line-height: 21.6px; clear: both; border-width: 1px; border-style: solid; border-color: rgb(0, 153, 204); background: rgb(246, 251, 255); overflow: hidden; font-family: tahoma, arial, "Microsoft YaHei";'>

复制代码

代码如下:
</div>
<p class="msgborder" style='margin: 0px auto 3px; padding: 0px 3px; outline: none; line-height: 25.2px; font-size: 14px; clear: both; border-right: 1px solid rgb(0, 153, 204); background: rgb(221, 237, 251); overflow: hidden; border-left: 1px solid rgb(0, 153, 204); word-break: break-all; border-bottom: 1px solid rgb(0, 153, 204); word-wrap: break-word; font-family: tahoma, arial, "Microsoft YaHei";'>
 
{dede:sql sql='select * from dede_member order by logintime limit 0,12'} 
<a href=../member/index.php?uid= target='_blank'></a> 
{/dede:sql} 

 调取12个上传了头像的会员按最后登录时间排序并显示出他们的头像 
<div class="msgheader" style='margin: 3px auto 0px; padding: 0px 3px; outline: none; line-height: 21.6px; clear: both; border-width: 1px; border-style: solid; border-color: rgb(0, 153, 204); background: rgb(246, 251, 255); overflow: hidden; font-family: tahoma, arial, "Microsoft YaHei";'>

复制代码

代码如下:
</div>
<p class="msgborder" style='margin: 0px auto 3px; padding: 0px 3px; outline: none; line-height: 25.2px; font-size: 14px; clear: both; border-right: 1px solid rgb(0, 153, 204); background: rgb(221, 237, 251); overflow: hidden; border-left: 1px solid rgb(0, 153, 204); word-break: break-all; border-bottom: 1px solid rgb(0, 153, 204); word-wrap: break-word; font-family: tahoma, arial, "Microsoft YaHei";'>
 
{dede:sql sql='select * from dede_member where length(face)>0 order by logintime limit 0,12'} 
<a href=../member/index.php?uid= target='_blank'><img src= /></a> 
{/dede:sql} 

 以上本人都已测试成功 dede首页推荐会员和会员积分排行调用代码 调用说明：推荐会员（带用户头像）
<div class="msgheader" style='margin: 3px auto 0px; padding: 0px 3px; outline: none; line-height: 21.6px; clear: both; border-width: 1px; border-style: solid; border-color: rgb(0, 153, 204); background: rgb(246, 251, 255); overflow: hidden; font-family: tahoma, arial, "Microsoft YaHei";'>

复制代码

代码如下:
</div>
<p class="msgborder" style='margin: 0px auto 3px; padding: 0px 3px; outline: none; line-height: 25.2px; font-size: 14px; clear: both; border-right: 1px solid rgb(0, 153, 204); background: rgb(221, 237, 251); overflow: hidden; border-left: 1px solid rgb(0, 153, 204); word-break: break-all; border-bottom: 1px solid rgb(0, 153, 204); word-wrap: break-word; font-family: tahoma, arial, "Microsoft YaHei";'>
 
{dede:sql sql="SELECT mid,mtype,userid,uname,matt,face 
FROM dede_member 
where matt = 1 and mtype='个人' 
LIMIT 0 , 10"} 
头像：<img src=" 
if(!@me)@me = 'http://bbs.dedecms.com/attachment/upload/87/11787.gif'; 
" /> 
用户名：<a href='/member/?/'></a> 
{/dede:sql} 
 
if(!@me)@me = 'http://bbs.dedecms.com/image/post/smile/default/14.gif'; 


 为用户头像图片 是如果用户头像为空的话要显示的图像这个大家自己改吧 调用说明：会员积分排行 
<div class="msgheader" style='margin: 3px auto 0px; padding: 0px 3px; outline: none; line-height: 21.6px; clear: both; border-width: 1px; border-style: solid; border-color: rgb(0, 153, 204); background: rgb(246, 251, 255); overflow: hidden; font-family: tahoma, arial, "Microsoft YaHei";'>

复制代码

代码如下:
</div>
<p class="msgborder" style='margin: 0px auto 3px; padding: 0px 3px; outline: none; line-height: 25.2px; font-size: 14px; clear: both; border-right: 1px solid rgb(0, 153, 204); background: rgb(221, 237, 251); overflow: hidden; border-left: 1px solid rgb(0, 153, 204); word-break: break-all; border-bottom: 1px solid rgb(0, 153, 204); word-wrap: break-word; font-family: tahoma, arial, "Microsoft YaHei";'>
 
 
{dede:sql sql="Select mid,userid,uname,scores From dede_member order by scores desc limit 0,10"} 
<dd><a href='/member/?/'></a> 
积分</dd> 
{/dede:sql}

頁: [1]

琼殿技术论坛's Archiver

DEDECMS织梦系统的会员调用方法详细介绍