CI Framework ar operation (array form) implementation of methods for inserting multiple SQL data _php instance

In this paper, the method of inserting multiple SQL data into a CI framework ar operation is described. Share to everyone for your reference, specific as follows:

If you don't use AR, you can do this:

INSERT into TABLE (FIELDS) VALUES (' 1 ', ' 2 '), (' 3 ', ' 4 ');
$this->db->query ($sql);

Individuals still like the AR operation CI, the old version (2.0) should not insert more than one operation of data, the new version can be used:

$this->db->insert_batch ();

The following cases:

$data = Array (
  ' name ' => ' PHP ', '
  url ' => ' http://www.jb51.net '
 ),
 Array (
  ' name ' => ' cloud-dwelling community ',
  ' url ' => ' http://www.jb51.net ')
;
$this->db->insert_batch (' mytable ', $data);

The SQL generated above is the same:

Copy Code code as follows:

INSERT into mytable (name, URL) VALUES (' PHP ', ' http://www.jb51.net '), (' cloud-dwelling community ', ' http://www.jb51.net ')

Summary: Thedata parameters in the database shortcuts in the CI framework are typically one-dimensional associative arrays .

More interested in CodeIgniter related content readers can view the site topics: "CodeIgniter Introductory Course", "CI (CodeIgniter) Framework Advanced Course", "PHP Excellent Development Framework Summary", "thinkphp Introductory Course", " Thinkphp Common Methods Summary, "Zend Framework Introduction Course", "PHP object-oriented Programming Introduction Course", "Php+mysql Database operation Introduction Tutorial" and "PHP common database Operation Skills Summary"

I hope this article will help you with the PHP program design based on CodeIgniter framework.