$keyfield = NULL;
$key = NULL;
$number = NULL;
$page = NULL;
if(array_key_exists( 'number',$_GET)) $number = $_GET["number"];
if(array_key_exists( 'page',$_GET)) $page = $_GET["page"];
if(array_key_exists( 'keyfield',$_POST)) $keyfield = $_POST["keyfield"];
if(array_key_exists( 'keyfield',$_GET) && !$keyfield) $keyfield = $_GET["keyfield"];
if(array_key_exists( 'key',$_POST)) $key = $_POST["key"];
if(array_key_exists( 'key',$_GET) && !$key) $key = $_GET["key"];
/***** for Security - CSRF ******/
include_once "bbs_csrf_check.php";
/* Parameterが間違えたら
$id_check = FALSE;
$keyQuery_Check = FALSE;
$email_ok_check = FALSE;
$id_ok_check = FALSE;を返す。
*/
if(!$page) {$page=1;}
if(!$keyQuery_Check) {
$encoded_key ="";
$query = "SELECT count(pg_seqnum) FROM mirine WHERE pg_lang='J'";
} else {
$encoded_key=urlencode($key);
$query="SELECT count(pg_seqnum) FROM mirine WHERE pg_lang='J' AND $keyfield LIKE '%$key%'";
}
$result=mysql_query($query, $db);
if(!$result) {
error("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(!$keyQuery_Check) {
echo("[total : $total_record]");
} else {
echo("[search : $total_record]");
}
?>
( / )
|
| 번호 |
제목 |
게시일 |
조회수 |
$time_limit=60*60*24*3;
$queryColumns="pg_seqnum,pg_title,pg_sdate,pg_edate,pg_photo1,pg_ref,pg_signdate";
if(!$keyQuery_Check) {
$query="SELECT $queryColumns FROM mirine WHERE pg_lang='J' ORDER BY pg_seqnum DESC";
} else {
$query="SELECT $queryColumns FROM mirine WHERE pg_lang='J' AND $keyfield LIKE '%$key%' ORDER BY pg_seqnum DESC";
}
$result=mysql_query($query, $db);
if(!$result) {
error("QUERY_ERROR");
exit;
}
$article_num=$total_record - $num_per_page*($page-1);
for($i=$first; $i<=$last; $i++) {
$my_pg_seqnum=mysql_result($result, $i, 0);
$my_pg_title=mysql_result($result, $i, 1);
$my_pg_sdate=mysql_result($result, $i, 2);
$my_pg_edate=mysql_result($result, $i, 3);
$my_pg_photo1=mysql_result($result, $i, 4);
$my_pg_ref=mysql_result($result, $i, 5);
$my_pg_signdate=mysql_result($result, $i, 6);
if(!(preg_match("//",$my_pg_title))){
if (mb_strlen($my_pg_title) >= 46){
$my_pg_title = mb_strimwidth($my_pg_title, 0, 46, "...", $encode);
}
}
if(!strcmp($keyfield, "pg_title") && $key) {
$my_pg_title=preg_replace("/$key/", "$key", $my_pg_title);
}
echo("
| $article_num |
");
if($keyfield){
echo(" $my_pg_title");
}else{
echo(" $my_pg_title");
}
$date_diff= time() - $my_signdate;
if($number == $my_pg_seqnum) {
echo(" ");
} else {
if(($date_diff < $time_limit) && ($my_signdate > $renewal_day)) {
echo(" ");
} else {
echo("");
}
}
$my_pg_signdate=date("y-m-d", $my_pg_signdate);
?>
| echo("$my_pg_signdate") ?> |
echo("$my_pg_ref") ?> |
$article_num--;
}
?>
|
|
$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;
if($keyfield){
echo("[Previous ${page_per_block}]");
}else{
echo("[Previous ${page_per_block}]");
}
}
for($direct_page=$first_page+1; $direct_page <= $last_page; $direct_page++) {
if($page==$direct_page) {
echo("[$direct_page]");
}else{
if($keyfield){
echo("[$direct_page]");
}else{
echo("[$direct_page]");
}
}
}
if($block < $total_block) {
$my_page=$last_page+1;
if($keyfield){
echo("[Next ${page_per_block}]");
}else{
echo("[Next ${page_per_block}]");
}
}
?>
|
if($page>1) {
$page_num=$page-1;
if($keyfield){
echo(" ");
}else{
echo(" ");
}
}else{
echo(" ");
}
if($IsNext>0) {
$page_num=$page+1;
if($keyfield){
echo(" ");
}else{
echo(" ");
}
}else{
echo(" ");
}
?>
|