本文整理匯總了PHP中Song::getLyricsFromAPI方法的典型用法代碼示例。如果您正苦於以下問題：PHP Song::getLyricsFromAPI方法的具體用法？PHP Song::getLyricsFromAPI怎麽用？PHP Song::getLyricsFromAPI使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Song的用法示例。
在下文中一共展示了Song::getLyricsFromAPI方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: while
<?php
require_once "config/config.inc";
$db = $_SESSION['db'];
$stmt = $db->prepare("select id from song;");
$stmt->execute();
while ($s = $stmt->fetch(PDO::FETCH_NUM)) {
$song = new Song($s[0]);
$lyrics = Song::getLyricsFromAPI($song->getMainArtist(), $song->getTitle());
$stmt2 = $db->prepare("update song set lyrics = :lyrics where id = :id;");
$stmt2->bindParam("lyrics", $lyrics, PDO::PARAM_STR);
$stmt2->bindParam("id", $s, PDO::PARAM_INT);
if ($stmt2->execute()) {
print 1;
} else {
print 0;
}
$stmt2->closeCursor();
}
$stmt->closeCursor();示例2: explode
$stmt->closeCursor();
}
# BELONG
$title_genres = explode("%@", $_POST['genres_' . $n]);
foreach ($title_genres as $genre) {
$stmt = $db->prepare("select id from genre where label = ?;");
$stmt->execute(array($genre));
$genre_id = $stmt->fetch(PDO::FETCH_NUM);
$stmt->closeCursor();
$genre_id = $genre_id[0];
$stmt = $db->prepare("insert into belong (song, genre) values (:song, :genre);");
$stmt->execute(array("song" => $song_id, "genre" => $genre_id));
$stmt->closeCursor();
}
# LYRICS
$lyrics = Song::getLyricsFromAPI($title_artists[0], $title);
$stmt = $db->prepare("update song set lyrics = :lyrics where id = :id;");
$stmt->bindParam("lyrics", $lyrics, PDO::PARAM_STR);
$stmt->bindParam("id", $song_id, PDO::PARAM_INT);
$stmt->execute();
$stmt->closeCursor();
# ARTWORK
Album::storeArtworkFromAPI($album_id);
# KNOWN
$stmt = $db->prepare("insert into know (user, song, owned, date) values (:user, :song, 0, unix_timestamp());");
$stmt->bindParam("user", $_SESSION['user']->getId(), PDO::PARAM_INT);
$stmt->bindParam("song", $song_id, PDO::PARAM_INT);
$stmt->execute();
$stmt->closeCursor();
$n++;
}