html output formatting php -
i trying format html output db using php , here's problem:
how should formated:
... <li> <div class="row-wrapper"> <div class="some-class-1">array-element-1</div> <div class="some-class-1">array-element-2</div> <div class="some-class-1">array-element-3</div> <div class="some-class-2">array-element-4</div> </div> <div class="row-wrapper"> <div class="some-class-1">array-element-5</div> <div class="some-class-1">array-element-6</div> <div class="some-class-1">array-element-7</div> <div class="some-class-2">array-element-8</div> </div> <div class="row-wrapper"> <div class="some-class-1">array-element-9</div> <div class="some-class-1">array-element-10</div> <div class="some-class-1">array-element-11</div> <div class="some-class-2">array-element-12</div> </div> </li> <li> <div class="row-wrapper"> <div class="some-class-1">array-element-13</div> <div class="some-class-1">array-element-14</div> <div class="some-class-1">array-element-15</div> <div class="some-class-2">array-element-16</div> </div> <div class="row-wrapper"> <div class="some-class-1">array-element-17</div> <div class="some-class-1">array-element-18</div> <div class="some-class-1">array-element-19</div> <div class="some-class-2">array-element-20</div> </div> <div class="row-wrapper"> <div class="some-class-1">array-element-21</div> <div class="some-class-1">array-element-22</div> <div class="some-class-1">array-element-23</div> <div class="some-class-2">array-element-24</div> </div> </li> ... etc.
data held inside array gathered mysql db, far got this:
$num_thumbs = 4; //number od elemets in row $result = myqueryfunction("select * table_name order id asc"); $num_rows = mysql_num_rows($result); if (!empty($num_rows)) { while ($row = mysql_fetch_array($result)) { $thumbs_array[] = "<a href=\"" . $row[0] . "\"><img src=\"" . $row[1] . "\""; } $thumb_p = "<div>\n"; mysql_free_result($result); $i = 1; foreach ($thumbs_array &$thumb_link) { if ($i == $num_thumbs) { $i = 1; $thumb_p .= "<div class=\"some-class-2\">" . $thumb_link . "</div>"; $thumb_p .= "</div>\n<div class=\"row-wrapper\">\n"; } else { $thumb_p .= "\t\n<div class=\"some-class-1\">" . $thumb_link . "</div>"; $i++; } } $thumb_p .= "\n</div>\n"; } print($thumb_p);
this covers part of code formatting:
<div class="row-wrapper"> <div class="some-class-1">array-element-13</div> <div class="some-class-1">array-element-14</div> <div class="some-class-1">array-element-15</div> <div class="some-class-2">array-element-16</div> </div> <div class="row-wrapper"> <div class="some-class-1">array-element-17</div> <div class="some-class-1">array-element-18</div> <div class="some-class-1">array-element-19</div> <div class="some-class-2">array-element-20</div> </div> <div class="row-wrapper"> <div class="some-class-1">array-element-21</div> <div class="some-class-1">array-element-22</div> <div class="some-class-1">array-element-23</div> <div class="some-class-2">array-element-24</div> </div>
i've been thinking of using variable $newlist = null; updated @ each row, can check if has changed next one. ideas? in advance :)
it seems you're trying put li every 3 div. in case, can :
$thumb_p = "<li>\n<div class=\"row-wrapper\">\n"; mysql_free_result($result); $i = 1; $j = 0; foreach ($thumbs_array &$thumb_link) { if ($i == $num_thumbs) { $i = 1; $thumb_p .= "<div class=\"some-class-2\">" . $thumb_link . "</div>"; $thumb_p .= "</div>\n"; if($j == 3) { $thumb_p .= "</li>\n<li>"; $j = 0; } $thumb_p .= "<div class=\"row-wrapper\">\n"; $j++; } else { $thumb_p .= "\t\n<div class=\"some-class-1\">" . $thumb_link . "</div>"; $i++; } } $thumb_p .= "\n</div>\n</li>\n";
i can't try think it's okay. li added every 3 row-wrapper print.
Comments
Post a Comment