I think there is a misunderstanding how databases work. You need only ONE database. The name of that one you add to the database.php file (as default db). Then u create a TABLE 'posts' in that database. If you add more models later, you just create more tables, but u always use the same db.
Hope that helps -flosky "Larry E. Masters" <[email protected]> schrieb: Did you read the part about conventions? Where did you see name your table cake_posts? Try following conventions first then look at moving onto more advanced things. -- Larry E. Masters On Thu, Sep 29, 2011 at 9:29 PM, Yves S. Garret <[email protected]> wrote: 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 -- 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
