Sveiki, turiu komentarų skriptą, veikia jis normaliai, visus duomenys įrašo į duomenų bazę tik ne ten kur reikia. Kaip padaryti, kad priskirtu komentarą tam tikram įrašui.
Kodas:
<?php
include('blokas/baze.php');
if(isset($_GET['id'])){$id=$_GET['id'];}
if(!isset($id)){$id=1;}
$result=mysql_query("SELECT * FROM knygos WHERE id='$id'",$linkas);
$myrow = mysql_fetch_array($result);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Sveciu knyga</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<a href="knyga.php"></a> <a href="vartpagr.php">Pagrindinis</a>
<?php
?>
<table width="1024px" height="900px"align="center">
<tr>
<td valign="top" align="left">
<table
<?php
session_start();
if (isset($_SESSION['username']))
{
$idd=$_SESSION['id'];
$result2=mysql_query("SELECT * FROM user where id='$idd'",$linkas);
$array = mysql_fetch_array($result2);
$pav=$array["img"];
$data=date ('Y-n-j');
print <<<HERE
<table>
<tr height='600px'>
<td id='svtableright'>
<form name='forma' action='sv.php' method='post'>
<p>Tekstas:</p><textarea name='text' rows='' cols='22'></textarea>
<p><input value='$idd' name='id2' type='hidden'></p>
<p><input value='$_SESSION[name]' name='name' type='hidden'></p>
<p><input value='$pav' name='pav' type='hidden'></p>
<p><input value='$data' name='data' type='hidden'></p>
<p><input name='sub' type='submit'value='Skelbti'></p>
</form>
<td valign='top'>
HERE;
if(isset($_POST['text'])){ $text=$_POST['text'];if($text==''){unset($text);}}
if(isset($_POST['sub'])){ $sub=$_POST['sub'];if($sub==''){unset($sub);}}
if(isset($_POST['id2'])){ $id2=$_POST['id2'];if($id2==''){unset($id2);}}
if(isset($_POST['name'])){ $name=$_POST['name'];if($name==''){unset($name);}}
if(isset($_POST['pav'])){ $pav=$_POST['pav'];if($pav==''){unset($pav);}}
if(isset($_POST['data'])){ $data=$_POST['data'];if($data==''){unset($data);}}
if(isset($sub))
{
if(isset($text)){
$text=htmlspecialchars($text);
/*
$title=htmlentities($title);*/
$result2=mysql_query("INSERT INTO knygos(komentaras) VALUES('$text')");
}
else
{
echo"Visi laukai privalo būti užpildyti !";
}
}
$result=mysql_query("SELECT * FROM svkomentarai ORDER BY id DESC",$linkas);
$myrow = mysql_fetch_array($result);
do{
printf("
<table id='komenttable'><tr><td id='leftlaukstilius'><img src='avatar/%s' id='svavatar'/><p>%s</p></td><td valign='top'><p><b></b>%s</p><p>%s</p></td></tr></table>
",$myrow["image"],$myrow["username"],$myrow["title"],$myrow["text"]);
}
while($myrow = mysql_fetch_array($result));
print <<<HERE
</td>
</tr>
</table>
HERE;
}
else
die("<p>Įveskite prisijungimo duomenys pagrindiniame puslapyje !<br/> <a href='index.php'>Pagrindinis</a></p>");
?>
</td>
</tr>
</table>
<?php
?>
</body>
</html>
