update.php from nacl30d/akio

update.php
Summary

Maintainability

0 mins
Test Coverage

Issues
<?php
    require_once('./conf/functions.php');
    session_start();

    //URLに含まれている記事のIDを取得
    $n = $_GET['n'];
    $redirect = "./result.php?n=" . $n; //フォームページはidごとに動的なURLを発行

    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        #動作確認テスト用
        // $_SESSION['ans'] = $_POST['ans'];
        $ans = $_POST['ans'];
        if (!$_POST['name']) {
            $_POST['name'] = "名無し";
        }

        #DB接続
        $pdo = connectDB();
        #データ更新
        $sql = "INSERT INTO answers (n, name, mon1, mon2, mon3, mon4, mon5, tue1, tue2, tue3, tue4, tue5, wed1, wed2, wed3, wed4, wed5, thu1, thu2, thu3, thu4, thu5, fri1, fri2, fri3, fri4, fri5) VALUES (:n, :name, :mon1, :mon2, :mon3, :mon4, :mon5, :tue1, :tue2, :tue3, :tue4, :tue5, :wed1, :wed2, :wed3, :wed4, :wed5, :thu1, :thu2, :thu3, :thu4, :thu5, :fri1, :fri2, :fri3, :fri4, :fri5);";
        //データベース関連の処理
        $statement = $pdo -> prepare($sql);
        $result = $statement->execute([
        ':n' => $n, ':name' => h($_POST['name']),
        ':mon1' => $ans['0'],':tue1' => $ans['1'], ':wed1' => $ans['2'], ':thu1' => $ans['3'], ':fri1' => $ans['4'],
        ':mon2' => $ans['5'], ':tue2' => $ans['6'], ':wed2' => $ans['7'], ':thu2' => $ans['8'], ':fri2' => $ans['9'],
        ':mon3' => $ans['10'], ':tue3' => $ans['11'], ':wed3' => $ans['12'], ':thu3' => $ans['13'], ':fri3' => $ans['14'],
          ':mon4' => $ans['15'], ':tue4' => $ans['16'], ':wed4' => $ans['17'], ':thu4' => $ans['18'], ':fri4' => $ans['19'],
        ':mon5' => $ans['20'], ':tue5' => $ans['21'], ':wed5' => $ans['22'], ':thu5' => $ans['23'], ':fri5' => $ans['24']
        ]);
        if(!$result){
            var_dump($statement->errorinfo());
            exit('DB Error (failed to add record)'); //入に失敗したエラーメッセージ
        }

        #次のページにリダイレクト
        header("Location: $redirect");
        exit();
    }

?>

<!DOCTYPE html>
<?php include('meta.php') ?>
    <title>予定を入力｜AKIO</title>
 </head>
<body>
<?php include('header.html'); ?>

<div class="row">
            

<div class="row center">
    <div class="col l6 offset-l3 s12 ">
        <form action="" method="POST" id="insertForm">

        <!-- <p>Name:</p><input type="text" name="name" value="名無し" /> -->
        <div class="row">
            <div class="col l6 offset-l3 s12 ">

                <br />
                <h5 class="green-text">タップして空きコマ情報を入力！</h5>
                <table class="update">
                    <tr><th></th><th>Mon.</th><th>Tue.</th><th>Wed.</th><th>Thu.</th><th>Fri.</th></tr>
                    <?php
                        //テーブル生成（各tdにidを割り振る）
                        $num = 0;
                        for ($i = 1; $i < 6 ; $i++) { 
                            echo '<tr>','<th>', $i ,'</th>';
                            for ($j = 1; $j < 6 ; $j++) { 
                                 echo '<td ' , 'id="'.$num.'" ' , 'class="ng"' , ' onClick="judge('.$num.')"' , '>' , '<input type="hidden" name="ans[]"'.' id="a'.$num.'"'.' value="0">' , '</td>';//各tdにidを発行（クリックイベント用）、onClickで各idを渡す。
                                 $num++;
                            }
                            echo '</tr>' , PHP_EOL;
                        }
                    ?>
                </table>

                <br />
                <h5 class="green-text">名前を入力！</h5>
                <div class="input-field">
                       <i class="material-icons prefix">account_circle</i>
                       <input id="icon_prefix" type="text" class="validate" name="name">
                       <label for="icon_prefix">Name</label>
                   </div>
                   <input class="btn" type="submit" value="登録" name="insert" >
            </div>
        </div>
    </form>
    </div>
</div>

<?php include('footer.php'); ?>

</body>
</html>