Exemplo n.º 1
0
 /**
  * File/Folder safe name of song
  *
  * @return string
  * @throws SMException
  */
 public function getFileSafeTitle()
 {
     if (empty($this->song)) {
         throw new SMException('Song myst be set');
     }
     return Utility::GenerateSafeFileName($this->song->getTitle());
 }
Exemplo n.º 2
0
<?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();