¾È³çÇϼ¼¿©...
¿ì¼± °Á°¡ ³Ñ ÁÁ³×¿©.. ±Ùµ¥ Á¦°¡ php·Î ¸¸µå´Âµ¥
ÇÑÁٴ亯¿¡¼ ¿¡·¯¶«½Ã °í¹ÎÇÏ´Ù°¡ ÀÌ·¸°Ô ±Û ¿Ã¸³´Ï´Ù.
¿ì¼± ´äº¯ ó¸®ÇÏ´Â ºÎºÐ¿¡¼ Äõ¸® ºÎºÐ¿¡¼ ¿¡·¯°¡
³ª±æ·¡ °ªÀ» ´Ù Âï¾îºÃ´Âµ¥ ´Ù ºÒ·¯¿É´Ï´Ù.
151512121111121212121211080727311220.117.161.137You have an error in your SQL syntax near '(number,parent,guest_name,password,comment,ip,writetime) values('15','15' at line 1insert into (number,parent,guest_name,password,comment,ip,writetime) values('15','15','1212','1111','12121212121','220.117.161.137',1080727311)
ÀÌ·¸°Ô ¿¡·¯°¡ ³³´Ï´Ù...
¼Ò½º´Â
<?
// ÇÊ¿äÇÑ ¼³Á¤ÀÌ ´ã°ÜÀÖ´Â config.php¸¦ include ½ÃŲ´Ù.
include "../admin/config.php";
// Mysql Server¿¡ Á¢¼ÓÇÑ´Ù.
$conn = mysql_pconnect( $set_host, $set_user, $set_password );
mysql_select_db( $set_dbname );
$tablename = $simplereply;
//ÀÔ·ÂÆû(write.php)¿¡¼ Àü¼ÛµÈ ³»¿ëÀ» º¯¼ö¿¡ ´ã½À´Ï´Ù.
$guest_name = addslashes($guest_name);
$password = addslashes($password);
$comment = addslashes($comment);
echo $number;
echo $parent;
echo $guest_name;
echo $password;
echo $comment;
//µðÆúÆ® °ªÀÌ ÇÊ¿äÇÑ º¯¼ö¿¡´Â µðÆúÆ® °ªÀ» ³Ö½À´Ï´Ù.
$writetime = time();
$ip = getenv("REMOTE_ADDR");
echo $writetime;
echo $ip;
//SQL ¸í·ÉÀ» ÀÌ¿ëÇØ ÀԷ¹ÞÀº ³»¿ë°ú µðÆúÆ®°ª µîÀ» MySQL¿¡ ÀÔ·Â(insert)ÇÕ´Ï´Ù.
$sql = "insert into $tablename (number,parent,guest_name,password,comment,ip,writetime)
values('$number','$parent','$guest_name','$password','$comment','$ip',$writetime)";
mysql_query($sql) or die (mysql_error().$sql);
//±Û ÀÔ·ÂÀÌ ¿Ï·áµÇ¸é º¸±â ÆäÀÌÁö·Î ÀÚµ¿ À̵¿Çϵµ·Ï ÇÕ´Ï´Ù
if ($msg=='') {
$msg = "¼º°øÀûÀ¸·Î µî·ÏµÇ¾ú½À´Ï´Ù";
echo " <html><head>
<script name=javascript>
if('$msg' != '') {
self.window.alert('$msg');
}
location.href='view.php?id=$id&page=$page&number=$number&src_name=$src_name&src_value=$src_value';
</script>
</head>
</html> ";
} else {
echo " <html><head>
<script name=javascript>
if('$msg' != '') {
self.window.alert('$msg');
}
history.go(-1);
</script>
</head>
</html> ";
}
?>
À̺κÐÀÌ ´ä±Û ÀúÀåÇÏ´Â ¼Ò½ºÀÔ´Ï´Ù..
create table simplereply (
number int(8) not null auto_increment primary key,
parent int(8) not null,
guest_name char(12) not null,
pwd char(16) not null,
comment text not null,
ip char(15) not null,
writetime int(8) not null
);
À̺κÐÀº Å×ÀÌºí ±¸Á¶ÀÔ´Ï´Ù...
view ºÎºÐÀº
<form method=post name=write action='simplereply_ok.php' onsubmit="return check_comment_submit(this)">
<input type=hidden name=id value='<?=$id?>'>
<input type=hidden name=page value='<?=$page?>'>
<input type=hidden name=number value='<?=$number?>'>
<input type=hidden name=parent value='<?=$number?>'>
<input type=hidden name=src_name value='<?=$src_name?>'>
<input type=hidden name=src_value value='<?=$src_value?>'>
<?
while($array2 = mysql_fetch_array($result2)) {
$cmt_number = $array2[number]; // ±Û ¹øÈ£
$cmt_name = stripslashes($array2[guest_name]); // °£´ÜÇÑ ´ä±Û ³»¿ë
$cmt_comment = nl2br(stripslashes($array2[comment])); // °£´ÜÇÑ ´ä±Û ³»¿ë
$cmt_date = date('Y-m-d',$array2[writetime]); // ±Û¾´ ³¯Â¥
$cmt_time = date('H:i:s',$array2[writetime]); // ±Û¾´ ½Ã°£
$a_simple_del = "<a onfocus='blur();' href=simplereply_del.php?id=$id&number=$number&page=$page&replyno=$replyno&src_name=$src_name&src_value=$src_value&cmt_number=$cmt_number>";
?>
<tr>
<td><? echo $cmt_name; ?></td>
</tr>
<tr>
<td><? echo $cmt_comment; ?></td>
</tr>
<tr>
<td><? echo $cmt_date; ?> <? $cmt_time; ?></td>
</tr>
<?
}
?>
<tr>
<td class="gray_130">
<img src="../img/no.gif" width="18" height="1"><img src="../img/t_name.gif" width="24" height="7" align="absmiddle">
<input type="text" name="guest_name" maxlength="10" style="width:60px;"class="input2">
<img src="../img/t_pw.gif" width="50" height="7" align="absmiddle">
<input type="password" name="password" maxlength="10" style="width:60px;"class="input2">
<br>
<img src="../img/t_comment.gif" width="42" height="7" align="absmiddle"> <input type="text" name="comment" style="width:450px;" class="input2">
<input type="image" src="../img/s_ok.gif" width="30" height="18" align="absmiddle" border="0" name="replybn" id="replybn"></td>
</tr>
</form>
</table>
ÀÌ·¸°Ô ó¸®Çß±¸¿© À§¿¡¼
$simplereply_id = "simplereply"; // °£´ÜÇÑ ´ä±Û Å×À̺í À̸§ ÁöÁ¤
$query2 = "select * from simplereply where parent=$number order by number"; // °£´ÜÇÑ ´ä±ÛÀ» ºÒ·¯¿È
$result2 = mysql_query($query2) or die (mysql_error());
ÀÌ·¸°Ô ó¸®Çß½À´Ï´Ù....
Á¦°¡ ÇÏ´Ù°¡ ÀÌ·¸°Ô ±ÛÀ» ³²±â°Ô µÇ¾ú½À´Ï´Ù..
Çѹø ºÁÁÖ¼¼¿ä... ¤Ð.-
|