db.php:
Code: Selecteer alles
<?php
$dbhost = "ip.naar.je.sam.doos";
$dbuser = "samgebruiker";
$dbpass = "samwachtwoord";
$dbname = "samdatabase";
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ("Error connecting to mysql");
mysql_select_db($dbname);
?>
Code: Selecteer alles
<?php require("db.php"); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Muziekjes sleep geval ...</title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.5.js"></script>
<script type="text/javascript" src="jquery-ui-1.7.1.custom.min.js"></script>
<link rel="stylesheet" href="../base.css" media="screen" type="text/css" />
<style>
ul {
padding: 0;
margin:0;
}
#contentWrap {
width: 570px;
margin-left:auto;
margin-right:auto;
}
#contentTop {
width: 550px;
padding:10px;
height:50px;
}
#contentGelukt {
width: 548px;
padding:10px;
background-color:#fff08c;
height:150px;
border: #a90f0f solid 1px;
color:#000;
font-weight:bold;
font-size:40px;
background-image:url('https://s3-eu-west-1.amazonaws.com/production.agenda-uitgaan.nl/shared/system/images/productions/title/48625/newkids_kleiner.jpg');
background-repeat:no-repeat;
}
#contentLeft {
}
#contentLeft li {
list-style-type: none;
padding: 10px;
margin:0 0 4px 0;
border: #CCCCCC solid 1px;
}
</style>
<script type="text/javascript">
$(document).ready(function(){
$('#contentGelukt').hide();
$(function() {
$("#contentLeft ul").sortable({ opacity: 0.6, cursor: 'move', update: function() {
var order = $(this).sortable("serialize") + '&action=updateRecordsListings';
$.post("updateDB.php", order, function(theResponse){
$("#contentGelukt").html(theResponse).delay(100).slideDown(200).fadeIn(500).delay(1000).slideUp(200).fadeOut(500);
window.setTimeout('location.reload()', 2500);
});
}
});
});
});
window.setTimeout('location.reload()', 60000);
</script>
</head>
<body>
<div id="contentWrap">
<h1>Playlist'0'nat0r</h1>
<table class="results_header_table" cellpadding="5" cellspacing="0">
<tr>
<td>Sleep de nummers heen en weer voor een andere volgorde!</td>
</tr>
</table>
<div id="contentGelukt"></div>
<div id="contentLeft">
<ul>
<?php
$query = "SELECT * FROM queuelist, songlist WHERE queuelist.songID = songlist.ID ORDER BY sortID ASC";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
$classname = ($a++ % 2) ? "ACP_even" : "ACP_oneven";
?><li class="<?php if ($row['requestID'] != 0) { echo ('ACP_verzoek');} else {echo $classname; } ?>" id="recordsArray_<?php echo $row['songID']; ?>"><img title='Artist' src='../images/icons/user_silhouette.png' border='0' width='16' height='16' alt='Artist' /> <span><?php echo $row['artist'] . "</span> <br /> <img title='Title' src='../images/icons/music.png' border='0' width='16' height='16' alt='Title' /> " . $row['title']; ?>
</li>
<?php } ?>
</ul>
</div>
</div>
</body>
</html>
updateDB.php:
Code: Selecteer alles
<?php
require("db.php");
$action = mysql_real_escape_string($_POST['action']);
$updateRecordsArray = $_POST['recordsArray'];
if ($action == "updateRecordsListings"){
$listingCounter = 1;
foreach ($updateRecordsArray as $recordIDValue) {
$query = "UPDATE queuelist SET sortID = " . $listingCounter . " WHERE songID = " . $recordIDValue;
mysql_query($query) or die('Error, insert query failed');
$listingCounter = $listingCounter + 1;
}
echo 'Tis gelukt JONGUH!';
}
?>
