六本木ヒルズ49階(アカデミーヒルズ)を拠点とした、大和賢一郎のフォトブログです。
‘;
echo ‘2012年3月20日に書き始めて、2012年9月10日に終了しました。
‘;
$sql = ”;
$today = date(“Y-m-d”) . ‘ 00:00:00’;
$sql = sprintf(“SELECT * FROM %s WHERE day <= '%s' ORDER BY day DESC", $table_name,$today);
$re = mysql_query($sql); $i=0;
while($arr = mysql_fetch_array($re,MYSQL_ASSOC)){
$arr_day__fromdb[$i] = $arr["day"];
$arr_title__fromdb[$i] = $arr["title"];
$arr_body__fromdb[$i] = $arr["body"];
$timestamp = strtotime($arr_day__fromdb[$i]);
$timestamp_yy = date("y", $timestamp);
$timestamp_yyyy = date("Y", $timestamp);
$timestamp_mm = date("m", $timestamp);
$timestamp_dd = date("d", $timestamp);
$gazou_file_name = $timestamp_yy . $timestamp_mm . $timestamp_dd ;
$blogTitle = stripslashes(urldecode($arr_title__fromdb[$i]));
$blogDay = $timestamp_yyyy . '/' . $timestamp_mm . '/' . $timestamp_dd;
$blogBody = stripslashes(urldecode($arr_body__fromdb[$i]));
echo '‘ .
‘‘ . mb_convert_encoding(urldecode($blogTitle), “UTF-8”, “SJIS”) . ‘‘ . ‘ ’ . $blogDay . ‘
‘ .
mb_convert_encoding(urldecode($blogBody), “UTF-8”, “SJIS”);
echo ‘
‘;
echo ‘
‘;
$i=$i+1;
} mysql_free_result($re); // end of while.
?>