vb.org Archive - Getting Data from vb Database

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Getting Data from vb Database (https://vborg.vbsupport.ru/showthread.php?t=126803)

tsptom

09-16-2006 11:59 PM

Getting Data from vb Database

On the homepage of my website (not the forum), I list the total number of board members I have. I currently have this hard coded and have been updating this manually each night. Does anyone have any code (html or php) that would automate this - like connect to the vb database and do a Select count(*) from user, and display it?

I'm not sure how to do it.

Thanks

nico_swd

09-19-2006 01:14 PM

PHP Code:


		
			


include('./forum_path/global.php');



$query = $db->query("SELECT COUNT(*) AS total FROM ". TABLE_PREFIX ."user");

$users = $db->fetch_array($query);



echo 'Total users: '. $users['total'];

grazianno

09-19-2006 02:16 PM

thx nico_swd

tsptom

09-19-2006 05:07 PM

Yes, thank you! I'll give that a shot.

nico_swd

09-19-2006 06:23 PM

Note that this code would mess up the "who's online" page since the page where you're gonna put it in is not defined. You can add these lines before including the global.php file to avoid that.

PHP Code:


		
			
define('THIS_SCRIPT', basename($_SERVER['PHP_SELF'], '.php'));

define('LOCATION_BYPASS', 1);

All times are GMT. The time now is 05:03 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00984 seconds Memory Usage 1,715KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: