PHP making HTML menu with Recursive Function

Question

I have categories table in MySQL Database. It looks like this; categories Table Image

I have a function for make a Recursive Function for make HTML Menu. But, I'm stuck for last 3-4 hours. This is my code in Codeigniter Model;

public function deneme($parent_id = 0, $sub_mark = 0) {
    $this->db->select('*');
    $this->db->from('categories');
    $this->db->where('parent_id = ' . $parent_id);
    $this->db->order_by('id', 'ASC');
    $query = $this->db->get();
    if($query->num_rows() > 0) {
        foreach($query->result_array() as $row) {
            echo '
            <li class="active">
                <a href="index.html">' . $row['name'] . '</a>
            </li>
            ';
            $sub_mark++;
            $this->deneme($row['id'], $sub_mark, $str);
        }
    }
}

So, it only can make this;

<li class="active">
    <a href="index.html">Anasayfa</a>
</li>
<li class="active">
    <a href="index.html">Uygulamalar</a>
</li>
<li class="active">
    <a href="index.html">Cilt Bakımı</a>
</li>
<li class="active">
    <a href="index.html">Medikal Cilt Bakımı</a>
</li>
<li class="active">
    <a href="index.html">Innofacial İle Bakım</a>
</li>
.
.
.

But, I want to do this like;

<li class="active">
    <a href="index.html">Anasayfa</a>
</li>
<li class="active">
    <a href="index.html">Uygulamalar</a>
    <ul>
        <li>
            <a href="index.html">Cilt Bakımı</a>
                <ul>
                    <li>
                        <a href="index.html">Medikal Cilt Bakımı</a>
                    </li>
                    <li>
                        <a href="index.html">Innofacial Ile Bakım</a>
                    </li>
                    <li>
                        <a href="index.html">Jetpeel Ile Bakım</a>
                    </li>
                </ul>
        </li>
    </ul>
</li>
.
.
.

How can I do this? Thanks!

Mohammad C · Accepted Answer · 2018-12-08 14:21:09Z

1

You are missing the ul tags to make your list nested. Also i added an if statement to make sure only the top level lists have active class.

if($query->num_rows() > 0) {
    echo '<ul>';
    foreach($query->result_array() as $row) {
        if ($parent_id == 0) {
            echo '<li class="active">';
        } else {
            echo '<li>';
        }
        echo '<a href="index.html">' . $row['name'] . '</a> </li> '; 
        $sub_mark++;
        $this->deneme($row['id'], $sub_mark, $str);
    }
    echo '</ul>';
}

answered Dec 8, 2018 at 14:21

Mohammad C

1,3411 gold badge8 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Muhammed Çağlar TUFAN Over a year ago

Wow! Very good! How can I return a string when the latest call to function, do you have any idea about this?

Collectives™ on Stack Overflow

PHP making HTML menu with Recursive Function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related