<span class="pln"> </span><span class="pun"><?</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\Result</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 GetResult * * @author hoksi */</span><span class="pln"> </span><span class="kwd">class</span><span class="pln"> </span><span class="typ">GetResult</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"> $db </span><span class="pun">=</span><span class="pln"> db_connect</span><span class="pun">();</span><span class="pln"> $query </span><span class="pun">=</span><span class="pln"> $db</span><span class="pun">-></span><span class="pln">table</span><span class="pun">(</span><span class="str">'my_table'</span><span class="pun">)-></span><span class="kwd">get</span><span class="pun">();</span><span class="pln"> echo </span><span class="str">'<p>`getResult()`는 쿼리 결과를 objects의 배열로 반환하고, 실패시는 빈 배열을 반환합니다.</p>'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'<ul>'</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">foreach</span><span class="pln"> </span><span class="pun">(</span><span class="pln">$query</span><span class="pun">-></span><span class="pln">getResult</span><span class="pun">()</span><span class="pln"> </span><span class="kwd">as</span><span class="pln"> $row</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> echo </span><span class="str">'<li>'</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">title</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">name</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">email</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'</li>'</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> echo </span><span class="str">'</ul>'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'<p>이 메소드는 `getResultObject()`의 별칭입니다.</p>'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'<ul>'</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">foreach</span><span class="pln"> </span><span class="pun">(</span><span class="pln">$query</span><span class="pun">-></span><span class="pln">getResultObject</span><span class="pun">()</span><span class="pln"> </span><span class="kwd">as</span><span class="pln"> $row</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> echo </span><span class="str">'<li>'</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">title</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">name</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">email</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'</li>'</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> echo </span><span class="str">'</ul>'</span><span class="pun">;</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"> array</span><span class="pun">()</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> $db </span><span class="pun">=</span><span class="pln"> db_connect</span><span class="pun">();</span><span class="pln"> $query </span><span class="pun">=</span><span class="pln"> $db</span><span class="pun">-></span><span class="pln">table</span><span class="pun">(</span><span class="str">'my_table'</span><span class="pun">)-></span><span class="kwd">get</span><span class="pun">();</span><span class="pln"> echo </span><span class="str">'<p>결과를 배열로 얻으려면 `getResult("array")`와 같이 하면됩니다..</p>'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'<ul>'</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">foreach</span><span class="pln"> </span><span class="pun">(</span><span class="pln">$query</span><span class="pun">-></span><span class="pln">getResult</span><span class="pun">(</span><span class="str">'array'</span><span class="pun">)</span><span class="pln"> </span><span class="kwd">as</span><span class="pln"> $row</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> echo </span><span class="str">'<li>'</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'title'</span><span class="pun">];</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'name'</span><span class="pun">];</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'email'</span><span class="pun">];</span><span class="pln"> echo </span><span class="str">'</li>'</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> echo </span><span class="str">'</ul>'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'<p>`getResult("array")`는 `getResultArray()`의 별칭입니다.</p>'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'<ul>'</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">foreach</span><span class="pln"> </span><span class="pun">(</span><span class="pln">$query</span><span class="pun">-></span><span class="pln">getResultArray</span><span class="pun">()</span><span class="pln"> </span><span class="kwd">as</span><span class="pln"> $row</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> echo </span><span class="str">'<li>'</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'title'</span><span class="pun">];</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'name'</span><span class="pun">];</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'email'</span><span class="pun">];</span><span class="pln"> echo </span><span class="str">'</li>'</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> echo </span><span class="str">'</ul>'</span><span class="pun">;</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"> custom</span><span class="pun">()</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> $db </span><span class="pun">=</span><span class="pln"> db_connect</span><span class="pun">();</span><span class="pln"> $query </span><span class="pun">=</span><span class="pln"> $db</span><span class="pun">-></span><span class="pln">table</span><span class="pun">(</span><span class="str">'my_table'</span><span class="pun">)-></span><span class="kwd">get</span><span class="pun">();</span><span class="pln"> echo </span><span class="str">'<p>`getResult()`의 각 결과 객체에 대해 인스턴스화 할 클래스를 나타내는 문자열을 전달할 수도 있습니다.</p>'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'<ul>'</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">foreach</span><span class="pln"> </span><span class="pun">(</span><span class="pln">$query</span><span class="pun">-></span><span class="pln">getResult</span><span class="pun">(</span><span class="str">'\App\Controllers\Database\Result\User'</span><span class="pun">)</span><span class="pln"> </span><span class="kwd">as</span><span class="pln"> $row</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> echo </span><span class="str">'<li>'</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">name</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">reverseName</span><span class="pun">();</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">email</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'</li>'</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> echo </span><span class="str">'</ul>'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'<p>이 사용법은 ``getCustomResultObject()``의 별칭입니다.</p>'</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'<ul>'</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">foreach</span><span class="pln"> </span><span class="pun">(</span><span class="pln">$query</span><span class="pun">-></span><span class="pln">getCustomResultObject</span><span class="pun">(</span><span class="str">'\App\Controllers\Database\Result\User'</span><span class="pun">)</span><span class="pln"> </span><span class="kwd">as</span><span class="pln"> $row</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> echo </span><span class="str">'<li>'</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">name</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">reverseName</span><span class="pun">();</span><span class="pln"> echo </span><span class="str">' - '</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">email</span><span class="pun">;</span><span class="pln"> echo </span><span class="str">'</li>'</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> echo </span><span class="str">'</ul>'</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="pun">}</span>