Men kan bare ik forstår hvordan den kode så skal se ud :/ her er lige hvad der er indtil videre
<?php
// include the database configuration and
// open connection to database
include 'library/config.php';
include 'library/opendb.php';
?>
<?php
// =======================
// Show guestbook entries
// =======================
// how many guestbook entries to show per page
$rowsPerPage = 5;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use the value as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset ( where to start fetching the entries )
$offset = ($pageNum - 1) * $rowsPerPage;
// prepare the query string
$query = "SELECT id, name, email, url, message, DATE_FORMAT(entry_date, '%d.%m.%Y') ".
"FROM news ".
"ORDER BY id DESC ". // using ORDER BY to show the most current entry first
"LIMIT $offset, $rowsPerPage"; // LIMIT is the core of paging
// execute the query
$result = mysql_query($query) or die('Error, query failed. ' . mysql_error());
// if the guestbook is empty show a message
if(mysql_num_rows($result) == 0)
{
?>
<p> News table is empty </p>
<?php
}
else
{
// get all guestbook entries
while($row = mysql_fetch_array($result))
{
// list() is a convenient way of assign a list of variables
// from an array values
list($id, $name, $email, $url, $message, $date) = $row;
// change all HTML special characters,
// to prevent some nasty code injection
$name = htmlspecialchars($name);
$message = htmlspecialchars($message);
// convert newline characters ( \n OR \r OR both ) to HTML break tag ( <br> )
$message = nl2br($message);
?>
<table width="360" border="0" cellpadding="0" cellspacing="0" class="Main_Text">
<tr>
<td width="211" align="left"> <a href="mailto:<?=$email;?>" class="email">
<?=$name;?>
</a> </td>
<td width="149" align="right"><small>
<?=$date;?>
</small></td>
</tr>
<tr>
<td colspan="2">
<?php
function VisLidt($sText, $iCount){
#Fjerner kommaer da det ikke ser så smart ud med et komma til sidst i en sætning
$sText = ereg_replace("," ,"", $sText);
#Fjerner breaks
$sText = ereg_replace("<br>"," ", $sText);
#Splitter teksten ved mellemrum
$sTempSplit = split(" ", $sText);
#Sætter min midlertidige textstreng til ingenting
$sTempText = "";
#Hvis iCount er større end den fulde artikel sættes iCount til artiklens længde
if($iCount > count($sTempSplit)){
$iCount = count($sTempSplit);
}
#Laver en sætning med antal (iCount) ord
for($i = 0; $i < $iCount; $i++){
$sTempText = "$sTempText " . $sTempSplit[$i];
}
#Hvis der er flere ord i artiklen sættes "..." på for at vise at den fortsættes
if($iCount < count($sTempSplit)){
$sTempText = $sTempText . "...";
}
#Færdiggør teksten til udskrift
return $sTempText;
}
$sArtikel = "$message";
#Hvor mange ord skal vises
$iOrd = 2;
#Udskriv artiklen beskåret
$sKortArtikel = VisLidt($sArtikel, $iOrd);
echo $sKortArtikel;
?>
<?php
// if the visitor input her homepage url show it
if($url != '')
{
// make the url clickable by formatting it as HTML link
$url = "<a href='$url' target='_blank'>$url</a>";
?>
<br> <small>Homepage : <?=$url;?></small>
<?php
}
?>
<br />
<img src="dots.gif" /> </td>
</tr>
</table>
<br>
<?php
} // end while
?>
<?php
// close the database connection since
// we no longer need it
include 'library/closedb.php';
?>
<?php
}
?>
</td>
</tr>
</table> </td>
</tr>
</table>
<span class="style3">
<?
}
?>
For jeg kan da ik bare hive
<?php
// include the database configuration and
// open connection to database
include 'library/config.php';
include 'library/opendb.php';
?>
<?php
// =======================
// Show guestbook entries
// =======================
// how many guestbook entries to show per page
$rowsPerPage = 5;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use the value as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset ( where to start fetching the entries )
$offset = ($pageNum - 1) * $rowsPerPage;
// prepare the query string
$query = "SELECT id, name, email, url, message, DATE_FORMAT(entry_date, '%d.%m.%Y') ".
"FROM news ".
"ORDER BY id DESC ". // using ORDER BY to show the most current entry first
"LIMIT $offset, $rowsPerPage"; // LIMIT is the core of paging
// execute the query
$result = mysql_query($query) or die('Error, query failed. ' . mysql_error());
// if the guestbook is empty show a message
if(mysql_num_rows($result) == 0)
{
?>
<p> News table is empty </p>
<?php
}
else
{
// get all guestbook entries
while($row = mysql_fetch_array($result))
{
// list() is a convenient way of assign a list of variables
// from an array values
list($id, $name, $email, $url, $message, $date) = $row;
// change all HTML special characters,
// to prevent some nasty code injection
$name = htmlspecialchars($name);
$message = htmlspecialchars($message);
// convert newline characters ( \n OR \r OR both ) to HTML break tag ( <br> )
$message = nl2br($message);
?>
<table width="360" border="0" cellpadding="0" cellspacing="0" class="Main_Text">
<tr>
<td width="211" align="left"> <a href="mailto:<?=$email;?>" class="email">
<?=$name;?>
</a> </td>
<td width="149" align="right"><small>
<?=$date;?>
</small></td>
</tr>
<tr>
<td colspan="2">
<?php
function VisLidt($sText, $iCount){
#Fjerner kommaer da det ikke ser så smart ud med et komma til sidst i en sætning
$sText = ereg_replace("," ,"", $sText);
#Fjerner breaks
$sText = ereg_replace("<br>"," ", $sText);
#Splitter teksten ved mellemrum
$sTempSplit = split(" ", $sText);
#Sætter min midlertidige textstreng til ingenting
$sTempText = "";
#Hvis iCount er større end den fulde artikel sættes iCount til artiklens længde
if($iCount > count($sTempSplit)){
$iCount = count($sTempSplit);
}
#Laver en sætning med antal (iCount) ord
for($i = 0; $i < $iCount; $i++){
$sTempText = "$sTempText " . $sTempSplit[$i];
}
#Hvis der er flere ord i artiklen sættes "..." på for at vise at den fortsættes
if($iCount < count($sTempSplit)){
$sTempText = $sTempText . "...";
}
#Færdiggør teksten til udskrift
return $sTempText;
}
$sArtikel = "$message";
#Hvor mange ord skal vises
$iOrd = 2;
#Udskriv artiklen beskåret
$sKortArtikel = VisLidt($sArtikel, $iOrd);
echo $sKortArtikel;
?>
<?php
// if the visitor input her homepage url show it
if($url != '')
{
// make the url clickable by formatting it as HTML link
$url = "<a href='$url' target='_blank'>$url</a>";
?>
<br> <small>Homepage : <?=$url;?></small>
<?php
}
?>
<br />
<img src="dots.gif" /> </td>
</tr>
</table>
<br>
<?php
} // end while
?>
<?php
// close the database connection since
// we no longer need it
include 'library/closedb.php';
?>
<?php
}
?>
</td>
</tr>
</table> </td>
</tr>
</table>
<span class="style3">
<?
}
?>
ud og smide det op øverst på siden?
