Several database connection

PosInfo

I want to have 4 or 5 mysql databases...for better organisation of my network project.

Can I in one page , made with several include function , to have multiple connections?

Each include page that connects with its own mysql database.
I want to have 3 or 4 users...some of them will see only 1 include and others will have to see 3-4 includes (each include connects with its own database).

Is that possible?

laserlight

I want to have 4 or 5 mysql databases...for better organisation of my network project.

What is wrong with having a single database, but using access control appropriately?

PosInfo

Well..I dont know what is wrong...but I just want to make it simple as it can get...for my first steps in php/mysql...

halojoy

I agree with laserlight
for most website applications it is enough to use 1 database.
And one connection script to this db.
In your db you can create many 'tables'8/b].

the usual way is to have 1 'users' table, for registred members
php ACL scripts <- search gooogle
have Access Control Levels
and this is 1 field/column in the 'users' table

This can be a 'number' or a 'group'
and sometimes both a number level and groups.

Group can be 'guest' 'newbie' 'regular' 'vip' 'moderator' 'admin' 'owner' 'whatever'
Levels can be simnply: 0 1 2 3 4 5 6 7 8 or 9
And your script would check each login to see what Access Level this person has got.

🙂