function posts2send($mysqlPostsResult)
{
$postsArray = [];
while ($mysqlPostRow = mysqli_fetch_array($mysqlPostsResult)) {
$postAssocArray = mysql2AssocArray($mysqlPostRow);
if ($postAssocArray['parentPostId'] == 0) {
$postsArray[] = array('id' => $postAssocArray['id'], 'parentPostId' => $postAssocArray['parentPostId'], 'postHTML' => parentPost2HTML($postAssocArray['id'], post2HTML($postAssocArray), ""));
} else {
$postsArray[] = array('id' => $postAssocArray['id'], 'parentPostId' => $postAssocArray['parentPostId'], 'postHTML' => post2HTML($postAssocArray));
}
}
return $postsArray;
}
<source src="files/sounds/smb_jump.mp3" type="audio/mpeg">
<source src="files/sounds/smb_jump.wav" type="audio/wav">
</audio>
<div class="row" id="posts-container">
<?php
// Loop and print out each forum post
while ($postResult = mysqli_fetch_array($posts, MYSQL_ASSOC)) {
// Turns the sql array into a properly formated post array
$post = mysql2AssocArray($postResult);
$postHtml = post2HTML($post);
// Get all the replies for this post
$repliesHtml = '';
$postReplies = mysqli_query($db, "SELECT * FROM forum_posts WHERE parent_id='" . $post['id'] . "' AND forum='{$forumId}' ");
while ($reply = mysqli_fetch_array($postReplies)) {
$repliesHtml .= post2HTML(mysql2AssocArray($reply));
}
// Print a forum post and all its replies
echo parentPost2HTML($post['id'], $postHtml, $repliesHtml);
}
?>
</div> <!-- .row #posts-container -->
<hr>
<?php
$all_posts = mysqli_query($db, "SELECT * FROM forum_posts WHERE `forum` = '{$forumId}' AND `parent_id` = 0");
$num_posts = mysqli_num_rows($all_posts);
$num_pages = ceil($num_posts / $forumDetails['posts_per_page']);
$paginationHtml = '';
for ($i = 1; $i < $num_pages + 1; $i++) {
