Как да направя...

teram · 12 Май 2007

Как трябва да стане кода за да може в базата да се записва

а в страницата да показва картинката ?

Код:

<?php 
mysql_connect($server, $user, $pass)or die("Сайтът не може да се свърже към базата данни"); 
@mysql_select_db($db) or die("Грешна база данни"); 
$chars="SET CHARACTER SET cp1251";mysql_query($chars);

$pageNum = 1; 

if(isset($_GET['page'])) 
{ 
$pageNum = $_GET['page']; 
} 


$id=$_GET['id']; 
$query = "SELECT COUNT(id_com) AS numrows FROM comments WHERE id = '$id' "; 
$result = mysql_query($query) or die('Error, query failed1'); 
$row = mysql_fetch_array($result, MYSQL_ASSOC); 
$numrows = $row['numrows']; 


$redove = ($pageNum - 1) * $broinastranicacom; 


$id=$_GET['id']; 
$querys = " SELECT * FROM comments WHERE id = '$id' ORDER BY chas and minuti and den DESC LIMIT $redove, $broinastranicacom"; 
$results = mysql_query($querys) or die('Error, query failed2'); 


while($row = mysql_fetch_array($results)) 
{ 
$id=$row[id]; 
$username=$row[username]; 
$minuti=$row[minuti]; 
$chas=$row[chas]; 
$den=$row[den]; 
$mesec=$row[mesec]; 
$godina=$row[godina]; 
$comment=$row[comment]; 


echo "<table width=100% border=0 cellpadding=0 cellspacing=0> 
<tr> 

<td class=text height=19 background=images/fontcom.gif>  Добавил: <b><a href=forum/profile.php?mode=viewprofile&u=".$username.">".$username."</a></b></td> 
</tr> 

<tr> 
<td> 
<table id=lineLRBs class=nav border=0 cellpadding=0 cellspacing=0 width=100%> 
<tr> 
<td height=25px id=lineBottom width=100%> <i><b>".$chas.":".$minuti." - ".$den." ".$mesec.", ".$godina." г.</b></i></td> 
</tr> 
<tr> 
<td width=100%><div><table cellpadding=5 width=100%> 
<tr> 
<td width=100%>".$comment."</td> 
</tr> 
</table></div></td> 
</tr> 
</table></table>"; 
echo "<br>"; 
} 

if ($numrows<1) 
{echo "";} 

$maxPage = ceil($numrows/$broinastranicacom); 

$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 
echo '<center><font face="Tahoma" style="font-size: 8pt"></font> '; 
for($page = 1; $page <= $maxPage; $page++) 
{ 
if ($page == $pageNum) 
{ 
$nomeranastranici .= "<font face=\"Tahoma\" style=\"font-size: 8pt\">$page</font>"; 
} 
else 
{ 
$nomeranastranici .= " <font face=\"Tahoma\" style=\"font-size: 8pt\"><a href=\"$self?id=$id&page=$page\">$page</a> </font>"; 
} 
} 


if ($pageNum > 1) 
{ 
$page = $pageNum - 1; 
$predishna = "<font face=\"Tahoma\" style=\"font-size: 8pt\"><a href=\"$self?id=$id&page=$page\">[<<<<<]</a> </font>"; 

$parva = "<font face=\"Tahoma\" style=\"font-size: 8pt\"><a href=\"$self?id=$id&page=1\">[първа]</a> </font>"; 
} 
else 
{ 
$predishna = ' '; 
$parva = ' '; 
} 

if ($pageNum < $maxPage) 
{ 
$page = $pageNum + 1; 
$sledvashta = "<font face=\"Tahoma\" style=\"font-size: 8pt\"><a href=\"$self?id=$id&page=$page\">[>>>>>]</a> </font>"; 

$posledna = "<font face=\"Tahoma\" style=\"font-size: 8pt\"><a href=\"$self?id=$id&page=$maxPage\">[последна]</a></font>"; 
} 
else 
{ 
$sledvashta = ' '; 
$posledna = ' '; 
} 
?> 

<?php 

