Система за коментари

M

mitaka961

Registered
Здравейте имам една система за новини и искам да ви попитам някой може ли да ми добави коментари към нея.Който може да пише на лс или на скайп:cesekara_1996
 
Защо не кажеш коя е системата, ако я има тук или не дадеш малко код и ще ти я направя. Защо да ти пиша на скайп при положение, че и на някой друг може да му е полезен кода.
 
news.php
Код: 
<?
$result = mysql_query("SELECT * FROM news ORDER BY id DESC") or die (mysql_error());
while($data = mysql_fetch_assoc($result)) {
$id = $data['id'];
$rl = mysql_query('SELECT COUNT(*) as ctn FROM `com_news` WHERE novina='.$id);
$ruw = mysql_fetch_assoc($rl);
$comments = $ruw['ctn'];
echo "<div class='article'><h4 style='font-size:15px;'>$data[title]</h4><br />
<b style='style='font-size:12px;'>$data[text]</b><br /><br />
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tbody><tr><td width='50%'><b style='color: rgb(255, 255, 255); font-size:11px;'>Публикувано на: $data[date]</b></td><td align='right' width='50%'><b style='color: rgb(255, 255, 255); font-size:11px;'>Коментари: <b><a href='select_news.php?id=$data[id]'>";
if($comments == 0){

echo "Няма коментари";
}
else
{
echo "$comments";
}
echo"</a></b>

</b></td></tr>
</tbody></table>
</div>";
}
?>

select_news.php
Код: 
<?
error_reporting(0); 
session_start();
$id = $_GET['id'];

if ($id) {
$zaqvka = mysql_query("SELECT * FROM `news` WHERE id='$id'");
$res = mysql_fetch_assoc($zaqvka);
if($id != $res[id]){
echo "Няма такава новина!";
}
else
{
echo "асд";
$sql = mysql_query("SELECT * FROM news WHERE id='$id'") or die (mysql_error());
$data = mysql_fetch_assoc($sql);
echo "<div class='article'><h4 style='font-size:15px;'>$data[title]</h4><br />
<b style='style='font-size:12px;'>$data[text]</b><br /><br />
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tbody><tr><td width='50%'><b style='color: rgb(255, 255, 255); font-size:11px;'>Публикувано на: $data[date]</b></td></td></tr></tbody></table></div>";
}
}
?>

<form method='post' action=''>
<table width='400'><tr><td>
Име:</td><td><input name='avtor' type='text' class='style-focus' size='25' maxlength='20' /></td></tr>
<?
$id = $data['id'];
$rl = mysql_query('SELECT COUNT(*) as ctn FROM `com_news` WHERE novina='.$id);
$ruw = mysql_fetch_assoc($rl);
$comments = $ruw['ctn'];
echo "
<tr><td></td><td>";
if($comments == 0){

echo "все още не са коментирали новината!";
}
echo"<td></tr><br />";

?>
<tr><td>Коментар:</td><td><textarea name='komentar' class='style-focus' cols='36' rows='6'>
</textarea></td></tr>
<tr><td colspan='2'><input type='submit' name='submit' value='Добави коментара' class='style-focus' /></td></tr>
</table>
</form>

<br/>

<?

if ($_POST['submit']) {
$avtor = htmlspecialchars($_POST['avtor']);
$komentar = htmlspecialchars($_POST['komentar']);
$date = date("d.M.Y, H:i");
	if($avtor == NULL || $komentar == NULL){
		echo "<div class='error'><b>Всички полета са задължителни!!!</b></div>";
	}
	else{
$sql = "INSERT INTO com_news (`novina`, `avtor`, `date`, `komentar`) VALUES ('$id', '$avtor', '$date', '$komentar')";
mysql_query($sql) or die (mysql_error());
echo "<meta http-equiv='refresh' content='0;url=select_news.php?id=$data[id]'>";
echo "Коментара е добавен успешно.";
}
}
$sql = "SELECT * FROM com_news WHERE novina='$id' ORDER BY id DESC";
$result = mysql_query($sql) or die (mysql_error());
while($com = mysql_fetch_assoc($result)) {
echo "<div style='background-color: #999; border: 1px solid #222; color:#000; padding:5px; font: 13px tahoma;'>
<b>$com[avtor]</b> каза: <span style='float:right; font: 11px tahoma;'>$com[date]</span><br/><hr size='1' color='#222' />
$com[komentar]</div><br />";
}
?>

SQL:

Код: 
DROP TABLE IF EXISTS com_news;
CREATE TABLE com_news (
   id int(12) NOT NULL auto_increment,
   novina varchar(12) NOT NULL,
   avtor varchar(255) NOT NULL,
   komentar text NOT NULL,
   date varchar(50) NOT NULL,
   PRIMARY KEY (id)
);
DROP TABLE IF EXISTS news;
CREATE TABLE news (
   id int(255) NOT NULL auto_increment,
   title varchar(255) NOT NULL,
   text text NOT NULL,
   avtor varchar(255) NOT NULL,
   date varchar(50) NOT NULL,
   PRIMARY KEY (id)
);

Инклудваш си config файла във всяка страница и си готов !
 
Ето я моята система за новини ако можете вградете една система за коментари

newscenter.php

