Hallo Tweakers,
Ik probeer mijn winamp playlist in php te krijgen zodat mensen kunnen stemmen welk nummer er draait.
Dit heb ik gedaan door middel van dit topic:
[topic=188484/1/50]
Nu wil het feit dat mn Mysql Database (heb al gedowngrade van 4 alpha om zeker te weten dat het niet aan de database ligt.) gigantisch zit te bokken.
Ik krijg steeds deze error:
http://www.atteveld.cistron.nl/mp3.JPG
Dit is mn index.php
Weet iemand wat ik hier aan kan doen?
Bedankt
Ik probeer mijn winamp playlist in php te krijgen zodat mensen kunnen stemmen welk nummer er draait.
Dit heb ik gedaan door middel van dit topic:
[topic=188484/1/50]
Nu wil het feit dat mn Mysql Database (heb al gedowngrade van 4 alpha om zeker te weten dat het niet aan de database ligt.) gigantisch zit te bokken.
Ik krijg steeds deze error:
http://www.atteveld.cistron.nl/mp3.JPG
Dit is mn index.php
PHP:
1
| <? // // MP3vote (Freeware) by Michel Arendsen, 2001 < michel@arendsen-webdevelopment.nl > // It is a bit of a mess, but it works ;) //include("conf.php");$conn = mysql_connect($dbserver, $dbuser, $dbpasswd);function give_me_next() {global $conn, $db; $pquery = "select * from playlist where (votes <> 0) order by votes desc, pid asc limit 1"; $presult = mysql_db_query($db, $pquery); $counti = mysql_numrows($presult); if ($counti<>0) { $p = mysql_fetch_array($presult); $pid = $p["pid"]; $title = $p["title"]; echo "$pid: $title"; } else { echo "No votes: Playing random"; }}echo "<html>";echo "<title>MP3vote</title>";echo "</head>";echo "";echo "<body link=\"#000080\" vlink=\"#000080\" alink=\"#000080\">";echo "";if (!isset($wat)) {echo "<font face=\"Verdana\"><h2>MP3vote v1.1-beta</h2></font>";echo "<font size=\"2\" face=\"Verdana\">";check_if_running();echo "Now playing: <b>'";include("$urlPlay?wat=track"); [b]REGEL 44[/b]// Try this of the include fails??//$fp = fopen("$urlPlay?wat=track","r");//$fp2 = fgets($fp, 4096);//echo "$fp2";echo "'</b><br>Next: '";echo give_me_next();echo "'<br><a href='list.php'>Voted playlist</a></font><br><br>";echo " <table border=\"0\" width=\"464\" height=\"33\">";echo " <tr>";echo " <td width=\"19\" height=\"11\" bgcolor=\"#C0C0C0\"><b><font size=\"2\" face=\"Verdana\">ID</font></b></td>";echo " <td width=\"344\" height=\"11\" bgcolor=\"#C0C0C0\"><b><font size=\"2\" face=\"Verdana\">&nbsp;<a href='index.php?order=title'>Title</a></font></b></td>";echo " <td width=\"79\" height=\"11\" bgcolor=\"#C0C0C0\"><font size=\"2\" face=\"Verdana\"><b><a href='index.php?order=rank'>Vote</a></b></font></td>";echo " </tr>";if (!isset($order)) { $pquery = "select * from playlist order by pid";} else if ($order=="rank") { $pquery = "select * from playlist order by votes desc";} else if ($order=="title") { $pquery = "select * from playlist order by title";} $presult = mysql_db_query($db, $pquery); if ($presult) { while ($p = mysql_fetch_array($presult)) { $pid = $p["pid"]; $title = $p["title"];echo " <tr>";echo " <td width=\"19\" height=\"10\"><font size=\"2\" face=\"Verdana\">$pid</font></td>";echo " <td width=\"344\" height=\"10\"><font size=\"2\" face=\"Verdana\">$title</font></td>";echo " <td width=\"79\" height=\"10\"><font size=\"2\" face=\"Verdana\">[<a href=\"index.php?wat=vote&id=$pid\">vote</a>]</font></td>";echo " </tr>"; }}echo " </table>";}if ($wat=="vote" && isset($id)) {mysql_connect($dbserver, $dbuser, $dbpasswd); $pquery = "select * from playlist where pid = '$id'"; $presult = mysql_db_query($db, $pquery); if ($presult) { while ($p = mysql_fetch_array($presult)) { $pid = $p["pid"]; $title = addslashes($p["title"]); $votes = ($p["votes"])+1; $squery = "select vid from votes where title='$title' and ip='$REMOTE_ADDR' and DATE_ADD(datum, interval $min_vote MINUTE) > now()"; $sresult = mysql_db_query($db, $squery); $counts = mysql_numrows($sresult); if ($counts==0) { $query = "update playlist set votes='$votes' where pid='$pid'"; $result = mysql_db_query($db, $query); $datum = date("Y-m-d H:i:s"); $iquery = "insert into votes values(NULL, '$title', '$REMOTE_ADDR', '$datum')"; $iresult = mysql_db_query($db, $iquery); if ($result) { echo "<font size=\"2\" face=\"Verdana\">Your vote has been processed...<br>Total vote count for '$title' is $votes</font>"; } } else { echo "<font size=\"2\" face=\"Verdana\"><b>Sorry</b>, you are not allowed to vote more times in $min_vote minutes for the same song.</font>"; } } } echo "<br><br>[<a href='index.php'>terug</a>]";}echo "<p align='right'><font size=\"1\" align='right' face=\"Verdana\">MP3vote - &copy M. Arendsen, 2001</font></p>";echo "</body>";echo "";echo "</html>";?> |
Weet iemand wat ik hier aan kan doen?
Bedankt
. Die lees ik echt wel hoor 
Maar goed, ik ben in een vriendelijke bui 
Dit topic is gesloten.
