Please add your name to place a request.';
exit();
} else {
$reqsongID = $songid;
settype($reqsongID, 'integer');
if (empty($reqname)){
$reqname = 'Guest of '.SITE_NAME.'';
}else{
$reqname = $reqname;
}
if (empty($rmessage)){
$reqmsg = '';
}else{
$reqmsg = $rmessage;
}
$sqlinsertreq = "INSERT INTO `requests` SET `songID`='$reqsongID', `username`='$reqname', `userIP`='$reqip', `message`='$rmessage', `requested`=now();";
$resultreq = mysqli_query($db_conx, $sqlinsertreq);
if($resultreq > 0) {
$sqlselect = mysqli_query($db_conx, "SELECT `artist`, `title` FROM `songs` WHERE `ID`='$reqsongID' ",1);
while($row = mysqli_fetch_array($sqlselect)){
$artist = $row["artist"];
$title = $row["title"];
}
echo '
Request Successful
You\'ve requested '.$title.' by '.$artist.' to be played.
Thank you '.$reqname.'!
'.$reqmsg.'
';
} else {
echo '
ALERT: SORRY!
Something went wrong.
';
}
}
?>