Data inserted three times CodeIgniter

Question

$data = array(
    'date' => $time,
    'boxoffice'=> $boxoffice,
    'upcoming'=> $upcoming,
    'intheaters'=> $intheaters,
    'opening' => $opening,
    'user'  => $users,
    'movie' => $movies,
    'star'  => $actors,
    'diractor' => $directores,
    'writer'  => $writeres,
    'cast'  => $casts,
    'comment'=> $comment,
    'image' => $images,
    'genre' => $genre,
    'country'=> $countrycode
);

try {
    $this->db->insert('muvidb_updatehistory',$data);
}
catch (Exception $e){}

I have those codes above in my project, at first it seems working fine but when i looked into my table, the value inserted three times. I’m new in codeigniter and i am stuck with this problem.

Anyone have an idea why is this happening?

Something is off, theres something you're not showing us. That code would never be called 3 times. — Jan Dragsbaek, Nov 29 '11 at 11:33
Jan is right, that couldn't insert three times just from that code. Could you share a little more with us? Also, you might want to add some more indexes to your table in your db to avoid this problem both sides. — eyaka1, Nov 29 '11 at 11:36
original url is http://www.muvidb.com/index.php/updatedb/history/ — Abhilash Joseph, Nov 29 '11 at 11:47
function history(){ $data=array( 'date' =>$time, 'boxoffice' => $boxoffice, 'upcoming' => $upcoming, 'intheaters' => $intheaters, 'opening' => $opening, 'user' => $users, 'movie' => $movies, 'star' => $actors, 'diractor' => $directores, 'writer' => $writeres, 'cast' => $casts, 'comment' => $comment, 'image' => $images, 'genre' => $genre, 'country' => $countrycode ); try { $this->db->insert('muvidb_updatehistory',$data); } catch (Exception $e){} } — Abhilash Joseph, Nov 29 '11 at 11:49
"NOTHING IS OFF " well, evidently, something IS off, otherwise it wouldn't be inserting the record into the db 3 times. — Flukey, Nov 29 '11 at 11:52
Flukey : just ref this url :http://codeigniter.com/forums/viewthread/204526/ and tel What happed in this ???? — Abhilash Joseph, Nov 29 '11 at 12:05

score 0 · Accepted Answer · answered Dec 01 '11 at 04:53

Have you checked to see if you have some sort of rewrite trickery or a dev debug tool that would access that URL 3 times? (Or even a referrer search bot, or the like...)

This is why you should probably verify it's a POST request before inserting data. GET requests that adhere to HTTP specs shouldn't alter data...

score 0 · Answer 2 · edited May 23 '17 at 12:03

0

You probably have poor double submit checking. More information, see my answer here: duplicate data insert in CodeIgniter

Your best bet in this case is to see if the data already exists, and if it does, to update it instead of insert. I'll add an example later.

edited May 23 '17 at 12:03

Community

1
1

answered Dec 01 '11 at 05:07

Gustav Bertram

14,591
3
40
65

Data inserted three times CodeIgniter

2 Answers2