Your code looks a bit non-standard. What's ItemKey1? And field name are
normally lower camel case.
Try this (assuming you primary key on the items table is 'id' and your
description field is 'item_description'):
public function view($id = null) {
$this->set(
'item',
$this->Item->find(
'first',
array('Item.id' => $id)
)
);
}
Then in your view:
<?php
echo $this->Html->link(
$item['Item']['item_description'],
array(
'controller' => 'items', <=== note the controller is
all lower case
'action' => 'view',
$item['Item']['id']
)
);
?>
Jeremy Burns
Class Outfit
http://www.classoutfit.com
On 4 Dec 2011, at 23:2743, davfergus wrote:
> Good evening,
>
> Rookie developer, in MVC for 6 months, CakePHP for about 1. My
> current tests with Cake can be seen at: http://174.129.130.149/items
>
> I am experiencing an issue on the drill down. I paste everything into
> a text doc so I could do a line by line but the issue is eluding me.
>
> I can successfully see all items of my table. I can click the link
> and go from index.ctp to view.ctp. My id passes successfully. No db
> data shows on view.ctp, but there are no errors. The test var in item
> 2 below displays. I cast $id as an (int) and did a gettype to test,
> and it came back as an int. Still no luck? I am assuming I am
> missing something quite simple, but after three hours of looking at
> this I obviously do not know what I am looking at.
>
> 1. app/Model/Item.php
>
> class Item extends AppModel {
> public $name = 'Item';
> }
>
> 2. app/Controller/ItemsController.ctp contains the following (index()
> works like a champ):
> public function view($id = null) {
> $this->Item->ItemKey1 = $id;
> $this->set('item', $this->Item->read());
> $this->set('testvar', 'it is set');
> }
>
> index successfully executes find('all');
>
> 3. app/View/Items/view.ctp contains the line: echo $item['Item']
> ['DBField']; and echo $testvar;
>
> a. index.ctp does the following: <?php echo $this->Html-
>> link($item['Item']['ItemDescription'], array('controller' => 'Items',
> 'action' => 'view', $item['Item']['ItemKey1']) ); ?>
> the link works and I go to the correct page, I do a view source
> and everything is there minus any data from the db. I've tried
> changing item names to upper case, adding an 's', but each changes
> throws an error. I thought the issue was the id coming in as a string
> so I cast to an int, still no dice.
>
> R/s,
> Dave
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> [email protected] For more options, visit this group at
> http://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
