# Using the phpbb mysql information to make a members only section on my website

**URL:** <https://forum.kirupa.com/t/using-the-phpbb-mysql-information-to-make-a-members-only-section-on-my-website/186968>\
**Category:** Uncategorized\
**Created:** [April 25, 2006, 5:32pm UTC](https://forum.kirupa.com/t/using-the-phpbb-mysql-information-to-make-a-members-only-section-on-my-website/186968 "2006-04-25T17:32:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lemuel](https://avatars.discourse-cdn.com/v4/letter/l/f9ae1b/32.png) [@Lemuel](https://forum.kirupa.com/u/Lemuel)\
**Post date:** [April 25, 2006, 5:32pm UTC](https://forum.kirupa.com/t/using-the-phpbb-mysql-information-to-make-a-members-only-section-on-my-website/186968/1 "2006-04-25T17:32:11Z")

</div>

Hi I recently installed phpBB on my web server.  
(its a free forum software available from [http://phpbb.com](http://phpbb.com))

The website I’m building is for a club of mine. I was wondering if it was possible to access and use the Mysql database that stores the Forum users information to create a members only login for my website.

I need to have password protected pages for the members site but I don’t want to have just one password passed out to all members. Because if I wanted to lock out an ex-member I’d have to track down and contact every club member to give them the new login name and password.  
And having a system where I upload something like an updated text file containing login names and passwords everytime a new member joins sounds like a huge pain in the Adze.

If it isn’t possible to get and use the data from that database, does anyone know how I could setup a form or something that would add peoples name to that, or a different database with some kind of confirmation system? That way a non-member couldn’t just sign up for a login name and password without a admin or something accepting him/her and being able to run around the members site after filling out a 2 minute form.

Any suggestions or ideas would be a huge help.

Thanks for at least taking the time to read this.

-Lem

---

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [April 25, 2006, 6:40pm UTC](https://forum.kirupa.com/t/using-the-phpbb-mysql-information-to-make-a-members-only-section-on-my-website/186968/2 "2006-04-25T18:40:22Z")

</div>

yes it is possible!!!  
i have done this before  
ok…

1.On php my admin locate where usernames and passwords are stored.  
2.On dreamweaver 8, create a form with 2 input boxes and a submit button.  
3.Goto Application then “Log in user” if not done already follow…  
1.Goto Windows, Databases,  
2.Click on the "+"  
3. follow…  
1.Connection name: (Insert your connection name)  
2.MySQL server: (Insert your MySQL server)  
3.Username: (Insert your username)  
4.Password: (Insert your password)  
5.Database: (Click “Select” and choose the database your PHPBB stuff is in)

6.Now a windows should appear after pressing "Log in user"  
follow…  
Get input from: (select the form you wish to get username and pass from)  
USER/PASS field: (select the texboxes you want to specify username and password)

Validate using connection: (Choose the connection you just made)  
Table: (Choose the table in which your PHPBB stuff is in)  
Username collom: (Choose the collom which your PHPBB usernames are kept)  
Password collom: (Choose the collom which your PHPBB passwords are kept)

You should know what to do in the rest

Im not so certain if there are colloms there is a why thou

---

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [April 25, 2006, 6:52pm UTC](https://forum.kirupa.com/t/using-the-phpbb-mysql-information-to-make-a-members-only-section-on-my-website/186968/3 "2006-04-25T18:52:27Z")

</div>

Also may i ask are you running your own server???

---

<div class="post-metadata">

**Author:** ![Lemuel](https://avatars.discourse-cdn.com/v4/letter/l/f9ae1b/32.png) [@Lemuel](https://forum.kirupa.com/u/Lemuel)\
**Post date:** [April 25, 2006, 8:38pm UTC](https://forum.kirupa.com/t/using-the-phpbb-mysql-information-to-make-a-members-only-section-on-my-website/186968/4 "2006-04-25T20:38:00Z")

</div>

Thanks for the fast reply.  
I’ll follow your intructions right away.

> [@chris.jones071@](#):
>
> Also may i ask are you running your own server???

I’m not running my own server, I’m renting a server from Powweb.  
[http://www.Powweb.com](http://www.Powweb.com)

I don’t have access to a computer I could dedicate to hosting my own website, and my ISP would have a fit if I started getting traffic like that.

-Lem
