Sing/addListResult.php at master · enpitut2019/Sing · 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
<!DOCTYPE html>
<html lang="en">

<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title>ぬるトーク</title>
  <link rel="stylesheet" type="text/css" href="main.css">
  <style type='text/css'>
  </style>
</head>

<?php
  $url = parse_url(getenv("DATABASE_URL"));
  $con = pg_connect("host=" . $url['host'] . " port="
  . $url['port'] . " dbname=" . substr($url['path'], 1)
  . " user=" . $url['user'] . " password=" . $url['pass']);
?>


<body>
  <div id="header">
    <a id="title" href="index.php">ぬるトーク</a>
    <ul id="menu">
      <li><a href="index.php">ホーム</a></li>
      <li><a href="myList.php">趣味の閲覧</a></li>
      <li><a href="addList.php">趣味の追加</a></li>
      <li><a href="matching.php">マッチング</a></li>
    </ul>
  </div>
  <div id="main">
  <h1 style="font-size: 80px ">趣味を追加しました</h1>

  <a href="myList.php">確認</a><br />
  <a href="index.php">戻る</a><br />
  <?php
    $check = session_start();
    if(!isset($check)){
      print("セッションの確立に失敗しました");
    }
    $session_id = session_id();
    foreach($_POST["hobbyAdd"] as $hobby_name){
      if (isset($hobby_name)) {
        $res_uid = pg_query($con, "SELECT uid FROM users WHERE session_id = '".$session_id."'"); #or die("クエリ実行エラーです" . pg_last_error());
        $uid = pg_fetch_row($res_uid)[0];

        $res_hid = pg_query($con, "SELECT hid FROM hobbies WHERE hobby_name = '".$hobby_name."'"); # or die("クエリ実行エラーです" . pg_last_error());
        $hid = pg_fetch_row($res_hid)[0];

        $res_ins = pg_query($con, "INSERT INTO user_hobbies VALUES(".$uid.", ".$hid.")"); # or die("クエリ実行エラーです" . pg_last_error());
      }
    }
  ?>
  </div>
  <div id="footer">
    <span id="footer_text">Copyright&copy; 2019 ぬるんちゅ All Rights Reserved.</span>
  </div>
</body>

</html>