質問編集履歴
1
誤字
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -7,7 +7,7 @@
|
|
|
7
7
|
console.log(data.name);
|
|
8
8
|
|
|
9
9
|
ではダメなのでしょうか。
|
|
10
|
-
|
|
10
|
+
始めて日が浅いものでわかりづらいかもしれませんがよろしくお願い致します。
|
|
11
11
|
|
|
12
12
|
|
|
13
13
|
|
|
@@ -19,7 +19,7 @@
|
|
|
19
19
|
$.ajax({
|
|
20
20
|
type:'POST',
|
|
21
21
|
//リクエスト先URL
|
|
22
|
-
url:'
|
|
22
|
+
url:'php1.php',
|
|
23
23
|
//受け取るデータ形式
|
|
24
24
|
datatype:'json',
|
|
25
25
|
//渡すデータ
|
|
@@ -57,7 +57,7 @@
|
|
|
57
57
|
|
|
58
58
|
|
|
59
59
|
|
|
60
|
-
-
|
|
60
|
+
-php1-
|
|
61
61
|
|
|
62
62
|
<?php
|
|
63
63
|
session_start();
|
|
@@ -66,12 +66,12 @@
|
|
|
66
66
|
$_SERVER['HTTP_X_REQUESTED_WITH']!=='XMLHttpRequest') {
|
|
67
67
|
die('error');# code...
|
|
68
68
|
}
|
|
69
|
-
$db=mysqli_connect("
|
|
69
|
+
$db=mysqli_connect("","","","")
|
|
70
70
|
or die(mysqli_connect_error());
|
|
71
71
|
mysqli_set_charset($db,'utf-8');
|
|
72
72
|
|
|
73
73
|
if (isset($_POST["message"])&&$_POST["message"]!==""&&isset($_SESSION["id"])) {
|
|
74
|
-
$sql1=sprintf('INSERT INTO
|
|
74
|
+
$sql1=sprintf('INSERT INTO postsb SET member_id=%d,
|
|
75
75
|
message="%s" , created=NOW() ' ,
|
|
76
76
|
mysqli_real_escape_string($db,$_SESSION["id"]),
|
|
77
77
|
mysqli_real_escape_string($db,$_POST["message"])
|
|
@@ -79,7 +79,7 @@
|
|
|
79
79
|
mysqli_query($db,$sql1) or die(mysqli_error($db));
|
|
80
80
|
}
|
|
81
81
|
|
|
82
|
-
$sql=sprintf('SELECT m.name , p.* FROM
|
|
82
|
+
$sql=sprintf('SELECT m.name , p.* FROM membersb m , postsb p
|
|
83
83
|
WHERE m.id=%d ORDER BY p.created DESC ' ,
|
|
84
84
|
mysqli_real_escape_string($db,$_SESSION["id"])
|
|
85
85
|
);
|
|
@@ -97,4 +97,69 @@
|
|
|
97
97
|
|
|
98
98
|
echo json_encode(
|
|
99
99
|
$res,JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_HEX_AMP
|
|
100
|
-
);# code..
|
|
100
|
+
);# code..
|
|
101
|
+
|
|
102
|
+
-php2-
|
|
103
|
+
|
|
104
|
+
<?php
|
|
105
|
+
session_start();
|
|
106
|
+
$db=mysqli_connect("","","","")
|
|
107
|
+
or die(mysqli_connect_error());
|
|
108
|
+
mysqli_set_charset($db,'utf-8');
|
|
109
|
+
|
|
110
|
+
//$_SESSION["id"](user id)がセットされていて最後の行動から1時間以内の場合
|
|
111
|
+
if(isset($_SESSION["name"])&&$_SESSION["time"]+3600>time()){
|
|
112
|
+
$_SESSION["time"]=time();
|
|
113
|
+
$sql=sprintf('SELECT * FROM yuuhichat_membersb WHERE name="%s" ' ,
|
|
114
|
+
mysqli_real_escape_string($db,$_SESSION["name"])
|
|
115
|
+
);
|
|
116
|
+
$record=mysqli_query($db,$sql) or die(mysqli_error($db)
|
|
117
|
+
);
|
|
118
|
+
$table=mysqli_fetch_assoc($record);
|
|
119
|
+
$_SESSION["id"]=$table["id"];
|
|
120
|
+
}else {
|
|
121
|
+
header('Location:out.php');# code...
|
|
122
|
+
}
|
|
123
|
+
?>
|
|
124
|
+
|
|
125
|
+
<!DOCTYPE>
|
|
126
|
+
<html lang="ja">
|
|
127
|
+
<head>
|
|
128
|
+
<meta charset="utf-8">
|
|
129
|
+
<meta name="viewport" content="width=device-width,initial-scale=1.0">
|
|
130
|
+
<link rel="stylesheet" href="yuuhichat_aoi.css" type="text/css">
|
|
131
|
+
<script src="//code.jquery.com/jquery-1.12.0.min.js"></script>
|
|
132
|
+
<title>チャット</title>
|
|
133
|
+
</head>
|
|
134
|
+
<body>
|
|
135
|
+
<h1>CHAT</h1>
|
|
136
|
+
<p>
|
|
137
|
+
<?php
|
|
138
|
+
echo
|
|
139
|
+
"<span id='name'>".
|
|
140
|
+
htmlspecialchars($table["name"],ENT_QUOTES,"utf-8").
|
|
141
|
+
htmlspecialchars($table["id"],ENT_QUOTES,"utf-8").
|
|
142
|
+
"</span>".
|
|
143
|
+
"<span id='welcome'>"." welcome!!!"."</span>";
|
|
144
|
+
?>
|
|
145
|
+
</p>
|
|
146
|
+
<form id="form" action="" method="post">
|
|
147
|
+
<p>
|
|
148
|
+
<textarea id="message"name="message" rows="8" cols="40"></textarea>
|
|
149
|
+
</p>
|
|
150
|
+
<p>
|
|
151
|
+
<input id="post" type="submit" name="post" value="POST"/>
|
|
152
|
+
<p id='ok'></p>
|
|
153
|
+
|
|
154
|
+
</p>
|
|
155
|
+
</form>
|
|
156
|
+
<p>
|
|
157
|
+
<a href="out.php">LOG OUT</a>
|
|
158
|
+
</p>
|
|
159
|
+
<?php
|
|
160
|
+
echo '<p id="res">';
|
|
161
|
+
echo '</p>';# code...
|
|
162
|
+
?>
|
|
163
|
+
<script src="js.js"></script>
|
|
164
|
+
</body>
|
|
165
|
+
</html>
|