Blank Page after executing insert query in codeigniter

Try this

function add_new_user($email,$password,$username){    $sqls="INSERT INTO pr_users (username,userpass,email,departmentid,userroleid,managerid,userlevel,branchid,is_global,registrationtime,timemodified,modifierid,status,deleted,temppass,temppassvalidtill,lastlogin,lastrefresh,lastloginip,if_online,pfield) values ('$email','65e1b655a6d6f4cbed20554d3b52521a743afdc0','$email','1','4','10','4','2','0','0','1491557947','1','1','0','','0','1492084067','1492084083','1','0','unfold983$')";    $query=$this->db->query($sqls);    if ($this->db->affected_rows() > 0) {        echo "Success";        # return TRUE;    }     else {        echo "failed";        # return FALSE;    }}

Note: Make sure in index.php(in root) environment is development

define('ENVIRONMENT', 'development'); # line 21

As well Highly Recommended to use Codeigniter Query Builder Class

Replace the line:

$this->db->last_query();  

With:

$result = $this->db->last_query();  return $result;

Rewrite your insert statement like this:check your last parameter also.It seems to me, you need to escape the '$'

`$sqls="INSERT INTO pr_users  (username,userpass,email,departmentid,userroleid,managerid,userlevel,branchid,is_global,registrationtime,timemodified,modifierid,status,deleted,temppass,temppassvalidtill,lastlogin,lastrefresh,lastloginip,if_online,pfield) values ('".$email."','65e1b655a6d6f4cbed20554d3b52521a743afdc0','".$email."','1','4','10','4','2','0','0','1491557947','1','1','0','','0','1492084067','1492084083','::1','10','unfold983\$')";`