|










|
|
|
 |
0 |
|
View Articles |
|
 |
 Name |
±Ã±ÝÀÌ |
(2004-03-31 19:18:31, Hit : 12933, Vote : 2259)
|
|
 |
Subject |
 ÇÑÁٴ亯 ¿¡·¯.... ¤Ð.- |
 |
 |
¾È³çÇϼ¼¿©...
¿ì¼± °Á°¡ ³Ñ ÁÁ³×¿©.. ±Ùµ¥ Á¦°¡ 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());
ÀÌ·¸°Ô ó¸®Çß½À´Ï´Ù....
Á¦°¡ ÇÏ´Ù°¡ ÀÌ·¸°Ô ±ÛÀ» ³²±â°Ô µÇ¾ú½À´Ï´Ù..
Çѹø ºÁÁÖ¼¼¿ä... ¤Ð.-
|
 µÎ¸®¹¶½Ç |
You have an error in your SQL syntax near ¹®Àå...
¹®Àå ±Ùó¿¡¼ SQL ±¸¹®¿¡·¯°¡ ³µ´Ù´Â ¸»ÀÌÁÒ. Äõ¸®¸¸ ³õ°í º¸¸é ¿ì¼± number ´Â auto_increment.. Áï ÀÚµ¿Áõ°¡°ªÀÔ´Ï´Ù. ±×³É '' ó·³ ºóÄÀ¸·Î µÎ¸é µÇ°ÚÁÒ.
±× ´ÙÀ½.. Insert ½Ã Çʵå¸íÀÌ À߸øµÇ¾ú³×¿ä. Å×ÀÌºí¿¡´Â password Çʵ尡 ¾ø´Âµ¥ Insert ½Ã Çʵå¸í¿¡ password °¡ ÁöÁ¤µÇ¾î ÀÖ½À´Ï´Ù. Çʵå¸íÀÌ password °¡ ¾Æ´Ï¶ó pwd ÀÏÅ×ÁÒ?
±×¸®°í $tablename=$simplereply; ÀÌ°Ô ¾Æ´ÏÁÒ.
$ ´Â º¯¼ö¶õ ¶æÀÔ´Ï´Ù. $tablename="simplereply"; ÀÌ°Ô ¸Â½À´Ï´Ù. |
|
|
 ±Ã±ÝÀÌ |
¾Æ~~ ³×.. Á¦°¡ Çʵå¸íÀ» °íÄ£ÁÙ ¾Ë¾Ò´Âµ¥ ¾È °íÃÆ°í,
¸¶Áö¸·¿¡ Å×À̺í¸íÀ» º¯¼ö¸¦ ½è±º¿ä.... --^
µÎ¸®¹¶½Ç´Ô~~~ °¨»çÇÕ´Ï´Ù... ^^ |
|
 |

|
|

|
|