1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
|
<?php
function bbcode_parse($text)
{
$alt = array('[b]', '[/b]', '[url]', '[/url]');
$neu = array('<b>', '</b>', '<a href="', '">Link</a>');
$text = str_replace($alt, $neu, $text);
return $text;
}
$host = 'localhost'; // Adresse des MySQL-Servers
$username = 'user1'; // MySQL-Benutzer ... Besitzer der Datenbank
$dbname = 'usr_user1_1'; // Name der Datenbank
$passwd = ''; // Passwort des MySQL-Benutzers
@$db = new mysqli($host, $username, $passwd, $dbname);
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$query = 'SELECT wbb1_1_post.username, wbb1_1_post.subject, wbb1_1_post.message, wbb1_1_post.time
FROM wbb1_1_post, wbb1_1_thread
WHERE wbb1_1_post.postID = wbb1_1_thread.firstPostID
AND wbb1_1_thread.boardID =35
ORDER BY wbb1_1_thread.time DESC
LIMIT 0 , 30';
$res = $db->query($query);
$num_res = $res->num_rows;
for($i = 0; $i < $num_res; $i++)
{
$row = $res->fetch_assoc();
echo '<b>'.($i+1).'. '.stripslashes($row['subject']).'</b> von '.stripslashes($row['username']);
echo '<p>'.bbcode_parse(stripslashes($row['message'])).'</p><br /><br />';
}
$res->close();
$db->close();
?> |