"; } } $db = "search"; $table = "buy_old"; $conn = mysql_connect("localhost","guest","") or die("µ¥ÀÌŸ ¼­¹ö¿¡ Á¢±Ù ÇÒ ¼ö ¾ø½À´Ï´Ù."); mysql_select_db("$db",$conn); ?> ½ÅÈ­Á¤º¸½Ã½ºÅÛÁÖ½Äȸ»ç ÀüÀÚ»ó°Å·¡(ÆË´Ï´Ù)
home logout logout Intranet ä¿ëÁ¤º¸ Sitemap E-mail English
 
"; echo " \n"; ?>
 
 
µî·ÏÀÚ
 
À̸ÞÀÏ
 
ÀüÈ­¹øÈ£
 
ÆÑ½º¹øÈ£
 
Á¦ ¸ñ
 
³»¿ë
 
ÆÇ¸ÅÀ¯È¿ÀÏ
  ³â ¿ù ÀÏ
ÆÐ½º¿öµå
 
 
" ?>
 
 
\n"; echo "window.alert('±Û Á¦¸ñÀ» ±âÀÔÇÏÁö ¾Ê¾Ò½À´Ï´Ù. ') \n"; echo "history.go(-1) \n"; echo ""; exit; } if ($Contents=="") { echo " "; exit; } if ($Name=="") { echo " "; exit; } if ($Passwd=="") { echo " "; exit; } if ($Contents=="") { echo " "; exit; } $query1 = "select Tot_No from $table order by Tot_No desc"; $result1 = mysql_query($query1,$conn); if(!$result1){ $Tot[0] = 0; } else { $Tot = mysql_fetch_row($result1); } $Tot_No=$Tot[0] + 1; $dbresult = mysql_query("select Tot_No from $table order by Tot_No desc",$conn); $totalnumber = mysql_num_rows($dbresult); $dbresult1 = mysql_query("select Class_No from $table order by Class_No desc",$conn); if (!$totalnumber) { $Tot_No=1; $Class_No=1; } else { $maxnumber = mysql_result($dbresult,0,"Tot_No"); $maxrefnum = mysql_result($dbresult1,0,"Class_No"); $Tot_No = $maxnumber + 1; $Class_No = $maxrefnum +1; } $Date_buy="$Date_buy1/$Date_buy2/$Date_buy3"; $query2="INSERT INTO $table VALUES('$Tot_No','$Class_No','$ansnum','$mem_id','$Tel','$Fax','$Theme','$Name','$Email','$Contents','$Passwd','$Date_buy','0')"; $result2=mysql_query($query2,$conn); if(!$result2) { echo " "; } } if($mode == "fix_form") { echo "
"; echo " \n"; echo " \n"; if($mem_id != "eshinhwa") { ?>

 
ºñ¹Ð¹øÈ£
 

 
 
 
 
\n"; echo "window.alert('ÆÐ½º¿öµå°¡ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù. ') \n"; echo "history.go(-1) \n"; echo ""; myql_close($conn); exit; } } $query1 = "select Tel,Fax,Theme,Name,E_mail,Contents,Password,Date_buy from $table where Tot_No='$No'"; $result1 = mysql_query($query1,$conn); $bbs_value = mysql_fetch_row($result1); $OutTel= $bbs_value[0]; $OutFax= $bbs_value[1]; $OutTheme = $bbs_value[2]; $OutName = $bbs_value[3]; $OutE_mail = $bbs_value[4]; $OutContents =$bbs_value[5]; $OutPasswd =$bbs_value[6]; $OutDate_buy=$bbs_value[7]; $OutDate_buy=explode("/",$OutDate_buy); mysql_free_result($result1); mysql_close($conn); echo ""; echo ""; echo " \n"; echo "\n"; echo "\n"; ?>

 
µî·ÏÀÚ
 
À̸ÞÀÏ
 
ÀüÈ­¹øÈ£
 
ÆÑ½º¹øÈ£
 
Á¦ ¸ñ
 
³»¿ë
 
ÆÇ¸ÅÀ¯È¿ÀÏ
  ³â ¿ù ÀÏ
ÆÐ½º¿öµå
 
 
" ?>
 
 
\n"; echo "window.alert('±Û Á¦¸ñÀ» ±âÀÔÇÏÁö ¾Ê¾Ò½À´Ï´Ù. ') \n"; echo "history.go(-1) \n"; echo ""; exit; } if ($Contents=="") { echo " "; exit; } if ($Name=="") { echo " "; exit; } if ($Passwd=="") { echo " "; exit; } if ($Contents=="") { echo " "; exit; } $Date_buy="$Date_buy1/$Date_buy2/$Date_buy3"; $query2 = "update $table Set Tel='$Tel',Fax='$Fax',Theme='$Theme',Name='$Name',E_mail='$Email',Contents='$Contents',Password='$Passwd',Date_buy='$Date_buy' where Tot_No='$No'"; $result2 = mysql_query($query2,$conn); if(!$result2) { echo " "; exit; } } if($mode == "delete_form" ) { echo ""; echo " \n"; echo " \n"; if($mem_id != "eshinhwa"){ ?>

 
ºñ¹Ð¹øÈ£
 

 
 
 
 
