Re: how can i get the page number in a model

i did it !!!!!!!!

i passed the page current number to the (paginate) function in the
($extra) argument instead of passing it in the $limit argument,

here is the modefied code:

/////////////// the controller //////////
class LessonsController extends AppController {
var $name = 'Lessons';
var $paginate = array('Lesson' => array('limit' => 2, 'page' => 1));

function friday() {
if(! isset($this->passedArgs["page"])) $pageNumber=0;
else $pageNumber=$this->passedArgs["page"]-1;

$this->paginate = Set::merge($this->paginate,
array('Lesson'=>array('limit'=>2, 'page'=>1, 'extra'=>$pageNumber)));

$this->set('lessons', $this->paginate('Lesson'));
}
}

/////////////// the model ///////////////
class Lesson extends AppModel {
var $name = 'Lesson';

function paginate($conditions, $fields, $order, $limit, $page = 1,
$recursive = null, $extra = array()) {

$offset=$extra["extra"];
return $this->query(
"SELECT *
FROM lessons
WHERE YEAR(created) = (
SELECT DISTINCT( YEAR(created)))
FROM lessons
ORDER BY id DESC
LIMIT $offset ,1)
ORDER BY id DESC");
}

function paginateCount($limit, $pageCount, $conditions = null,
$recursive = 0, $extra = array()) {
$results =$this->query(
"SELECT COUNT(*) count
FROM lessons
WHERE lessons.status='1'");

return $results[0][0]["count"];
}
}

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---