0) { $page_data++; unset($listNo); } } else { if($row_end <= $row) { $lastFlg = FALSE; break; } else if($row_start <= $row) { $listNo[] = $arr["NO"]; } } $row++; } if($page == -1) { $page = $page_data; } $message_data = ""; if(0 < count($listNo)) { $sql = sprintf("select * from %s where NO in(", $tableNames[$func_no]); for( $i = 0; $i < count($listNo); $i++ ) { if($i > 0) { $sql = $sql.","; } $sql = $sql.$listNo[$i]; } $sql = $sql.") and VALID_STATUS = 1 order by NO DESC"; $con = mysql_logon(); $rtn = mysql_query($sql, $con); mysql_close($con); $row = 0; while($arr = mysql_fetch_array($rtn)) { $name = htmlspecialchars($arr["NAME"], ENT_QUOTES); $title = htmlspecialchars($arr["TITLE"], ENT_QUOTES); $comment = htmlspecialchars($arr["COMMENT"], ENT_QUOTES); $message_data = $message_data."
"; if(0 < strlen($arr["PHOTO_FILE_NAME1"])) { $message_data = $message_data.sprintf("
", $urlPaths[$func_no].$arr["NO"]."/".$arr["PHOTO_FILE_NAME1"], nl2br($comment), makePhotoFileURL($arr["NO"], $arr["PHOTO_FILE_NAME1"])); } else { $message_data = $message_data."
 
\r\n"; } if(0 < strlen($arr["TITLE"])) { $message_data = $message_data.sprintf("
%s
", nl2br($title)); } $message_data = $message_data.sprintf("
%s
", nl2br($comment)); $message_data = $message_data."
"; $message_data = $message_data.sprintf("
%s
", $name); $message_data = $message_data."
"; $row++; } } $btn_data = ""; if($lastFlg && $page == 0) { $btn_data = ""; } else if($lastFlg ) { $btn_data = $btn_data.""; $btn_data = $btn_data.""; } else if($page == 0) { $btn_data = $btn_data.""; $btn_data = $btn_data.""; } else { $btn_data = $btn_data.""; $btn_data = $btn_data.""; $btn_data = $btn_data.""; $btn_data = $btn_data.""; } $contents = str_replace("", $titleNames[$func_no], $contents); $contents = str_replace("", $oomidashiNames[$func_no], $contents); $contents = str_replace("", $func_no, $contents); $contents = str_replace("", $message_data, $contents); $contents = str_replace("", $btn_data, $contents); $contents = str_replace("", $page, $contents); $contents = str_replace("", sprintf("- %d頁 -", $page + 1), $contents); print $contents; //-------------------------------------------------------------------- //更新日付文字列の作成 //-------------------------------------------------------------------- function makeUpdateDateString($update_date) { return sprintf("更新日付:%s", $update_date); } //-------------------------------------------------------------------- //写真ファイルのサムネイルURLを作成する処理 //-------------------------------------------------------------------- function makePhotoFileURL($no, $photo) { global $func_no; global $urlPaths; $makeURL = $urlPaths[$func_no].$no."/".$photo; $parts = pathinfo($makeURL); $makeURL = $parts['dirname']."/".$parts['filename']."_s.".$parts['extension']; return $makeURL; } ?>