Код: 
<?php session_start(); ?>
<?php
session_start();
include("conn.php");
echo '<head>
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/> 
</head>';
function utf8_general_ci($str,$from,$len)
{
  return preg_replace('#^(?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.$from.'}'.
                       '((?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.$len.'}).*#i',
                       '$1',$str);
}
$broinastranica = 10;
$pageNum = 1; 
if(isset($_GET['page'])) { 
        $pageNum = (int)$_GET['page'];
} 
$redove = ($pageNum - 1) * $broinastranica; 
mysql_query("SET CHARACTER SET UTF-8");
mysql_query("SET NAMES UTF-8");
$query = mysql_query(" SELECT * FROM `novini` ORDER BY id DESC" . " LIMIT $redove, $broinastranica"); 
while ($row = mysql_fetch_array($query)) { 
        $newstext = $row['newstext'];
		$newstext = strlen($newstext) > 130 ? mb_substr($newstext,0,130,'utf8') . "..." :$newstext;
        $newsauthor = $row['newsauthor'];
        $newsname = $row['newsname'];
        $id = $row['id'];
        if($_SESSION['admin']) {
                $edit = "<a href='adminnews.php?act=editnews&id=$id'>Промени новината</a><br><a href='adminnews.php?act=dellnews&id=$id'>Изтрий новината</a>";
        }
        echo "
        <center><table border='0' width='540' id='table1' cellspacing='0' cellpadding='0'>
                        <tr>
                                        <td id='titlecenter' align='center'>
                                        <table border='0' width='93%' id='table2' cellspacing='6' cellpadding='0'>
                                                        <tr>
                                                                        <font color=white>$newsname</td>
                                                        </tr>
                                        </table>
                                        </td>
                        </tr>
                        <tr>
                                        <td id='bgcenter' align='center'>
											<font size='3'>$newstext</font><br />
											<font size='3'>$edit</font><br />
											<font size='2'><a href='news_view.php?id=$row[id]'><left>Прочети цялата новина »<left></a></font>
										</td>
                        </tr>
                        <tr>
                                        <td id='footercenter'></td>
                        </tr>
        </table><center><br>";
}
$query = mysql_query("SELECT COUNT(id) AS broi FROM novini") or die (mysql_error());  
$row = mysql_fetch_array($query, MYSQL_ASSOC); 
$numrows = $row['broi']; 
$maxPage = ceil($numrows/$broinastranica); 
$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) { 
if ($page == $pageNum) {
        $nomeranastranici .= "<a href='#top'><b>$page</b></a> "; 
} else {
        $nomeranastranici .= "<a href=\"$self?page=$page\">$page</a> ";
}
} if ($pageNum > 1) {
        $page = $pageNum - 1; 
        $predishna = "<a href=\"$self?page=$page\"> <b>«</b> </a> "; 
} else {
        $predishna = ' ';
} if ($pageNum < $maxPage) {
        $page = $pageNum + 1;
        $sledvashta = "<a href=\"$self?page=$page\"> <b>»</b> </a> ";
} else {
        $sledvashta = ' ';
}
echo "". $predishna . $nomeranastranici . $sledvashta;
?>

news_view.php

Код: 
<?php
session_start();
include("conn.php");
echo '<head>
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>';

$id = $_GET['id'];
$our = mysql_query("SELECT * FROM novini WHERE id = '$id'") or die (mysql_error());
$row = mysql_fetch_assoc($our);
mysql_query("SET CHARACTER SET latin1");
mysql_query("SET NAMES latin1");
        $id = $row['id'];
        if($_SESSION['admin']) {
                $edit = "<a href='admin.php?act=editnews&id=$id'>Промени новината</a><br><a href='admin.php?act=dellnews&id=$id'>Изтрий новината</a>";
        }
        echo "
        <center><table border='0' width='540' id='table1' cellspacing='0' cellpadding='0'>
                        <tr>
                                        <td id='titlecenter' align='center'>
                                        <table border='0' width='93%' id='table2' cellspacing='6' cellpadding='0'>
                                                        <tr>
                                                                        <font color=white>$row[newsname]</td>
                                                        </tr>
                                        </table>
                                        </td>
                        </tr>
                        <tr>
                                        <td id='bgcenter' align='center'>
											<font size='3'>$row[newstext]</font><br />
											<font size='3'>$edit</font><br />
										</td>
                        </tr>
                        <tr>
                                        <td id='footercenter'></td>
                        </tr>
        </table><center><br>";
?>

conn.php

Код: 
<?php
$user="Име"; // Базаданни потребител
$password="Парола"; // Базаданни парола
$database="База"; // Име на Базата данни
$link=mysql_connect('localhost',$user,$password);
$db=mysql_select_db($database);
mysql_query("SET CHARACTER SET latin1");
mysql_query("SET NAMES latin1");
?>

SQL

Код: 
CREATE TABLE IF NOT EXISTS `novini` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`newsname` varchar( 60 ) CHARACTER SET latin1 NOT NULL ,
`newstext` text CHARACTER SET latin1 NOT NULL ,
`newsauthor` varchar( 11 ) CHARACTER SET latin1 NOT NULL default 'Admin',
PRIMARY KEY ( `id` ) ,
FULLTEXT KEY `newstext` ( `newstext` )
) ENGINE = MYISAM DEFAULT CHARSET = cp1251 COLLATE = cp1251_bulgarian_ci AUTO_INCREMENT =1
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе