/**
* public function wikiLinks()
* Postcondition: the links from wikipedia are stored into Database.
*/
public function wikiLinks()
{
$parentTitlesArray = $this->getLinks($this->_college);
$titlesArray = array();
for ($i = 0; $i < count($parentTitlesArray); $i++) {
$titlesArray[$i] = $parentTitlesArray[$i]["title"];
}
// pass titlesArray to abhi's urlparser method, will sort and check titles
// print_r($titlesArray);
$processedArray = urlParser::parseContent($titlesArray);
// add comment about structure of parseContent.....
// code to input into db
$college = str_replace("_", " ", $this->_college);
print_r($processedArray);
for ($i = 0; $i < count($processedArray); $i++) {
if ($processedArray[$i][1] == "sports") {
$array = array("CollegeDivSports" => "{$processedArray[$i][0]}", "CollegeID" => "");
$this->_dbConnection->insertIntoTable("CollegeDivSports", "CollegeSummary", "CollegeName", $college, "CollegeID", $array);
} elseif ($processedArray[$i][1] == "clubs") {
$array = array("CollegeClub" => "{$processedArray[$i][0]}", "CollegeID" => "");
$this->_dbConnection->insertIntoTable("CollegeClubs", "CollegeSummary", "CollegeName", $college, "CollegeID", $array);
} elseif ($processedArray[$i][1] == "research") {
$array = array("CollegeResearch" => "{$processedArray[$i][0]}", "CollegeID" => "");
$this->_dbConnection->insertIntoTable("CollegeResearch", "CollegeSummary", "CollegeName", $college, "CollegeID", $array);
} elseif ($processedArray[$i][1] == "arts") {
$array = array("CollegeArt" => "{$processedArray[$i][0]}", "CollegeID" => "");
$this->_dbConnection->insertIntoTable("CollegeArts", "CollegeSummary", "CollegeName", $college, "CollegeID", $array);
} else {
$array = array("CollegeLink" => "{$processedArray[$i][0]}", "CollegeID" => "", "LinkTag" => "{$processedArray[$i][1]}");
$this->_dbConnection->insertIntoTable("CollegeLinks", "CollegeSummary", "CollegeName", $college, "CollegeID", $array);
}
}
}
