public function wikiSnippet() { $college = $this->_college; $college = str_replace(" ", "_", $college); $this->setTitle($college); $this->setProp("revisions"); // section 0 $this->setFormat("php"); $this->setAdditionalProperties("&rvprop=content&rvsection§ion=0"); // text content of page, only the text which appears before $this->setAPIUrl(); $source = urlParser::cURL($this->_apiURL); $decoded = unserialize($source); $key = key($decoded["query"]["pages"]); $valueArray = $decoded["query"]["pages"][$key]["revisions"]["0"]["*"]; // print_r($valueArray); $established = parser::parseSnippet("|established", $valueArray); $established = parser::refineSnippet($established, "established"); //print_r($established); $type = parser::parseSnippet("|type", $valueArray); $type = parser::refineSnippet($type); //print_r($type); $president = parser::parseSnippet("|president", $valueArray); $president = parser::refineSnippet($president); //print_r($president); $city = parser::parseSnippet("|city", $valueArray); $city = parser::refineSnippet($city); //print_r($city); $country = parser::parseSnippet("|country", $valueArray); $country = parser::refineSnippet($country); //print_r($country); $location = $city . ", " . $country; //print_r($location); $endowment = parser::deepParseSnippet("|endowment", $valueArray); $endowment = parser::refineSnippet($endowment); //print_r($endowment); $faculty = parser::parseSnippet("|faculty", $valueArray); $faculty = parser::refineSnippet($faculty, "faculty"); //print_r($faculty); if ($faculty == "") { $faculty = parser::parseSnippet("|staff", $valueArray); // uses $faculty for ease of adding to db $faculty = parser::refineSnippet($faculty, "faculty"); //print_r($athletics); } $undergrad = parser::parseSnippet("|undergrad", $valueArray); if ($undergrad == null) { $undergrad = parser::parseSnippet("| undergrad", $valueArray); } $undergrad = parser::refineSnippet($undergrad, "undergrad"); //print_r($undergrad); $postgrad = parser::parseSnippet("|postgrad", $valueArray); if ($postgrad == null) { $postgrad = parser::parseSnippet("| postgrad", $valueArray); } $postgrad = parser::refineSnippet($postgrad, "postgrad"); if ($postgrad == "") { $postgrad = "0"; } //print_r($postgrad); $campus = parser::parseNew("|campus", $valueArray); $campus = parser::refineSnippet($campus); print_r($campus); return; $athletics = parser::deepParseSnippet("|athletics", $valueArray); $athletics = parser::refineSnippet($athletics); // print_r($athletics); // needs further parsing if ($athletics == "") { $athletics = parser::deepParseSnippet("|free", $valueArray); // used $athletics for ease of adding to db $athletics = parser::refineSnippet($faculty); // print_r($athletics); // needs further parsing } $website = parser::parseSnippet("|website", $valueArray); if ($website == false) { $website = parser::parseSnippet("website", $valueArray); } if ($website == false) { $website = $this->getUrl(); } // print_r($website); $website = parser::refineSnippet($website); // print_r($website); // code to add to database "CollegeSummary" $college = str_replace("_", " ", $this->_college); $array = array("CollegeUrl" => "{$website}", "CollegeLocation" => "{$location}", "CollegePostGrads" => "{$postgrad}", "CollegeUnderGrads" => "{$undergrad}", "CollegeAcademicStaff" => "{$faculty}", "CollegeEndowmentFund" => "{$endowment}", "CollegeCampus" => "{$campus}", "CollegeType" => "{$type}", "CollegeEstablished" => "{$established}", "CollegePresident" => "{$president}"); $this->_dbConnection->updateTable("CollegeSummary", "CollegeSummary", "CollegeName", $college, "CollegeID", $array, "CollegeName = '{$college}'"); }