Example #1
0
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 
}
Example #2
0
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));
}