Yoyo2
Новичок
Не добавляется коменты в базу! Помогите!!
Превед всем!!!
Подскажите пожалуйста, есть ли чтото неверное в :
И вот и страничика с формой:
Превед всем!!!
Подскажите пожалуйста, есть ли чтото неверное в :
PHP:
<?php include ("blocks/db.php");
if (isset($_POST['author']))
{
$author = $_POST['author'];
}
if (isset($_POST['text']))
{
$text = $_POST['text'];
}
if (isset($_POST['pr']))
{
$pr = $_POST['pr'];
}
if (isset($_POST['sub_com']))
{
$sub_com = $_POST['sumb_com'];
}
if (isset($_POST['id']))
{
$id = $_POST['id'];
}
if (isset($sub_com))
{
if (isset ($author)) {trim($author); }
else {$author = "";}
if (isset ($text)) {trim($text); }
else {$text = "";}
if (empty($author) or empty($text))
{
exit ("<p>All fields are required. <br> <input name='back' type='button' value='Back' onclick='javascript:self.back();'></p>");
}
$author = stripslashes($author);
$text = stripslashes($text);
$author = htmlspecialchars($author);
$text = htmlspecialchars($author);
$result = mysql_query ("SELECT sum FROM sumimg",$db);
$myrow = mysql_fetch_array($result);
if ($pr == $myrow["sum"])
{
$date = date("Y-m-d");
$result2 = mysql_query ("INSERT INTO comments (post,author,text,date) VALUES ('$id','$author','$text','$date')");
}
else exit ("<p>Incorrect sum result. <br><input name='back' type='button' value='Back' onclick='javascript:self.back();'></p>");
}
?>
PHP:
<?php
include ("blocks/db.php");
if (isset($_GET['id'])) {$id = $_GET['id'];}
/* Check for numbers */
if (!preg_match("|^[\d]+$|", $id)) {
exit ("<p>Wrong format. Check URL!</p><p><a href='scripts.php'>Back</a></p>");
}
$result = mysql_query("SELECT * FROM scripts WHERE id='$id'",$db);
$myrow = mysql_fetch_array($result);
$new_view = $myrow["views"] +1;
$update = mysql_query ("UPDATE scripts SET views='$new_view' WHERE id='$id' ",$db)
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head><meta name="description" content="<? echo $myrow['meta_d']; ?>">
<meta name="keywords" content="<? echo $myrow['meta_k']; ?>">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title><?php echo $myrow['title']; ?></title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="690" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#666666" class="main_border">
<? include("blocks/header.php"); ?>
<? include("blocks/menu.php"); ?>
<tr>
<td height="261" valign="top" background="Drag to a file to choose it." bgcolor="#666666"><div align="center">
<p class="name"><? echo $myrow['title']; ?></p>
<p class="adds">Version: <? echo $myrow['version']; ?></p>
<p class="adds">Price: <? echo $myrow['price']; ?></p>
<p class="adds">Views: <? echo $myrow['views']; ?></p>
<p align="left"> </p>
<p><? echo $myrow['feature']; ?> </p>
<p align="left"> </p>
<div class="in_text"><? echo $myrow['text']; ?></div>
<? echo $myrow['buybutt'] ?>
<?
echo "<p class='comm_title'>Comments:</p>";
$result3 = mysql_query ("SELECT * FROM comments WHERE post='$id'",$db);
if (mysql_num_rows($result3)> 0)
{
$myrow3 = mysql_fetch_array($result3);
do
{
printf ("<div class='com_div'><p class='comm'>Comment Added: <strong>%s</strong> <br> Date: <strong>%s</strong><p>
<p class='comm_text'>%s</p></div>",$myrow3["author"], $myrow3["date"], $myrow3["text"]);
}
while ($myrow3 = mysql_fetch_array($result3));
}
?>
<?
$result4 = mysql_query ("SELECT img FROM sumimg",$db);
$myrow4 = mysql_fetch_array($result4); ?>
<p class='comm_title'>Add new comment:</p>
<p class='align'>
<form action="comment.php" method="post" name="form_com" class="comments">
<p><label>Enter your name:</label><br><input name="author" type="text" size="30" maxlength="12"></p>
<p><label>Enter comment text: <br><textarea name="text" cols="30" rows="5"></textarea> </label></p>
<p> </p>
<p>Enter the result:<br><img src="<? echo $myrow4["img"]; ?>" width="80" height="40">
<br><input style='margin-left:10px;' name="pr" type="text" size="5" maxlength="5"></p>
<input name="id" type="hidden" value="<? echo $id; ?>">
<p><input name="sub_com" type="submit" value="Add Comment"></p>
</form>
</p>
</td>
</tr>
<? include("blocks/footer.php"); ?>
</table>
</body>
</html>