Session w/multiple databases ? |
[eluser]krsanky[/eluser]
I want to try using a database with my sessions. The issue is I have two databases. The default and most oft used database is a MS Sql Server instance on another machine. The webserver also has a local Mysql database running. I want to connect to the local mysql one for session stuff. To get this to work (using the NOT default database with sessions) I had to edit the Session.php library file. It seems to work, but is this the right way? (or is there a better way?) Basically I changed the way that Session.php loads the database: Code: //$this->CI->load->database('local'); The commented out line is the original. I then did a search/replace from Code: $this->CI->db Code: $this->CI->local_db Like I said it seems fine, but I don't like editing the core library stuff. So is there a better way? thanks, paul w
[eluser]Randy Casburn[/eluser]
You should really use a separate library file named MY_session or something and place it in your application/libraries directory. This way you can override the native session library without hacking the core library. Here is a file for you to work with: http://ellislab.com/forums/viewthread/89886/ I too need to support multiple databases with sessions. If this is something that is important to you, then add a comment to the post above and see if there is other interest in the community. Maybe someone else is interested too. Randy |
Welcome Guest, Not a member yet? Register Sign In |