質問編集履歴
3
実際に使っているコードに変更
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -34,7 +34,7 @@
|
|
|
34
34
|
|
|
35
35
|
|
|
36
36
|
|
|
37
|
-
$query = "INSERT INTO table(ymd,category,category_id,t" .$h . $i . ") VALUES('" .$y.$m.$d . "','booked','" . $staff_id . "','" . $client_id . "') ON DUPLICATE KEY UPDATE t" . $h.$i . "=" .$client_id;
|
|
37
|
+
$query_register_timetable = "INSERT INTO salt26_timetable(ymd,category,category_id,t" .$h . $i . ") VALUES('" .$y.$m.$d . "','booked','" . $staff_id . "','" . $client_id . "') ON DUPLICATE KEY UPDATE t" . $h.$i . "=" .$client_id;
|
|
38
38
|
|
|
39
39
|
```
|
|
40
40
|
|
|
@@ -50,7 +50,7 @@
|
|
|
50
50
|
|
|
51
51
|
```PHP
|
|
52
52
|
|
|
53
|
-
INSERT INTO table(ymd,category,category_id,t1300) VALUES('20180731','booked','40','
|
|
53
|
+
INSERT INTO salt26_timetable(ymd,category,category_id,t1300) VALUES('20180731','booked','40','0') ON DUPLICATE KEY UPDATE t1300=0
|
|
54
54
|
|
|
55
55
|
```
|
|
56
56
|
|
2
情報不足を補填
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -7,6 +7,32 @@
|
|
|
7
7
|
|
|
8
8
|
|
|
9
9
|
```PHP
|
|
10
|
+
|
|
11
|
+
$staff_id = $_POST['staff_id'];
|
|
12
|
+
|
|
13
|
+
$menu_id = $_POST['menu_id'];
|
|
14
|
+
|
|
15
|
+
$y = $_POST['y'];
|
|
16
|
+
|
|
17
|
+
$m = $_POST['m'];
|
|
18
|
+
|
|
19
|
+
$d = $_POST['d'];
|
|
20
|
+
|
|
21
|
+
$h = $_POST['h'];
|
|
22
|
+
|
|
23
|
+
$i = $_POST['i'];
|
|
24
|
+
|
|
25
|
+
|
|
26
|
+
|
|
27
|
+
|
|
28
|
+
|
|
29
|
+
$client_id = $mysqli->insert_id;
|
|
30
|
+
|
|
31
|
+
// ↑ 別のSQL処理をし、idを取得しています。
|
|
32
|
+
|
|
33
|
+
// idの取得は問題なくできております。
|
|
34
|
+
|
|
35
|
+
|
|
10
36
|
|
|
11
37
|
$query = "INSERT INTO table(ymd,category,category_id,t" .$h . $i . ") VALUES('" .$y.$m.$d . "','booked','" . $staff_id . "','" . $client_id . "') ON DUPLICATE KEY UPDATE t" . $h.$i . "=" .$client_id;
|
|
12
38
|
|
1
誤字を修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -8,7 +8,7 @@
|
|
|
8
8
|
|
|
9
9
|
```PHP
|
|
10
10
|
|
|
11
|
-
$query = "INSERT INTO
|
|
11
|
+
$query = "INSERT INTO table(ymd,category,category_id,t" .$h . $i . ") VALUES('" .$y.$m.$d . "','booked','" . $staff_id . "','" . $client_id . "') ON DUPLICATE KEY UPDATE t" . $h.$i . "=" .$client_id;
|
|
12
12
|
|
|
13
13
|
```
|
|
14
14
|
|