Re: [fw-mvc] _request

Thank you so much for the help. It is 00.31AM here and my eyes can not see anything anymore.. So It is time to sleep ..

 

Thank you again so much

E

----- Original Message -----

From: Tom Van Schoor

To: Erdal YAZICIOGLU

Sent: Saturday, November 01, 2008 11:53 PM

Subject: Re: [fw-mvc] _request

Oooh now i see what's going wrong... you are casting your $type to int...

$type= (int)$this->_request->getParam('type');.... PHP is a string, not an int

try

$type= $this->_request->getParam('type');


Erdal YAZICIOGLU schreef:

Thank you so much for the quick response but it still lists all the type of articles...

 

ArticleController

 

function viewAction(){ 
  $articles = new Articles();
   $type= (int)$this->_request->getParam('type');
$select = $articles->select()->where('type = ?', $type);
 $this->view->articles = $articles->fetchAll($select);

 

view.phtml

<?foreach ($this->articles as $articles): ?>
<tr>
  <th scope="row" class="spec">
  <?php echo $this->escape($articles->type);?></a></th>
  <td><?php echo $this->escape($articles->title);?></td>
  <td><?php echo $this->escape($articles->author);?></td>
  <td><?php echo $this->escape($articles->date_published);?></td>
  <td></td>
</tr>
<?php endforeach;?>

 

 

E

----- Original Message -----

From: aurelijus@astdev.lt

To: Erdal YAZICIOGLU

Cc: fw-mvc@lists.zend.com

Sent: Saturday, November 01, 2008 11:22 PM

Subject: Re: [fw-mvc] _request

Hi,

FetchAll method requires using select() (http://framework.zend.com/manual/en/zend.db.select.html)

In your situation, it should look something like this:

$articles = new Articles();
 $type= (int)$this->_request->getParam('type');

$select = $articles->select()->where('type = ?', $type);
 $this->view->articles = $articles->fetchAll($select);

--
Aurelijus Valeiša
http://www.Aurelijus.eu

On Sat, Nov 1, 2008 at 11:03 PM, Erdal YAZICIOGLU <erdal.yazicioglu@gmail.com> wrote:

Hello

I am trying to get the request from with type but everytime I am endind up with fetching all the records from database..

The request is coming as
article/view/type/PHP
So under the ArticleController I created a viewAction function as...
$articles = new Articles();
 $type= (int)$this->_request->getParam('type');
 $this->view->articles = $articles->fetchAll('type='.$type);

When I click the article type it still lists me all the articles...Can you guys give me an hint or link to read..

Thanks