I have encrypted name in users table at the time of registration using codeIgniter's [$this->encryption->encrypt('sunil'). I am selecting record using following code.
$this->src('automaker')
->query("Select user_id, name, email_id from users)
->pipe($this->dataStore("users"));
This code giving me encrypted name which present it in db. When I am trying to show data in chart it display me name like [d8d3ed752701f6c0bc558c3aa819e486d217f04c41114fffa9ef70bfbeb155a55191ffeef4da36e] instead of [sunil]. So how can I decrypt name which selected using query by the use of [$this->encryption->decrypt('d8d3ed752701f6c0bc558c3aa819e486d217f04c41114fffa9ef70bfbeb155a55191ffeef4da36e')].
The chart code on view file is as follows
BarChart::create(array("dataSource"=>$this->dataStore("users"),
"width"=>"80%",
"height"=>"400px",
"columns"=>array(
"name"=>array(
'type' => 'string',
'label'=>'User Name',
),
"user_id"=>array(
'type' => 'number',
'label'=>'Id',
),
),
"clientEvents"=>array(
"itemSelect"=>"function(params){
console.log(params.selectedValue);
}"
),
));
Please give me solution.