CodeIgniter Forums
YEAR in active record - Printable Version

+- CodeIgniter Forums (
+-- Forum: Using CodeIgniter (
+--- Forum: Libraries & Helpers (
+--- Thread: YEAR in active record (/showthread.php?tid=71795)

YEAR in active record - pippuccio76 - 09-25-2018

HI , i have a table :

 `id` bigint(20) UNSIGNED NOT NULL,
  `data` date NOT NULL,
  `numero_settimana` int(11) NOT NULL,
  `giorno_settimanale` varchar(15) NOT NULL,
  `orari_apertura_id` int(11) NOT NULL,
  `stato_agenda_id` int(10) UNSIGNED NOT NULL COMMENT '= aperto chiuso o prenotato',
  `clienti_id` int(10) UNSIGNED DEFAULT NULL,
  `note` varchar(100) DEFAULT NULL

This is a part my function :

PHP Code:


But it get the row  of every years , how can i get only by year of var $data ($data have yyyy-mm-dd format) ?

RE: YEAR in active record - InsiteFX - 09-25-2018

Try this and see if it is what you want, not tested.

PHP Code:
$query $this->db->select('SELECT DATE("{$data}") as required_DATE')

RE: YEAR in active record - davicotico - 09-25-2018

PHP Code:
function getweek($numsettimana$data$tabella){
   $query $this->db->get();

RE: YEAR in active record - Gurutechnolabs - 10-01-2018


I just read your question. I think you need to change the data type.

you have to need to change your field data type for 'numero_settimana' int to DATE.

Hope it will help you friend.