require("inc.php");
session_start();
session_destroy();
//MySQLに接続
if(!$conn = mysql_connect(_DB_SERVER,_DB_UID,_DB_PASS)){
die('MySQL接続失敗');
}
//データベースの選択
if(!$sts = mysql_select_db(_DB_NAME,$conn)){
die('テーブル選択失敗');
}
$num=1;
// $sqllist="";
// $sqllist.="select artnum from album where ex = '1' ";
// $sqllist.="group by artnum order by date desc ";
// $mqlist = mysql_query($sqllist,$conn);
// if($rec = mysql_fetch_array($mqlist)){
// $num++;
// }
?>
mb_language("Ja") ;
mb_internal_encoding("JIS") ;
header('content-type: text/html; charset =' ._CHARSET);
?>
Blog One
//更新履歴の表示処理
$rireki = _rireki();
echo "$rireki";
?>
記事が実際にアップされた日付の新しいものから順番に表示されます。
|
}else{?>
▼ 記事リスト(記事タイトルをクリックすると記事の内容を確認できます。) |
$num=0;
$ii=0;
$pos = 0 + $_GET['pos'];
$maxrow = 30;
$fnum=0;
$sqllist="";
$sqllist.="SELECT `id`,`title`,`artnum`,`date`,`Odate` FROM `album` where ex = 1 ";
if($_SESSION['sqldum1']!=""){
$sqlcom = $_SESSION['sqldum1'];
$sqllist.=" and ( ${sqlcom} ) ";
unset($_SESSION['sqldum1']);
}
$sqllist.="order by `date` desc ";
//echo "$sqllist";
$mqlist = mysql_query($sqllist,$conn);
while($rec = mysql_fetch_array($mqlist)){
$fnum++;
if(($fnum%30)==0){
$num++;
}
}
if($pos > 5){
$ii=$pos-5;
if($pos>=($num-3)){
$ii=$num-9;
}
}
$sqllist .= " limit ".($pos * $maxrow).",$maxrow";
//echo "$sqllist";
$mqlist = mysql_query($sqllist,$conn);
while($rec = mysql_fetch_array($mqlist)){
$id = _hs($rec['id']);
$artnum=_hs($rec['artnum']);
$title=_hs($rec['title']);
$date=_hs($rec['date']);
$Odate = _hs($rec['Odate']);
$ex = _hs($rec['ex']);
$name="";
$sqll="";
$sqll.="select name from profile where id = '$id'";
$mqli = mysql_query($sqll,$conn);
if($rec2 = mysql_fetch_array($mqli)){
$name = $rec2['name'];
}
?>
年月日
記事の日付:}?> |
/" target=_blank>さん |
/?num=" target=_blank> |
}
if($fnum > 0){
if($sqlcom!=""){
$getcom="sqlcom=${sqlcom}\&";
}
if($fnum > ($pos * $maxrow) and (($pos + 1) * $maxrow) < $fnum){
$next = "".">>"."";
}else{
$next = ">>";
}
if($pos > 0 ){
$before = ""."<<"."";
}else{
$before = "<<";
}
}
?>
FirstPage
=$i;$i++){?>
>
}else{
echo "";
echo $i+1;
echo "";
echo " ";
}
}
}?>
>LastPage
}?>
|