Welcome Guest, Not a member yet? Register   Sign In
How to set transaction fail
#1

I have function insert and update bellow.

private function _insertNode($extra_fields = array())
{
$this->db->trans_start();
$this->db->insert($this->table_name, $extra_fields);
$id = $this->db->insert_id();
$parent_id = $extra_fields[$this->parent_column_name];
$group_id = $extra_fields[$this->group_column_name];
if ($parent_id == 0) {
$data['path'] = $group_id . '_' . $id . '_';
} else {
$this->db->select('path');
$this->db->from($this->table_name);
$this->db->where('id', $parent_id);
$result = $this->db->get()->row();
if(!empty($result)) {
$path = $result->path;
$data['path'] = $group_id . '_' . $path . $id . '_';
} else {
$this->db->trans_status = FALSE;
}
}
$this->db->where('id', $id);
$this->db->update($this->table_name, $data);
$this->db->trans_complete();
return $this->db->trans_status();
}

But how to i set trans_status fail? when $result is empty
Reply




Theme © iAndrew 2016 - Forum software by © MyBB