| タイトル | 主催者 | 実施日 | 開始時間 | 中継システム | " + pg_result($rtn, $j, $i)+" | "; } else { echo "" + pg_result($rtn, $j, $i) + " | "; } $i++; } echo ""; $j++; } /* Making Detail */ $query = "select event_name, owner, start_d, end_d, start_t, end_t, stream_name, audio, video, m_list, info, name, mail, phone, cellar, company, address from onm_tbl, stream_tbl, cordinator_tbl where onm_tbl.stream_code = stream_tbl.stream_code and onm_tbl.cordinator_code = cordinator_tbl.cordinator_code"; $rtn = pg_exec($con, $query); if (!$rtn) { echo "テーブル $table の検索に失敗しました。" pg_close($con); exit; } $m = pg_numrows($rtn); $n = pg_numfields($rtn); $item[0] = "イベント名"; $item[1] = "主催者名"; $item[2] = "開始日"; $item[3] = "終了日"; $item[4] = "開始時間"; $item[5] = "終了時間"; $item[6] = "中継システム"; $item[7] = "音声"; $item[8] = "画像"; $item[9] = "連絡用メーリングリスト"; $item[10] = "詳細情報"; $item[11] = "コーディネータ"; $item[12] = "E-Mail"; $item[13] = "Phone"; $item[14] = "携帯電話"; $item[15] = "組織名"; $item[16] = "住所"; $j = 0; while($j < $m) { $file_name = sprintf("detail/%s_%s.html", pg_result($rtn, $j, 2), pg_result($rtn, $j, 4)); if (fileSize($file_name) < 0) { $fp = fopen($file_name, "w"); fputs($fp, "
| "); fputs($fp, $item[$i]); fputs($fp, " | "); if ($i == 9) { fputs($fp, "\x3ca href=\x22mailto:"); fputs($fp, pg_result($rtn, $j, $i)); fputs($fp, "\x22>"); fputs($fp, pg_result($rtn, $j, $i)); fputs($fp, "\x3c/a\x3e"); } elseif ($i == 10) { fputs($fp, "\x3ca href=\x22 "); fputs($fp, pg_result($rtn, $j, $i)); fputs($fp, "\x22>"); fputs($fp, pg_result($rtn, $j, $i)); fputs($fp, "\x3c/a\x3e"); } else { fputs($fp, pg_result($rtn, $j, $i)); } fputs($fp, " |