<p>was having an issue when trying to return a multi array using sqlite over multiple rows.</p>
<p><a href="https://stackoverflow.com/questions/22745546/how-to-make-sqlite3-fetched-array-more-clean" target="blank" rel="noopener">Stack Overflow Inspiration</a>&nbsp;</p>
<p>I tried a few of these but it was not incrementing key, and also it was only showing one result.&nbsp;</p>
<h4>PHP</h4>
<pre><code class="php hljs">&nbsp; &nbsp; &nbsp; while($row = $result-&gt;fetchArray()) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $hasresults = true;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $returnarray = array();<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(isset($returnasarray) &amp;&amp; ($returnasarray == true)) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; / add to an array and return it. /<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; / each item needs its own sub array. /&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $key = 1;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $returnarray[$row['id']] = $row;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; / $returnarray[$key][$row['id']] = $row; /<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; / $returnarray[$key] = $returnarray[$row['id']] = $row; /<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $key = $key + 1;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // echo $key;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach($this-&gt;loadarray as $loadtitle) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $template-&gt;set($loadtitle, $row[$loadtitle]);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $returnarray-&gt;push();<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $loadvalue = $row[$loadtitle];<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $loadvalue = htmlentities($loadvalue);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $returnarray = [$key =&gt; ['$loadtitle',$loadvalue]];<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $key++;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /</code></pre>
<p>Yep that is a mess, so try again.&nbsp;</p>
<p>Ok try number two, this one seems to work, but does not extract all items just specified ones.&nbsp;</p>
<h4>PHP</h4>
<pre><code class="php hljs">&nbsp; &nbsp; &nbsp; $result = $this-&gt;db-&gt;query($sql);<br />&nbsp; &nbsp; &nbsp; $row = array();<br />&nbsp; &nbsp; &nbsp; $i = 0;<br />&nbsp; &nbsp; &nbsp; while($res = $result-&gt;fetchArray()) {<br /> &nbsp; &nbsp; &nbsp; $row[$i]['id'] = $res['id'];<br />&nbsp; &nbsp; &nbsp; &nbsp; $row[$i]['title'] = $res['title'];<br />&nbsp; &nbsp; &nbsp; &nbsp; $i++;<br />&nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; return $row</code></pre>
<p>I almost gave up on this one, but this is now returning this array so yay,...</p>
<p><img src="https://i.imgur.com/75MYpjT.png" /></p>
<p>Now that is working i have to see if i can auto load all items in the load array into that array output so i dont have to manually add each one per class.&nbsp;</p>
<p>Now i am happy, its working with the load array for all items required per class extend.&nbsp;</p>
<h4>PHP</h4>
<pre><code class="php hljs">&nbsp; &nbsp; &nbsp; $result = $this-&gt;db-&gt;query($sql);<br />&nbsp; &nbsp; &nbsp; $row = array();<br />&nbsp; &nbsp; &nbsp; $i = 0;<br />&nbsp; &nbsp; &nbsp; while($res = $result-&gt;fetchArray()) {<br />&nbsp; &nbsp; &nbsp; &nbsp; foreach($this-&gt;loadarray as $loadtitle) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $row[$i][$loadtitle] = $res[$load_title];<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; $i++;<br />&nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; return $row;</code></pre>
<p>Look at that beautiful JSON array.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.imgur.com/pc7Am0w.png" /></p>