inserting multiple rows in database on codeigniter

Question

Possible Duplicate:
insert multiple rows via a php array into mysql

i am trying to insert only filled data in to the database. my controller

$code=$_POST['code'];
$rate=$_POST['rate'];
$quantity=$_POST['quantity'];
//$total=$_POST['rate']*$_POST['quantity'];
$count = count($_POST['code']);
for($i=0; $i<$count; $i++) {
    $data = array(
               'shop'=>$shop->$this->input->post('shop'),
               'code' => $code[$i], 
               'rate' => $rate[$i],
               'quantity' => $quantity[$i],
               'total' =>($rate[$i]*$quantity[$i])

           );
$this->load->model('buy_product_model');
$this->buy_product_model->add_product($data);

i have a drop downlist to select shop and for that shop i have created 15 input field.the fields are on the above.the problem is if i only fill up only one or two value it creates 15 rows in the database and 15 time repate the shop name.Can anyone fix this problem.

You don't seem to close your `for` loop anywhere, is that just a bad copy and paste from your code - or should I post that as the answer? — Fluffeh, Aug 31 '12 at 08:30

WatsMyName · Answer 1 · 2012-08-31T09:29:38.193

instead of manipulating $_POST in controller manipulate it in model like this

Your controller

$this->load->model('buy_product_model');
$this->buy_product_model->add_product($this->input->post());

EDIT

Make sure the form fields in html form are in array form like this

<input type="text" name="code[]" />

Your model

public function buy_product_model($postdata){
   extract($postdata);
   $count = count($code);
   for($i=0; $i<$count; $i++) {
       $data = array(
               'shop'=>$shop,
               'code' => $code[$i], 
               'rate' => $rate[$i],
               'quantity' => $quantity[$i],
               'total' =>($rate[$i]*$quantity[$i])

           );
       $this->db->insert('[YOUR TABLE]', $data); 
   }
}

MAKE SURE TO CHANGE [YOUR TABLE] TO YOURS

add rest of the code you have in method add_product of your model and iterate through a loop as you have done in your controller.

Edit:

Please check 'shop'=>$shop->$this->input->post('shop') part in your loop

it insert only one row and only the shop name nothing else.rest of the rows are not inserted in database — Rahat Islam Khan, Aug 31 '12 at 09:15

score 0 · Answer 2 · answered Aug 31 '12 at 08:42

0

Based on this part of your question:

i have a drop downlist to select shop and for that shop i have created 15 input field.the fields are on the above.the problem is if i only fill up only one or two value it creates 15 rows in the database and 15 time repate the shop name.Can anyone fix this problem.

It seems to be a problem of database design more so than an error in your code. If your table has a column called Shop Name and you are inserting data into it, you will repeat it fifteen times.

I would suggest breaking up the table into to and linking via a join between them like this:

Table Shops:
ID
Name

Table Products:
ID
shopID // This links to the first table on shopID=ID
...  and so on for your *product* information

answered Aug 31 '12 at 08:42

Fluffeh

33,228
16
67
80

its for, from which shop i have purchased those product. – Rahat Islam Khan Aug 31 '12 at 09:27
@RahatIslamKhan If you need the data, why are you unhappy with it being inserted? I don't understand. – Fluffeh Aug 31 '12 at 09:28
i may purchase many product from a shop.thats why i want to insert all the data at the same time – Rahat Islam Khan Aug 31 '12 at 10:40

score 0 · Answer 3 · answered Aug 31 '12 at 20:04

at last i fix it.here is my view

    <?php for($i = 1; $i <=10; $i++):?>
        <tr>
            <td>
                <?php echo $i;?>
            </td>

            <td>
            <input type="text" name="code[]" value="<?php echo '';?>" id="code" />
            </td>

            <td>
                <input type="text" name="rate[]" value="<?php echo '';?>" id="rate" />
            </td>
            <td>
                <input type="text" name="quantity[]" value="<?php echo '';?>" id="quantity" />
            </td>

        </tr>
        <?php endfor;?>

here is my controller

    if (empty($_POST)) 

    {

        $this->index();
    } 

else 
    {
        //insert to database
        $this->load->model('buy_product_model');
        $data= $this->buy_product_model->add_product();
        //echo "success";
        $this->index();
    }

model//

   $data  = array();
        $todayDate = date('Y-m-d');
        for($i = 0; $i < count($_POST['code']); $i++)
            {
                if($_POST['code'][$i] != '')
                    {
                        $data[] = array(
                            'code' => $_POST['code'][$i],
                            'shop' => $_POST['shop'],
                            'rate' => $_POST['rate'][$i],
                            'quantity' => $_POST['quantity'][$i],
                            'total' =>( $_POST['rate'][$i]*$_POST['quantity'][$i]),
                            'date' => $todayDate
                            );
                    }
            }
                $dataCount = count($data);

                if($dataCount)
                {
                $this->db->insert_batch('purchase', $data);
                }

                return $dataCount;

inserting multiple rows in database on codeigniter

3 Answers3

Linked