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
