How to create Codeigniter batch insert array

by

Try this:

$data = array(
   array(
      'title' => 'My title' ,
      'name' => 'My Name' ,
      'date' => 'My date'
   ),
   array(
      'title' => 'Another title' ,
      'name' => 'Another Name' ,
      'date' => 'Another date'
   )
);

$this->db->insert_batch('mytable', $data);

For more information, read here

More Related Contents:

  1. How to add an ORDER BY clause using CodeIgniter’s Active Record methods?
  2. Grouping WHERE clauses in Codeigniter
  3. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  4. Escaping SQL queries in Codeigniter
  5. CodeIgniter only executing default controller
  6. How print in Jquery / Datatables [closed]
  7. Sending email with gmail smtp with codeigniter email library
  8. How to remove “index.php” in codeigniter’s path
  9. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  10. How to set proper codeigniter base url?
  11. CodeIgniter: “The filetype you are attempting to upload is not allowed.”
  12. Find total number of results in mySQL query with offset+limit
  13. Redirect with CodeIgniter
  14. How do I check if the request is made via AJAX in CodeIgniter?
  15. Retrieve JSON POST data in CodeIgniter
  16. CodeIgniter MSSQL connection
  17. codeigniter, result() vs. result_array()
  18. Codeigniter – Using Multiple Databases
  19. CodeIgniter default controller in a sub directory not working
  20. How to create Codeigniter language files from database?
  21. Codeigniter multiple file upload messes file extension
  22. Codeigniter send email with attach file
  23. CodeIgniter – how to catch DB errors?
  24. How to set time zone in codeigniter?
  25. Handling PUT/DELETE arguments in PHP
  26. Object of class stdClass could not be converted to string
  27. How to integrate PHPMailer with Codeigniter 3
  28. How to stop GD2 from washing away the colors upon resizing images?
  29. .htaccess Redirect non-WWW to WWW preserving URI string
  30. How can I have CodeIgniter load specific pages using SSL?

Leave a Comment