vs.php

<?php

// sans :

// tous les produits
$records = $this->Database->execute( 'select * from tl_products where published = 1' );
$products = array();
while ( $records->next() )
{
  $products[] = $records->row();
}

// produit 1
$record = $this->Database->execute( 'select * from tl_products where id = 1' );
$record->next();
$product = $record->row();

if ( $post = $this->Input->post( 'product' ) )
{
  $this->Database->prepare( 'update tl_products ? where id = 1' )->set( $post )->execute();
}

$this->Template->products = $products;
$this->Template->product  = $product;





// avec :
$product  = new Product(1);
$products = $product->getAll( 'id', array( 'published = 1' ) );

if ( $post = $this->Input->post( 'product' ) )
{
  $product->update_attributes( $post );
}

$this->Template->products = $products;
$this->Template->product  = $product;
?>