function disp_members_p() { ?> <div id="members_p"> <h4>Liste des membres</h4> <p><?php $db = db_connect(); $req = $db->prepare('SELECT `m.id`, `m.name` FROM members'); $req->execute(); while ($data = $req->fetch()) { disp_link($data['m.id'], $data['m.name'], 'm'); ?> <br/><?php } $req->closeCursor(); ?> </p> </div><?php }
function disp_topic($t_id) { $db = db_connect(); $req = $db->prepare('SELECT `c.name`, `f.id`, `f.name`, `t.name`, `p.text`, `p.date`, `m.id`, `m.name` FROM topics LEFT JOIN forums ON `f.id` = `t.forum_id` LEFT JOIN cats ON `c.id` = `f.cat_id` LEFT JOIN posts ON `p.topic_id` = `t.id` LEFT JOIN members ON `m.id` = `p.author_id` WHERE `p.topic_id` = ?'); $req->execute(array($t_id)); if (!($data = $req->fetch())) { return 1; } if ($data['c.name'] == NULL || $data['f.name'] == NULL) { return 2; } ?> <div id="forum"> <h2> <?php echo htmlspecialchars($data['t.name']); ?> </h2> <p><a href="index.php">Index</a> -> <?php echo htmlspecialchars($data['c.name']) . ' -> '; disp_link($data['f.id'], htmlspecialchars($data['f.name']), 'f'); echo ' -> ' . $data['t.name']; ?> </p> <table><tr> <th>Auteur</th> <th>Date</th> <th>Message</th></tr><?php if ($data['p.text'] == NULL) { echo '<tr><td colspan=3>' . NO_POST . '</td></tr>'; } else { do { ?> <tr> <td><?php disp_link($data['m.id'], $data['m.name'], 'm'); ?> </td> <td><?php echo $data['p.date']; ?> </td> <td><p><?php echo nl2br(htmlspecialchars($data['p.text'])); ?> </p></td> </tr><?php } while ($data = $req->fetch()); } ?> </table><h3><a href="index.php?p=newp&id=<?php echo $t_id; ?> ">Poster un nouveau message</a></h3></div><?php $req->closeCursor(); $req = $db->prepare('UPDATE topics SET `t.nb_views` = `t.nb_views` + 1 WHERE `t.id` = ?'); $req->execute(array($t_id)); }