Der er noget kode her:
<?
$mysqlhost = "";
$mysqlnavn = "";
$mysqlpass = "";
$mysqldbase = "";
require("info.php");
if($id){
$id2 = $id;
mysql_connect("$mysqlhost", "$mysqlnavn", "$mysqlpass") OR DIE("Kunne ikke etabler en forbindelse til MySQLen.!");
mysql_select_db("$mysqldbase") OR DIE("Kunne ikke finde databasen!");
$res = mysql_query("select id, date_format(dato, '%d/%m-%Y') as dato, overskrift, billede, nyhed, email, navn from nyhed WHERE id = '$id' order by id desc LIMIT 0,9");
?><TABLE CELLPADDING="0" CELLSPACING="0" WIDTH="90%" BGCOLOR="#EBEBEB" style="padding-left: 10px;">
<TR><TD>
<?
while ($row = mysql_fetch_array($res)){
?>
<TABLE CELLPADDING="0" CELLSPACING="0" width="100%">
<tr>
<td><b><? echo "<BR>$row[overskrift]</b><BR>Skrevet den: $row[dato]"; ?><br><br></td>
</tr>
<tr>
<td style="padding-left: 6px;">
<img align="left" src="pics/<? echo $row[billede]; ?>"><? echo $row[nyhed]; ?></td>
</tr>
<tr>
<td style="padding-left: 6px;">Af: <a href="mailto:<? echo $row[email]; ?>">
<? echo "$row[navn]</A><BR><BR>"; }
?>
</TD></TR>
</TABLE>
<BR><BR><B>Kommentarer</B><BR><BR>
<?
mysql_close();
function sql_spoerg_og_faa_svar($query) {
$resultat = mysql_query($query);
if(!$resultat) {
udskriv_fejl("Kunne ikke udføre: <em>$query</em>");
}
while($raekke = mysql_fetch_array($resultat)) {
$resultat_array[] = $raekke;
}
return $resultat_array;
}
function string_tagster($str) {
$str = " ".$str." ";
$str = eregi_replace("([[:space:]{()\"'\[~#=:;\&?\_])((ftp|http|https|telnet|news|nttp|nntp|file):\/\/[a-z0-9~#%@æøå\&\(\):;=\?\/\.,_-]+(\\[|\\]|[a-z0-9~#%@æøå\*\&:;.,=\?!'\/_\+-])+)", "\\1<A HREF=\"\\2\" TARGET=\"_blank\" CLASS=\"link_sort2\">\\2</A>", $str);
$str = eregi_replace("([[:space:]{()\"'\[~#:;\&?\_])(www\.[a-z0-9~#%@æøå\&\(\):;=\?!'\/\.,_-]+(\\[|\\]|[a-z0-9~#%@æøå\*\&:;.,=\?!'\/_\+-])+)", "\\1<A HREF=\"
http://\\2\" TARGET=\"_blank\" CLASS=\"link_sort2\">\\2</A>", $str);
$str = eregi_replace("([[:space:]{()\"'\[~#=:;\&?\_])(ftp\.[a-z0-9~#%@æøå\&\(\):;=\?!'\/\.,_-]+(\\[|\\]|[a-z0-9~#%@æøå\&:;.,=\?!'\/_\+-])+)", "\\1<A HREF=\"
ftp://\\2\" CLASS=\"link_sort2\">\\2</A>", $str);
$str = eregi_replace("(mail:|[[:space:]{()\"'\[~#=;\&?])([_\.0-9a-z-]+@([_\.0-9a-z-]+)+\.[a-z]{2,4})","\\1<A HREF=\"mailto:\\2\" CLASS=\"link_sort2\">\\2</A>", $str);
return substr($str, 1);
}
function format_output($str) {
$str = htmlentities($str);
$str = str_replace(""", "\"", $str);
$str = string_tagster($str);
$str = ereg_replace("'</A>", "</A>'", $str);
$str = ereg_replace("'\" TARGET=\"_blank\">", "\" TARGET=\"_blank\">'", $str);
$str = ereg_replace(" ", " ", $str);
$str = str_replace("\\t", " ", $str);
$str = str_replace("\\r", "", $str);
$str = str_replace("\\n", "<BR>", $str);
$str = nl2br($str);
return $str;
}
mysql_connect("$mysqlhost", "$mysqlnavn", "$mysqlpass") OR DIE("Kunne ikke etabler en forbindelse til MySQLen.!");
mysql_select_db("$mysqldbase") OR DIE("Kunne ikke finde databasen!");
$sql = "select * from nyhed WHERE overid = '$id' order by id desc";
$resultat = sql_spoerg_og_faa_svar($sql);
if(count($resultat) < 1) {
echo "<b><i>Der er endnu ikke skrevet kommentarer til denne nyhed</i></b><BR><BR>";
} else {
$nr = count ($resultat);
for($i=0; $i<count($resultat); $i++) {
extract($resultat[$i]);
if(ereg("@", $email)) {
$navn = "<a class='link_sort2' href='mailto:$email' TITLE='Skriv en mail til $navn'>$navn</a>";}
$nyhed = format_output($nyhed);
echo "<B>Kommentar nr: $nr</B><BR> $nyhed<BR>";
echo "<b>Skrevet af:</b> $navn<BR><BR><BR>";
$nr--;
}} mysql_close(); ?>
<b>Skriv en kommentar</b><BR><BR>
<FORM METHOD="post" ACTION="gem.php">
<TABLE BORDER="0">
<TR>
<TD>Navn:<BR></TD>
<TD><INPUT name="navn" size="30"><BR></TD>
</TR>
<TR>
<TD>E-Mail:<BR></TD>
<TD><INPUT name="email" size="30"><BR></TD>
</TR>
</TABLE><BR>
Tekst:<BR>
<TEXTAREA NAME="nyhed" cols="40" rows="5"></TEXTAREA>
<?php
echo "<INPUT TYPE='hidden' NAME='overid' VALUE='$id2'>";
?>
<BR><BR>
<Input TYPE="submit" VALUE="Skriv kommentar"><BR><BR><A HREF="index.php">Nyhedsoversigt</A>
</FORM></TD></TR></TABLE>
<?}else{
mysql_connect("$mysqlhost", "$mysqlnavn", "$mysqlpass") OR DIE("Kunne ikke etabler en forbindelse til MySQLen.!");
mysql_select_db("$mysqldbase") OR DIE("Kunne ikke finde databasen!");
$res = mysql_query("select id, date_format(dato, '%d/%m-%Y') as datoen, overskrift, billede, nyhed, email, navn, antalkom FROM nyhed WHERE overid = '0' order by id desc LIMIT 0,9");
?><TABLE CELLPADDING="0" CELLSPACING="0" WIDTH="90%" BGCOLOR="#EBEBEB">
<TR><TD>
<?
while ($row = mysql_fetch_array($res)){
?>
<TABLE width="100%">
<tr>
<td><b><? echo "<BR>$row[overskrift]</b><BR>Skrevet den: $row[datoen]"; ?><br><br></td>
</tr>
<tr>
<td style="padding-left: 4px;">
<img align="left" src="pics/<? echo $row[billede]; ?>"><? echo $row[nyhed]; ?></td>
</tr>
<tr>
<td style="padding-left: 4px;">Af: <a href="mailto:<? echo $row[email]; ?>">
<? echo "$row[navn]</A><BR><BR><A HREF='?id=$row[id]'><center><i>Kommentér nyheden</i></A> <b>($row[antalkom])</b></center></TD></TR></TABLE><BR><BR>"; }
mysql_close();?>
</TD></TR>
</TABLE>
<?
} ?>