php - How do i update multiple rows with multiple condition in Code Igniter -


i learning php , using codeigniter framework. i'm using code in controller when inserting new data , it's working.

//insert multi rows tabel harga_inventori     $kode_inventori = $_post['kode_inventori'];     $result = array();     foreach($_post['kode_kategori_pelanggan'] $key => $val){         $result[] = array(                 "kode_kategori_pelanggan" => $_post['kode_kategori_pelanggan'][$key],                 "kode_inventori"=>$kode_inventori,                 "harga" => $_post['harga_jual'][$key],                 "diskon" => $_post['diskon'][$key]                 );     }     $res = $this->db->insert_batch('harga_inventori', $result);     redirect("inventori");

but when i'm using same pattern updating function, it's not working @ all.

for($i = 0; $i < count($_post['harga_jual'][$i]); $i++) {     if($_post['kode_kategori_pelanggan'][$i] != '') {         $res[] = array(                         'harga' => $_post['harga_jual'][$i],                         'diskon' => $_post['diskon'][$i],                        );         $this->db->where('kode_inventori',$_post['kode_inventori']);         $this->db->where('kode_kategori_pelanggan',$_post['kode_kategori_pelanggan'][$i]);         $this->db->update('harga_inventori',$res);     } } redirect("inventori");

i'm trying update_batch() got many errors, i'm using for loop , updating single row @ time.

what problem here?

its typo. should pass array $res not $data, , change $res[] $res since not needed. should check isset() prevent errors of undefined:

for($i = 0; $i < count($_post['harga_jual'][$i]); $i++) {     if(isset($_post['kode_kategori_pelanggan'][$i])) {         $res = array(                         'harga' => $_post['harga_jual'][$i],                         'diskon' => $_post['diskon'][$i],                        );         $this->db->where('kode_inventori',$_post['kode_inventori']);         $this->db->where('kode_kategori_pelanggan',$_post['kode_kategori_pelanggan'][$i]);         $this->db->update('harga_inventori',$res);     } } redirect("inventori");

it see of data know trying do. seems little strange initiate counter $i @ same time using array key in loop this: for($i = 0; $i < count($_post['harga_jual'][$i]); $i++)

it know how data in $_post looks like. try remove [$i] in loop. check each post variable set before using them, like:

for($i = 0; $i < count($_post['harga_jual']); $i++) {      if(isset($_post['kode_kategori_pelanggan'][$i])) {          // check if post variables set , if not set default value (in example empty string):         $harga_jual = isset($_post['harga_jual'][$i]) ? $_post['harga_jual'][$i] : '';          $diskon = isset($_post['diskon'][$i]) ? $_post['diskon'][$i] : '';                   $kode_inventori = isset($_post['kode_inventori']) ? $_post['kode_inventori'] : '';         $kode_kategori_pelanggan = $_post['kode_kategori_pelanggan'][$i]; // checked isset above...          $data = array(                     'harga' => $harga_jual,                     'diskon' => $diskon,                        );          $this->db->where('kode_inventori',$kode_inventori);         $this->db->where('kode_kategori_pelanggan', $kode_kategori_pelanggan);         $this->db->update('harga_inventori', $data);     } } redirect("inventori");

Comments

Post a Comment

Popular posts from this blog

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

android - Unable to generate FCM token from dynamically instantiated Firebase -

our business logic requires instantiate firebase during runtime. fetch firebase credentials (app id, api key etc.) default firebase location after knowing user's public key , create firebase instance using credentials. this means there 2 firebase instances used within app: the default "index" firebase gives credentials second the actual firebase intend use point forward the second firebase initialised this: firebaseapp app = firebaseapp.initializeapp(<context>, <options>, <app_label>); our problem traditional method of retrieving fcm token using firebaseinstanceidservice , ontokenrefresh() fails since ontokenrefresh() method called first firebase instance. directly calling string token = firebaseinstanceid.getinstance(app).gettoken(); returns null never ready when called. have tried polling test if token generated @ point. no luck. how can generate fcm token reliably firebase instance instantiated during runtime? i...
Read more