how to get last insert id after insert query in codeigniter active record

by

Try this

function add_post($post_data){
   $this->db->insert('posts', $post_data);
   $insert_id = $this->db->insert_id();

   return  $insert_id;
}

In case of multiple inserts you could use 

$this->db->trans_start();
$this->db->trans_complete();

More Related Contents:

  1. Codeigniter – multiple database connections
  2. UNION query with codeigniter’s active record pattern
  3. How would I use ON DUPLICATE KEY UPDATE in my CodeIgniter model?
  4. Delete the entire content of all table in a Database [closed]
  5. MyISAM versus InnoDB [closed]
  6. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  7. MySQL string replace
  8. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  9. How do I find the MySQL my.cnf location
  10. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  11. MySQL select one column DISTINCT, with corresponding other columns
  12. How to use mysql JOIN without ON condition?
  13. How to remove all non-alpha numeric characters from a string in MySQL?
  14. Define a variable within select and use it within the same select
  15. ERROR: Error 1005: Can’t create table (errno: 121)
  16. Mysql Convert Column to row (Pivot table )
  17. Merge two tables in one SQL query and make the date values unique
  18. How to get all columns’ names for all the tables in MySQL?
  19. How to fix double-encoded UTF8 characters (in an utf-8 table)
  20. How to integrate ElasticSearch with MySQL?
  21. How to change MySQL table names in Linux server to be case insensitive?
  22. MySQL command line formatting with UTF8
  23. MYSQL select DISTINCT values in two columns
  24. MySQL LOAD_FILE() loads null values
  25. MySQL Select ID’s which occur on different rows with multiple specific values for a column
  26. Use promise to process MySQL return value in node.js
  27. where does MySQL store database files?
  28. How can I achieve initcap functionality in MySQL?
  29. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  30. Dump only the data with mysqldump without any table information?

Leave a Comment