0 order by y_date,y_kubun,yt_kubun"; $result = sqlite_query($sql,$con); $row = sqlite_num_rows($result); $sql = "select distinct y_date from yotei where y_date > 00000000 order by y_date"; $result2 = sqlite_query($sql,$con); $row2 = sqlite_num_rows($result2); ?>
| 予定年月日 | \n"); print("予定内容 | \n"); print("予定区分 | \n"); print("予定完了区分 | \n"); print("チェック | \n"); print("\n"); for($i=0;$i<$row;$i++){ $array = sqlite_fetch_array($result); $year = (int)($array[1] / 10000); $month = ($array[1] / 100) % 100; $day = $array[1] % 100; $week = getWeek($array[1]); $date = $year."/".$month."/".$day."(".$week_s[$week].")"; print("|||||
| $date | \n"); print("$array[2] | \n"); if($array[3] == "L"){ print("講義 | \n"); }else{ if($array[3] == "W"){ print("仕事 | \n"); }else{ if($array[3] == "O"){ print("その他 | \n"); }else{ print("研究 | \n"); } } } if($array[4] == "R"){ print("未完了 | \n"); print("\n"); print("チェック\n"); print(" | \n"); }else{ print("完了 | \n"); print("\n"); print(""); print(" | \n"); } } ?>