$subModel = new Subscription(); $subscriptionWhere = ('fa_user_id =' .$this->db_session->userdata('id')); $subModel->where($subscriptionWhere); $subModel->order_by('startdatetime','DESC'); $subModel->join_related('subscriptiontypes')->get(); $this->data['previousSubDataCount'] = count($subModel->all); $this->data['previousSubData'] = $subModel->all; foreach($subModel->all as $test){ echo $test->subscriptiontype_displayname ."|" . date("m/d/y",strtotime($test->startdatetime)) . "|". date("m/d/y",strtotime($test->enddatetime)); }
<?php class Subscription extends DataMapper { var $has_one = array("fa_user","subscriptiontype"); var $validation = array( array( 'field' => 'fa_user_id', 'rules' => array('required') ), array( 'field' => 'subscriptiontype_id', 'rules' => array('required') ), array( 'field' => 'startdatetime', 'rules' => array('required') ), array( 'field' => 'enddatetime', 'rules' => array('required') ), array( 'field' => 'paypaldata', ) ); function Subscription() { parent::DataMapper(); } } ?>
<?php class Subscriptiontype extends DataMapper { function Subscriptiontype() { parent::DataMapper(); } } ?>