mysql:8852

もりきゅうです。

<konet218@xxxxxxxxxx> wrote:
> と、申されましても何とも・・・(汗)
^^;
PHPの勉強がてら作ってみました。
* php-4.3.4-Win32.zip

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html lang="ja">
<head>
<title>t1</title>
<link rel=stylesheet type="text/css" href="pi.css">
<meta http-equiv="Content-Type" content="text/html; charset=shift_jis">
</head>

<body>

<?php
$db = mysql_connect("localhost","user","password"); // 変更してください
mysql_select_db("test"); // 変更してください
$res = mysql_query("select
    date_format(mail_datetime,'%Y-%m-%d') as mail_date,
    hour(mail_datetime) as mail_hour,
    count(*)
  from master_tb, mail_tb
  where master_group_id = 1
    and mail_to_master_id = master_id
  group by mail_date, mail_hour;");
while ($row = mysql_fetch_row($res)) {
  list($date, $hour, $count) = $row;
  $count_tb[$date][$hour] = $count;
//  echo join("\t", $row), "\n";
}
mysql_close($db);
?>

<table>
<tr>
<th>日付 / 時刻</th>
<?php
for ($hour = 0; $hour < 24; $hour++) {
  print "<th>$hour</th>\n";
}
?>
</tr>
<?php
$time = time();
$firstday_time = mktime(0,0,0,
  date("m",$time),1,date("Y",$time));
$time = $firstday_time;
while (1) {
  $date = date("Y-m-d",$time);
?>
<tr>
<td><?php print $date ?></td>
<?php
for ($hour = 0; $hour < 24; $hour++) {
  $count = $count_tb[$date][$hour];
  print "<td>$count</td>\n";
}
?>
</tr>
<?php
  $tomorrow_time = mktime(0,0,0,
    date("m",$time),date("d",$time)+1,date("Y",$time));
  if (date("m",$tomorrow_time) != date("m",$time))
    break;
  $time = $tomorrow_time;
}
?>
</table>

</body>
</html>

----
YOSHIDA Kazuhiro  moriq@xxxxxxxxxx  http://www.moriq.com/