her er et førsøg....
- CEN
---------------------------- index.php -------------------------
<?
$mysqlhost = "localhost";
$mysqlnavn = "cen";
$mysqlpass = "mentos";
$mysqldbase = "prove";
//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,1");
?><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[dato]"; ?><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>"; }
?>
</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 "Der er endnu ikke skrevet kommentarer til denne nyhed<BR><BR>";
} else {
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 "$nyhed<BR>";
echo "Skrevet af: $navn<BR><BR>";
}} 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");
?><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]'>Kommentér nyheden</A> ($row[antalkom])</TD></TR></TABLE><BR><BR>"; }
mysql_close();?>
</TD></TR>
</TABLE><?
} ?>
------------------------------ gem.php -------------------------
<?
$mysqlhost = "localhost";
$mysqlnavn = "cen";
$mysqlpass = "mentos";
$mysqldbase = "prove";
mysql_connect("$mysqlhost", "$mysqlnavn", "$mysqlpass") OR DIE("Kunne ikke etabler en forbindelse til MySQLen.!");
mysql_select_db("$mysqldbase") OR DIE("Kunne ikke finde databasen!");
mysql_query("INSERT INTO nyhed (navn, email, nyhed, overid) VALUES ('$navn', '$email', '$nyhed', '$overid')");
mysql_query("UPDATE nyhed SET antalkom=antalkom+ 1 WHERE id='$overid'");
mysql_close();
header("Location:index.php?id=$overid");
?>