System newsów http://www.forumweb.pl/gotowe-komponenty-www/php-system-newsow-z-komentarzami-panel,59290?sid=4684ba1da8dbfd6d3813f806a5c7cf8e config.php Tabela CREATE TABLE `news` ( `id` INT NOT NULL AUTO_INCREMENT , `tytul` TINYTEXT NOT NULL , `tresc` TEXT NOT NULL , `data` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `id` ) ); CREATE TABLE `comments` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `post_id` int(10) NOT NULL, `autor` varchar(32) NOT NULL, `data` varchar(50) NOT NULL, `tresc` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); functions.php function showNews() { $sql1 = mysql_query("SELECT * FROM news ORDER BY id DESC"); while($news = mysql_fetch_assoc($sql1)) { $id = $news['id']; $sql2 = mysql_query("SELECT id FROM comments WHERE post_id=$id"); $nr = mysql_num_rows($sql2); echo'
'.$news['tresc'].'
Komentarze ['.$nr.']'; } } news.php ob_start(); require'config.php'; $adres = $_SERVER['REQUEST_URI']; $a = $_GET['kom']; $id = $_GET['id']; if(empty($id)) { header('Location: index.php'); # Przekierowanie, kiedy zmienna $_GET['id'] jest pusta exit; } $sql1 = mysql_query("SELECT * FROM news WHERE id=$id LIMIT 1"); $sql2 = mysql_query("SELECT * FROM comments WHERE post_id=$id"); $nr = mysql_num_rows($sql2); $news = mysql_fetch_assoc($sql1); echo'
'.$news['tresc'].'
Komentarze ['.$nr.']';
if(isset($a) && $a == 'dodaj')
{
$nazwa = substr(mysql_real_escape_string(htmlspecialchars($_POST['name'])),0,32);
$msg = substr(mysql_real_escape_string(htmlspecialchars($_POST['message'])),0,255);
$data = date("F j, Y , g:i a");
$ip=$_SERVER['REMOTE_ADDR'];
if(empty($_POST['name']) && ($_POST['message']))
{
echo'Wpisz nick i wiadomość';
}
elseif(empty($_POST['name']))
{
echo'Wpisz nick';
}
elseif(empty($_POST['message']))
{
echo'wpisz wiadmość';
}
if(!empty($_POST['name']) && ($_POST['message']))
{
$sql = mysql_query("INSERT INTO comments VALUES (0,'$id','$nazwa','$data','$msg','$ip')");
}
if($sql)
{
header('Location: news.php?id='.$id.'');
exit;
}
else echo mysql_error();
}
if($nr == 0)
{
echo 'Brak komentarzy.
';
}
else
{
include 'templates/comment.php';
}
include 'templates/form.php';
ob_end_flush();
?>
templates/comment.php
'.$nr.' wpisów';
while($kome = mysql_fetch_assoc($sql2)){echo #Nie usuwać tej linijki, ani następnej
'