質問編集履歴
1
誤字
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -16,7 +16,7 @@
|
|
|
16
16
|
|
|
17
17
|
ではダメなのでしょうか。
|
|
18
18
|
|
|
19
|
-
|
|
19
|
+
始めて日が浅いものでわかりづらいかもしれませんがよろしくお願い致します。
|
|
20
20
|
|
|
21
21
|
|
|
22
22
|
|
|
@@ -40,7 +40,7 @@
|
|
|
40
40
|
|
|
41
41
|
//リクエスト先URL
|
|
42
42
|
|
|
43
|
-
url:'
|
|
43
|
+
url:'php1.php',
|
|
44
44
|
|
|
45
45
|
//受け取るデータ形式
|
|
46
46
|
|
|
@@ -116,7 +116,7 @@
|
|
|
116
116
|
|
|
117
117
|
|
|
118
118
|
|
|
119
|
-
-php-
|
|
119
|
+
-php1-
|
|
120
120
|
|
|
121
121
|
|
|
122
122
|
|
|
@@ -134,7 +134,7 @@
|
|
|
134
134
|
|
|
135
135
|
}
|
|
136
136
|
|
|
137
|
-
$db=mysqli_connect("
|
|
137
|
+
$db=mysqli_connect("","","","")
|
|
138
138
|
|
|
139
139
|
or die(mysqli_connect_error());
|
|
140
140
|
|
|
@@ -144,7 +144,7 @@
|
|
|
144
144
|
|
|
145
145
|
if (isset($_POST["message"])&&$_POST["message"]!==""&&isset($_SESSION["id"])) {
|
|
146
146
|
|
|
147
|
-
$sql1=sprintf('INSERT INTO
|
|
147
|
+
$sql1=sprintf('INSERT INTO postsb SET member_id=%d,
|
|
148
148
|
|
|
149
149
|
message="%s" , created=NOW() ' ,
|
|
150
150
|
|
|
@@ -160,7 +160,7 @@
|
|
|
160
160
|
|
|
161
161
|
|
|
162
162
|
|
|
163
|
-
$sql=sprintf('SELECT m.name , p.* FROM
|
|
163
|
+
$sql=sprintf('SELECT m.name , p.* FROM membersb m , postsb p
|
|
164
164
|
|
|
165
165
|
WHERE m.id=%d ORDER BY p.created DESC ' ,
|
|
166
166
|
|
|
@@ -197,3 +197,133 @@
|
|
|
197
197
|
$res,JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_HEX_AMP
|
|
198
198
|
|
|
199
199
|
);# code..
|
|
200
|
+
|
|
201
|
+
|
|
202
|
+
|
|
203
|
+
-php2-
|
|
204
|
+
|
|
205
|
+
|
|
206
|
+
|
|
207
|
+
<?php
|
|
208
|
+
|
|
209
|
+
session_start();
|
|
210
|
+
|
|
211
|
+
$db=mysqli_connect("","","","")
|
|
212
|
+
|
|
213
|
+
or die(mysqli_connect_error());
|
|
214
|
+
|
|
215
|
+
mysqli_set_charset($db,'utf-8');
|
|
216
|
+
|
|
217
|
+
|
|
218
|
+
|
|
219
|
+
//$_SESSION["id"](user id)がセットされていて最後の行動から1時間以内の場合
|
|
220
|
+
|
|
221
|
+
if(isset($_SESSION["name"])&&$_SESSION["time"]+3600>time()){
|
|
222
|
+
|
|
223
|
+
$_SESSION["time"]=time();
|
|
224
|
+
|
|
225
|
+
$sql=sprintf('SELECT * FROM yuuhichat_membersb WHERE name="%s" ' ,
|
|
226
|
+
|
|
227
|
+
mysqli_real_escape_string($db,$_SESSION["name"])
|
|
228
|
+
|
|
229
|
+
);
|
|
230
|
+
|
|
231
|
+
$record=mysqli_query($db,$sql) or die(mysqli_error($db)
|
|
232
|
+
|
|
233
|
+
);
|
|
234
|
+
|
|
235
|
+
$table=mysqli_fetch_assoc($record);
|
|
236
|
+
|
|
237
|
+
$_SESSION["id"]=$table["id"];
|
|
238
|
+
|
|
239
|
+
}else {
|
|
240
|
+
|
|
241
|
+
header('Location:out.php');# code...
|
|
242
|
+
|
|
243
|
+
}
|
|
244
|
+
|
|
245
|
+
?>
|
|
246
|
+
|
|
247
|
+
|
|
248
|
+
|
|
249
|
+
<!DOCTYPE>
|
|
250
|
+
|
|
251
|
+
<html lang="ja">
|
|
252
|
+
|
|
253
|
+
<head>
|
|
254
|
+
|
|
255
|
+
<meta charset="utf-8">
|
|
256
|
+
|
|
257
|
+
<meta name="viewport" content="width=device-width,initial-scale=1.0">
|
|
258
|
+
|
|
259
|
+
<link rel="stylesheet" href="yuuhichat_aoi.css" type="text/css">
|
|
260
|
+
|
|
261
|
+
<script src="//code.jquery.com/jquery-1.12.0.min.js"></script>
|
|
262
|
+
|
|
263
|
+
<title>チャット</title>
|
|
264
|
+
|
|
265
|
+
</head>
|
|
266
|
+
|
|
267
|
+
<body>
|
|
268
|
+
|
|
269
|
+
<h1>CHAT</h1>
|
|
270
|
+
|
|
271
|
+
<p>
|
|
272
|
+
|
|
273
|
+
<?php
|
|
274
|
+
|
|
275
|
+
echo
|
|
276
|
+
|
|
277
|
+
"<span id='name'>".
|
|
278
|
+
|
|
279
|
+
htmlspecialchars($table["name"],ENT_QUOTES,"utf-8").
|
|
280
|
+
|
|
281
|
+
htmlspecialchars($table["id"],ENT_QUOTES,"utf-8").
|
|
282
|
+
|
|
283
|
+
"</span>".
|
|
284
|
+
|
|
285
|
+
"<span id='welcome'>"." welcome!!!"."</span>";
|
|
286
|
+
|
|
287
|
+
?>
|
|
288
|
+
|
|
289
|
+
</p>
|
|
290
|
+
|
|
291
|
+
<form id="form" action="" method="post">
|
|
292
|
+
|
|
293
|
+
<p>
|
|
294
|
+
|
|
295
|
+
<textarea id="message"name="message" rows="8" cols="40"></textarea>
|
|
296
|
+
|
|
297
|
+
</p>
|
|
298
|
+
|
|
299
|
+
<p>
|
|
300
|
+
|
|
301
|
+
<input id="post" type="submit" name="post" value="POST"/>
|
|
302
|
+
|
|
303
|
+
<p id='ok'></p>
|
|
304
|
+
|
|
305
|
+
|
|
306
|
+
|
|
307
|
+
</p>
|
|
308
|
+
|
|
309
|
+
</form>
|
|
310
|
+
|
|
311
|
+
<p>
|
|
312
|
+
|
|
313
|
+
<a href="out.php">LOG OUT</a>
|
|
314
|
+
|
|
315
|
+
</p>
|
|
316
|
+
|
|
317
|
+
<?php
|
|
318
|
+
|
|
319
|
+
echo '<p id="res">';
|
|
320
|
+
|
|
321
|
+
echo '</p>';# code...
|
|
322
|
+
|
|
323
|
+
?>
|
|
324
|
+
|
|
325
|
+
<script src="js.js"></script>
|
|
326
|
+
|
|
327
|
+
</body>
|
|
328
|
+
|
|
329
|
+
</html>
|