PlayerSQL Example

<table border="0">
<font face="verdana" size="2">
<?php
// Made by Smiba (bartsmienk)
// DO NOT REMOVE THESE LINES
// http://dev.bukkit.org/bukkit-plugins/playersql/

$connect = mysql_connect(localhost,username,password);
if (!$connect)
  {die('MySQL error: ' . mysql_error());}
mysql_select_db('users_main', $connect);
$sql = mysql_query("SELECT * FROM players") or die(mysql_error());
$sql_PlayerNames = array();
while ($row_user = mysql_fetch_assoc($sql)){
    $sql_PlayerNames[] = $row_user;
}
$online = 0;
$playernmr = 0;
foreach($sql_PlayerNames as $usrinfo){
    $online = $online + 1;
    $playernmr = $playernmr + 1;
}
echo "Online players: " .$online. "<br />";
echo "<b>play.minecraft.nl (" .$playernmr. "):</b><br />";
foreach($sql_PlayerNames as $usrinfo){
    echo '<img width="16px" height="16px" src="http://achievecraft.com/tools/avatar/16/'.$usrinfo['playername'].'.png"> ';
    echo $usrinfo['playername']. "<br />";
}
if (!$sql_PlayerNames){
echo "Er zijn geen spelers online <br />";
}
echo "<br />";
mysql_close($connect);
?>
</font>
</table>