RBA Cash Rate: 4.35% · 1AUD = 0.67 USD · Inflation: 4.1%  
Leading Digital Marketing Experts | 1300 235 433 | Aggregation Enquires Welcome | Book Appointment
1300235433
Example Interest Rates: Home Loan Variable: 5.38% (6.14%*) • Home Loan Fixed: 5.44% (6.26%*) • Fixed: 5.44% (6.26%*) • Variable: 5.38% (6.14%*) • Investment IO: 5.69% (6.52%*) • Investment PI: 5.49% (5.98%*)

PHP Threaded Comment Class

A few years ago I built a dodgy little site at Usenet.com.au that rendered Australian text Usenet newsgroups. While the front-end is offline, it'll be back online sometime in the future. One of the biggest challenges I faced in the early days was orientated around optimizing threaded articles. With several million articles in the database it quickly became evident that the original method of storing and displaying articles was problematic. It was slow, queries were long and complicated, and CPU resources were quite high.

My solution (for a small satellite website) came in the way of a simple class written by Jon Gales of JonGales.com . I've modified Jon's code myself and it works great. There are a lot of threaded comment classes around the place (including one within WordPress available for use under the GPL) but I found that Jon's was simply easy to use and implement for my quick and dirty solution.

The code is designed to be implemented into your own PHP project.

John's original code is below.

1
<?php 
2
class Threaded_comments
3
{
4
    public $parents  = array();
5
    public $children = array();
6
 
7
    /**
8
     * @param array $comments
9
     */
10
    function __construct($comments)
11
    {
12
        foreach ($comments as $comment)
13
        {
14
            if ($comment['parent_id'] === NULL)
15
            {
16
                $this->parents[$comment['id']][] = $comment;
17
            }
18
            else
19
            {
20
                $this->children[$comment['parent_id']][] = $comment;
21
            }
22
        }
23
    }
24
 
25
    /**
26
     * @param array $comment
27
     * @param int $depth
28
     */
29
    private function format_comment($comment, $depth)
30
    {
31
        for ($depth; $depth > 0; $depth--)
32
        {
33
            echo "\t";
34
        }
35
 
36
        echo $comment['text'];
37
        echo "\n";
38
    }
39
 
40
    /**
41
     * @param array $comment
42
     * @param int $depth
43
     */
44
    private function print_parent($comment, $depth = 0)
45
    {
46
        foreach ($comment as $c)
47
        {
48
            $this->format_comment($c, $depth);
49
 
50
            if (isset($this->children[$c['id']]))
51
            {
52
                $this->print_parent($this->children[$c['id']], $depth + 1);
53
            }
54
        }
55
    }
56
 
57
    public function print_comments()
58
    {
59
        foreach ($this->parents as $c)
60
        {
61
            $this->print_parent($c);
62
        }
63
    }
64
 
65
}

Here's example usage with the comment data provided as an array.

1
$comments = array(  array('id'=>1, 'parent_id'=>NULL,   'text'=>'Parent'),
2
                    array('id'=>2, 'parent_id'=>1,      'text'=>'Child'),
3
                    array('id'=>3, 'parent_id'=>2,      'text'=>'Child Third level'),
4
                    array('id'=>4, 'parent_id'=>NULL,   'text'=>'Second Parent'),
5
                    array('id'=>5, 'parent_id'=>4,   'text'=>'Second Child')
6
                );
7
 
8
$threaded_comments = new Threaded_comments($comments);
9
$threaded_comments->print_comments();

Example output:

1
Parent
2
 Child
3
  Child Third level
4
Second Parent
5
 Second Child

■ ■ ■

 
Download our complimentary 650-page guide on marketing for mortgage brokers. We'll show you exactly how we generate billions in volume for our clients.
Finance Guide, Cropped Top and Bottom
  Timezone: 1 · [ CHANGE ]

Like this article?

Share on Facebook
Share on Twitter
Share on Linkdin
Share on Pinterest
Picture of Martin Khoury

Martin Khoury

Martin is the Managing Director of BeliefMedia Pty Limited, and Australia's leading Finance Marketing Specialist. He is supported by a team of Australia's finest. Read more about Marty here.

Leave a comment

Call us on 1300 235 433
Enquire Online
Make an Appointment
General Enquires: 1300 235 433 • Support: (02) 8765 8887
The comparison rate is calculated on a secured loan of $150,000 with a term of 25 years with monthly principal and interest payments. WARNING: This comparison rate is true only for examples given and may not include all fees and charges. Different terms, fees or other loan amounts might result in a different comparison rate. Important Information: Applications are subject to credit approval. Full terms and conditions will be included in our loan offer. Fees and charges are payable. Interest rates are subject to change. Offer does not apply to internal refinances and is not transferable between loans. As this advice has been prepared without considering your objectives, financial situation or needs, you should consider its appropriateness to your circumstances before acting on the advice. [ Example Credit Guide Link ]
Facebook Twitter Youtube Linkedin Facebook-f
    
© BeliefMedia | Privacy • Terms • Disclaimer
BeliefMedia Pty Limited