Could you point what is going wrong in this MySQL/ Codeigniter form data insertion ?

          $dia = date('ymd');

            $programa =  $this->input->post('programa');
            $orgao =  $this->input->post('orgao');

            // In ----PostgreSQL:---- This code runs fine
            //$sql = "INSERT INTO tb_orgao(idorgao, idprograma, nome, data ) VALUES (nextval('id_seq_reg_orgao'::regclass),'%d', '%s', %s);";
            //$comando = sprintf($sql, $orgao , $dia, $programa);
            // $sql = pg_query($comando);

// Trying   to insert directly into MySQL -  no success
//            $sql = "INSERT INTO tb_orgao(idprograma, nome, data) VALUES ('%s', '%s', %d);";
//            $comando = sprintf($sql, $programa , $orgao, $dia );
//            $sql = mysql_insert_id($comando);

// Or using model:
          
            $sql = pg_query($comando);

             $data = array(
                  'idprograma' => $programa,
                  'nome' => $orgao,
                  'data' => $dia
                  );
             
             //     Transfering data to Model
              $this->orgao_model->form_insert($data);

Select allOpen in new window

   function form_insert($data){
            $this->db->insert('tb_orgao', $data);
    }
    

Select allOpen in new window

CREATE TABLE tb_orgao
(
  idorgao       INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  idprograma    INT(4) NOT NULL,
  nome          varchar(30) NOT NULL,
  data          date,
  FOREIGN KEY (idprograma) REFERENCES tb_programa(idprograma)
)ENGINE = INNODB;

Select allOpen in new window