function insertCompositionsOnDB() { $composers = getListComposers(); foreach ($composers as $index => $composer) { $slug = getSlugComposer($composer); $relevance = $index + 1; $db = new MysqliDb(HOST, USER, PASSWORD, DBNAME); $query = "INSERT INTO `composers`(`slug`,`name`,`relevance`)"; $query .= " VALUES ('" . $slug . "','" . $composer . "','" . $relevance . "');"; echo $query . PHP_EOL; $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); } } }