title: php codeigniter insert query
body: <p>Here is my model insert query. No any error but it is not work. Can any one explain what was the problem with the code.</p>
  
  <p>The query is :  </p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>INSERT INTO `user_invite` (`invt_code`, `invt_time`, `email`, `biz_id`, `role_role_id`) 
  VALUES ('IxKS0zgq6Dwv', '2017-10-02 09:27:38', 'test@gmail.com', '81', '3');</code></pre>
  </div>
  </div>
  </p>
  
  <p>when I got my last query and manually run it is working correctly. above is my last query.</p>
  
  <p>the problem with model my model is:
         public function adduser($sdata){</p>
  
  <pre><code>    $this-&gt;db-&gt;trans_start();
  
      $res = $this-&gt;db-&gt;insert('user_invite', $sdata);
  
      $this-&gt;db-&gt;trans_commit();
  
      $this-&gt;db-&gt;trans_complete();
  
      return $res;
  
  }
  </code></pre>