forked from F4irytale/weathering-with-you
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.php
146 lines (142 loc) · 3.75 KB
/
index.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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>把晴天带给你
</title>
<link rel="icon" href="images/favicon.ico">
<style type="text/css">
.images{
margin-left: 50px;
position:absolute;
z-index: -1;
}
.form{
position:absolute;
width: 400px;
height: 350px;
background-color: #FFDD99;
margin-left: 510px;
margin-top: 300px;
border-radius: 30px;
box-shadow: #ccc 0px 0px 5px;
}
.top_font{
margin-top: 2.5%;
margin-left: 5%;
margin-right: 5%;
}
.button{
background-color: #f44336;
border: none;
color: white;
padding: 8px 12px;
text-align: center;
font-size: 15px;
border-radius: 8px;
display:block;
margin:0 auto;
margin-top: 2.5%;
}
.form_main{
margin-left: 5%;
margin-right: 5%;
}
textarea{
resize: none;
width: 353px;
height: 45px;
}
.comment{
position: absolute;
margin-top: 680px;
width: 845px;
margin-left: 50px;
border-radius: 15px;
background-color: #FFDD99;
margin-bottom: 20px;
padding: 10px;
</style>
</head>
<body>
<div style="width: 100px;">
<div class="images">
<img src="images/main.jpg" width="900px" height="650px;">
</div>
<div class="form">
<div class="top_font">
<span style="font-size:25px; color: red;">￥3,400</span>
<span style="font-size:15px; color: red;">(含税)</span><br>
<span style="font-size: 15px;">由于下雨而困扰的你，无论在什么地方，100%的晴天女孩会为你带来阳光
</span>
</div>
<div class="form_main">
<form action="php/insert.php" method="post" id="main_form">
<input type="submit" name="" value="许愿放晴吧" class="button"><br>
<table>
<tr>
<td width="200px;"><span style="font-weight: 900px; font-size: 15px;">您希望的日期</span></td>
<td><span style="font-weight: 900px; font-size: 15px;">希望放晴的地方</span></td>
</tr>
<tr>
<td>
<input type="text" name="date" style="width: 150px; height: 20px;">
</td>
<td>
<input type="text" name="address" style="width: 150px; height: 20px;">
</td>
</tr>
<tr>
<td colspan="2">昵称<span style="font-size:12px; color: red;">*必填</span></td>
</tr>
<tr>
<td colspan="2"><input type="text" name="username" style="width: 353px; height: 20px;"></td>
</tr>
<tr>
<td colspan="2">希望放晴的理由<span style="font-size:12px; color: red;">*必填</span></td>
</tr>
<tr>
<td colspan="2">
<textarea name="comment" form="main_form" placeholder="请在此处输入文本..."></textarea>
</td>
</tr>
</table>
</form>
</div>
</div>
</div>
<div class="comment">
<div style="margin: 10px;">
<h1>大家的委托：</h1>
</div>
<?php
include"php/config.php";
$sql="select * from comment order by id desc limit 15";
$res=$mySQL->query($sql);
while($row=$res->fetch_array())
{
?>
<table style="margin: 15px;">
<tr>
<td colspan="2" style="font-size: 18px;"><?php echo $row['username']?>的委托:</td>
</tr>
<tr>
<td style="font-size: 15px;" colspan="2"><?php echo $row['why']?></td>
</tr>
<tr>
<td style="color: #424242; font-size: 13px;">希望在<?php echo $row['time']?></td>
<td colspan="" style="color: #424242; font-size: 13px;"><?php echo $row['address']?>天晴</td>
<hr style="color: #e1f5fe">
</tr>
</table>
<?php
}
$sql2="select count(*) from comment";
$res2=$mySQL->query($sql2);
$row2=$res2->fetch_array()
?>
<span style="margin: 15px; color: #f50057">已有<?php echo $row2['count(*)']?>人提交晴天委托</span>
<span style="margin: 15px; color: #f50057"><a href="php/find.php" style="text-decoration: none;">查看所有人的晴天委托</a></span>
</div>
</body>
</html>