phpBB – axew3.com

phpBB WordPress Integration Common Tasks extension

This is the main referral page for the

phpBB WordPress Integration – phpBB extension

You’ll find here the updated link to download the extension and/or detailed help on how to install and use it

phpBB WordPress Integration – phpBB extension

How to connect to external database using phpBB db classes

This is the simply way to connect to an external database in phpBB (we go to use mysql lib here, but you could use another of these available in /phpbb32/phpbb/db/driver folder changing namespace (if on php7> you need to use mysqli and NOT mysql or you’ll get error) using phpBB db classes

$w3dbhost = 'localhost';
$w3dbuser = 'root';
$w3dbpass = 'apass';
$w3dbname = 'mydbname';
$phpbb_c = new \phpbb\db\driver\mysql();
$phpbb_c->sql_connect($w3dbhost, $w3dbuser, $w3dbpass, $w3dbname, $port = false, $persistency = false, $new_link = false);
$sql = "SELECT * FROM myTable";
$result = $phpbb_c->sql_query($sql);
while ($row = $phpbb_c->sql_fetchrow($result))
{
	print_r($row);
}
$phpbb_c->sql_close($result);

$w3dbhost = 'localhost';

$w3dbuser = 'root';

$w3dbpass = 'apass';

$w3dbname = 'mydbname';

$phpbb_c = new \phpbb\db\driver\mysql();

$phpbb_c->sql_connect($w3dbhost, $w3dbuser, $w3dbpass, $w3dbname, $port = false, $persistency = false, $new_link = false);

$sql = "SELECT * FROM myTable";

$result = $phpbb_c->sql_query($sql);

while ($row = $phpbb_c->sql_fetchrow($result))

{

print_r($row);

}

$phpbb_c->sql_close($result);

This is it.

Note: if on Php7 > change line

$phpbb_c = new \phpbb\db\driver\mysql();
into
$phpbb_c = new \phpbb\db\driver\mysqli();

to switch and use mysqli.

WordPress phpBB integration plugin

WordPress w3all phpBB integration

Easy, light, powerful, secure!

It is ready to download and install on your WordPress the WordPress phpBB integration plugin – WP w3all phpbb page at WordPress plugins

Easy and extended documentation available here:

WordPress phpBB integration plugin help

A WordPress phpBB integration done with this plugin, give you:

Latest forums topics to display on blogs pages

WP users transfer to phpBB

phpBB template integration into WordPress