CakePHP Model display all data null

Question

I can not display the data.

My model (app/Model/Product.php)

class Product extends AppModel {
public $name = 'Product'; 
}

My controller (app/Controller/ProductsController.php):

class ProductsController extends AppController {
public $helpers = array('Html','Form','Session');
public $components = array('Session');
public $name = 'Products';

public function ver($id = null) {
$this->Product->id_producto = $id;
debug($this->Product->id_producto); //Show id with value Ex. 12,34,...
$this->set('products', $this->Product->read());
  }
}

My view (app/View/ver.ctp):

<?php debug($product['Product']['nombre']); ?> // Show 'null'
<h2><?php echo $product['Product']['nombre']?></h2></td></tr>
<strong>Descripci&oacute;n:</strong> <?php echo $product['Product']['descripcion']?> <br/>
<small>Fecha de registro: <?php echo $product['Product']['fecha_reg']?></small> <br/>
<small>Última modificación: <?php echo $product['Product']['Fecha_mod']?></small>

check out book.cakephp.org/2.0/en/models/retrieving-your-data.html and stackoverflow.com/questions/21819451/… As @nedstark said, you should use find — cornelb
– cornelb, Commented Apr 30, 2014 at 9:05

Simon · Accepted Answer · 2014-04-30 09:29:56Z

2

You are not using the default primary key: id. Define your primary key in your model:

class Product extends AppModel
{
    public $primaryKey = 'id_producto';
}

... and assing requesting product id to id in your controller. id will match to primary key id_producto in your database table:

public function ver($id = null) 
{
    $this->Product->id = $id;
    debug($this->Product->id); //Show id with value Ex. 12,34,...;
    $this->set('product', $this->Product->read());
}

Some notes:

In your controller you assign the results to plural 'products':

$this->set('products', $this->Product->read());

But in your view you use the variable in singular $product:

Try to use <?php debug($products['Product']['nombre']); ?> instead.

edited Apr 30, 2014 at 9:29

answered Apr 30, 2014 at 9:06

Simon

5,0143 gold badges57 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

AD7six Over a year ago

debug($products); is probably more useful - since that definitely exists.

hmaceves Over a year ago

Thank's very much! You are excelent!

Collectives™ on Stack Overflow

CakePHP Model display all data null

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related