thiscodeWorks - Organizing the best of code online

List view

var payload = {
   "items":[
      {
         "className":"cmdb_ci_computer",
         "values":{
            "name":"acanpiesx01"
         }
      }
   ]
};

var jsonUntil = new JSON();
var input = jsonUntil.encode(payload);
var output = SNC.IdentificationEngineScriptableApi.identifyCI(input);
gs.print(output);

#ci #mysql #portal

CI - update

$data = array(
  	'nazov' => $name,
  	'poznamka' => $poznamka,
  	'user_id' => $user_id,            
  	'date_modify' => date('Y-m-d H:i:s')
);

$this->db->where('ponuka_id',$ponuka_id);
$this->db->update('tsv_ponuky_h',$data);

#ci #mysql #portal

CI - kontrola query - num_rows()

$select = "SELECT * FROM tsv_sablonah WHERE sablona_id = '".(int)$sablona."'";
        
if($this->db->query($select)->num_rows() > 0 ){
  	return $this->db->query($select)->row();
} else {
  	return '';
}

#ci #mysql #portal

CI - insert data to database

$data = array(
  'nazov' => $name,
  'poznamka' => $poznamka,
  'user_id' => $user_id,
  'date_added' => date('Y-m-d H:i:s')
);
$this->db->insert('tsv_ponuky_h',$data);

$new_id = $this->db->insert_id();

IRE find CI but not insert or update

CI - update

CI - kontrola query - num_rows()

CI - insert data to database

Save snippets that work with our extensions