"; } } $db = "search"; $table = "buy_quick"; $conn = mysql_connect("localhost","guest","") or die("µ¥ÀÌŸ ¼­¹ö¿¡ Á¢±Ù ÇÒ ¼ö ¾ø½À´Ï´Ù."); mysql_select_db("$db",$conn); ?> ½ÅÈ­Á¤º¸½Ã½ºÅÛÁÖ½Äȸ»ç ÀüÀÚ»ó°Å·¡(»ð´Ï´Ù)
home 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); ?>

  ¢Æ ±ÞÈ÷ ±¸¸ÅÇϰíÀÚÇÏ´Â Á¦Ç°(»óǰ)À» µî·ÏÇϽʽÿä.
    ÇØ´çÁ¦Ç°(»óǰ)À» º¸À¯Çϰí ÀÖ´Â ´Ù¸¥ ȸ¿ø»ç°¡ Á÷Á¢ °ßÀûÀ» ÁøÇàÇÔÀ¸·Î½á Á÷°Å·¡°¡ °¡´ÉÇÕ´Ï´Ù.
    È¸¿ø(»ç)·Î µî·ÏÇÏ½Ã¾î °¡»ó´ë¸®Á¡À» °³¼³ÇÑ È¿°ú¸¦ ¸¸³£ÇϽñ⠹ٶø´Ï´Ù.

¢Æ °Å·¡ ´ç»çÀÚ°£ÀÇ Ã¥ÀÓÇÏ¿¡ ÀÌ·ç¾îÁö´Â °Å·¡ÀÎ ¸¸Å­ ȸ¿øÀ¸·Î½áÀÇ ½Å·Ú¸¦ ÁöÄÑÁֽñ⠹ٶø´Ï´Ù.
     
¹øÈ£ µî·ÏÀÚ ±¸¸Å³»¿ë À¯È¿ÀÏÀÚ ¿¬¶ôó Á¶È¸
"; } 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}°³]"); } ?>
 
  >