Eu sei como se cria uma outra instancia, a quetao é que eu teria que primeiro buscar em um banco de dados pra depois criar uma OUTRA conexao. Sera que eu chamando um model por padrao rola?
2009/4/28 Djalma Araújo | www.djalmaaraujo.com.br <[email protected]> > Putz, eu acho que minha duvioda era justamente isso, e eu li a > documentacao, so que eu nao sintetizei, vlw pela tentativa mas n me ajudou. > > 2009/4/28 Eric Saboia (Fortes Informatica) <[email protected]> > > Hehaueheuahaeuhae, doeu o olho :D >> >> ----- Original Message ----- >> *From:* Marcus Cavalcanti <[email protected]> >> *To:* CodeIgniter Brasil <[email protected]> >> *Sent:* Tuesday, April 28, 2009 3:02 PM >> *Subject:* Re: [CodeIgniter]Utilizando segunda conexão de banco de dados >> dinâmica >> >> Manually Connecting >> >> If only some of your pages require database connectivity you can manually >> connect to your database by adding this line of code in any function where >> it is needed, or in your class constructor to make the database available >> globally in that class. >> $this->load->database(); >> >> If the above function does *not* contain any information in the first >> parameter it will connect to the group specified in your database config >> file. For most people, this is the preferred method of use. >> Available Parameters >> >> 1. The database connection values, passed either as an array or a DSN >> string. >> 2. TRUE/FALSE (boolean). Whether to return the connection ID (see >> Connecting to Multiple Databases below). >> 3. TRUE/FALSE (boolean). Whether to enable the Active Record class. >> Set to TRUE by default. >> >> Manually Connecting to a Database >> >> The first parameter of this function can *optionally* be used to specify >> a particular database group from your config file, or you can even submit >> connection values for a database that is not specified in your config file. >> Examples: >> >> To choose a specific group from your config file you can do this: >> $this->load->database('group_name'); >> >> Where group_name is the name of the connection group from your config >> file. >> >> To connect manually to a desired database you can pass an array of values: >> $config['hostname'] = "localhost"; >> $config['username'] = "myusername"; >> $config['password'] = "mypassword"; >> $config['database'] = "mydatabase"; >> $config['dbdriver'] = "mysql"; >> $config['dbprefix'] = ""; >> $config['pconnect'] = FALSE; >> $config['db_debug'] = TRUE; >> $config['cache_on'] = FALSE; >> $config['cachedir'] = ""; >> $config['char_set'] = "utf8"; >> $config['dbcollat'] = "utf8_general_ci"; >> >> $this->load->database($config); >> >> For information on each of these values please see the configuration >> page<http://codeigniter.com/user_guide/database/configuration.html> >> . >> >> Or you can submit your database values as a Data Source Name. DSNs must >> have this prototype: >> $dsn = 'dbdriver://username:passw...@hostname/database'; >> >> $this->load->database($dsn); >> >> To override default config values when connecting with a DSN string, add >> the config variables as a query string. >> $dsn = 'dbdriver://username:passw...@hostname >> /database?char_set=utf8&dbcollat=utf8_general_ci&cache_on=true&cachedir=/path/to/cache'; >> >> $this->load->database($dsn); Connecting to Multiple Databases >> >> If you need to connect to more than one database simultaneously you can do >> so as follows: >> $DB1 = $this->load->database('group_one', TRUE); >> $DB2 = $this->load->database('group_two', TRUE); >> >> Note: Change the words "group_one" and "group_two" to the specific group >> names you are connecting to (or you can pass the connection values as >> indicated above). >> >> By setting the second parameter to TRUE (boolean) the function will return >> the database object. >> >> When you connect this way, you will use your object name to issue commands >> rather than the syntax used throughout this guide. In other words, rather >> than issuing commands with: >> >> $this->db->query(); >> $this->db->result(); >> etc... >> >> You will instead use: >> >> $DB1->query(); >> $DB1->result(); >> etc... >> >> >> -- >> Marcus Cavalcanti >> 21 9144-5068 >> www.marcuscavalcanti.net/blog >> >> >> 2009/4/28 Djalma Araújo | www.djalmaaraujo.com.br < >> [email protected]> >> >>> Opa, quando eu configuro no database.php além da conexão default uma >>> outra é blza. Sem broncas. Mas eu pergunto a vocês, qual seria a melhor >>> solução para eessa conexão ser dinâmica, por exemplo, eu acessaria outro >>> site remotamente. Então eu não posso ter fixo no database.php a conexão, >>> pois ela poderá ser qualquer uma. >>> >>> Alguém tem uma sugestão? >>> >>> >>> >>> -- >>> Atenciosamente, >>> Djalma Araújo >>> Consultor / Desenvolvedor WEB. >>> www.djalmaaraujo.com.br >>> >>> _______________________________________________ >>> Lista mailing list >>> [email protected] >>> http://codeigniter.com.br/mailman/listinfo/lista_codeigniter.com.br >>> >>> >> ------------------------------ >> >> _______________________________________________ >> Lista mailing list >> [email protected] >> http://codeigniter.com.br/mailman/listinfo/lista_codeigniter.com.br >> >> >> _______________________________________________ >> Lista mailing list >> [email protected] >> http://codeigniter.com.br/mailman/listinfo/lista_codeigniter.com.br >> >> > > > -- > Atenciosamente, > Djalma Araújo > Consultor / Desenvolvedor WEB. > www.djalmaaraujo.com.br > -- Atenciosamente, Djalma Araújo Consultor / Desenvolvedor WEB. www.djalmaaraujo.com.br
_______________________________________________ Lista mailing list [email protected] http://codeigniter.com.br/mailman/listinfo/lista_codeigniter.com.br
