StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You're doing it wrong. In your procedural example you're iterating over the data a row at a time; in your OO example, if you treat them as arrays and then print them, you're going through the data a column at a time instead. Rather than separating the data into separate ids and titles, I would treat them as a bundle (i.e. similar to how you did it in the procedural version) - an id goes with a title, not other ids, right?</p> <p>So, for example, you might have a member variable</p> <pre><code>private $texts = array(); </code></pre> <p>and then in your constructor, do:</p> <pre><code>while ($info_row = $info->fetch_array()) { $text = array( 'id' => $info_row['info_id'], 'title' => $info_row['info_title'] ); $this->texts[] = $text; } </code></pre> <p>and then provide a method to get at this array of arrays:</p> <pre><code>public function getTexts() { return $this->texts; } </code></pre> <p>Finally, you could iterate over it very similarly to how you did in the procedural example:</p> <pre><code><?php $display = new InfoTest(); foreach ($display->getTexts() as $text) { ?>  <?php echo $text['info_id']; ?>  <?php echo $text['info_title']; ?>  <? } ?> </code></pre> <p>Stepping back - you could ask if all this is really necessary. There's nothing inherently wrong with procedural PHP - if it does what you need it to do and does it clearly, you might be better off favoring simple over complex here.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload