PHP recursive function to delete all child nodes causes stackoverflow
The problem is in the recursive call:
remrecurs($curitem['parent']);it should be:
remrecurs($curitem['id']);Why?
Your objective is to delete the row with given id. First you check to see if it has any children. If yes you need to call the recursive delete on each of the children not on the parent again. You are calling the function recursively on the parent again..this leads to infinite recursive calls, you thrash the stack and crash.
Alternatively, you could let the database handle this. In MySQL, an InnoDB ON DELETE CASCADE will do this automatically.
CREATE TABLE category ( id INT PRIMARY KEY AUTO_INCREMENT, parent_id INT NULL, FOREIGN KEY (parent_id) REFERENCES category (id) ON DELETE CASCADE) ENGINE=InnoDBRoot nodes should have NULL as parent (not 0 as some people seem to employ on Adjancency List tables).