blank model

[jagguy]

Hi,

I have a cakePHP program that works and displays data from a database table.
The part I dont understand and I couldnt find anything on the cakephp blog as yet was the model was left blank?

q1) The model is left blank but still works so what is the default behaviour here for the model? It doesnt seem to be needed to do anything i?.

q2)I am selecting all the data from 1 table but how do I add  a sql statement to select part of the table or a join of 2 tables? the find 'all' seems to just do that only in finding all data from a table.

 

<?php
class Post extends AppModel
{
/*var $name='User';*/
}
?>


<?php
class PostsController extends AppController
{
public $helpers=array('Html','Form');

public function index()
{
$this->set('posts',$this->Post->find('all'));
}

public function home()
{
$this->set('posts',$this->Post->find('all'));
}
}
?>

view
///
..
<?php foreach ($posts as $item):
echo '<tr><td>'. $item['Post']['id']. '</td>';
echo '<td>'. $item['Post']['title'].'</td>';
echo '<td>'. $item['Post']['body'].'</td>';

echo '<td>'. $item['Post']['created'] .'</td>';
echo '</tr>';
endforeach;
unset($item);
?>