diff options
Diffstat (limited to 'index.php')
-rw-r--r-- | index.php | 23 |
1 files changed, 19 insertions, 4 deletions
@@ -24,25 +24,40 @@ include_once 'header.php'; die('Failure trying to display categories: ' . mysqli_error($dbc)); } + $sql = "SELECT thread_id, thread_subject, thread_date, user_id, user_name FROM threads JOIN users ON thread_author = user_id WHERE thread_cat = ? ORDER BY thread_id DESC LIMIT 1"; + $stmt = mysqli_stmt_init($dbc); + + if (!mysqli_stmt_prepare($stmt, $sql)) { + die('Could not create thread due to internal error: ' . mysqli_error($dbc)); + } + while ($row = mysqli_fetch_assoc($result)) { + mysqli_stmt_bind_param($stmt, "i", $row['cat_id']); + mysqli_stmt_execute($stmt); + + $thread_res = mysqli_stmt_get_result($stmt); + $thread = mysqli_fetch_assoc($thread_res); + echo '<tr><td class="left">'; echo '<h4><a href="category.php?id=' . $row['cat_id'] . '">' . $row['cat_name'] . '</a></h4>'; echo $row['cat_description']; - echo '</td><td class="right">Example thread<br><small>1 hour ago by <b>example user</b></small></td></tr>'; + echo '</td><td class="right">' . $thread['thread_subject'] . '<br>'; + echo '<small>by <b>' . $thread['user_name'] . '</b></small></td></tr>'; } + mysqli_stmt_close($stmt); mysqli_free_result($result); ?> </table> <table> <tr> <th class="left">Latest Threads</th> - <th class="right">Latest Post</th> + <th class="right">Categories</th> </tr> <?php include_once 'includes/db_inc.php'; - $sql = "SELECT thread_id, thread_subject, thread_date, user_name FROM threads LEFT JOIN users ON thread_author = user_id ORDER BY thread_id DESC LIMIT 5"; + $sql = "SELECT thread_id, thread_subject, thread_date, user_name, cat_id, cat_name FROM threads JOIN users ON thread_author = user_id JOIN categories ON thread_cat = cat_id ORDER BY thread_id DESC LIMIT 5"; $result = mysqli_query($dbc, $sql); if (!$result) { @@ -52,7 +67,7 @@ include_once 'header.php'; while ($row = mysqli_fetch_assoc($result)) { echo '<tr><td class="left">'; echo '<h4><a href="thread.php?id=' . $row['thread_id'] . '">' . $row['thread_subject'] . '</a></h4>'; - echo '<small>by <b>' . $row['user_name'] . '</b> on ' . date('M d, Y', strtotime($row['thread_date'])) . '</small></td><td class="right">by <b>cflip</b><br><small>01-22-2021 9:34</small></td></tr>'; + echo '<small>by <b>' . $row['user_name'] . '</b> on ' . date('M d, Y', strtotime($row['thread_date'])) . '</small></td><td class="right">Posted in <a href="category.php?id=' . $row['cat_id'] . '">' . $row['cat_name'] .'</a></td></tr>'; } mysqli_free_result($result); |