codeigniter calling empty_table before insert_batch

Question

I have a table(myTable) with 3 fields:

ID (int), posistion(int), products_id(int)

I have an form where we can change the order, and remove items from/in this list. After the user is done editing the list he submits the form.

I want to empty out the table before inserting the new data.

so i call $this->db->empty_table("myTable");

After that i insert the new data like this:

$this->db->insert_batch("jcarousel",$insert);

The problem is: somehow the empty_table() is called after the insert query, because my table always is empty. To be clear: My insert query is working fine when i comment out //$this->db->empty_table("myTable");

i have tried a couple of things, so my code i a bit messed up. Right now it looks like this:

public function change_carousel_order($value='')
{
    $this->output->enable_profiler(TRUE);
    $empty = $this->empty_table();
    //$empty = TRUE;
    $form = $this->input->post();
    //print_r($form['order']);
    $insert = array();
    foreach ($form['order'] as $key => $value) {
        //echo "value: ".$value;
        $insert[$key]['product_id'] = $value;
        $insert[$key]['posistion'] = $key;

    }
    echo $this->db->last_query();
    if($empty==TRUE)
    {
        echo "jaaa";
        echo $this->insert_change_carausel_order($insert);
    }
    else{
        echo "neee!";
    }
    echo $this->db->last_query();
    //redirect("welcome/jcarousel");
}
public function empty_table($value='')
{
    return $this->db->empty_table("jcarousel");
}
public function insert_change_carausel_order($insert=array())
{
    return $this->db->insert_batch("jcarousel",$insert);
}

Anyone who see what i am doing wrong? Why is'nt codeigniter inserting any data after empty_table() is called? Any help would be great full appreciated.

$this->output->enable_profiler(TRUE); tells us that there are 2 queries; the delete query runs indeed AFTER the insert query

0.0003       DELETE FROM `jcarousel` 
0.0002       INSERT INTO `jcarousel` (`posistion`, `product_id`) VALUES (0,'755'), (1,'835'), (2,'838')

and another result same setup:

0.0006       DELETE FROM `jcarousel` 
0.0002       INSERT INTO `jcarousel` (`posistion`, `product_id`) VALUES (0,'755'), (1,'835'), (2,'838')

what is you get echo $this->db->last_query(); after $this->insert_change_carausel_order($insert); — GBD
– GBD, Commented Nov 26, 2012 at 8:54
INSERT INTO jcarousel (posistion, product_id) VALUES (0,'755'), (1,'835'), (2,'838') — This_is_me
– This_is_me, Commented Nov 26, 2012 at 8:55
when and how you are calling change_carousel_order function. can you paste that code as well — GBD
– GBD, Commented Nov 26, 2012 at 9:18

GBD · Accepted Answer · 2012-11-26 08:56:46Z

0

I think you have spelling mistake issue.

As you stated

ID (int), position(int), products_id(int)

But in array you used as below

//wrong
$insert[$key]['product_id'] = $value;

//correct
$insert[$key]['products_id'] = $value;

//wrong
$insert[$key]['posistion'] = $key;

//correct
$insert[$key]['position'] = $key;

answered Nov 26, 2012 at 8:56

GBD

16k2 gold badges49 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

This_is_me Over a year ago

true i have spelling mistake, but i made the spelling mistake everywhere (except for the question). plus my insert query works fine when i command out the "$this->empty_table();" part

This_is_me Over a year ago

no, sorry, that was not the problem i am facing check my edited Question

This_is_me · Accepted Answer · 2013-06-20 12:28:01Z

0

The problem was chrome's firebug plugin. this causes the page to be loaded twice, there for the second time it loads it lost all its post data.

Hope i can help someone with this (beter late then never) awnser

answered Jun 20, 2013 at 12:28

This_is_me

9181 gold badge9 silver badges20 bronze badges

Collectives™ on Stack Overflow

codeigniter calling empty_table before insert_batch

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related