Call a function in a class

[gsc1ugs]

Hi

 

I'm new to PHP but not a complete novice but its not same as ASP, can I ask how a call a function from with a class?

 

my example code: I would like to call the function

 

repairCategories(0);

 

 

class MyClass

{

public function repairCategories($parent_id = 0) {

$query = $this->db->query("SELECT * FROM {category} WHERE parent_id = '" . (int)$parent_id . "'");

 

foreach ($query->rows as $category) {

// Delete the path below the current one

$this->db->query("DELETE FROM {category_path} WHERE category_id = '" . (int)$category['category_id'] . "'");

 

// Fix for records with no paths

$level = 0;

 

$query = $this->db->query("SELECT * FROM {category_path} WHERE category_id = '" . (int)$parent_id . "' ORDER BY level ASC");

 

foreach ($query->rows as $result) {

$this->db->query("INSERT INTO {category_path} SET category_id = '" . (int)$category['category_id'] . "', `path_id` = '" . (int)$result['path_id'] . "', level = '" . (int)$level . "'");

 

$level++;

}

 

$this->db->query("REPLACE INTO {category_path} SET category_id = '" . (int)$category['category_id'] . "', `path_id` = '" . (int)$category['category_id'] . "', level = '" . (int)$level . "'");

 

$this->repairCategories($category['category_id']);

}

}

}

[requinix]

It's not a static method so you'll need an instance of the class.

$myclass = new MyClass();

Then use the -> arrow operator.

$myclass->repairCategories(/* whatever value for $parent_id you want here */);