What is not working exactly? What is the error? I suggest you read the complete 3.0 ORM manual before going further, it will hopefully answer the questions you have about it.
On Tuesday, March 4, 2014 7:06:13 PM UTC+1, Bayezid Alam wrote: > > > after updating, Its not working, i may missing anything. > > 'Datasources' => [ > 'default' => [ > 'className' => 'Cake\Database\Connection', > 'driver' => 'Cake\Database\Driver\Mysql', > 'persistent' => false, > 'host' => 'localhost', > 'login' => 'loginname', > 'password' => 'password', > 'database' => 'cake3_db', > 'prefix' => false, > 'encoding' => 'utf8', > ], > > /** > * The test connection is used during the test suite. > */ > 'test' => [ > 'className' => 'Cake\Database\Connection', > 'driver' => 'Cake\Database\Driver\Mysql', > 'persistent' => false, > 'host' => 'localhost', > 'login' => 'my_app', > 'password' => 'secret', > 'database' => 'test_myapp', > 'prefix' => false, > 'encoding' => 'utf8', > ], > ], > > > *after executing pr(), getting below msg* > > Cake\ORM\Query Object > ( > [_hasFields:protected] => > [_useBufferedResults:protected] => 1 > [_hydrate:protected] => 1 > [_counter:protected] => > [_eagerLoader:protected] => > [_connection:protected] => Cake\Database\Connection Object > ( > [_config:protected] => Array > ( > [driver] => Cake\Database\Driver\Mysql > [persistent] => > [host] => localhost > [login] => loginname > [password] => password > [database] => cake3_db > [prefix] => > [encoding] => utf8 > [name] => default > ) > > [_driver:protected] => Cake\Database\Driver\Mysql Object > ( > [_baseConfig:protected] => Array > ( > [persistent] => 1 > [host] => localhost > [login] => loginname > [password] => > [database] => cake > [port] => 3306 > [flags] => Array > ( > ) > > [encoding] => utf8 > [timezone] => > [init] => Array > ( > ) > > [dsn] => > ) > > [_config:protected] => Array > ( > [driver] => Cake\Database\Driver\Mysql > [persistent] => > [host] => localhost > [login] => loginname > [password] => password > [database] => cake3_db > [prefix] => > [encoding] => utf8 > [name] => default > [port] => 3306 > [flags] => Array > ( > ) > > [timezone] => > [init] => Array > ( > ) > > [dsn] => > ) > > [_autoQuoting:protected] => > [_startQuote:protected] => ` > [_endQuote:protected] => ` > [_schemaDialect:protected] => > Cake\Database\Schema\MysqlSchema Object > ( > [_driver:protected] => Cake\Database\Driver\Mysql > Object > *RECURSION* > ) > > [_connection:protected] => PDO Object > ( > ) > > ) > > [_transactionLevel:protected] => 0 > [_transactionStarted:protected] => > [_useSavePoints:protected] => > [_logQueries:protected] => > [_logger:protected] => > ) > > [_type:protected] => select > [_parts:protected] => Array > ( > [delete] => 1 > [update] => Array > ( > ) > > [set] => Array > ( > ) > > [insert] => Array > ( > ) > > [values] => Array > ( > ) > > [select] => Array > ( > ) > > [distinct] => > [modifier] => Array > ( > ) > > [from] => Array > ( > ) > > [join] => Array > ( > ) > > [where] => > [group] => Array > ( > ) > > [having] => > [order] => > [limit] => > [offset] => > [union] => Array > ( > ) > > [epilog] => > ) > > [_templates:protected] => Array > ( > [delete] => DELETE > [update] => UPDATE %s > [where] => WHERE %s > [group] => GROUP BY %s > [having] => HAVING %s > [order] => %s > [limit] => LIMIT %s > [offset] => OFFSET %s > [epilog] => %s > ) > > [_transformedQuery:protected] => > [_dirty:protected] => 1 > [_resultDecorators:protected] => Array > ( > ) > > [_iterator:protected] => > [_defaultTypes:protected] => Array > ( > [Posts.id] => integer > [id] => integer > [Posts.title] => string > [title] => string > [Posts.body] => text > [body] => text > [Posts.created] => datetime > [created] => datetime > [Posts.modified] => datetime > [modified] => datetime > ) > > [_valueBinder:protected] => > [_functionsBuilder:protected] => > [_repository:protected] => App\Model\Table\PostsTable Object > ( > [_table:protected] => posts > [_alias:protected] => Posts > [_connection:protected] => Cake\Database\Connection Object > ( > [_config:protected] => Array > ( > [driver] => Cake\Database\Driver\Mysql > [persistent] => > [host] => localhost > [login] => loginname > [password] => password > [database] => cake3_db > [prefix] => > [encoding] => utf8 > [name] => default > ) > > [_driver:protected] => Cake\Database\Driver\Mysql Object > ( > [_baseConfig:protected] => Array > ( > [persistent] => 1 > [host] => localhost > [login] => loginname > [password] => > [database] => cake > [port] => 3306 > [flags] => Array > ( > ) > > [encoding] => utf8 > [timezone] => > [init] => Array > ( > ) > > [dsn] => > ) > > [_config:protected] => Array > ( > [driver] => Cake\Database\Driver\Mysql > [persistent] => > [host] => localhost > [login] => loginname > [password] => password > [database] => cake3_db > [prefix] => > [encoding] => utf8 > [name] => default > [port] => 3306 > [flags] => Array > ( > ) > > [timezone] => > [init] => Array > ( > ) > > [dsn] => > ) > > [_autoQuoting:protected] => > [_startQuote:protected] => ` > [_endQuote:protected] => ` > [_schemaDialect:protected] => > Cake\Database\Schema\MysqlSchema Object > ( > [_driver:protected] => > Cake\Database\Driver\Mysql Object > *RECURSION* > ) > > [_connection:protected] => PDO Object > ( > ) > > ) > > [_transactionLevel:protected] => 0 > [_transactionStarted:protected] => > [_useSavePoints:protected] => > [_logQueries:protected] => > [_logger:protected] => > ) > > [_schema:protected] => Cake\Database\Schema\Table Object > ( > [_table:protected] => posts > [_columns:protected] => Array > ( > [id] => Array > ( > [type] => integer > [length] => 10 > [unsigned] => 1 > [null] => > [default] => > [comment] => > [autoIncrement] => 1 > [precision] => > ) > > [title] => Array > ( > [type] => string > [length] => 50 > [null] => 1 > [default] => > [comment] => > [precision] => > [fixed] => > ) > > [body] => Array > ( > [type] => text > [length] => > [null] => 1 > [default] => > [comment] => > [precision] => > ) > > [created] => Array > ( > [type] => datetime > [length] => > [null] => 1 > [default] => > [comment] => > [precision] => > ) > > [modified] => Array > ( > [type] => datetime > [length] => > [null] => 1 > [default] => > [comment] => > [precision] => > ) > > ) > > [_indexes:protected] => Array > ( > ) > > [_constraints:protected] => Array > ( > [primary] => Array > ( > [type] => primary > [columns] => Array > ( > [0] => id > ) > > [length] => Array > ( > ) > > ) > > ) > > [_options:protected] => Array > ( > ) > > ) > > [_primaryKey:protected] => > [_displayField:protected] => > [_associated:protected] => Cake\ORM\Associations Object > ( > [_items:protected] => Array > ( > ) > > ) > > [_eventManager:protected] => Cake\Event\EventManager Object > ( > [_listeners:protected] => Array > ( > ) > > [_isGlobal:protected] => > ) > > [_behaviors:protected] => Cake\ORM\BehaviorRegistry Object > ( > [_table:protected] => App\Model\Table\PostsTable Object > *RECURSION* > [_eventManager:protected] => Cake\Event\EventManager > Object > ( > [_listeners:protected] => Array > ( > ) > > [_isGlobal:protected] => > ) > > [_methodMap:protected] => Array > ( > ) > > [_finderMap:protected] => Array > ( > ) > > [_loaded:protected] => Array > ( > ) > > ) > > [_entityClass:protected] => > [_validators:protected] => Array > ( > ) > > ) > > [_results:protected] => > [_mapReduce:protected] => Array > ( > ) > > [_formatters:protected] => Array > ( > ) > > [_cache:protected] => > [_options:protected] => Array > ( > ) > > ) > > > Please help.. > > > Thanks > > > > On Mon, Mar 3, 2014 at 11:47 PM, José Lorenzo <[email protected]<javascript:> > > wrote: > >> You need to update your app template, specifically your app.php file as >> the arguments for configuring a database connection recently changed: >> >> https://github.com/cakephp/app/blob/master/App/Config/app.default.php#L212 >> >> >> On Monday, March 3, 2014 4:49:53 PM UTC+1, Bayezid Alam wrote: >>> >>> Dears, >>> >>> DB Connection in Cake3 >>> >>> Located at /var/www/cake3/App/Config/app.php >>> /** >>> * Connection information used by the ORM to connect >>> * to your application's datastores. >>> */ >>> 'Datasources' => [ >>> 'default' => [ >>> 'className' => 'Cake\\Database\\Driver\\Mysql', >>> 'persistent' => false, >>> 'host' => 'localhost', >>> 'login' => *'loginName*', >>> 'password' => '*PassWord*', >>> 'database' => '*DatabaseName*', >>> 'prefix' => false, >>> 'encoding' => 'utf8', >>> ], >>> >>> /** >>> * The test connection is used during the test suite. >>> */ >>> 'test' => [ >>> 'className' => 'Cake\\Database\\Driver\\Mysql', >>> 'persistent' => false, >>> 'host' => 'localhost', >>> 'login' => 'my_app', >>> 'password' => 'secret', >>> 'database' => 'test_myapp', >>> 'prefix' => false, >>> 'encoding' => 'utf8', >>> ], >>> ], >>> >>> My Controller located at /var/www/cake3/App/ >>> Controller/PostsController.php >>> <?php >>> >>> /* >>> * To change this template, choose Tools | Templates >>> * and open the template in the editor. >>> */ >>> >>> namespace App\Controller; >>> >>> use Cake\ORM\TableRegistry; >>> >>> class PostsController extends AppController{ >>> public $helpers = array('Html', 'Form'); >>> >>> public function index(){ >>> >>> $posts = TableRegistry::get('Posts'); >>> >>> $posts = $posts->find(); >>> >>> >>> $this->set('posts', $posts); >>> } >>> } >>> ?> >>> >>> My Table located at /var/www/cake3/App/Model/Table/PostsTable.php >>> >>> <?php >>> >>> /* >>> * To change this template, choose Tools | Templates >>> * and open the template in the editor. >>> */ >>> >>> namespace App\Model\Table; >>> >>> use Cake\ORM\Table; >>> >>> class PostsTable extends Table{ >>> public function initialize(array $config){ >>> $this->table('posts'); >>> } >>> >>> } >>> ?> >>> >>> >>> View located at /var/www/cake3/App/Template/Posts/index.ctp >>> >>> <h1>Blog posts</h1> >>> <table> >>> <tr> >>> <th>Id</th> >>> <th>Title</th> >>> <th>Created</th> >>> </tr> >>> >>> <!-- Here is where we loop through our $posts array, printing out >>> post info --> >>> <?php foreach ($posts as $post): ?> >>> <tr> >>> <td><?php echo $post['Post']['id']; ?></td> >>> <td> >>> <?php echo >>> $this->Html->link($post['Post']['title'],array('controller' >>> => 'posts', 'action' => 'view', $post['Post']['id'])); ?> >>> </td> >>> <td><?php echo $post['Post']['created']; ?></td> >>> </tr> >>> <?php endforeach; ?> >>> <?php unset($post); ?> >>> </table> >>> >>> >>> It's showing only Header names, not bringing any data from Database. i >>> Have three more records on database. >>> >>> Please help me, am i missing any thing or not? >>> >>> >>> -- >> Like Us on FaceBook https://www.facebook.com/CakePHP >> Find us on Twitter http://twitter.com/CakePHP >> >> --- >> You received this message because you are subscribed to the Google Groups >> "CakePHP" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/cake-php. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/groups/opt_out.
