douhan8892
douhan8892
2013-02-05 09:49

CodeIgniter将多维数组作为单独的行插入到数据库表中

已采纳

saving post value to an array.

$data2 = array(
  'invoice_id' =>($id),
  'order_id' => $this->input->post('order_id'),
  'invoiceitems_servicetype' =>$this->input->post('type'),
  'invoiceitems_quantity' => $this->input->post('quantity'),
  'invoiceitems_unitprice' => $this->input->post('rate'),
  'invoiceitems_notes' => $this->input->post('description')
      );

 $this->db->insert('abc_invoiceitems', $data2);

print_r($data2);

Array Structure.

Array
(
    [invoice_id] => 21
    [order_id] => 1
    [invoiceitems_servicetype] => Array
        (
            [0] => Order
            [1] => Miscellaneous
            [2] => Order
        )

    [invoiceitems_quantity] => Array
        (
            [0] => 5
            [1] => 64
            [2] => 88
        )

    [invoiceitems_unitprice] => Array
        (
            [0] =>  5
            [1] =>  6
            [2] =>  8
        )

    [invoiceitems_notes] => Array
        (
            [0] => test Data1
            [1] => test Data2
            [2] => test Data3
        )

)

Insert array values to database table.

TABLE NAME --- abc_invoiceitems 
 +------------+----------+--------------------------+-----------------------+------------------------+--------------------+
 | invoice_id | order_id | invoiceitems_servicetype | invoiceitems_quantity | invoiceitems_unitprice | invoiceitems_notes |
 +------------+----------+--------------------------+-----------------------+------------------------+--------------------+

I got this following error and the error is :

the values are returning as array.

INSERT INTO abc_invoiceitems (invoice_id, order_id, invoiceitems_servicetype, invoiceitems_quantity, invoiceitems_unitprice, invoiceitems_notes) VALUES ('21', '1', Array, Array, Array, Array)

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

2条回答

  • dougu1896 dougu1896 8年前

    Fetch post values:

    $temp =count($this->input->post('type'));//counting number of row's
$type= $this->input->post('type');
$quantity = $this->input->post('quantity');
$rate = $this->input->post('rate');
$description = $this->input->post('description');

    Loop through Key values:

    for($i=0; $i<$temp;$i++){
  $data2 = array(
  'invoice_id' =>($id),
  'order_id' => $this->input->post('order_id'),
  'invoiceitems_servicetype' =>$type[$i],
  'invoiceitems_quantity' => $quantity[$i],
  'invoiceitems_unitprice' => $rate[$i],
  'invoiceitems_notes' => $description[$i]
      );
   $this->db->insert('abc_invoiceitems', $data2);
  }
    点赞 评论 复制链接分享
  • dpy33121 dpy33121 8年前

    How about turning the arrays into serialized strings?

    $data2 = array(
    'invoice_id' =>($id),
    'order_id' => $this->input->post('order_id'),
    'invoiceitems_servicetype' => serialize($this->input->post('type')),
    'invoiceitems_quantity' => serialize($this->input->post('quantity')),
    'invoiceitems_unitprice' => serialize($this->input->post('rate')),
    'invoiceitems_notes' => serialize($this->input->post('description'))
);

$this->db->insert('abc_invoiceitems', $data2);

    When you want to pull the data back out of the database, you can unserialize the strings.

    点赞 评论 复制链接分享
提交

