Изкарване на коментари. Помогнете ми

emcuemnecu · 25 Януари 2010

Първо със скриптовете, които използвам:
Sql:

Код:

CREATE TABLE `1` (
  `id` int(10) NOT NULL auto_increment,
  `time` varchar(50) collate cp1251_bulgarian_ci NOT NULL,
  `nick` varchar(50) collate cp1251_bulgarian_ci NOT NULL,
  `message` varchar(250) collate cp1251_bulgarian_ci NOT NULL,
  `ip` varchar(50) collate cp1251_bulgarian_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci AUTO_INCREMENT=1 ;

chat.php

Код:

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">


<link rel="stylesheet" href="css.css" type="text/css">
<script type="text/javascript">

</script>

<table cellpadding="0" cellspacing="0" style="border:1px solid #101010">
  <tr>
    <td><div align="center" style="height:350px; width:550px; overflow:auto;">
      <?
	  include "conf.php";
	  $sql = mysql_query("SELECT * FROM `1` WHERE to_id = '$to_id' ORDER BY `id` DESC") or die(mysql_error());
	  while ($row = mysql_fetch_array($sql)) {
	  if ($admin==$_SERVER['REMOTE_ADDR']) { $delete = " <a href=del.php?id=$row[id]>-del-</a>"; }
	  echo $to_id ;
	  echo "
	  <table class=\"chats\" width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr>
      <td width=\"50%\" align=left class=forumlink><strong>".$row[nick]."</strong></td>
      <td width=\"50%\" align=right class=\"genmed\"><strong>".date("H:i:s",$row['time'])."<br>".date("d.m.y",$row['time'])."</strong></td></tr>
      ";
	  $message = $row[message];
	  $message = str_replace(":biggrin:","<img border=0 src=smiles/icon_biggrin.gif>","$message");
	  $message = str_replace(":confused:","<img border=0 src=smiles/icon_confused.gif>","$message");
	  $message = str_replace(":cool:","<img border=0 src=smiles/icon_cool.gif>","$message");
	  
	  $message = str_replace(":cry:","<img border=0 src=smiles/icon_cry.gif>","$message");
	  $message = str_replace(":eek:","<img border=0 src=smiles/icon_eek.gif>","$message");
	  
	  $message = str_replace(":evil:","<img border=0 src=smiles/icon_evil.gif>","$message");
	  $message = str_replace(":exclaim:","<img border=0 src=smiles/icon_exclaim.gif>","$message");
	  $message = str_replace(":idea:","<img border=0 src=smiles/smiles/icon_idea.gif>","$message");
	  
	  $message = str_replace(":lol:","<img border=0 src=smiles/icon_lol.gif>","$message");
	  $message = str_replace(":mad:","<img border=0 src=smiles/icon_mad.gif>","$message");
	  $message = str_replace(":mrgreen:","<img border=0 src=smiles/icon_mrgreen.gif>","$message");
	  
	  $message = str_replace(":neutral:","<img border=0 src=smiles/icon_neutral.gif>","$message");
	  $message = str_replace(":question:","<img border=0 src=smiles/icon_question.gif>","$message");
	  $message = str_replace(":redface:","<img border=0 src=smiles/icon_redface.gif>","$message");
	  $message = str_replace(":rolleyes:","<img border=0 src=smiles/icon_rolleyes.gif>","$message");
	  
	  $message = str_replace(":sad:","<img border=0 src=smiles/icon_sad.gif>","$message");
	  $message = str_replace(":smile:","<img border=0 src=smiles/icon_smile.gif>","$message");
	  $message = str_replace(":wink:","<img border=0 src=smiles/icon_wink.gif>","$message");
	  
	  $message = str_replace(":twisted:","<img border=0 src=smiles/icon_twisted.gif>","$message");
	  $message = str_replace(":razz:","<img border=0 src=smiles/icon_razz.gif>","$message");
	  $message = str_replace(":surprised:","<img border=0 src=smiles/icon_surprised.gif>","$message");
	  $message = str_replace(":arrow:","<img border=0 src=smiles/icon_arrow.gif>","$message");
	  
	  echo "
	  <tr><td colspan=\"2\" class=\"genmed\">".$message."".$delete."</td></tr>
	  
	  </table><hr width=99%>";
	  }
	  ?>
      </div></td>
  </tr>
  <tr>
    <td height="114"><form name="message" id="message" action="send.php?id=<?php echo $to_id ?>" method="post">
      <div align="center">
  <input name="user" type="text" class="inputs" size="47" value="Напиши своето име" onClick="this.value=''">
  <input type="submit" value="Изпрати" class=button>
  <br>
<textarea name="message" cols="60" rows="10" class="inputs"></textarea>
  <br>
  <br>
   <img src="smiles/icon_biggrin.gif"       width="15" height="15" onclick="addsmiley(' :biggrin: ')">
   <img src="smiles/icon_confused.gif"      width="15" height="15" onclick="addsmiley(' :confused: ')">
   <img src="smiles/icon_cool.gif"          width="15" height="15" onclick="addsmiley(' :cool: ')">
  
   <img src="smiles/icon_cry.gif"           width="15" height="15" onclick="addsmiley(' :cry: ')">
   <img src="smiles/icon_eek.gif"           width="15" height="15" onclick="addsmiley(' :eek: ')">
   <img src="smiles/icon_evil.gif"          width="15" height="15" onclick="addsmiley(' :evil: ')">
  
   <img src="smiles/icon_exclaim.gif"       width="15" height="15" onclick="addsmiley(' :exclaim: ')">
   <img src="smiles/icon_idea.gif"          width="15" height="15" onclick="addsmiley(' :idea: ')">
   <img src="smiles/icon_lol.gif"           width="15" height="15" onclick="addsmiley(' :lol: ')">
  
   <img src="smiles/icon_mad.gif"           width="15" height="15" onclick="addsmiley(' :mad: ')">
   <img src="smiles/icon_mrgreen.gif"       width="15" height="15" onclick="addsmiley(' :mrgreen: ')">
   <img src="smiles/icon_neutral.gif"       width="15" height="15" onclick="addsmiley(' :neutral: ')"><br>
  
  <img src="smiles/icon_question.gif"       width="15" height="15" onclick="addsmiley(' :question: ')">
  <img src="smiles/icon_redface.gif"        width="15" height="15" onclick="addsmiley(' :redface: ')">
  <img src="smiles/icon_rolleyes.gif"       width="15" height="15" onclick="addsmiley(' :rolleyes: ')">
  
  <img src="smiles/icon_sad.gif"            width="15" height="15" onclick="addsmiley(' :sad: ')">
  <img src="smiles/icon_smile.gif"          width="15" height="15" onclick="addsmiley(' :smile: ')">
  <img src="smiles/icon_wink.gif"           width="15" height="15" onclick="addsmiley(' :wink: ')">
  
  <img src="smiles/icon_twisted.gif"        width="15" height="15" onclick="addsmiley(' :twisted: ')">
  <img src="smiles/icon_razz.gif"           width="15" height="15" onclick="addsmiley(' :razz: ')">
  <img src="smiles/icon_surprised.gif"      width="15" height="15" onclick="addsmiley(' :surprised: ')">
  
  <img src="smiles/icon_arrow.gif"          width="15" height="15" onclick="addsmiley(' :arrow: ')"> </div>
    </form></td>
  </tr>
</table>

emcuemnecu · 25 Януари 2010

send.php

Код:

<?
if (empty($_POST['user']) || empty($_POST['message'])) { $ref = $_SERVER['HTTP_REFERER']; header("Location:$ref"); }
else { 
include "conf.php";
$nick = htmlspecialchars(addslashes($_POST['user']));
$message = htmlspecialchars(addslashes($_POST['message']));
$to_id = htmlspecialchars(addslashes($_GET['id']));
$data = time();
$ip = $_SERVER['REMOTE_ADDR'];
$sql = mysql_query("
INSERT INTO `bgraparc_chatbox`.`1` (`id` ,`time` ,`nick` ,`message` ,`ip`,`to_id`) VALUES ('' , '$data', '$nick', '$message', '$ip','$to_id');") or die(mysql_error());
mysql_close();
$ref = $_SERVER['HTTP_REFERER']; header("Location:$ref");
}
?>

Създадох в phpmyadmin нова структура ли не знам как да го нарека под името:
to_id със стойност 5 ,обаче проблема е следния, че не записва коментарите във to_id а ги записва само във id, и не ги изкарва в страницата
Във страницата извеждам така:

Код:

<?php
$GLOBALS['to_id'] = 2;
include("LiveChat/chat.php"); ?>

във всяка страница където искам да има коментар просто променам циврите 1 или 2 или 3 и така, но не иска да изкарва.

Изкарване на коментари. Помогнете ми

emcuemnecu

Registered

emcuemnecu

Registered