if ($mem_sid ==""){
echo "";
} else {
$db = "search";
$table = "buy_quick";
$conn = mysql_connect("localhost","guest","") or die("µ¥ÀÌŸ ¼¹ö¿¡ Á¢±Ù ÇÒ ¼ö ¾ø½À´Ï´Ù.");
mysql_select_db("$db",$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"," ",$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";
}
?>
| |
|
| |
|
| |
|
|
|
|
|
 |
mysql_close($conn);
exit;
}
########### ÇÑ ÆäÀÌÁö´ç Ãâ·ÂÇÒ °Ô½Ã¹°ÀÇ ¼ö
$num_per_page ="10";
########### °Ô½Ã¹° Ãâ·Â¸ñ·Ï ÇÏ´Ü¿¡ ¸µÅ©¸¦ °É ÆäÀÌÁöÀÇ °³¼ö
$page_per_block = 10;
########## µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇÑ´Ù. ###########
if(!$page) {
$page = 1;
}
########## Àüü°Ô½Ã¹°ÀÇ ÃÑ °³¼ö¸¦ °¢°¢ ±¸ÇÑ´Ù. ##########
$query = "SELECT count(Tot_No) FROM $table WHERE Mem_id='$Mem_id'";
$result = mysql_query($query,$conn);
if (!$result) {
echo ("****QUERY_ERROR******");
exit;
}
$total_record = mysql_result($result,0,0);
########## ÇöÀçÀÇ ÆäÀÌÁö¿¡¼ Ãâ·ÂÇÒ °Ô½Ã¹°ÀÇ ¹üÀ§¸¦ °áÁ¤ÇÑ´Ù. ##########
if(!$total_record) {
$first = 1;
$last = 0;
} else {
$first = $num_per_page*($page-1);
$last = $num_per_page*$page;
$IsNext = $total_record - $last;
if($IsNext > 0) {
$last -= 1;
} else {
$last = $total_record - 1;
}
}
########## Àüü ÆäÀÌÁö¼ö¸¦ °è»êÇÑ´Ù. ##########
$total_page = ceil($total_record/$num_per_page);
?>
|
|
|
| |
|
|
|
|
|
|
| ¹øÈ£ |
±¸¸Å³»¿ë |
µî·ÏÀÚ |
À¯È¿ÀÏÀÚ |
¿¬¶ôó |
Á¶È¸ |
|
|
|
|
|
|
if($total_record != "0") {
$time_limit = 60*60*24*$notify_new_article;
########## ÇöÀçÆäÀÌÁöÀÇ ¹üÀ§³»¿¡ Ãâ·ÂÇÒ °á°ú·¹Äڵ弼Ʈ¸¦ ¾ò´Â´Ù. ##########
$query = "select * from $table WHERE Mem_id='$Mem_id' order by Tot_No desc";
$result= mysql_query($query,$conn);
if (!$result) {
echo ("QUERY_ERROR!!!!!!!");
exit;
}
########## °Ô½Ã¹°ÀÇ °¡»ó¹øÈ£(°Ô½Ã¹°ÀÇ °³¼ö¿¡ µû¸¥ ÀϷùøÈ£) ##########
$article_num = $total_record - $num_per_page*($page-1);
for($i = $first; $i <= $last; $i++) {
$my_num = mysql_result($result,$i,'Tot_No');
$my_theme= mysql_result($result,$i,'Theme');
$my_name= mysql_result($result,$i,'Name');
$my_date= mysql_result($result,$i,'Date_buy');
$my_tel = mysql_result($result,$i,'Tel');
$my_email = mysql_result($result,$i,'E_mail');
$my_Contact_No = mysql_result($result,$i,'Contact_No');
?>
|
|
|
|
|
|
|
}
} else {
?>
| ÇØ´ç µ¥ÀÌŸ°¡
¾ø½À´Ï´Ù. |
|
|
|
|
|
|
}
?>
|
########## °Ô½Ã¹° ¸ñ·Ï ÇÏ´ÜÀÇ °¢ ÆäÀÌÁö·Î Á÷Á¢ À̵¿ÇÒ ¼ö ÀÖ´Â ÆäÀÌÁö¸µÅ©¿¡ ´ëÇÑ ¼³Á¤À» ÇÑ´Ù. ##########
$total_block = ceil($total_page/$page_per_block);
$block = ceil($page/$page_per_block);
$first_page = ($block-1)*$page_per_block;
$last_page = $block*$page_per_block;
if($total_block <= $block) {
$last_page = $total_page;
}
########## ÀÌÀüÆäÀÌÁöºí·Ï¿¡ ´ëÇÑ ÆäÀÌÁö ¸µÅ© ##########
if($block > 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}°³]");
}
?>
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
 |
} ?>