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 cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/groups/opt_out.
