Insert data failed using codeigniter and mysql

Question

i have a little bit error when doing a simple registration form. My problem is the data that have input is not inserted in database.

But before i using horizontal form the data can be inserted in my database. I'm using MySQL. this is my controller :

function create(){  
$data = array(
            'nik' => $this->input->post('nik'),
            'nama' => $this->input->post('nama'),
            'tgl_lahir' =>$this->input->post('tgl_lahir'),
            'no_hp' => $this->input->post('no_hp'),
            'alamat' => $this->input->post('alamat')
        );
        $this->db->insert('profile_mitra',$data);
        redirect('admin/daftar_mitra');
    }

and this my view called tambah_mitra.php.

View (tambah_mitra.php)

<?php $this->load->view('templates/head');?>
<?php $this->load->view('templates/sidebar');?>
<body>
  <div class="content-wrapper">
    <section class="content-header">
<section class="content">
      <div class="row">
        <!-- left column -->
        <div class="col-md-6">
          <!-- general form elements -->
          <div class="box box-primary">
            <div class="box-header with-border">
              <h3 class="box-title">Tambah Mitra</h3>

            </div>
            <!-- /.box-header -->
            <!-- form start -->
            <form role="form">
              <div class="box-body">
                <div class="form-group">
                  <?php echo validation_errors();?>
              <?php echo form_open('admin/daftar_mitra');?>
                  <label for="exampleInputEmail1">NIK</label>
                  <input type="text" class="form-control" id="nik" placeholder="NIK">
                </div>
                <div class="form-group">
                  <label for="exampleInputEmail1">Nama</label>
                  <input type="text" class="form-control" id="nama" placeholder="Nama">
                </div>
                 <div class="form-group">
                  <label for="exampleInputEmail1">Tanggal Lahir</label>
                  <input type="date" class="form-control" id="tgl_lahir" placeholder="">
                </div>
                <div class="form-group">
                  <label for="exampleInputEmail1">No.HP</label>
                  <input type="text" class="form-control" id="no_hp" placeholder="Nomor Handphone">
                </div>
                <div class="form-group">
                  <label for="exampleInputPassword1">Alamat</label>
                  <input type="alamat" class="form-control" id="alamat" placeholder="Alamat Lengkap">
                </div>
                <!-- <div class="form-group">
                  <label for="exampleInputFile">File input</label>
                  <input type="file" id="exampleInputFile">

                  <p class="help-block">Example block-level help text here.</p>
                </div> -->
                <!-- <div class="checkbox">
                  <label>
                    <input type="checkbox"> Check me out
                  </label>
                </div> -->
              </div>
              <!-- /.box-body -->

              <div class="box-footer">
                <input class="btn btn-success" type="submit" value="Simpan">
              </div>
            </form>
          </div>
        </div>
      </div>
    </section>
        </div>
        </body>
<?php $this->load->view('templates/footer');?>

Hi, and welcome to SO! What have you tried so far?

Max von Hippel
– Max von Hippel

2018-12-26 05:06:03 +00:00
Commented Dec 26, 2018 at 5:06 — Max von Hippel
– Max von Hippel, Commented Dec 26, 2018 at 5:06

PHP Geek · Accepted Answer · 2018-12-26 05:01:40Z

1

it is not inserting because you did not define name of input filed.i think this is the reason of not inserting data. please try.

<div class="form-group">
                      <label for="exampleInputEmail1">Nama</label>
                      <input type="text" class="form-control" id="nama" name="nama" placeholder="Nama">
                    </div>

answered Dec 26, 2018 at 5:01

PHP Geek

4,0632 gold badges19 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

exception_thrown · Accepted Answer · 2018-12-26 03:35:38Z

0

try closing your form

<?php echo form_close();?>

Also to see the errors use

<?php echo form_error('nik');

and continue filling the (' ') in with your variables to see what the error is.

answered Dec 26, 2018 at 3:35

exception_thrown

5831 gold badge8 silver badges24 bronze badges

Collectives™ on Stack Overflow

Insert data failed using codeigniter and mysql

View (tambah_mitra.php)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

View (tambah_mitra.php)

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related