相关推荐

  • CodeIgniter将多维数组作为单独的行插入到数据库表中 phpmysql
    8年前
    回答 2 已采纳 saving post value to an array. $data2 = array( 'invoice_id' =&gt;($id), 'order_id' =&gt; $this-&gt;input-&gt;post('order_id'), 'invoiceitems_servicetype' =&gt;$this-&gt;input-&gt;post('type'), 'invoiceitems_quantity' =&gt; $this-&gt;input-&gt;post('quantity'), 'invoiceitems_unitprice' =&gt; $this-&gt;input-&gt;post('rate'), 'invoiceitems_notes' =&gt; $this-&gt;input-&gt;post('description') ); $this-&gt;db-&gt;insert('abc_invoiceitems', $data2); print_r($data2); Array Structure. Array ( [invoice_id] =&gt; 21 [order_id] =&gt; 1 [invoiceitems_servicetype] =&gt; Array ( [0] =&gt; Order [1] =&gt; Miscellaneous [2] =&gt; Order ) [invoiceitems_quantity] =&gt; Array ( [0] =&gt; 5 [1] =&gt; 64 [2] =&gt; 88 ) [invoiceitems_unitprice] =&gt; Array ( [0] =&gt; 5 [1] =&gt; 6 [2] =&gt; 8 ) [invoiceitems_notes] =&gt; Array ( [0] =&gt; test Data1 [1] =&gt; test Data2 [2] =&gt; test Data3 ) ) Insert array values to database table. TABLE NAME --- abc_invoiceitems +------------+----------+--------------------------+-----------------------+------------------------+--------------------+ | invoice_id | order_id | invoiceitems_servicetype | invoiceitems_quantity | invoiceitems_unitprice | invoiceitems_notes | +------------+----------+--------------------------+-----------------------+------------------------+--------------------+ I got this following error and the error is : the values are returning as array. INSERT INTO abc_invoiceitems (invoice_id, order_id, invoiceitems_servicetype, invoiceitems_quantity, invoiceitems_unitprice, invoiceitems_notes) VALUES ('21', '1', Array, Array, Array, Array)
  • Codeigniter多维数组插入数据库 phpmysql
    6年前
    回答 2 已采纳 Hello im trying to insert a multidimensional array into mysql using codeigniter. Im having some trouble getting the values to enter correctly. Here is how the multidimensional array looks Array ( [2] =&gt; Array ( [A] =&gt; FName 2 [B] =&gt; LName 2 [C] =&gt; PhoneNo 2 [D] =&gt; FaxNo 2 ) [3] =&gt; Array ( [A] =&gt; FName 3 [B] =&gt; LName 3 [C] =&gt; PhoneNo 3 [D] =&gt; FaxNo 3 ) [4] =&gt; Array ( [A] =&gt; FName 4 [B] =&gt; LName 4 [C] =&gt; PhoneNo 4 [D] =&gt; FaxNo 4 ) [5] =&gt; Array ( [A] =&gt; FName 5 [B] =&gt; LName 5 [C] =&gt; PhoneNo 5 [D] =&gt; FaxNo 5 ) [6] =&gt; Array ( [A] =&gt; FName 6 [B] =&gt; LName 6 [C] =&gt; PhoneNo 6 [D] =&gt; FaxNo 6 ) [7] =&gt; Array ( [A] =&gt; FName 7 [B] =&gt; LName 7 [C] =&gt; PhoneNo 7 [D] =&gt; FaxNo 7 ) [8] =&gt; Array ( [A] =&gt; FName 8 [B] =&gt; LName 8 [C] =&gt; PhoneNo 8 [D] =&gt; FaxNo 8 ) [9] =&gt; Array ( [A] =&gt; FName 9 [B] =&gt; LName 9 [C] =&gt; PhoneNo 9 [D] =&gt; FaxNo 9 ) ) Here is what i've tried doing function insertfiles($arr_data) { foreach ($arr_data as $value) { foreach($value as $key =&gt; $a){ $data = array( 'Firstname' =&gt; $a, 'Lastname' =&gt; $a, 'Phone'=&gt;$a, 'Fax' =&gt;$a ); $this-&gt;db-&gt;insert('test', $data); } } } Im sure im messing this up horribly, it is inserting the values into the database but it's inserting them as follows since it wont let me upload an image im providing a link to view this image online. http://psadatadesign.com/img/test-bmp.jpg any help would be appreciated. As im trying to figure out what i have done wrong.
  • 如何在CI中将多维数组插入数据库？ phpmysql
    4年前
    回答 1 已采纳 I have this array. Array ( [customer_id] =&gt; Array ( [customer_id] =&gt; 132 ) [file_name] =&gt; Array ( [0] =&gt; ht5appletv11.png [1] =&gt; twitter-100px11.png ) [file_path] =&gt; Array ( [0] =&gt; C:/xampp/htdocs/maintenance_assurance_sys/uploads/ht5appletv11.png [1] =&gt; C:/xampp/htdocs/myproject/uploads/twitter-100px11.png ) ) I want to insert these data into database with Row by Row in CI.But the customer_id is always same in each row. file_name and file_path will change. For example: How can i do that? +---------------------------------------------------------------------+ | customer_id | file_name |file_path | | 132 | ht5appletv11.png | C:/xampp/htodcs/..... | | 132 | twitter-100px11.png | C:/xampp/htodcs/..... | +---------------------------------------------------------------------+ Here is my Code... function insertUploadedFiles($data) { foreach ($data as $fileData) { $datas[] = array( 'customer_id' =&gt; $fileData['customer_id'], 'file_name' =&gt; $fileData['file_name'], 'file_path' =&gt; $fileData['file_path'] ); } $this-&gt;db-&gt;insert_batch('t_customer_file_ref', $datas); } But it's only get customer_id and the file_name &amp; file_path show error like this. Message: Undefined index: file_name Undefined index: file_path
  • 通过codeigniter中的嵌套数组将多行插入数据库 phpmysql
    5年前
    回答 1 已采纳 according to insert multiple rows using one forigenk value in form i want to insert multiple data at once through nested array. in my case data doesn't insert into the database. and no error messages to display.my code is below. any one can please help me to slove this problem. controller public function create(){ // validate fields $this-&gt;form_validation-&gt;set_rules('work_product_id', 'Work Product Id', 'required'); $this-&gt;form_validation-&gt;set_rules('work_item_description', 'Work Item Description', 'required'); $this-&gt;form_validation-&gt;set_rules('quantity', 'Quantity', 'required'); $this-&gt;form_validation-&gt;set_rules('rate', 'Rate', 'required|numeric'); $this-&gt;form_validation-&gt;set_rules('laboure_hrs', 'Laboure Hrs', 'required|numeric'); $this-&gt;form_validation-&gt;set_rules('laboure_cost', 'Laboure Cost', 'required|numeric'); // getting value of input fields if ($_POST) { $project_id=$this-&gt;input-&gt;post('project'); $staff_id=$this-&gt;input-&gt;post('staff_id'); $item_no=$this-&gt;input-&gt;post('work_product_id'); $description=$this-&gt;input-&gt;post('work_item_description'); $qty=$this-&gt;input-&gt;post('quantity'); $unit=$this-&gt;input-&gt;post('unit'); $rate=$this-&gt;input-&gt;post('rate'); $laboure_hrs=$this-&gt;input-&gt;post('laboure_hrs'); $laboure_cost=$this-&gt;input-&gt;post('laboure_cost'); $amount=$this-&gt;input-&gt;post('txtmultTotal'); $data=[]; for ($i = 0; $i &lt; count($this-&gt;input-&gt;post('work_product_id')); $i++) { $data[$i] = array( 'project_id' =&gt; $project_id, 'staff_id' =&gt; $staff_id[$i], 'item_no' =&gt; $item_no[$i], 'description' =&gt; $description[$i], 'qty' =&gt; $qty[$i], 'unit' =&gt; $unit[$i], 'rate' =&gt; $rate[$i], 'laboure_hrs' =&gt; $laboure_hrs[$i], 'laboure_cost' =&gt; $laboure_cost[$i], 'amount' =&gt; $amount[$i], ); } print_r($data); $this-&gt;boq_model-&gt;create($data); } } model function create($data){ $this -&gt; db-&gt; insert_batch('boq',$data); }
  • 在codeigniter php中将多维数组转换为单个数组 php
    3年前
    回答 2 已采纳 I have a multidimensional array as shown below Array ( [0] =&gt; Array ( [0] =&gt; stdClass Object ( [id] =&gt; 237 ) [1] =&gt; stdClass Object ( [id] =&gt; 228 ) ) [1] =&gt; Array ( [0] =&gt; stdClass Object ( [id] =&gt; 247 ) [1] =&gt; stdClass Object ( [id] =&gt; 238 ) ) ) I want to convert into single array as shown below Array ( [0] =&gt; stdClass Object ( [id] =&gt; 237 ) [1] =&gt; stdClass Object ( [id] =&gt; 228 ) [2] =&gt; stdClass Object ( [id] =&gt; 247 ) [3] =&gt; stdClass Object ( [id] =&gt; 238 ) ) I have tried with the following solution Convert multidimensional array into single array But the result am not getting Its Coming Null How to get the desired result for the above input. Any help appreciated.
  • 在codeigniter中进行多维输入数组检查 php
    8年前
    回答 1 已采纳 Currently I have data that it must has 1 title and 1 content, and randomly number (or none) link group (linktext and link ) , (as the it is dynamic generated) E.g. LinkText1 , Link1 , LinkText2, Link2....and so on. So, one example data is: title:"abc" content:"test" linktext1:"yahoo" link1:"http://yahoo.com" my form is &lt;input type="text" name="linktext[]"&gt; &lt;input type="text" name="link[]"&gt; The problem is, simply $this-&gt;form_validation-&gt;set_rules('linkTxt[]', '連結標題', 'required'); $this-&gt;form_validation-&gt;set_rules('link[]', '連結地址', 'required'); is not working I would like to if either linkTxt[0] or link[0] (or any pair) is exist , check the corresponding pair. If none of them exist (User can choose not to insert any link) (then no checking require) Thanks
  • 如何获取数组中的值以及如何使用codeigniter在数据库中插入 phpjson
    4年前
    回答 2 已采纳 Here i have one array, in this array i have one more array name studentAbsentId, now i want insert the studentAbsentId in database, like here studentAbsentId 2 and studentAbsentId 2 is absent so i need to insert the two rows My updated code print_r($params); Array ( [studentAbsentId] =&gt; Array ( [0] =&gt; 2 [1] =&gt; 3 ) [schoolId] =&gt; 2 [classId] =&gt; 1 [sectionId] =&gt; 1 [studentAbsentDate] =&gt; 2017-04-18 [reg_date] =&gt; 2017-04-18 05:20:17 [created_by] =&gt; 1 ) Now i want to take only studentAbsentId,how can do? expected results 2 3
  • 将数组插入sql数据库中的列 phpmysql
    7年前
    回答 1 已采纳 I'm using codeigniter, below is my array. How do I insert the data into a database with column name sibbling_name and sibbling_age. I tried a CI tutorial but it showed me an error because 0,1,2 is not field in db. Of course is it how to change that [0] into 'sibbling_name' column and [0] in sibblingAge into 'sibbling_age' column? [sibblingName] =&gt; Array ( [0] =&gt; Ryan Yaohari [1] =&gt; Rico Yaohari [2] =&gt; Rino Yaohari ) [sibblingAge] =&gt; Array ( [0] =&gt; 23 [1] =&gt; 21 [2] =&gt; 19 )
  • 如何将数据库中的ip地址值拆分为CodeIgniter中的数组格式 php
    3年前
    回答 2 已采纳 I'm working on the CodeIgniter application where I want to split IP address into the array format. Actually, I'm getting values from the database column but unable to create the array from the dynamic values which are getting from the database? Controller Code Getting Values from the database $system = $this-&gt;Xin_model-&gt;read_enter_allow_ip_address_info(1); $allowlist = array($system[0]-&gt;enter_allow_ip_address); $finalipallow = nl2br($allowlist); if(!in_array($_SERVER['REMOTE_ADDR'],$finalipallow)){ $Return['error'] = 'Login Failed'; $this-&gt;output($Return); } Models Query public function read_enter_allow_ip_address_info($id) { $condition = "setting_id =" . "'" . $id . "'"; $this-&gt;db-&gt;select('enter_allow_ip_address'); $this-&gt;db-&gt;from('xin_system_setting'); $this-&gt;db-&gt;where($condition); $this-&gt;db-&gt;limit(1); $query = $this-&gt;db-&gt;get(); return $query-&gt;result(); } Dynamic Values From The Database Column '10.0.0.1','10.0.0.2','10.0.0.3','::1' how do I split IP address values from database into the array format like this static array $finalipallow = array( '10.0.0.1', '10.0.0.2', '10.0.0.3', '::1' ); I have a static array which is working with if condition but I want to convert dynamic values into the array like the static array? Working now here the solution of it $system = $this-&gt;Xin_model-&gt;read_enter_allow_ip_address_info(1); $allowlist = $system[0]-&gt;enter_allow_ip_address; $finalipallow = str_getcsv($allowlist, ",", "'"); if(!in_array($_SERVER['REMOTE_ADDR'],$finalipallow)){ $Return['error'] = 'Login Failed'; $this-&gt;output($Return); }
  • CodeIgniter中多维数组的未定义索引 php
    9年前
    回答 2 已采纳 This will probably be very easy to get a solution for, but I can't get it to work and I've been trying some different methods I've found online ( read SO ). The strange is that my code worked perfectly when I had a different source for the images. Anyway my error: Message: Undefined index: url Filename: models/imageloader.php Line Number: 21 The code creating the array: &lt;?php class imageLoader extends CI_Model { var $gallery_path; var $gallery_path_url; function __construct() { parent::__construct(); $this-&gt;gallery_path = realpath(APPPATH . '../public_html/images'); $this-&gt;gallery_path_url = base_url() . 'images/'; } function get_images() { //$this-&gt;session-&gt;userdata('email') $this-&gt;db-&gt;where('upload_email', $this-&gt;session-&gt;userdata('email')); $query = $this-&gt;db-&gt;get('uploaded_images'); $images = array(); if($query-&gt;num_rows &gt; 0) { foreach($query-&gt;result_array() as $row) { $images[] = array( 'url' =&gt; $this-&gt;gallery_path_url . $row['url'], 'thumb_url' =&gt; $this-&gt;gallery_path_url . 'thumbs/' . $row['url'] ); } return $images; } } } And last the view for displaying some images: &lt;?php $x=0; if(isset($images) &amp;&amp; count($images)): foreach($images as $image): ?&gt; &lt;div class="thumb"&gt; &lt;a href="&lt;?php echo $image['url']; ?&gt;"&gt;&lt;img src="&lt;?php echo $image['thumb_url']; ?&gt;" /&gt;&lt;/a&gt; &lt;/div&gt; &lt;?php $x++; /*if($x == 21) break;*/ endforeach; else: ?&gt; My old code that sucks but work: http://pastie.org/3566053
  • codeigniter mysql_CodeIgniter连接数据库及快速入门
    4月前
    天使投资人Adam的博客 一、数据库配置CodeIgniter 有一个配置文件让你存放数据库连接值(username:用户名，password:密码，database name:数据库名，等等..). 该配置文件位于application/...配件文件存放在一个如下格式的一个多维数组...
  • CodeIgniter连接数据库及快速入门
    6年前
    weixin_33898876的博客 原文:CodeIgniter连接数据库及快速入门一、数据库配置 　CodeIgniter 有一个配置文件让你存放数据库连接值（username:用户名，password:密码，database name:数据库名，等等..）. 该配置文件位于application/config...
  • ci mysql 配置_CodeIgniter框架——数据库类(配置+快速入门)
    4月前
    weixin_39586683的博客 1、数据库配置CodeIgniter 有一个配置文件让你存放数据库连接值(username:用户名，password:密码，database name:数据库名，等等..). 该配置文件位于application/config...配件文件存放在一个如下格式的一个多维数组...
  • CI框架连接数据库配置操作以及多数据库操作
    8年前
    摘取天上星的博客 下面的内容将简单说明怎样使用数据库。更详细的信息请阅读各个函数的单独介绍页面。 初始化数据库类 下面的代码将依据你的数据库配置载入并初始化数据库类: $this-&gt;load-&gt;database();   一旦被载入，你可以在任何...
  • phpci框架连接mysql_ci框架连接数据库
    4月前
    weixin_39606048的博客 数据库快速入门例子代码下面的内容将简单说明怎样使用数据库。更详细的信息请阅读各个函数的单独介绍页面。初始化数据库类下面的代码将依据你的数据库配置载入并初始化数据库类:$this-&gt;load-&gt;database();一旦...
  • ci框架连接数据库
    7年前
    chaoren2011的博客 下面的内容将简单说明怎样使用数据库。更详细的信息请阅读各个函数的单独介绍页面。 初始化数据库类 下面的代码将依据你的数据库配置载入并初始化数据库类: $this-&gt;load-&gt;database();   一旦被载入，你...
  • ci mysql重连_ci框架连接数据库
    2月前
    维林兄弟的博客 数据库快速入门例子代码下面的内容将简单说明怎样使用数据库。更详细的信息请阅读各个函数的单独介绍页面。初始化数据库类下面的代码将依据你的数据库配置载入并初始化数据库类:$this-&gt;load-&gt;database();一旦...
  • ci mysql重连,CI框架连接数据库配置操作以及多数据库操作
    16天前
    销号le的博客 数据库快速入门例子代码下面的内容将简单说明怎样使用数据库。更详细的信息请阅读各个函数的单独介绍页面。初始化数据库类下面的代码将依据你的数据库配置载入并初始化数据库类:$this-&gt;load-&gt;database();一旦...
  • ci框架mysql多条件_CI框架连接数据库配置操作以及多数据库操作
    4月前
    半路的疯子的博客 数据库快速入门例子代码 下面的内容将简单说明怎样使用数据库。更详细的信息请阅读各个函数的单独介绍页面。 初始化数据库类 下面的代码将依据你的数据库配置载入并初始化数据库类: $this-load-database(); 一旦被...
  • CodeIgniter Doctrine2基本使用（二）(转)
    3年前
    weixin_34075551的博客 继上次写的一篇文章《CodeIgniter Doctrine2基本使用（一）》写到操作实体的之通过Channel这个实体向数据库表插入一条数据，那么今天要写的就是通过实体获取数据，当然查询这一块比较多，可能也会分好几篇讲。...