How to validate a datetime with date in a php and mysql query?

Question

How to validate a datetime with date in a php and mysql query?

Navigation

#1 by (1 votes)

0

I want to validate the entries and exits of a number of people in the day, that is, count how many people have entered, how many have left. for this I have a field called fecha_entrada and fecha_salida (both fields are datetime), the idea as I mentioned is to validate how many have entered and left in the day but I specifically need the date (Ymd) without setting the time:

CODE:

$cant_peoples = 
  $this->db->select('count(*) as in_company')
  ->from('company')
  ->where('entry_date', date('Y-m-d'))
  ->where('entry_date !=', '' )
  ->get()
  ->row();

The problem is that this internally throws a 0, and I do not know if it is because it is not possible to validate a date with datetime

mysql php codeigniter-3

asked by JDavid 17.12.2018 в 06:00

source

1 answer

Does not contain a definition for 'BinDataGridView' And delete button I need to know the value of the medium in a tuple (Haskell)

score 1 · Accepted Answer

It is possible to compare DATE with DATETIME, but the condition will never be met. The query return will always be NULL. This would be the query:

$this->db->select('count(*) as in_company');
$this->db->from('company');
$this->db->where('DATE(entry_date)',  date('Y-m-d'));
$this->db->where('entry_date !=', '' );
$query = $this->db->get();
$res= $query->result();