0
 829   42   8
  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"; ÀÌ°Ô ¸Â½À´Ï´Ù.
 2004/03/31 21:13:26    

±Ã±ÝÀÌ
¾Æ~~ ³×.. Á¦°¡ Çʵå¸íÀ» °íÄ£ÁÙ ¾Ë¾Ò´Âµ¥ ¾È °íÃÆ°í,
¸¶Áö¸·¿¡ Å×À̺í¸íÀ» º¯¼ö¸¦ ½è±º¿ä.... --^
µÎ¸®¹¶½Ç´Ô~~~ °¨»çÇÕ´Ï´Ù... ^^
 2004/04/01 00:49:48   


no
subject
name
date
hit
*
689
  À̹ø¿¡ À¥¸¶½ºÅÍ ½ÃÇèÀ» º¸´Âµ¥..^^Á¶±Ý ... [1]

°ø¼±¹Ì
2005/08/18 9092 1902
688
  php°Ô½ÃÆÇÀ» ¸¸µé´Ù°¡.. [2]

°ø¼±¹Ì
2005/08/31 10118 1886
687
  ¿þ¸Þ³ª..¤¾¤¾¤¾¤¾¸»¸Ó¸®¸»ÀÌÁÒ¤¾¤¾ [1]

°ø¼±¹Ì
2005/09/07 9391 2010
686
  Áú¹®!!

±¸µ¿Àº
2002/08/12 8186 1921
685
  apache2triad1.4.3 ÀÌ ÇÁ·Î±×... [1]

±¸¿µÈñ
2005/12/17 9131 1894
684
  µÎ¸®¹¶½Ç´Ô! ±×¸®°í º´¸ñ´Ô ²À ºÎʵ右... [5]

±Ã±×¹Ì~
2003/02/05 6645 1409
683
  OA±â»ç...

±Ã±Ý
2002/05/20 9425 2298
682
  please....

±Ã±Ý
2002/07/25 8490 1780
681
  ¸®½ºÆ®Ãâ·Â [1]

±Ã±Ý
2003/11/27 8597 1786
680
  ºñÁÖ¾óº£ÀÌÁ÷¿¡ ´ëÇÏ¿© ±Ã±Ý [2]

±Ã±Ý
2004/08/26 13664 2403
679
  php°Ô½ÃÆÇ¿¡¼­.. Áú¹®ÀÔ´Ï´Ù.. [2]

±Ã±Ý
2008/02/12 9788 2016
678
  ºñÁÖ¾ó º£ÀÌÁ÷ ·£´ý ÆÄÀÏ¿¡ °üÇØ¼­...

±Ã±Ý..
2002/06/10 8657 1896
677
  [Áú¹®]ccna,ccsa,scsa¿¡ °üÇØ.....

±Ã±ÝÀÌ
2002/08/02 8824 1835
676
  ¿À¶óŬ view¿¡ °üÇÑ Áú¹°

±Ã±ÝÀÌ
2002/11/05 9385 1979
675
  JSP + DB ¿¬µ¿ºÎºÐ [2]

±Ã±ÝÀÌ
2003/04/12 9490 2016

  ÇÑÁٴ亯 ¿¡·¯.... ¤Ð.- [2]

±Ã±ÝÀÌ
2004/03/31 12933 2259
673
    ÇÑÁٴ亯 »èÁ¦ Áú¹®ÀÌ¿©... ¤Ð.- [2]

±Ã±ÝÀÌ
2004/04/01 9506 2064
672
  php°Ô½ÃÆÇ ¸¸µé±â¿¡¼­ Áú¹®ÀÌ¿ä [1]

±Ã±ÝÀÌ
2004/11/15 9536 1930
671
  ±Ã±ÝÇØ¼­¿ä..

±Ã±ÝÇØ¼­
2002/07/20 8541 1891
670
  ¾Æ·¡ Áú¹®ÀÇ ÇлýÀä...

±Ã±ÝÇØ¼­2
2002/07/20 8717 1979
[1][2][3][4][5][6][7] 8 [9][10]..[42] [next]

Copyright 1999-2025 Zeroboard / skin by Zetyx