if($_POST['Submit']){ 

$id = $_POST['id'];

$ip = $_SERVER['REMOTE_ADDR']; 
$minuti = $_POST['minuti']; 
$chas = $_POST['chas']; 
$den = $_POST['den']; 
$mesec = $_POST['mesec']; 
$godina = $_POST['godina']; 
$username = $_POST['username']; 
$comment = $_POST['comment']; 
if(empty($comment)){ 
echo "";
die();
};

$comment=preg_replace("/(\[b\])(.+?)(\[\/b\])/i", "<b>\\2</b>", $comment);
$comment=preg_replace("/(\[i\])(.+?)(\[\/i\])/i", "<i>\\2</i>", $comment);
$comment=preg_replace("/(\[u\])(.+?)(\[\/u\])/i", "<u>\\2</u>", $comment);
$comment=preg_replace("/(\[email=(.+?)\])(.+?)(\[\/email\])/i", '<a href="mailto:\\2" target="_blank">\\3</a>',$comment);
$comment=preg_replace("/(\[email\])(.+?)(\[\/email\])/i", '<a href="mailto:\\2">\\2</a>', $comment);
$comment=preg_replace("/(\[url\])(.+?)(\[\/url\])/i", '<a href="\\2" target="_blank">\\2</a>', $comment);
$comment=preg_replace("/(\[url=\])(.+?)(\[\/url\])/i", '<a href="\\2" target="_blank">\\2</a>', $comment);
$comment=preg_replace("/(\[url=(.+?)\])(.+?)(\[\/url\])/i", '<a href="\\2" target="_blank">\\3</a>', $comment);
$comment=preg_replace("/(\[color=(.+?)\])(.+?)(\[\/color\])/i", '<font color=\\2>\\3</font>',$comment);


$comment=str_replace(":usmivka:",'<img src="images/smilies/icon_smile.gif" border="0">',$comment);
$comment=str_replace(":(",'<img src="images/smilies/icon_sad.gif" border="0">',$comment);
$comment=str_replace(":rolleyes:",'<img src="images/smilies/icon_rolleyes.gif" border="0">',$comment);
$comment=str_replace(":D",'<img src="images/smilies/icon_biggrin.gif" border="0">',$comment);
$comment=str_replace(":?",'<img src="images/smilies/icon_confused.gif" border="0">',$comment);
$comment=str_replace("8)",'<img src="images/smilies/icon_cool.gif" border="0">',$comment);
$comment=str_replace(";(",'<img src="images/smilies/icon_cry.gif" border="0">',$comment);
$comment=str_replace("O.o",'<img src="images/smilies/icon_eek.gif" border="0">',$comment);
$comment=str_replace(":!:",'<img src="images/smilies/icon_exclaim.gif" border="0">',$comment);
$comment=str_replace(":idea:",'<img src="images/smilies/icon_idea.gif" border="0">',$comment);
$comment=str_replace(":lol:",'<img src="images/smilies/icon_lol.gif" border="0">',$comment);
$comment=str_replace(":evil:",'<img src="images/smilies/icon_evil.gif" border="0">',$comment);
$comment=str_replace(":twisted:",'<img src="images/smilies/icon_twisted.gif" border="0">',$comment);
$comment=str_replace(":x",'<img src="images/smilies/icon_mad.gif" border="0">',$comment);
$comment=str_replace(":question:",'<img src="images/smilies/icon_question.gif" border="0">',$comment);
$comment=str_replace(":P",'<img src="images/smilies/icon_razz.gif" border="0">',$comment);
$comment=str_replace(":oops:",'<img src="images/smilies/icon_redface.gif" border="0">',$comment);
$comment=str_replace(":o",'<img src="images/smilies/icon_surprised.gif" border="0">',$comment);
$comment=str_replace(";)",'<img src="images/smilies/icon_wink.gif" border="0">',$comment);
$comment=str_replace(":|",'<img src="images/smilies/icon_neutral.gif" border="0">',$comment);
$comment=str_replace(":B",'<img src="images/smilies/icon_mrgreen.gif" border="0">',$comment);

mysql_connect($server, $user, $pass)or die("Сайтът не може да се свърже към базата данни"); 
@mysql_select_db($db) or die("Грешна база данни"); 
$query = "INSERT INTO `comments` (`id`, `username` , `minuti`, `chas`, `den`, `mesec`, `godina`, `ip`, `comment`, `title`) 
VALUES ( 
'$id', '$username', '$minuti', '$chas', '$den', '$mesec', '$godina', '$ip', '$comment', '$title' 
);"; 
$ok = mysql_query($query); 
if($ok){ 
echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=vic.php?id_vic=$id_vic\">"; 
}else{ 
echo "Възникна грешка <br><b>";
echo mysql_error(); 
} 
} ?>

Как да направя...

teram

Registered