How to create ul inside li elements and li elements inside ul elements using PHP and mysql table dynamically

Question

0.00/5 (No votes)

See more:

i have table in mysql like below in that colums and data are
id refid name userdefined
1 0 A
2 0 B
3 0 C
5 1 A1
6 5 AA
7 5 AB
8 6 a1
9 6 a2
10 1 A2
11 1 A3
12 2 B1
13 2 B2
14 3 C1
15 3 C2

what i want is using php recursive function add the ul li elements and li ul elements dynamically how to create the data like this.please help me thanks in advance.

A

A1

AA

a1
a2

AB

A2
A3

B

B1
B2

C

C1
C2

What I have tried:

i have tried this function it is not working as expected .it is adding empty ul empty for each child element inside how to prevent that . please help me thanks in advance.

PHP

<?php

mysql_connect('localhost','root','');

mysql_select_db("test");

function submenu($parentid=0){
    $sql=mysql_query("SELECT * FROM test WHERE refid=".$parentid);
    {
      //echo '<ul>';
            while($row=mysql_fetch_array($sql))
            {
              if(mysql_num_rows($sql)>0)
              {
                echo '<ul>';
              $sql1=mysql_query("SELECT * FROM test WHERE refid=".$row['id']);
              if(mysql_num_rows($sql1)>0 && $row['refid']==0)
              {

              //echo '<li><a href="'.$row['userdefined'].'">'.$row['name'].'</a>';
                echo '<li class="limain">'.$row['name'];
                 //echo '<li><a href="'.$row['userdefined'].'">'.$row['name'].'</a>';
              submenu($row['id']);
              echo '</li>';
              //echo '<ul>';
            }
              else{
               //echo '<ul>';
               echo '<li class="lichild"><a href="'.$row['userdefined'].'">'.$row['name'].'</a>';
               submenu($row['id']);
               echo '</li>';
            }
          }

          echo '</ul>';
      }

    }
  }

submenu();

 ?>

Posted 12-Nov-17 18:07pm

Member 13153537

Updated 13-Nov-17 17:29pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

EZW · Accepted Answer · 2017-11-13T17:29:00

Solution 1

function submenu($parentid = 0)
{
    $sql = mysql_query("SELECT * FROM test WHERE refid=" . $parentid);

    echo '<ul>';

    while($row = mysql_fetch_assoc($sql))
    {
        if($row['refid'] == 0)
        {
            echo '<li>';
            echo $row['name'];
            submenu($row['id']);
            echo '</li>';
        }
        else
        {
            echo '<li>';
            echo "<a href=\"{$row['userdefined']}\">{$row['name']}</a>";
            submenu($row['id']);
            echo '</li>';
        }
    }

    echo '</ul>';
}

submenu();

Though I recommend you moving away from these mysql_functions and converting your code to PDO as those functions are deprecated since 5.5.0 and are completely removed in PHP 7.0.0 (according to the PHP manual)

Posted 13-Nov-17 17:29pm

EZW

Updated 13-Nov-17 17:37pm

v4

Comments

Member 13153537 14-Nov-17 0:56am

thanks for your help and support.but i want to add class names for each parent element
and child element and each grand child elements using that function .how to do that please help me thanks in advance.

EZW 14-Nov-17 22:46pm

You mean design each child UL differently in CSS?

Member 13153537 15-Nov-17 0:05am

yes by using css if i open the page first time it will show only parent elements like
A
B
C

then i click on A it should show child elements of A not grand child elements
again if i click A child elements like A1 it should show A1 child elements how to do that.please give me any example.I am sorry i am asking every small doubt also because i am fresher.thanks in advance.

EZW 15-Nov-17 22:50pm

https://www.cssscript.com/pure-css-vertical-multi-level-navigation-menu/

They have what you want. Mess around with it to make it yours (Those "has-sub" aren't required. You can have a menu with that CSS without those classes)

Member 13153537 15-Nov-17 23:37pm

thanks bro for your help.

Member 13153537 15-Nov-17 23:56pm

instead of using hover i want to implement using click using jquery or javascript how
to do that give me any example.thanks in advance.

EZW 16-Nov-17 12:19pm

Some variants I found on google. You should try googling as well. That is all I'm doing to find these options

https://www.jqueryscript.net/menu/Multi-level-Side-Menu-Plugin-jQuery.html

https://codyhouse.co/gem/css-multi-level-accordion-menu/

Member 13153537 16-Nov-17 23:18pm

ok thanks for your help and support

EZW 16-Nov-17 23:29pm

No problem. Holler if anything

Member 13153537 17-Nov-17 0:56am

ok thanks.

i have created page using header ,menu,footer and content.
menu is loading from the database.what i want is if click on the menu link
the new form should display between the header and footer without reloading the menu and page how to that please help me thanks in advance.

Member 13153537 27-Nov-17 4:51am

bro i have posted a question.you have time can you please check once.