function walkTheCategories($canon, $active) { global $connection; global $DBErrorMsg; //query for canon children if ($active === '1') { //get deactivated nav $data = getNavData(3, $canon, true); } else { //get active nav $data = getNavData(1, $canon, true); } $parentId = getCanonId($canon); foreach ($data as $subCanon => $id) { //deactivate $query = "UPDATE..."; if (!($result = $connection->query($query))) { echo databaseErrorMsg($DBErrorMsg); } //recursively find all children walkTheCategories($subCanon, $active); } }
function controllerParentDeact() { //get list of product pages $canon = isset($_GET['nav']) ? $_GET['nav'] : false; $data = getNavData(2, $canon, false); $returnData = array(); //check if any have deactivated children foreach ($data as $key => $value) { $deact = getParentDeact($key); foreach ($deact as $deKey => $deValue) { $returnData[$key][$deKey] = $deValue; } } return json_encode($returnData); }