In Previous version 2.2.6 i was using following code:
$dataField='tm.*,IFNULL(CONCAT_WS(" " ,pm.firstName,pm.lastName),"") as assignedToName,IFNULL(cm.caseNo,"") as CaseNo,IFNULL(cm1.fileNo,"") as fileNo,IFNULL(sm.caseStage,"") as caseStage';
$qryTable='task_mst as tm
LEFT JOIN case_mst as cm on tm.caseNo=cm.ID
LEFT JOIN case_mst as cm1 on tm.fileNo=cm1.ID
LEFT JOIN party_mst as pm on tm.assignedTo=pm.ID
LEFT JOIN session_mst as sm on tm.sessionId=sm.ID';
Now i am using Version 3.1.0 but "_protect_identifiers" will give error message
Fatal error: Cannot access protected property CI_DB_mysqli_driver::$_protect_identifiers
Can anyone tell me how to use "protect_identifiers()" in codeigniter 3.1.0?
here is a sample
return 'SELECT '.$this->escape_identifiers('name') .' FROM '.$this->escape_identifiers('sysobjects') .' WHERE '.$this->escape_identifiers('type')." = 'U'";
Try to set like this..
For more refer this.