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+unsubscribe@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.
No comments:
Post a Comment