Gs_php_final/home.php at master · kichis/Gs_php_final · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
<?php
session_start();
include("funcs.php");

// dbへ接続
$pdo = db_conn();
// 語り情報取得（新しい順に表示）
$sql = "SELECT stories.id AS id, stories.title AS title, users.user_name AS user, stories.date AS date, stories.content AS content, stories.horror AS horror FROM stories INNER JOIN users ON stories.user = users.user_id WHERE status = 1 ORDER BY id DESC;";
$stmt = $pdo->prepare($sql);
$status = $stmt->execute();

//語りデータ取り出し
$view="";
if($status==false) {
    sql_error();
}else{

}

?>

<!DOCTYPE html>
<html lang="ja">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="css/style.css">
    <!-- base font -->
    <link href="https://fonts.googleapis.com/css2?family=Noto+Serif+JP:wght@500&display=swap" rel="stylesheet">
    <!-- specific font -->
    <link href="https://fonts.googleapis.com/css2?family=Noto+Serif+JP:wght@700&display=swap" rel="stylesheet">
    <!-- CSS only -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
    <title>あなたと百物語</title>


</head>
<body class="body">
    <?php
    if($_SESSION["user_status"]==1){
        include("menu_user.php");
    }else if($_SESSION["user_status"]==2){
        include("menu_admin.php");
    }else if($_SESSION["user_status"]==3){
        include("menu_ban.php");
    }else{   //session: 0/なし
        include("menu_visit.php");
    }
    ?>

    <div id="mainImage">
        <div id="inst">
            <h5>《百物語（ひゃくものがたり）》</h5>
            <p>夜、数人が集まって順番に怪談を語り合う遊び。<br>
            ろうそくを100本立てておいて、1話終わるごとに1本ずつ消していき、<br>
            100番目が終わって真っ暗になったとき、化け物が現れるとされる。</p>
        </div>
    </div>

    <form method="post" action="test.php">
<button onclick="location.href='./ayakas.php'" value="1" name="hoge"></button>
</form>

    <div id="storyArea">
        <div class="under"></div>
        <div class="over">
        <?php
        while( $r = $stmt->fetch(PDO::FETCH_ASSOC)){
        ?>
            <p style="float:left; margin-bottom:5px"><b>題：<a href="story.php?id=<?=$r["id"]?>"><?=$r["title"]?></a></b></p>
            <p>&#160;&#160;&#160;(<?=$r["date"]?>)&#160;&#160;&#160;<i class="fas fa-ghost"></i>&#160;<?=$r["horror"];?></p>
            <p style="margin-bottom:30px">語り手：<?=$r["user"]?></p>
        <?php
        }
        ?>
        </div>
    </div>

<!-- copyright -->
    <?php include("copyright.php"); ?>

<!-- JS, Popper.js, and jQuery -->
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
</body>
</html>