\n"; echo "\n"; // channel要素 echo " \n"; echo " \n"; echo " " ."http://www.digital-dragon.co.jp/test/btn/btn/".$filename."php?btnid=". $filename."\n"; echo " ". mb_convert_encoding( $q1, "UTF-8" )."\n"; echo " ja\n"; echo " baton system v1.0\n"; echo " Copyright (c) 2007 blog-de-baton. All Rights Reserved.\n"; echo " Weblog\n"; echo " http://backend.userland.com/rss\n"; // item要素 $dbdir = '../../../secure/db/'; $dbh = sqlite_open( $dbdir."baton.sqlite", 0660); $sqlstr = "select * from btn order by dt desc limit 10"; $result = sqlite_query($dbh, $sqlstr); // $dt = array(); // $title = array(); // $q1 = array(); // $filename = array(); // while( $rec = sqlite_fetch_array($result, SQLITE_ASSOC) ) { // array_push( $q1, str_replace("\\","", $rec['q1'] )); // array_push( $title,str_replace("\\", "", $rec['title'])); // array_push( $filename,str_replace("\\", "", $rec['filename'])); // array_push( $dt,date( "Y/m/d H:i:s", $rec['dt'] )); // //} while( $rec = sqlite_fetch_array( $result, SQLITE_ASSOC ) ) { // $title = mb_convert_encoding($title ,"UTF-8").; $title = mb_convert_encoding( str_replace("\\", "", $rec['title'])."バトン", "UTF-8"); $link = "http://www.digital-dragon.co.jp/test/btn/btn/".str_replace("\\", "", $rec['filename'])."php?btnid=". str_replace("\\", "", $rec['filename']); $description = mb_convert_encoding("q1 ".str_replace("\\","", $rec['q1'] )."? " ."q2 ".str_replace("\\","", $rec['q2'] )."? ", "UTF-8"); $pubdate = date( "r", $rec['dt'] ); // １つのitem要素を出力する echo " \n"; echo " \n"; echo " ". $link. "\n"; echo " ". $description . "\n"; echo " ". $pubdate."\n"; echo " \n"; } // 終わり echo " \n"; echo "\n"; sqlite_close( $dbh ); ?>