\n"; echo "window.alert(' ÆÐ½º¿öµå°¡ ÀÏÄ¡ ÇÏÁö ¾Ê½À´Ï´Ù. ') \n"; echo "history.go(-1) \n"; echo ""; myql_close($conn); exit; } else { $query2 ="delete from $table where ToT_No='$No'"; $result2 = mysql_query($query2,$conn); if(!$result2) { echo "erro result2"; } } } else { $query2 ="delete from $table where ToT_No='$No'"; $result2 = mysql_query($query2,$conn); } } if($mode == "view"){ $query1 = "select Tel,Fax,Theme,Name,E_mail,Contents,Date_buy,Contact_No from $table where Tot_No='$No'"; $result1 = mysql_query($query1,$conn); $bbs_view = mysql_fetch_row($result1); $OutTel = $bbs_view[0]; $OutFax = $bbs_view[1]; $OutTheme=$bbs_view[2]; $OutName = $bbs_view[3]; $OutE_mail = $bbs_view[4]; $OutContents = ereg_replace("\n","\n",$bbs_view[5]); $OutDate_buy = $bbs_view[6]; $OutCN = $bbs_view[7]; mysql_free_result($result1); $OutCN = $OutCN+1; $query2 = "update $table Set Contact_No='$OutCN' where Tot_No='$No'"; $result2 = mysql_query($query2,$conn); if($postcolor == "" || $postfont == "") { $postcolor="white"; $postfont="black"; } ?>

 
   Á¦ ¸ñ
 
   µî·ÏÀÚ
 
   E-mail
 
   ÀüÈ­¹øÈ£
 
   ÆÑ½º¹øÈ£
 
   ÆÇ¸ÅÀ¯È¿ÀÏ
 
   ÆÇ¸Å³»¿ª
   
 
   
  " ?> " ?>
 
  " ?>  
 
0) { $last -= 1; } else { $last = $total_record - 1; } } ########## Àüü ÆäÀÌÁö¼ö¸¦ °è»êÇÑ´Ù. ########## $total_page = ceil($total_record/$num_per_page); ?>

  ¢Æ º¸À¯Çϰí ÀÖ´Â °úÀ×,ºÒ¿ë Àç°í¸¦ µî·ÏÇÏ½Ã¸é µË´Ï´Ù.
    ±¸¸Å¿¡ °ü½ÉÀÖ´Â ¹æ¹®ÀÚ¿ÍÀÇ Á÷°Å·¡°¡ °¡´ÉÇÕ´Ï´Ù. ¿øÇÏ´Â Á¦Ç°À» Ư°¡¿¡ ±¸¸ÅÇÒ ¼ö ÀÖ´Â ±âȸ¿Í
    Àç°íºÎ´ãÀ» ´ú¾î »óÈ£ WIN-WINÇÒ ¼ö ÀÖ´Â ±âȸ¸¦ ³õÄ¡Áö ¸¶½Ê½Ã¿À.

¢Æ °Å·¡ ´ç»çÀÚ°£ÀÇ Ã¥ÀÓÇÏ¿¡ ÀÌ·ç¾îÁö´Â °Å·¡ÀÎ ¸¸Å­ ȸ¿øÀ¸·Î½áÀÇ ½Å·Ú¸¦ ÁöÄÑÁֽñ⠹ٶø´Ï´Ù.
   
¹øÈ£ µî·ÏÀÚ ÆÇ¸Å³»¿ë À¯È¿ÀÏÀÚ ¿¬¶ôó Á¶È¸
"; } echo $my_name; ?>  $my_theme"; ?>
1) { $my_page = $first_page; echo("[ÀÌÀü ${page_per_block}°³]"); } ########## ÇöÀçÀÇ ÆäÀÌÁö ºí·°¹üÀ§³»¿¡¼­ °¢ ÆäÀÌÁö·Î ¹Ù·Î À̵¿ÇÒ ¼ö ÀÖ´Â ÇÏÀÌÆÛ¸µÅ©¸¦ Ãâ·ÂÇÑ´Ù. ########## for($direct_page = $first_page+1; $direct_page <= $last_page; $direct_page++) { if($page == $direct_page) { echo("[$direct_page]"); } else { echo("[$direct_page]"); } } ########## ´ÙÀ½ÆäÀÌÁöºí·Ï¿¡ ´ëÇÑ ÆäÀÌÁö ¸µÅ© ########## if($block < $total_block) { $my_page = $last_page+1; echo("[´ÙÀ½ ${page_per_block}°³]"); } ?>
 
  >