Help please! (creating an array, getting values from database)

[specdroid]

Hi! Eto po yung php function ko inside a class po.

public function offset()
{
$in_offset = "select 
date_format(b.date,'%W'),
b.date as ddate,
a.time_in as daily_time_in,
b.time_in as schedule_time_in,
a.time_out as daily_time_out,
b.time_out as schedulte_time_out,
minute(timediff(a.time_out,b.time_out)) as time_out_offset,
minute(timediff(a.time_in,b.time_in)) + minute(timediff(a.time_out,b.time_out)) as daily_offset,
minute(timediff(a.time_in,b.time_in)) as time_in_offset
from 
daily_schedule a
left join daily_attendance b on a.date=b.date and a.employee_id = b.employee_id
where 
b.employee_id=".$this->user." and b.date='".$this->date."'
group by 
b.date
";

$result = $this->mysqli($in_offset);

$r1 = $result->fetch_array(MYSQLI_ASSOC);

return $r1;
}

gusto ko pong mangyari is may another function po na kkuha ng dates from a certain table in my db na gagawing array then ibabato niya sa function ko sa taas. working na po kasi yan pero for a single date lang po. gusto ko kasi is yung multiple. thank you po sa tutulong.

 

[jskhulitz]

I think, what you are looking for is this.

 

[jhersonn20]

try to use find_in_set in MYSql