如何使用mysql在PHP中显示特定用户登录的特定菜单项 [英] How to show specific menu items for specific user login in PHP using mysql
问题描述
我在mysql中有一个表是这样的测试表列
id refid name userdefined
1 0 A
2 0 B
3 0 C
4 1 A1 abc
5 1 A2 cde
6 2 B1
7 2 B2
8 3 C3
9 3 c4
10 3 c5
11 2 C7
12 2 C8 lmn
13 11 c9
14 11 c10
使用上面的表我正在使用php函数创建动态菜单。
i还有一个表是登录字段和这样的数据< br $>
id用户名密码field3
1 john john 1,3,4,5,6,7,8,9
现在我想要的是现在如果john登录只显示field3相关值菜单。
如何做到这一点请帮助我提前感谢。
我尝试过:
i已经创建了这样的php函数
有趣ction子菜单($ parentid = 0){
global $ conn ;
$ sql = mysqli_query($ conn, SELECT * FROM test WHERE refid =.$parentid);
{
$ rowcount = mysqli_num_rows($ sql);
if($ rowcount> 0){
echo ' < UL>'跨度>;
}
while($ row = mysqli_fetch_array($ sql,MYSQLI_ASSOC))
{
if($ row ['' refid'] == 0)
{
echo < li class =limain>'。$ row [ ' name'];
子菜单($ row [' id']);
echo ' < / li>' 跨度>;
}
else {
if($ row [' userdefined']){
echo ' < li class =lichild>< a
href ='。$ row [' userdefined']。' >'。$ row [' name']。' < / A>'跨度>;
} else {
echo ' < li class =lichild>'。$ row [' name'];
}
子菜单($ row [' id']);
echo ' < / li>' 跨度>;
}
}
if($ rowcount> 0){
echo ' < / ul>';
}
}
}
// mysqli_close($ con);
?>
parentid = 0){
global
连接跨度>;
SQL = mysqli_query(
i have a tables in mysql one is test table columns like this
id refid name userdefined
1 0 A
2 0 B
3 0 C
4 1 A1 abc
5 1 A2 cde
6 2 B1
7 2 B2
8 3 C3
9 3 c4
10 3 c5
11 2 C7
12 2 C8 lmn
13 11 c9
14 11 c10
using above table i am creating the dynamic menu using php function.
i have one more table is login fields and data like this
id username password field3
1 john john 1,3,4,5,6,7,8,9
now what i want is now if john login show only the field3 releated values menu.
how to do that please help me thanks in advance.
What I have tried:
i have created php function like this
function submenu($parentid=0){
global $conn;
$sql=mysqli_query($conn,"SELECT * FROM test WHERE refid=".$parentid);
{
$rowcount=mysqli_num_rows($sql);
if($rowcount>0){
echo '<ul>';
}
while($row=mysqli_fetch_array($sql,MYSQLI_ASSOC))
{
if($row['refid']==0)
{
echo '<li class="limain">'.$row['name'];
submenu($row['id']);
echo '</li>';
}
else{
if($row['userdefined']){
echo '<li class="lichild"><a
href="'.$row['userdefined'].'">'.$row['name'].'</a>';
}else{
echo '<li class="lichild">'.$row['name'];
}
submenu($row['id']);
echo '</li>';
}
}
if($rowcount>0){
echo '</ul>';
}
}
}
//mysqli_close($con);
?>
parentid=0){ global
conn;
sql=mysqli_query(
这篇关于如何使用mysql在PHP中显示特定用户登录的特定菜单项的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!