How to limit inserting data into MySql using codeiginter

Question

How to limit inserting data into MySql using codeiginter? I have 10000 array data. But I want to limit only 200 data at each process. Next process have to insert from data that is not yet inserted. Here is my code from controller:

<?php
 foreach($data["result"] as $key) {

    $insert=$this->db->insert('master_mahasiswa_pt',$key );
    if (!$insert && $this->db->error()) {

  echo "Data nim"; echo " "; echo $key['nipd'] ; echo " ";  echo "Sudah Ada"; echo '<br>'; 
} else {
 echo "Data nim"; echo " "; echo $key['nipd'] ; echo " ";  echo "Sudah Masuk"; echo '<br>';
}
}
}
}
?>

Here is example from my array data:

Array
(
    [error_code] => 0
    [error_desc] => 
    [result] => Array
        (
            [0] => Array
                (
                    [id_reg_pd] => 35e86b4f-1b8b-407b-b49e-9d125cba2cb5
                    [nipd] => 150015020
                    [id_pd] => b5261e3d-6aed-41e9-a329-1ebe6191d53c
                    [nm_pd] => ACDB
                    [tgl_lahir] => 1996-06-16
                    [id_sms] => 63d9ecdb-4468-4883-a1aa-13ad3f88fce1
                    [fk__sms] => Teknik Informatika                                                              
                    [id_sp] => 89a93cb2-f959-45d3-8a75-f349be529b87
                    [fk__sp] => STMIK 
                    [tgl_masuk_sp] => 2015-08-25
                    [id_jns_daftar] => 1
                    [fk__jns_daftar] => Peserta didik baru
                    [id_jns_keluar] => 
                    [fk__jns_keluar] => 
                    [tgl_keluar] => 
                    [ket] => 
                    [skhun] => 
                    [a_pernah_paud] => 0
                    [a_pernah_tk] => 0
                    [mulai_smt] => 20151
                    [sks_diakui] => 0
                    [jalur_skripsi] => 
                    [judul_skripsi] => 
                    [bln_awal_bimbingan] => 
                    [bln_akhir_bimbingan] => 
                    [sk_yudisium] => 
                    [tgl_sk_yudisium] => 
                    [ipk] => 
                    [no_seri_ijazah] => 
                    [sert_prof] => 
                    [a_pindah_mhs_asing] => 
                    [nm_pt_asal] => 
                    [nm_prodi_asal] => 
                )

        )

)

score 0 · Answer 1 · answered Jan 30 '17 at 08:11

$i = 0;
    foreach ($data["result"] as $key) {
        if ($i < 201) {
            $insert = $this->db->insert('master_mahasiswa_pt', $key);
            if (!$insert && $this->db->error()) {

                echo "Data nim";
                echo " ";
                echo $key['nipd'];
                echo " ";
                echo "Sudah Ada";
                echo '<br>';
            } else {
                echo "Data nim";
                echo " ";
                echo $key['nipd'];
                echo " ";
                echo "Sudah Masuk";
                echo '<br>';
            }
        }
        $i++;
    }

How to limit inserting data into MySql using codeiginter

1 Answers1