Форма за коментари.

[ReD_z0n3]

Дайте някой код за коментар под файл ( файловете ми се изкарват по ID )

 

[darkmas]

създаваш си дб komentar
id int(4) auto_increment primery
failid varchar(255)
from varchar(255)
komentar varchar(1000)
date varchar(255)

<table width="250" border="0" align="center" cellpadding="1" cellspacing="1">
        <form method="POST" name="add" id="add">

    <tr>
        <td align="center"><p>Потребител</p><input type="text" name="from" value="" size="30" /></td>
</tr>

<tr>
    <td align="center"><p></p><textarea name="komentar" rows="5" cols="50"></textarea></td>

</tr>
<tr>
<td align="center"><input name="submit" type="submit" value="Коментирай" ></td>
</tr>

<?php
$failid = $_GET['id'];  // March 10, 2001, 5:16 pm
if($_POST['submit']){//Взимаме написаното във формата

$id = "NULL";
$from = "$_POST[from]";
$komentar = "$_POST[komentar]";
$date = "$_POST[date]";
$date = date("F j, Y, g:i a");
if($from == "от" || $komentar == "komentar" || $date == "date"){
echo "Некоректно попълване, моля попълнете всички полета!";
}
else {
$sql = "INSERT INTO `komentar` VALUE ('$id','$fileid','$from','$komentar', '$date');";//и го записвами в базата данни
}
$result = mysql_query($sql) or die (mysql_error());
if($result){// Ако се е записало изкарва това ако не

}
}
else {//изкарва това
echo mysql_error();
}

?>

</form>
</table>
 <?php

echo "
</form>
<br />
<hr width='595' size='1' color='#dadada' />";
$query = mysql_query("SELECT * FROM `komentar` WHERE fileid`='$id'"." ORDER BY id DESC") or die(mysql_error());
while($row = mysql_fetch_array($query)){
echo "
<div>
<tr>
<td class='mainTxt'>
<br /><b style='color:#4f8af4; font-size:17px;'>$row[from]</b><br />
$row[komentar]<br />
публикувано на:<b style='color:#4f8af4; font-size:12px;'>$row[date]</b>
</td></tr>
</div>
 ";
}


 ?>

 

[Pupe64etoo_92]

Добавих един скрипт които скрива формата.

forma.php

<script>
function showContent(vThis)
{
vParent = vThis.parentNode;
vSibling = vParent.nextSibling;
while (vSibling.nodeType==3) { 
vSibling = vSibling.nextSibling;
};
if(vSibling.style.display == "none")
{
vThis.alt = "Добави коментар";
vSibling.style.display = "block";
} else {
vSibling.style.display = "none";
vThis.alt = "Добави коментар";
}
return;
}
</script>

<?php 

if($_POST['Submit']){ 

$minuti = $_POST['minuti']; 
$chas = $_POST['chas']; 
$den = $_POST['den']; 
$mesec = $_POST['mesec']; 
$godina = $_POST['godina']; 
$username = $_POST['username']; 
$comment = $_POST['comment'];  
if(empty($username)){ 
echo "Моля, въведете име"; 
die(); 
}; 
if(empty($comment)){ 
echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=fullnews.php?id=$id\">";
die();
}; 

mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни"); 
@mysql_select_db($db_name) or die("Грешна база данни"); 
$query = "INSERT INTO `comments` ( `id_com` , `id` , `username` , `minuti`, `chas`, `den`, `mesec`, `godina`, `ip`, `comment`, `title`) 
VALUES ( 
'NULL', '$id', '$username', '$minuti', '$chas', '$den', '$mesec', '$godina', '$ip', '$comment', '$title' 
);"; 
$ok = mysql_query($query); 
if($ok){ 
echo "<font class=ws10 color=#fff>Коментара е Добавен</font>"; 
}else{ 
echo "Възникна грешка"; 
} 
}; 

?></center> 
<table align="center" width="551" height="auto" border="#000000 1px splid">
<tr>
<td id="lineLRBs" class="nav"> 
<form action=fullnews.php?id=<?php echo "$id" ?> method=post name=form> 
<input type="hidden" value="<?php print(date("i")); ?>" name="minuti"> 
<input type="hidden" value="<?php print(date("G")); ?>" name="chas"> 
<input type="hidden" value="<?php print(date("j")); ?>" name="den"> 
<input type="hidden" value="<?php print(date("F")); ?>" name="mesec"> 
<input type="hidden" value="<?php print(date("Y")); ?>" name="godina"> 
<input type="hidden" value="<?php echo $_SERVER['REMOTE_ADDR']; ?>" name="ip"> 
<input type="hidden" value="<?php echo "$id_news" ?>" name="id_news"> 
<input type="hidden" value="<?php echo "$title" ?>" name="title">
<input type="hidden" value="<?php echo "<font>".$user->data['username']."</font>" ?>" name="username"> 
<h5 align="center"><img alt="Добави коментар" border="0" style="margin-right:6px; margin-top:3px; margin-bottom:-3px; cursor:pointer;" onclick="showContent(this);" /></h5>
<div align="center" style="display:none;">
<textarea rows=7 class=commentbox name=comment cols=45 type=text style="border:#000000 1px solid; background-color:#CCCCCC;"></textarea><br /><br /><input type=submit style="border:#000000 1px solid; background-color:#CCCCCC;" name=Submit value=Добави class=form> 
</div>
</form>

config.php

<?php 
$server = "бд сървър"; 
$dbusername = "бд име"; 
$dbpassword = "бд пасс"; 
$db_name = "comments"; 
$link=mysql_connect($server,$dbusername,$dbpassword); 
$db=mysql_select_db($db_name); 
mysql_query('SET CHARACTER SET UTF8'); 


?>

MySQL.sql

CREATE TABLE `comments` (
  `id_com` int(50) NOT NULL auto_increment,
  `id` varchar(250) default NULL,
  `username` varchar(26) default NULL,
  `email` varchar(70) default NULL,
  `minuti` varchar(50) default NULL,
  `chas` varchar(50) default NULL,
  `den` varchar(50) default NULL,
  `mesec` varchar(50) default NULL,
  `godina` varchar(50) default NULL,
  `ip` varchar(160) default NULL,
  `comment` text,
  `title` varchar(250) default NULL,
  PRIMARY KEY  (`id_com`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ;