function insertComposersOnDB() { $db = new MysqliDb(HOST, USER, PASSWORD, DBNAME); $composers = getListComposersDb(); foreach ($composers as $index => $composer) { $compositions = extractCompositionsFromSearchHtmls($composer['name']); foreach ($compositions as $composition) { echo "Inserting " . $composition . "..." . PHP_EOL; $relevance = $index + 1; $query = "INSERT INTO `compositions`(`composer_id`,`name`,`relevance`)"; $query .= " VALUES ('" . $composer['id'] . "','" . escapeSingleQuote($composition) . "','" . $relevance . "');"; $db->rawQuery($query); } } }
function getCompositions() { $composers = getListComposers(); $composers = array_slice($composers, 0, 2); foreach ($composers as $composer) { // We first save the HTMLs of the search "[composer] + compositions" saveHtmlSearchComposerCompositions($composer); // Once saved, we extract the compositions $compositions = extractCompositionsFromSearchHtmls($composer); $compositions = array_slice($compositions, 0, 1); // For each composition, let's try to retrieve the info from Wikipedia foreach ($compositions as $composition) { // TODO: THIS IS NOT DONE! getWikipediaPageForComposition($composition); } } }