0
 829   42   1
  View Articles

Name  
   ±Ã±ÝÀÌ  (2004-03-31 19:18:31, Hit : 12942, 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
*
829
  Èì ÄôÄôµû

ÆÄ¶õ
2008/11/23 12630 2446
828
  Èì ¹øÈ£ [2]

¹ÙÅõ
2003/05/20 17112 2031
827
 ºñ¹Ð±ÛÀԴϴ٠ȸ¿ø°¡ÀÔ¿¡ ´ëÇÏ¿©.. [1]

±èȯÈñ
2003/08/09 8 0
826
  È¸¿ø°¡ÀÔ °ü·Ã.. [1]

Áø
2004/03/27 9761 2255
825
  Çü~ ÀßÁö³Â¾î? ^^ [2]

¼Õ»ó¿í
2005/09/19 9550 2268
824
 ºñ¹Ð±ÛÀÔ´Ï´Ù Çü, 95Çйø ¹è»ó¿øÀÔ´Ï´Ù. [1]

¹è»ó¿ø
2006/09/28 5 0
823
  ÇìÇì ¶Ç Áú¹®ÀÌ¿ä~~^^; [3]

À̰æÁø
2003/08/08 9824 2219
822
    ÇذáÀÌ ¾ÈµÇ´Â±º¿ä...¤Ð_¤Ð [1]

stub363
2004/01/01 8857 2131
821
  ÇÑÁÙ¸Þ¸ðÀå..¤»¤» [4]

ÀÌÁø¼ö
2006/05/27 12353 2332

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

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

±Ã±ÝÀÌ
2004/04/01 9521 2064
818
  ÇѰ¡Áö¸¸ ´õ¹°¾îº¼°Ô¿ä. [1]

±è¹Î¼ö
2003/03/25 8750 1833
817
  ÇÑ ¼ö ºÎʵ右´Ï´Ù. [2]

ÀÓÃá½Ä
2005/01/02 9039 1926
816
 ºñ¹Ð±ÛÀÔ´Ï´Ù ÇлýÀä..µµ¿òÀ» ºÎʵ右´Ï´Ù [2]

±èȯÈñ
2003/06/21 12 0
815
  ÇÏÀ̸µÅ© ±èÅ¿µ ÀÔ´Ï´Ù ¿î¿µÀÚ´Ô °ËÅä¹Ù... [1]

±èÅ¿µ
2005/02/23 9361 2050
814
  ÇÁ·Î±×·¥¼öÁ¤À»À§ÇÑ ¼Ò½ºº¸±â [1]

Á¤¿µÀÏ
2006/04/28 9486 2192
813
  ÇÁ·Î±×·¡¹Ö ÇÏ´Ù°¡ ¸·Çô¼­@_@;;

¹ÙÅõ
2003/05/23 8563 1850
812
  Æû¿¡¼­ ³Ñ°Ü¿Â °ªÀ» µ¥ÀÌÅͺ£À̽º¿¡ ÀúÀå... [2]

±èÁÖ¿Ï
2005/08/03 9365 1951
811
  Æû¸ÞÀÏ¿¡¼­ Àü´Þ ¼Ò½º¸¦ ¾µ¼ö°¡ ÀÖÀ»±î¿ä... [2]

¾îµÎ¹Î
2003/03/17 8312 1898
810
 ºñ¹Ð±ÛÀÔ´Ï´Ù Æû¸ÞÀÏ¿¡ ´ëÇÑ Áú¹®ÀÔ´Ï´Ù [2]

Kimjinhee
2003/02/11 9 0
1 [2][3][4][5][6][7][8][9][10]..[42] [next]

Copyright 1999-2025 Zeroboard / skin by Zetyx