Index:
<?php
$title = 'Det Radikale Venstre i Svendborg';
include('header.php');
print "<h1>Aktuelt</h1>";
include('inc.config.php');
$query = mysql_query("SELECT id,title,image,synopsis FROM news ORDER BY id DESC LIMIT 5") or die(mysql_error());
while ($row = mysql_fetch_assoc($query)) {
print '<p>';
print empty($row['image']) ? '' : '<img border=0 align="right" src="files/'.$row['image'] . '" class="image">';
print '<span lang="da"><b>' . $row['title'] . '</b></span><br>';
print $row['synopsis'];
print '<br><a href="news.display.php?id='.$row['id'].'">Læs mere</a></p>';
print '<p> </p>';
}
?>
<div class="hr"></div>
<a href="news.search.php">Søg efter tekst</a>
<?php
include('footer.php');
?>
Mens news.display.php er:
<?php
$title = 'Det Radikale Venstre i Svendborg';
include('header.php');
include('inc.config.php');
$query = mysql_query("SELECT *,DATE_FORMAT(date,'%e/%c-%y %T') AS date FROM news WHERE id=".$_GET['id']."");
$row = mysql_fetch_assoc($query);
echo '<h1>'.$row['title'].'</h1>';
echo '<p><b>'.$row['synopsis'].'</b></p>';
echo '<p>'.$row['author'].' - '.$row['date'].'</p>';
echo nl2br($row['text']);
echo '<div class="hr"></div>';
$query = mysql_query("SELECT *,DATE_FORMAT(date,'%e/%c-%y %T') AS date FROM comments WHERE parent=".$_GET['id']." ORDER BY id ASC");
if (mysql_num_rows($query) > 0) {
echo '<h2>Kommentarer</h2>';
while ($row = mysql_fetch_assoc($query)) {
echo empty($row['email']) ? htmlspecialchars($row['name']) : '<a href="mailto:'.$row['email'].'">'.htmlspecialchars($row['name']).'</a>';
echo ' ('.$row['date'].')<br><br>';
echo nl2br(htmlspecialchars($row['text']));
echo '<div class="hr"></div>';
}
}
?>
<h2>Kommenter tekst</h2>
<form method="post" action="../form.handle.php">
<input type="hidden" name="referer" value="comment">
<input type="hidden" name="parent" value="<?php echo $_GET['id']; ?>">
Navn: <input type="text" name="name" style="width: 120px">
Email: <input type="text" name="email" style="width: 120px"><br>
<textarea name="text" rows="7" cols="0" style="width: 328px"></textarea><br><br>
<input type="submit" value="Send">
</form>
<div class="hr"></div>
<a href="../index.php">Seneste tekster</a> | <a href="../news.search.php">Søg efter tekst</a>
<div class="hr"></div>
<?php
include('footer.php');
?>
Og inc.config.php:
<?php
/* Indstillinger : database */
$cfg['mysql']['host'] = 'xxx'; // Host til database
$cfg['mysql']['username'] = 'xxx'; // Brugernavn til database
$cfg['mysql']['password'] = 'xxx'; // Kodeord til database
$cfg['mysql']['database'] = 'xxx'; // Database
/* Indstillinger : administrationsmodul */
$cfg['admin']['username'] = 'webmaster'; // Brugernavn til administrationsmodul
$cfg['admin']['password'] = 'XXX'; // Kodeord til administrationsmodul
/* Indstillinger : side */
$cfg['limit'] = 4; // Antal resultater pr. side.
$cfg['pages_each_way'] = 3; // Sider der peger hver vej
/* Redigering ikke nødvendig herunder */
mysql_connect($cfg['mysql']['host'],$cfg['mysql']['username'],$cfg['mysql']['password']);
mysql_select_db($cfg['mysql']['database']);
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM news"),0);
$offset = isset($_GET['offset']) ? $_GET['offset'] : 0;
$start_point = ($offset-($cfg['pages_each_way']*$cfg['limit']) < 0) ? 0 : $offset-($cfg['pages_each_way']*$cfg['limit']);
$end_point = ($offset+($cfg['pages_each_way']*$cfg['limit']) > $total) ? $total : $offset+($cfg['pages_each_way']*$cfg['limit']);
$page_number = ($start_point/$cfg['limit'])+1;
?>
Slettet bruger
Ny bruger
Nybegynder
Opret
Preview
