<span class="pln"> </span><span class="pun">&lt;?</span><span class="pln">php </span><span class="kwd">namespace</span><span class="pln"> </span><span class="typ">App</span><span class="pln">\Controllers\Database\Helper</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">use</span><span class="pln"> </span><span class="typ">App</span><span class="pln">\Controllers\BaseController</span><span class="pun">;</span><span class="pln"> </span><span class="com">/** * Description of Query * * @author hoksi */</span><span class="pln"> </span><span class="kwd">class</span><span class="pln"> </span><span class="typ">Query</span><span class="pln"> </span><span class="kwd">extends</span><span class="pln"> </span><span class="typ">BaseController</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">function</span><span class="pln"> index</span><span class="pun">()</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="com">/* @var $db \CodeIgniter\Database\BaseConnection */</span><span class="pln"> $db </span><span class="pun">=</span><span class="pln"> db_connect</span><span class="pun">();</span><span class="pln"> $db</span><span class="pun">-&gt;</span><span class="pln">table</span><span class="pun">(</span><span class="str">'my_table_insert'</span><span class="pun">)-&gt;</span><span class="pln">insert</span><span class="pun">([</span><span class="pln"> </span><span class="str">'name'</span><span class="pln"> </span><span class="pun">=&gt;</span><span class="pln"> </span><span class="str">'test'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'title'</span><span class="pln"> </span><span class="pun">=&gt;</span><span class="pln"> </span><span class="str">'test-title'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'email'</span><span class="pln"> </span><span class="pun">=&gt;</span><span class="pln"> </span><span class="str">'test@test.com'</span><span class="pln"> </span><span class="pun">]);</span><span class="pln"> echo </span><span class="str">'&lt;h2&gt;$db-&gt;insertID()&lt;/h2&gt;'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'&lt;p&gt;데이터베이스 INSERT 수행시 INSERT ID입니다.&lt;/p&gt;'</span><span class="pun">;</span><span class="pln"> echo $db</span><span class="pun">-&gt;</span><span class="pln">insertID</span><span class="pun">();</span><span class="pln"> echo </span><span class="str">'&lt;h2&gt;$db-&gt;affectedRows()&lt;/h2&gt;'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'&lt;p&gt;“쓰기(insert, update, delete)” 유형 쿼리를 수행할 때 영향을 받는 행의 갯수를 표시합니다.&lt;/p&gt;'</span><span class="pun">;</span><span class="pln"> echo $db</span><span class="pun">-&gt;</span><span class="pln">affectedRows</span><span class="pun">();</span><span class="pln"> echo </span><span class="str">'&lt;h2&gt;$db-&gt;getLastQuery()&lt;/h2&gt;'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'&lt;p&gt;마지막으로 실행 된 쿼리(결과가 아닌 쿼리 문자열)를 나타내는 Query 개체를 반환합니다.&lt;/p&gt;'</span><span class="pun">;</span><span class="pln"> echo $db</span><span class="pun">-&gt;</span><span class="pln">getLastQuery</span><span class="pun">();</span><span class="pln"> $db</span><span class="pun">-&gt;</span><span class="pln">table</span><span class="pun">(</span><span class="str">'my_table_insert'</span><span class="pun">)-&gt;</span><span class="pln">truncate</span><span class="pun">();</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="pun">}</span>