Asju W

Generation

fix invalid codeSat, 15 Apr 2023

function jjj($array){ if(isset($array['query'])){ switch($array['category']){ default: break; case 'a': $HelperCategory = "HelperCategory= '1' AND"; break; case 'd': $HelperCategory = "HelperCategory= '2' AND"; break; case 'k': $HelperCategory = "HelperCategory= '3' AND"; break; case 'p': $HelperCategory = "HelperCategory= '4' AND"; break; } switch($array['query']){ default: break; case 'sex': $query = "HelperSex"; break; case 'service': $query = "HelperServiceStatus"; break; case 'action': $query = "HelperActionStatus"; break; } $sql = $this->db->query(" SELECT HelperCategory, $query, count($query) FROM Helpers WHERE $HelperCategory HelperActionStatus IN('действующий','приостановленный') GROUP BY $query "); if ($sql->fetchColumn() <= 0){ return []; }else{ $sql = $this->db->query(" SELECT HelperCategory, $query, count($query) AS count$query FROM Helpers WHERE $HelperCategory HelperActionStatus IN('действующий','приостановленный') GROUP BY $query "); while($row = $sql->fetch(PDO::FETCH_LAZY)){ $e[$row[$query]] = $row["count$query"];//$v; } return $e; } } }

function jjj($array){ if(isset($array['query'])){ switch($array['category']){ default: break; case 'a': $HelperCategory = "HelperCategory= '1' AND"; break; case 'd': $HelperCategory = "HelperCategory= '2' AND"; break; case 'k': $HelperCategory = "HelperCategory= '3' AND"; break; case 'p': $HelperCategory = "HelperCategory= '4' AND"; break; } switch($array['query']){ default: break; case 'sex': $query = "HelperSex"; break;

Questions about programming?Chat with your personal AI assistant