|
|
|
| ¹øÈ£ |
Á¦¸ñ |
À̸§ |
ÆÄÀÏ |
µî·ÏÀÏ |
Á¶È¸ |
|
$time_limit = 60*60*24*$notify_new_article;
########## ÇöÀçÆäÀÌÁöÀÇ ¹üÀ§³»¿¡ Ãâ·ÂÇÒ °á°ú·¹Äڵ弼Ʈ¸¦ ¾ò´Â´Ù. ##########
if(!eregi("[^[:space:]]+",$key)) {
$query="select * from $table order by Class_No desc,ansnum asc";
} else {
$query = "select * from $table WHERE $keyfield LIKE '%$key%' 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');
$my_email = mysql_result($result,$i,'E_mail');
$my_Contact_No = mysql_result($result,$i,'Contact_No');
$Outansnum=mysql_result($result,$i,'ansnum');
$my_file_name= mysql_result($result,$i,'file_name');
$Theme = substr($my_theme,0,40);
if($my_file_name != "" ) {
$name = explode( ".",$my_file_name);
$ext = strtolower($name[1]); // À̹ÌÁö ÈÀÏÀÇ È®ÀåÀÚ ¼±ÅÃ
if($ext == "zip") { $file_img=" "; }
if($ext == "xls") { $file_img=" "; }
if($ext == "wav") { $file_img=" "; }
if($ext == "ra") { $file_img=" "; }
if($ext == "psd") { $file_img=" "; }
if($ext == "pdf") { $file_img=" "; }
if($ext == "ppt") { $file_img=" "; }
if($ext == "png") { $file_img=" "; }
if($ext == "mp3") { $file_img=" "; }
if($ext == "jpg") { $file_img=" "; }
if($ext == "gif") { $file_img=" "; }
if($ext == "hwp") { $file_img=" "; }
if($ext == "exe") { $file_img=" "; }
if($ext == "doc") { $file_img=" "; }
if($ext == "mid") { $file_img=" "; }
if($ext == "bmp") { $file_img=" "; }
if($ext == "st3") { $file_img=" "; }
} else {
$file_img ="";
}
$my_date =explode( " ",$my_date);
?>
| echo $my_num ?> |
if($Outansnum != 0){ echo " "; }
echo " $Theme ";
?>
|
if ($my_email != ""){ echo ""; }
?>
echo $my_name ?>
|
echo $file_img ?> |
echo $my_date[0] ?> |
echo $my_Contact_No ?> |
|
} ?>
|
########## °Ô½Ã¹° ¸ñ·Ï ÇÏ´ÜÀÇ °¢ ÆäÀÌÁö·Î Á÷Á¢ À̵¿ÇÒ ¼ö ÀÖ´Â ÆäÀÌÁö¸µÅ©¿¡ ´ëÇÑ ¼³Á¤À» ÇÑ´Ù. ##########
$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}°³]");
}
?>
|
|
if ($keyfield == "Name"){
$chk2 == "checked"; $chk1 == ""; $chk3=="";
} else if ($keyfield == "Contents"){
$chk3 == "checked"; $chk1 == ""; $chk2=="";
} else {
$chk1 == "checked"; $chk2 == ""; $chk3=="";
}
?>
|
|
| |
|