六本木ブログ

六本木ヒルズ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.

?>