PHP labelCheck Examples

Example #1

File: library_functions.php Project: wsbf/new.wsbf.net-old

/** FOR USE BY review_backend.php (mode INSERT) **/
function reviewAlbum($albumID, $album_name, $album_code, $artist_name, $label, $genre, $general_genreID, $review, $username, $reviewer, $rotation)
{
    if (!is_numeric($albumID)) {
        return FALSE;
    }
    if (!is_numeric($general_genreID)) {
        return FALSE;
    }
    $album_name = mysql_real_escape_string($album_name);
    $genre = mysql_real_escape_string($genre);
    $review = mysql_real_escape_string($review);
    $username = mysql_real_escape_string($username);
    $reviewer = mysql_real_escape_string($reviewer);
    $rotation = mysql_real_escape_string($rotation);
    $artistID = artistCheck($artist_name);
    if (!$artistID) {
        $artistID = insertArtist($artist_name);
    }
    if (!($labelID = labelCheck($label))) {
        $labelID = insertLabel($label);
    }
    if ($album_code == $albumID) {
        $album_code = getNewAlbumCode();
        $rotation = 7;
    }
    $query = sprintf("UPDATE libalbum SET album_name='%s', album_code='%s', artistID='%d', labelID='%d', genre='%s', general_genreID='%d', rotationID='%d' WHERE albumID = '%d'", $album_name, $album_code, $artistID, $labelID, $genre, $general_genreID, $rotation, $albumID);
    mysql_query($query) or die("reviewAlbum failed : " . mysql_error());
    $query = sprintf("REPLACE INTO libreview (albumID, review, username, reviewer) VALUES ('%d', '%s', '%s', '%s')", $albumID, $review, $username, $reviewer);
    mysql_query($query) or die("reviewAlbumSubmitReview failed : " . mysql_error());
    return TRUE;
}

Example #2

File: import_submit.php Project: wsbf/new.wsbf.net-old

echo "<h1>PRELIMINARY IMPORT SYSTEM</h1>\n";
echo "<h3>Import Submission/Confirmation</h3>\n";
echo "<p>Go <a href='" . urldecode($_POST['redirect']) . "'>back</a>...</p>\n";
echo "<div id='contents'>";
$artist = trim($_POST['artist']);
$album = trim($_POST['album']);
$label = trim($_POST['label']);
$genre = trim($_POST['genre']);
$general_genreID = $_POST['general_genreID'];
$medium = $_POST['medium'];
$number_of_discs = sprintf("%d", $_POST['number_of_discs']);
if ($artist == "" || $album == "") {
    die("Please fill in artist and album!");
}
if ($label != "") {
    $lID = labelCheck($label);
    if ($lID) {
        echo "Label already exists: {$lID} for {$label}<br>";
    } else {
        $lID = insertLabel($label);
        echo "New label ID: {$lID} for {$label}<br>";
    }
} else {
    $lID = LABEL_DUMMY;
}
$aID = artistCheck($artist);
if ($aID) {
    echo "Artist already exists: {$aID}<br>";
} else {
    $aID = insertArtist($artist);
    echo "New artist ID: {$aID} for {$artist}<br>";