title: Insert data with CodeIgniter Active Records
body: <p>My question is about inserting data with CodeIgniter Active record. There's an example on the guide to insert data with array:</p>
  
  <pre><code>$data = array(
     'title' =&gt; 'My title' ,
     'name' =&gt; 'My Name' ,
     'date' =&gt; 'My date'
  );
  
  $this-&gt;db-&gt;insert('mytable', $data); 
  </code></pre>
  
  <p>I wonder if there is some other way to insert the active record data, For example in in similar syntax:</p>
  
  <pre><code>    $this -&gt; db -&gt; select (*);
      $this -&gt; db -&gt; from ('users');
      $this -&gt; db -&gt; where('id', $id);
      $this -&gt; db -&gt; limit(1);
  
      $query = $this-&gt;db-&gt;get();
  </code></pre>
  
  <p>Thanks.</p>