您现在的位置是：孟垂博自媒体博客 ✈ 学习笔记

php留言板怎么只显示登录会员自己发布的文章

07-06最后更新时间：2024-04-16【已收录】人已围观收藏

简介首先感谢：misterpan给解惑。
执行语句：
$sql="select mes_info.user,mes_info.title,mes_info.content,mes_info.ip,mes_info.addtime,mes_info.shenhe from mes_info left join admin on(admin.user_name = mes_info.user) where admin.user_name = '{$username}'";

首先感谢：misterpan给解惑。
留言板既然有了会员登录发布功能，肯定对应的要分布自己的权限，首先就是对自己数据的权限》
下面贴一下自己试错和最终的代码：

session_start();
$username = $_SESSION['username'];
//$sql = "select * from mes_info order by id desc";  输出了所有发布者信息
//$sql="select mes_info.user,mes_info.title,mes_info.content,mes_info.ip,mes_info.addtime,mes_info.shenhe from admin,mes_info where admin.user_name = mes_info.user"; 输出了所有会员登录发布的信息，并没有判断是哪个用户的信息
//$sql="select mes_info.user,mes_info.title,mes_info.content,mes_info.ip,mes_info.addtime,mes_info.shenhe from mes_info left join admin on(admin.user_name = mes_info.user) where admin.user_name = 'admin'}";这里其实是为了测试这条语句写法是不是正确，直接指定输出会员为admin的所有发布数据
$sql="select mes_info.user,mes_info.title,mes_info.content,mes_info.ip,mes_info.addtime,mes_info.shenhe from mes_info left join admin on(admin.user_name = mes_info.user) where admin.user_name = '{$username}'";这个为正确的语句，满足判断是哪一个用户登录，并输出改用户的信息。