-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupload_result.php
127 lines (122 loc) · 3.73 KB
/
upload_result.php
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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
<?php
session_name("j160219s");
session_start();
?>
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>MatatabiHouse（情報工学実験）</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="css/slide.css">
<script type="text/javascript" src="js/openclose.js"></script>
</head>
<body>
<div id="container">
<header>
<h1 id="logo"><a href="index.php">MatatabiHouse</a></h1>
</header>
<!--小さな端末用（480px以下端末）メニュー-->
<nav id="menubar-s">
<ul>
<li><a href="index.php">Home</a></li>
<li><a href="list.php">Cast</a></li>
<li><a href = "ranking.php">Ranking</a></li>
<li><a href="login.php">Login</a></li>
</ul>
</nav>
<aside id="mainimg">
<img src="images/1.jpg" alt="" id="slide1">
<img src="images/2.jpg" alt="" id="slide2">
<img src="images/3.jpg" alt="" id="slide3">
<img src="images/kazari.png" alt="" id="kazari">
<!--大きな端末用（481px以上端末）メニュー-->
<nav id="menubar">
<ul>
<li><a href="index.php">Home</a></li>
<li><a href="list.php">Cast</a></li>
<li><a href="ranking.php">Ranking</a></li>
<li><a href="login.php">Login</a></li>
</ul>
</nav>
</aside>
<div id="contents">
<div id="main">
<section>
<h2>キャスト採用</h2>
<?php
if(isset($_SESSION['login_name'])){
$conn = pg_connect("host=localhost dbname=j160219s user=j160219s");
$cat_name = $_POST['cat_name'];
$query_test = "select * from cats where name = $1";
$result_test = pg_prepare($conn, "test", $query_test);
$result_test = pg_execute($conn, "test", array($cat_name));
if(pg_num_rows($result_test)==0){
$query = "insert into cats (name, rsvd_cnt, img) values($1, 0, $2)";
$result = pg_prepare($conn, "upload", $query);
$uploaddir = "./cimages/";
$uploadfile = $uploaddir . $_SESSION['id']."_".basename($_FILES['upfile']['name']);
if(is_uploaded_file($_FILES['upfile']['tmp_name'])){
if(move_uploaded_file($_FILES['upfile']['tmp_name'], $uploadfile)){
$result = pg_execute($conn, "upload", array($cat_name, $uploadfile));
print "登録が完了しました<br>";
}
}
else{
$default_pass = './images/default.png';
$result = pg_execute($conn, "upload", array($cat_name, $default_pass));
}
}
else{
print "その名前のキャストがすでに在籍します。名前を変更してください。<br>";
}
}
else{
print "キャストの応募をするには会員登録が必要です。<br>";
}
?>
<img src="images/sample.jpg" width="314" height="60" border="0" />
</section>
</div>
<!--/main-->
<div id="sub">
<nav class="box1">
<h2>MENU</h2>
<ul class="submenu">
<li><a href="list.php">キャスト一覧</a></li>
<li><a href="upload.php">キャスト採用</a></li>
<li><a href="ranking.php">指名ランキング</a></li>
</ul>
<h2>会員システム</h2>
<ul class="submenu2">
<?php
if(!isset($_SESSION['login_name'])){
print<<<EOF
<li><a href="regist.php">新規登録</a></li>
<li><a href="login.php">ログイン</a></li>
EOF;
}else{
print<<<EOF
<li><a href="indivisual.php">予約状況</a></li>
<li><a href="passwd.php">パスワード変更</a><li>
<li><a href="logout.php">ログアウト</a></li>
EOF;
}
?>
</ul>
</nav>
</div>
<!--/sub-->
</div>
<!--/contents-->
<p id="pagetop"><a href="#">↑</a></p>
</div>
<!--/container-->
<footer>
<small>Copyright© <a href="index.html">SAMPLE CLUB</a> All Rights Reserved.</small>
<span class="pr"><a href="http://template-party.com/" target="_blank">《Web Design:Template-Party</a>＆<a href="http://girl-staff.com/">Girl-Staff》</a></span>
</footer>
</body>
</html>