Pixel2Life Forum > Displaying IPB Stats

Pixel2Life Forum > Member Tutorials and Requests > Forum Tutorial Archives > PHP Tutorials

Slashman X

Mar 30 2007, 05:26 PM

Didnt see it posted here so i thought i'd post a tut for this

CODE

<?php
    //CONNECT TO FORUMS DB//
  $conn = mysql_connect("localhost","FORUMSDBUSERNAME","DBPASSWORD");
   mysql_select_db(FORUMDBNAME) or die(mysql_error());
$members = mysql_query("SELECT * FROM ibf_members");//Selects the member db
$total_members = mysql_num_rows ($members);//Counts the # of rows of member db
$posts = mysql_query("SELECT * FROM ibf_posts");//Selects post db
$total_posts = mysql_num_rows ($posts);//Counts rows of post db

?>

Put That At the top of the page, replace capital letters in $conn

Now somewhere in your page put

CODE

<?php
echo $total_members;

echo $total_posts;
?>

to show the stats

Xuxiix

Apr 2 2007, 06:21 AM

This isn't much of a tutorial. And, about this: "Put That At the top of the page, replace capital letters in $conn." What about the "FORUMDBNAME" in mysql_secelt_db? They don't have to edit that? (Because it's not in $conn.) Oh, and also, what if they aren't runnning their MySQL server on localhost? (Although I know most people does.) You should also describe it some more.

Ahh well, too much critism, and maybe I'm just expecting more from tutorials. By the way, it's a nice cool little trick.

Kkthxbai.