public function foo($z) { global $constructCount; ++$constructCount; $w2 = 2; newobj()->g(newobj(), 7, 8, $w2 = $this->foo(newobj())); }
public function foo($z) { $w1 = 1; $w2 = 2; newobj()->g("hi", $w1, 7, 8, $w2 = $this->foo(newobj())); }
function getDataParticipation($contestID) { // get contest name $contestName = FALSE; setContestName($contestID, $contestName); $score = "score"; if (useFfscore()) { $score = "cached_ffScore"; } $foreignSchool = getForeignSchoolConstraints(); $query = "\n SELECT \n (SELECT COUNT(`team`.ID) \n FROM `team` \n WHERE `team`.cached_officialForContestID = :contestID)\n as nbTeamsAll,\n (SELECT COUNT(`team`.ID) \n FROM `team` \n WHERE `team`.cached_officialForContestID = :contestID\n AND `team`.cached_nbBoy + `team`.cached_nbGirl = 1)\n as nbTeamsSingle,\n (SELECT COUNT(`team`.ID) \n FROM `team` \n WHERE `team`.cached_officialForContestID = :contestID\n AND `team`.cached_nbBoy = 0\n AND `team`.cached_nbGirl = 1)\n as nbTeamsGirl,\n (SELECT COUNT(`team`.ID) \n FROM `team` \n WHERE `team`.cached_officialForContestID = :contestID\n AND `team`.cached_nbBoy = 1\n AND `team`.cached_nbGirl = 0)\n as nbTeamsBoy,\n (SELECT COUNT(`team`.ID) \n FROM `team` \n WHERE `team`.cached_officialForContestID = :contestID\n AND `team`.cached_nbBoy = 1\n AND `team`.cached_nbGirl = 1)\n as nbTeamsMixed,\n (SELECT COUNT(`contestant`.ID) \n FROM `contestant`, `team` \n WHERE `contestant`.teamID = `team`.ID\n AND `team`.cached_officialForContestID = :contestID)\n as nbParticipants,\n (SELECT COUNT(`contestant`.ID) \n FROM `contestant`, `team` \n WHERE `contestant`.teamID = `team`.ID\n AND `team`.cached_officialForContestID = :contestID\n AND `contestant`.genre = 1)\n as nbParticipantsGirl,\n (SELECT SUM(`team`.{$score}) \n FROM `team` \n WHERE `team`.cached_officialForContestID = :contestID)\n as sumScoreAll,\n (SELECT SUM(`team`.{$score}) \n FROM `team` \n WHERE `team`.cached_officialForContestID = :contestID\n AND `team`.cached_nbBoy + `team`.cached_nbGirl = 1)\n as sumScoreSingle,\n (SELECT SUM(`team`.{$score}) \n FROM `team` \n WHERE `team`.cached_officialForContestID = :contestID\n AND `team`.cached_nbBoy = 0\n AND `team`.cached_nbGirl = 1)\n as sumScoreGirl,\n (SELECT SUM(`team`.{$score}) \n FROM `team` \n WHERE `team`.cached_officialForContestID = :contestID\n AND `team`.cached_nbBoy = 1\n AND `team`.cached_nbGirl = 0)\n as sumScoreBoy,\n (SELECT SUM(`team`.{$score}) \n FROM `team` \n WHERE `team`.cached_officialForContestID = :contestID\n AND `team`.cached_nbBoy = 1\n AND `team`.cached_nbGirl = 1)\n as sumScoreMixed,\n (SELECT COUNT(`school`.ID) \n FROM `school` \n WHERE EXISTS (\n SELECT * FROM `group` \n WHERE `group`.schoolID = `school`.ID\n AND EXISTS (\n SELECT * FROM `team`\n WHERE `team`.groupID = `group`.ID\n AND `team`.cached_officialForContestID = :contestID\n )))\n as nbSchools\n "; $options = array(":contestID" => $contestID); $stmt = db()->prepare($query); $stmt->execute($options); $results = $stmt->fetch(PDO::FETCH_OBJ); if ($results === FALSE) { return newerror("no teams participated"); } $descr = newobj(array("contestID" => $contestID, "contestName" => $contestName)); foreach ($results as $key => $value) { $descr->{$key} = $value; } return $descr; }
public function foo($z) { $w2 = 2; newobj()->g(newobj(), 7, 8, $w2 = $this->foo(newobj())); }