[resources.invisionpower.com - pliki] Tips and Tricks > Show your Forus ebers on your Website

[DawPi]

Hi Guys!

Ever wanted to display how many members you have, their posts, and when they joined on your website? If you do I have this simple code that will do so for you.

<?

/*

Forum Members display script by Fishfish0001

Do not remove this

*/

?>

<table width=95%% border=0 cellpadding=3 cellspacing=1 >

<tr>

<td>Username</td>

<td>Joined</td>

<td>Posts</td>

<br />

<?php

// Make a MySQL Connection

$host="localhost";

$username="";

$password="";

$database="";

$table="ibf_members";

$query = "SELECT * FROM $table";

mysql_connect("$host", "$username", "$password") or die(mysql_error());

echo "";

mysql_select_db("$database") or die(mysql_error());

echo "Database is Active...<br />";

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){

echo "<tr>";

echo "<td>";

echo $row['name'];

echo "</td>";

echo "<td>";

echo gmstrftime( '%d-%B %y', $row['joined'] );

echo "</td>";

echo "<td>";

echo $row['posts'];

echo "</td>";

echo "<br />";

}

?>

</tr>

</table>

Wyświetl pełny artykuł