Using MySQL functions in codeigniter active record method

Question

I am stuck with this query , please tell me how to convert this query into codeigniter active record method

select * from view_log where user_id=XXXX and date(time) = curdate();

where time is a time stamp , so I want to extract date out of it and compare it with today's date. I have tried to use set but its not working, even passing it as a string is not working.

bipen · Accepted Answer · 2013-06-19 11:23:06Z

4

try this

  $this->db->select('*');
  $this->db->from('view_log');
  $this->db->where('user_id=XXXX and date(time) = curdate()');
  $result=$this->db->get();

or the simplest way

  $this->db->select('*');
  $this->db->from('view_log');
  $this->db->where('user_id','XXX');
  $this->db->where('DATE(time)', 'CURDATE()', FALSE);
  $result=$this->db->get();

edited Jun 19, 2013 at 11:23

answered Jun 19, 2013 at 10:51

bipen

36.6k9 gold badges51 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

bipen Over a year ago

are you getting any error ?? if yes then please let me know the error that you are getting

Shivam Over a year ago

$this->db->where('user_id',$user_id); $this->db->where("DATE(time)",'CURDATE()',false); This worked for me ! Thank bipen for your answer

MJ X · Accepted Answer · 2013-06-19 11:07:49Z

2

I think date is a field in our table

if date is a field in you table try this way

$this->db->select('*');
$this->db->from('view_log');
$this->db->where('user_id','XXX');
$this->db->where('date', 'CURDATE()', FALSE);
$result=$this->db->get();

answered Jun 19, 2013 at 11:07

MJ X

9,12413 gold badges85 silver badges124 bronze badges

1 Comment

Shivam Over a year ago

$this->db->where('user_id',$user_id); $this->db->where("DATE(time)",'CURDATE()',false); This worked for me ! Thank mehdi for your answer.

Killer Whale · Accepted Answer · 2013-06-20 02:27:55Z

0

Or simplely, you can use this code $query = $this->db->query($sql); But before using any mysql query in controller, you should try to run it in phpmyadmin. I think you will know extractly your query is right or wrong ...

answered Jun 20, 2013 at 2:27

Killer Whale

872 silver badges12 bronze badges

Collectives™ on Stack Overflow

Using MySQL functions in codeigniter active record method

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related