fork(1) download
copy 
  1. <?php
  2.  
  3. try {
  4.  
  5.     /*
  6.     switch (true) {
  7.         case !isset($_REQUEST['date']):
  8.         case !is_string($date = $_REQUEST['date']):
  9.             throw new Exception('日付を指定してください');
  10.     }
  11.     
  12.     $dbname = '';
  13.     $dbuser = '';
  14.     $dbpass = '';
  15.     
  16.     $pdo = new PDO("mysql:dbname={$dbname};host=localhost;charset=utf8", $dbuser, $dbpass);
  17.     $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  18.     
  19.     $sql = 'SELECT * FROM tableA JOIN tableB ON tableA.staff_id = tableB.staff_num WHERE s_date = ?';
  20.     $stmt = $pdo->prepare($sql);
  21.     $stmt->execute(array($date));
  22.     $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
  23.     */
  24.  
  25.     $rows = array(
  26.         array(
  27.             's_date' => '08-04',
  28.             'staff_id' => '002',
  29.             'cell01' => '10:35,会議室,1',
  30.             'cell02' => '-',
  31.             'cell03' => '-',
  32.             'cell200' => '19:40,フロアB,3',
  33.             'staff_num' => '002',
  34.             'staff_name' => 'A山A男',
  35.             'belong' => 'A支店',
  36.         ),
  37.     );
  38.  
  39.     array_walk_recursive($rows, function (&$v, $k) {
  40.         if (strpos($k, 'cell') !== 0) {
  41.             return;
  42.         }
  43.         $values = explode(',', $v, 3);
  44.         if (!isset($values[2])) {
  45.             $values = array_fill(0, 3, '-');
  46.         }
  47.         $keys = array('time', 'place', 'flag');
  48.         $v = array_combine($keys, $values);
  49.     });
  50.  
  51. } catch (Exception $e) {
  52.  
  53.     $error = htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8');
  54.  
  55. }
  56.  
  57. ?>
  58. <!DOCTYPE html>
  59. <html>
  60. <head>
  61. <meta charset="UTF-8">
  62. <title>Test</title>
  63. </head>
  64. <body>
  65. <?php if (isset($error)): ?>
  66. <p><?=$error?></p>
  67. <?php elseif (!$rows): ?>
  68. <p>データが見つかりませんでした</p>
  69. <?php else: ?>
  70. <?php foreach ($rows as $row): ?>
  71. <table border>
  72. <caption><?=$row['staff_name']?>(<?=$row['s_date']?>)</caption>
  73. <tr>
  74. <th>場所</th>
  75. <th>開始時間</th>
  76. </tr>
  77. <?php foreach (array_slice($row, 2, -3) as $r): ?>
  78. <?php if ($r['time'] === '-') { continue; }?>
  79. <tr class="style<?=$r['flag']?>">
  80. <td><?=$r['place']?></td>
  81. <td><?=$r['time']?></td>
  82. </tr>
  83. <?php endforeach; ?>
  84. </table>
  85. <?php endforeach; ?>
  86. <?php endif; ?>
  87. </body>
  88. </html>
Success #stdin #stdout 0.01s 20568KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Test</title>
</head>
<body>
<table border>
<caption>A山A男(08-04)</caption>
<tr>
<th>場所</th>
<th>開始時間</th>
</tr>
<tr class="style1">
<td>会議室</td>
<td>10:35</td>
</tr>
<tr class="style3">
<td>フロアB</td>
<td>19:40</td>
</tr>
</table>
</body>
</html>
https://ideone.com/CCdqen
language:
PHP (php 7.3.5)
created:
10 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!