The tutorial didn't really tell me how to do that. Actually, I'm not telling Cake anywhere what DB to use. How and where can I set that?
On Thu, Sep 29, 2011 at 4:04 PM, Ryan Schmidt <[email protected]>wrote: > ......so you have a *database* called cake_posts that contains a *table* > called posts? > > Also, in your config I see you have chosen not to set up the $default > database config but instead to set up a new config called $cake_posts. Where > are you telling CakePHP that you want it to use the new $cake_posts config > instead of the $default config? > > > > On Sep 29, 2011, at 14:02, Yves S. Garret wrote: > > > Yes. I called the database cake_posts. Do I set something up so that it > points to that specific db? > > > > 2011/9/29 Vinícius Moraes de Araújo <[email protected]> > > You have the table posts created on your database ? > > > > Atenciosamente, > > > > Vinícius Moraes > > > > > > 2011/9/29 Yves S. Garret <[email protected]> > > By the way, this is my database.php file: > > > > <?php > > /** > > * This is core configuration file. > > * > > * Use it to configure core behaviour ofCake. > > * > > * PHP versions 4 and 5 > > * > > * CakePHP(tm) : Rapid Development Framework (http://cakephp.org) > > * Copyright 2005-2011, Cake Software Foundation, Inc. ( > http://cakefoundation.org) > > * > > * Licensed under The MIT License > > * Redistributions of files must retain the above copyright notice. > > * > > * @copyright Copyright 2005-2011, Cake Software Foundation, Inc. ( > http://cakefoundation.org) > > * @link http://cakephp.org CakePHP(tm) Project > > * @package cake > > * @subpackage cake.app.config > > * @since CakePHP(tm) v 0.2.9 > > * @license MIT License ( > http://www.opensource.org/licenses/mit-license.php) > > */ > > /** > > * In this file you set up your database connection details. > > * > > * @package cake > > * @subpackage cake.config > > */ > > /** > > * Database configuration class. > > * You can specify multiple configurations for production, development > and testing. > > * > > * driver => The name of a supported driver; valid options are as > follows: > > * mysql - MySQL 4 & 5, > > * mysqli - MySQL 4 & 5 Improved Interface (PHP5 only), > > * sqlite - SQLite (PHP5 only), > > * postgres - PostgreSQL 7 and higher, > > * mssql - Microsoft SQL Server 2000 and higher, > > * db2 - IBM DB2, Cloudscape, and Apache Derby ( > http://php.net/ibm-db2) > > * oracle - Oracle 8 and higher > > * firebird - Firebird/Interbase > > * sybase - Sybase ASE > > * adodb-[drivername] - ADOdb interface wrapper (see below), > > * odbc - ODBC DBO driver > > * > > * You can add custom database drivers (or override existing drivers) by > adding the > > * appropriate file to app/models/datasources/dbo. Drivers should be > named 'dbo_x.php', > > * where 'x' is the name of the database. > > * > > * persistent => true / false > > * Determines whether or not the database should use a persistent > connection > > * > > * connect => > > * ADOdb set the connect to one of these > > * (http://phplens.com/adodb/supported.databases.html) and > > * append it '|p' for persistent connection. (mssql|p for example, or > just mssql for not persistent) > > * For all other databases, this setting is deprecated. > > * > > * host => > > * the host you connect to the database. To add a socket or port number, > use 'port' => # > > * > > * prefix => > > * Uses the given prefix for all the tables in this database. This > setting can be overridden > > * on a per-table basis with the Model::$tablePrefix property. > > * > > * schema => > > * For Postgres and DB2, specifies which schema you would like to use the > tables in. Postgres defaults to > > * 'public', DB2 defaults to empty. > > * > > * encoding => > > * For MySQL, MySQLi, Postgres and DB2, specifies the character encoding > to use when connecting to the > > * database. Uses database default. > > * > > */ > > class DATABASE_CONFIG { > > > > var $default = array( > > 'driver' => 'mysqli', > > 'persistent' => false, > > 'host' => 'localhost', > > 'login' => 'root', > > 'password' => 'summer11', > > 'database' => 'mysql', > > 'prefix' => '', > > //'encoding' => 'utf8', > > ); > > > > var $cake_posts = array( > > 'driver' => 'mysqli', > > 'persistent' => false, > > 'host' => 'localhost', > > 'login' => 'root', > > 'password' => 'summer11', > > 'database' => 'cake_posts', > > 'prefix' => '', > > //'encoding' => 'utf8', > > ); > > > > var $doc_lookup = array( > > 'driver' => 'mysqli', > > 'persistent' => false, > > 'host' => 'localhost', > > 'login' => 'root', > > 'password' => 'summer11', > > 'database' => 'doc_lookup', > > 'prefix' => '', > > //'encoding' => 'utf8', > > ); > > > > var $test = array( > > 'driver' => 'mysql', > > 'persistent' => false, > > 'host' => 'localhost', > > 'login' => 'user', > > 'password' => 'password', > > 'database' => 'test_database_name', > > 'prefix' => '', > > //'encoding' => 'utf8', > > ); > > } > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
