Insert Data from array to database on Codeigniter -


i want insert data array, array format codeigniter frameworks.

array ( [run_date] => array ( [0] => 2015-06-15 11:10 [1] => 2015-06-15 11:10 [2] => 2015-06-15 11:10 [3] => 2015-06-15 11:10 ) [msisdn] => array ( [0] => 8499270093 [1] => 8599387282 [2] => 6281019183 [3] => 8597375112 ) )

i've been trying use insert_batch command on codeigniter it's not works @ all. such below.

my controller

function insertfromconfirmation() {     $datanew = array(        'run_date' => $this->input->post('run_date'),        'msisdn' => $this->input->post('msisdn')     );      print_r($datanew);       $this->modelmsisdn->insertdataarray($datanew);  }

and model

public function insertdataarray($datanew) {     $this->db->insert_batch('subscription_renewal', $datanew); }

error shown:

error number: 1054 unknown column '0' in 'field list' insert `subscription_renewal` (`0`, `1`, `2`, `3`) values ('2015-06-15 11:10','2015-06-15 11:10','2015-06-15 11:10','2015-06-15 11:10'), ('8499270093','8599387282','6281019183','8597375112')

filename: c:\xampp\htdocs\msisdn_tools_new\system\database\db_driver.php line number: 330

table structure

  create table subscription_renewal (   id int(11) not null auto_increment,   msisdn varchar(32) character set utf8 not null,   service varchar(64) character set utf8 not null,   adn varchar(8) character set utf8 not null,   operator varchar(32) character set utf8 not null,   channel varchar(16) character set utf8 not null,   status tinyint(4) not null,   description varchar(20) character set utf8 default null,   blacklist_status tinyint(4) not null,   date_created datetime not null,   date_modified datetime not null,   run_date datetime default null,   price varchar(30) default null,   primary key (id) ) engine=innodb auto_increment=476 default charset=latin1

insert batch array structure looking incorrect, should pass input data set array of each row... see sample array structure

 $run_date = $this->input->post('run_date');  $msisdn = $this->input->post('msisdn');  $datanew = array();  foreach($run_date $k => $v){        $datanew[] = array(            'run_date' => $v,            'msisdn' => $msisdn[$i] //suppose $msisdn[] have same key length $run_date[] array            );  }  $this->modelmsisdn->insertdataarray($datanew);

Comments

Post a Comment

Popular posts from this blog

javascript - Google App Script ContentService downloadAsFile not working -

i have web app developed using google app script htmlservice , html form, populating excel sheet in google drive using spreadsheetapp . , 1 section calling contentservice download data excel file. function doget(e) { // read excel sheet //getappfile(); // render application html template return htmlservice.createtemplatefromfile('index').evaluate() .settitle('go smart') .setsandboxmode(htmlservice.sandboxmode.iframe); } function downloaddoublequatecsvfile() { var sheetid = propertiesservice.getscriptproperties().getproperty('sheetid'); var ss = spreadsheetapp.openbyid(sheetid).getactivesheet(); //var ss = spreadsheetapp.getactivespreadsheet().getactivesheet(); var maxcolumn = ss.getlastcolumn(); var maxrow = ss.getlastrow(); var data = ss.getrange(1, 1, maxrow, maxcolumn).getvalues(); if (data.length > 1) { var csv = ""; (var row = 0; row < data.length; row++) { (var c...
Read more

javascript - Function overwritting -

is there way overwrite function or event handling in function? using addeventlistener, can have many event handlers on element want var test=document.getelementbyid("div"); test.addeventlistener("click",function(){alert("im first");},false); test.addeventlistener("click",function(){alert("im second");},false); // alerts "im first" , after "im second" but if want overwrite function/event example based on client width example this function one() { alert("first"); } function two() { alert("second"); } window.onresize = function() { var test = document.getelementbyid("div"); if (window.innerwidth > 500) { test.onclick = 1 } else { test.onclick = two; } } is possible in javascript? in case use effective little known approach. addeventlistener can accept object property handleevent event handler. in case it's easy overwr...
Read more

c# - Exception when attempting to modify Dictionary -

i creating dictionary manage threads , ran exception when attempt clear dead threads after adding threads dictionary. using system; using system.collections.generic; using system.threading; namespace syscat { public class threadmanager { public static readonly threadmanager globalthreadmanager = new threadmanager( ); /// <summary> /// initializes new instance of <see cref="syscat.threadmanager"/> class. /// </summary> public threadmanager( ) { } /// <summary> /// create new threadmanager threads within basetm , deinitializes basetm /// </summary> public threadmanager( threadmanager basetm ) { this.threads = basetm.threads; basetm.threads.clear( ); } private dictionary<guid,thread> threads = new dictionary<guid, thread>( ); /// <summary> /// attempts obtain unused threadid within ...
Read more