postgresql - 如何使用 codeigniter 进行操作

Question

如何从 View 中获取数据数组？以及如何插入我的数据库？

我的看法，我尝试了很多代码但仍然是一个错误，对我的问题和我糟糕的英语感到抱歉

<form role="form" action="<?php echo base_url().'potongan/validasi'?>" action="GET">
          <div class="box-body">
          <div class="box-header with-border">
          <div class="row">
            <div class="col-xs-3">
            <label >NIM</label>
            <input type="text" class="form-control" name="nim" id="nim" placeholder="NIM" value="<?php echo $nime ?>" readonly>
            </div>
            <div class="col-xs-3">
            <label >Nama Mahasiswa</label>
            <input type="text" class="form-control" name="namamhs" placeholder="Nama Mahasiswa" value="<?php echo $nim[0]->namamhs ?>" disabled>
            </div>
            <div class="col-xs-3">
            <label >Jurusan</label>
            <input type="text" class="form-control" name="jurusan" placeholder="Jurusan" value="<?php echo $nim[0]->jurusan ?>" disabled>
            </div>  
          </div>
            <br>
            <div class="form-group">
              <label >Kode Beasiswa</label>
                <input type="text" class="form-control " name="kdbeasiswa" value="<?php echo $kdbeasiswa ?>" readonly>
            </div>

             <div class="form-group">
              <label >Keterangan</label>
                <input type="text" class="form-control " name="keterangan" value="<?php echo $keterangan ?>" readonly>
            </div>

            <div>
              <table class="table table-bordered table-striped">
                <tr>
                  <th></th>
                  <th>Kode</th>
                  <th>Deskripsi</th>
                  <th>Tahun Akademik</th>
                  <th>semester</th>
                  <th>Tagihan</th>
                  <th>Beasiswa</th>
                  <th>Terbayar</th>
                  <th>Potongan</th>
                </tr>
                  <?php foreach ($nim as $n): ?>
                    <tr>
                    <td>
                        <input type="hidden" class="form-control " name="id[]" value="<?php echo $n->thakad.$n->smtakad.$n->kdkeu; ?>" maxlength="3" >
                    </td>
                    <td><input type="hidden" class="form-control " name="kdkeu[]" value="<?php echo $n->kdkeu; ?>" maxlength="3" ><?php echo $n->kdkeu; ?></td>
                    <td><?php echo $n->deskeu; ?></td>
                    <td><input type="hidden" class="form-control " name="thakad[]" value="<?php echo $n->thakad; ?>" maxlength="3" ><?php echo $n->thakad; ?></td>
                    <td><input type="hidden" class="form-control " name="smtakad[]" value="<?php echo $n->smtakad; ?>" maxlength="3" ><?php echo $n->smtakad_view; ?></td>
                    <td><?php echo $n->tagihan; ?></td>
                    <td><?php echo $n->beasiswa; ?></td>
                    <td><?php echo $n->terbayar; ?></td>
                    <td>
                        <input type="text" class="form-control " name="prosentase_bea[]" value="<?php echo $n->potongan; ?>"  maxlength="3">
                    </td>
                    </tr>
                  <?php endforeach ?>
              </table>
            </div>
            </div>
            <br>
              <button class="btn btn-info" style="float: right;">submit</button>
          </div>
          <!-- /.box-body -->
        </form>

当我没有向数据库提交数据插入并且出现类似错误时，我的 Controller 看起来像这样

Filename: C:/xampp/htdocs/tagihan/system/database/DB_query_builder.php Line Number: 1498

$data = array();

    $count = count($this->input->post('device'));

        for($i=0; $i<$count; $i++) {

        $data[] = array(
        $thakad= $this->input->get('thakad'),
        $smtakad= $this->input->get('smtakad'),
        $kb = $this->input->get('kdbeasiswa'),
        $kk = $this->input->get('kdkeu'),
        $nim= $this->input->get('nim'),
        $pb = $this->input->get('prosentase_bea'),
        $status = 1,                  
        $user = $this->session->userdata('username'),
        $kt = $this->input->get('keterangan'),
        $curentDate = date("Y-m-d"));


}
$this->db->insert_batch('keu_beasiswapermhs',$data);
redirect('http://localhost/tagihan/potongan');

Answer 1

养成使用正确的 MVC 的习惯

查看

<form action="URL" method="post">
</form>

Controller

$this->model->function_name();
redirect('URL');

型号

function function_name(){
   $dataArr = array(
   'field_name'=>$this->input->post('form_input_name'),
   );
   $this->db->INSERT('tbl_name',$dataArr);
}