CODEWITHSUNDEEP
phpmysqlcodeigniter
Shaker Younis
Shaker Younis

Reputation: 21

translate CodeIgniter query into normal mySQL query

How can I translate this function written in CodeIgniter into a normal MySQL query?

public function getUserAttend ( $User_ID , $Date_From , $Date_To )
{
    $this -> db -> select 
            ( ''
            . '(select attend_permission_confirmed from ts_permission pr  where pr.attend_in_attend_id = att.attend_id LIMIT 1 ) as attend_permission_confirmed_out '
            . ',(select attend_permission_confirmed from ts_permission pr  where pr.attend_out_attend_id = att.attend_id   LIMIT 1 ) as attend_permission_confirmed_in '
            . ',`attend_id`, `attend_date`, `attend_user`, `attend_time_in`, `attend_time_out`, `attend_ctime_in`, `attend_ctime_out`, `attend_notes_in`, `attend_notes_out`, `attend_modifiedby`, `attend_checkoutip`'
            . ', `attend_official_in`, `attend_official_out`, `attend_morning_permission` '
            , FALSE );

    $this -> db -> order_by ( 'attend_id' , 'ASC' );
    $res = $this -> db -> get_where ( "ts_attendance as att" , array (
        "attend_user" => $User_ID ,
        "attend_date >= " => $Date_From ,
        "attend_date < " => $Date_To
            )
    );

    return $res -> result_array ();
}

Note that I have no expertise with the Php CodeIgniter framework. Can you explain what this code represents in mySQL?

Upvotes: 2

Views: 99

Answers (1)

Vickel
Vickel

Reputation: 7997

You can use Codeigniters built-in function last_query()

$qstring= $this->db->last_query();

more information here:

Upvotes: 2

Related Questions