Are there any PHP Frameworks (e.g. CodeIgniter) that support database connections on a per user acco
Posted
by Brad G
on Stack Overflow
See other posts from Stack Overflow
or by Brad G
Published on 2010-04-22T22:11:59Z
Indexed on
2010/04/22
22:13 UTC
Read the original article
Hit count: 237
I'm looking into developing a multi-tenant SaaS application, and I found several sites that describe a solid way to separate the data using tenantIDs and updateable views. e.g. This blog post
It all hinges on the ability to have your user accounts authenticated from a master users table and then having their respective database connections use those user-specific credentials. This way, the views can pull the userid and map it to the tenantID to display that user's view. However, most PHP frameworks tend to be very static when it comes to database connections (stored in text config files). They appear to be at odds.
Does anyone know: a) how to make CodeIgniter handle this gracefully? b) a different PHP framework that might?
© Stack Overflow or respective owner
