recursive function to get all the child categories

by

I had a hard time trying to figure out your function. I think this will do what you want. It gets all the children of a category with ID $id, and also their children (thus getting the whole sub category, sub sub category effect that you wanted).

function categoryChild($id) {
    $s = "SELECT ID FROM PLD_CATEGORY WHERE PARENT_ID = $id";
    $r = mysql_query($s);

    $children = array();

    if(mysql_num_rows($r) > 0) {
        # It has children, let's get them.
        while($row = mysql_fetch_array($r)) {
            # Add the child to the list of children, and get its subchildren
            $children[$row['ID']] = categoryChild($row['ID']);
        }
    }

    return $children;
}

This function will return:

$var = array(
        'categoryChild ID' => array(
                'subcategoryChild ID' => array(
                        'subcategoryChild child 1' => array(),
                        'subcategoryChild child 2' => array()
                )
        ),
        'anotherCategoryChild ID' => array() # This child has no children of its own
);

It basically returns an array with the ID of the child and an array containing the IDs of its children. I hope this is of any help.

More Related Contents:

  1. Auto Increment ID’s of 4 digit
  2. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  3. Calculating distance between zip codes in PHP
  4. Echo menu tree with recursive function
  5. Algorithm for generating a random number
  6. Get sum from nodes tree
  7. mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource
  8. How to properly set up a PDO connection
  9. How to implement authorization using a Telegram API?
  10. Using PHP 5.5’s password_hash and password_verify function
  11. Search with comma-separated value mysql
  12. How to do this in Laravel, subquery where in
  13. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  14. Levenshtein: MySQL + PHP
  15. PHP MySQLI Prevent SQL Injection [duplicate]
  16. mysql PDO how to bind LIKE
  17. How to test if a MySQL query was successful in modifying database table data?
  18. How do i “echo” a “Resource id #6” from a MySql response in PHP?
  19. Does mysql_real_escape_string() FULLY protect against SQL injection?
  20. Recursive categories with a single query?
  21. Why does this return Resource id #2? [duplicate]
  22. Anonymous recursive PHP functions
  23. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  24. Insert current date in datetime format mySQL
  25. MySQL Query IN() Clause Slow on Indexed Column
  26. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  27. Update query PHP MySQL [duplicate]
  28. Do I have to use mysql_real_escape_string if I bind parameters?
  29. finding common prefix of array of strings
  30. How to sort MYSQL fulltext search results by relevancy

Leave a Comment