teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問複数の日付をDBにUPDATEする場合、レコードの値をそれぞれ別の値に置き換える処理について

編集履歴

質問編集履歴

1

修正

2016/07/08 04:45

投稿

leoairen
leoairen

スコア122

test CHANGED
File without changes
test CHANGED
@@ -102,9 +102,9 @@
102
102
 
103
103
  foreach( $holiday_array as $key => $value ) {
104
104
 
105
- $sql = "update calendartbl set is_deleted = '%%n%%', modify_datetime = now() where holiday = '%%n%%'";
105
+ $sql = "update calendartbl set is_deleted = '%%n%%' where holiday = '%%n%%'";
106
-
106
+
107
- $ret2 = f_db_update($sql, $tobe, $value);
107
+ $ret2 = f_db_update($sql, $tobe, $value);
108
108
 
109
109
  print("aaa1");
110
110
 
@@ -116,9 +116,9 @@
116
116
 
117
117
  foreach( $holiday_array as $key => $value ) {
118
118
 
119
- $sql = "update calendartbl set is_deleted = '%%n%%', modify_datetime = now() where holiday = '%%n%%'";
119
+ $sql = "update calendartbl set is_deleted = '%%n%%' where holiday = '%%n%%'";
120
-
120
+
121
- $ret2 = f_db_update($sql, $tobe, $value);
121
+ $ret2 = f_db_update($sql, $tobe, $value);
122
122
 
123
123
  print("aaa2");
124
124
 
@@ -132,7 +132,7 @@
132
132
 
133
133
  foreach( $holiday_array as $key => $value ) {
134
134
 
135
- $sql = "update calendartbl set is_deleted = '%%n%%', modify_datetime = now() where holiday = '%%n%%'";
135
+ $sql = "update calendartbl set is_deleted = '%%n%%' where holiday = '%%n%%'";
136
136
 
137
137
  $ret2 = f_db_update($sql, $tobe, $value);
138
138
 
@@ -146,7 +146,7 @@
146
146
 
147
147
  foreach( $holiday_array as $key => $value ) {
148
148
 
149
- $sql = "update calendartbl set is_deleted = '%%n%%', modify_datetime = now() where holiday = '%%n%%'";
149
+ $sql = "update calendartbl set is_deleted = '%%n%%' where holiday = '%%n%%'";
150
150
 
151
151
  $ret2 = f_db_update($sql, $tobe, $value);
152
152
 
@@ -160,9 +160,9 @@
160
160
 
161
161
  foreach( $holiday_array as $key2 => $value2 ) {
162
162
 
163
- $sql = "insert IGNORE into calendartbl (holiday, create_staff_id, modify_staff_id, create_datetime, modify_datetime, is_deleted) values ('%%n%%', '%%n%%', '%%n%%', now(), now(), '%%n%%')";
163
+ $sql = "insert IGNORE into calendartbl (holiday, is_deleted) values ('%%n%%', '%%n%%')";
164
-
164
+
165
- $ret = f_db_update($sql, $value2, $staff['staff_id'], $staff['staff_id'], $tobe2);
165
+ $ret = f_db_update($sql, $value2, $tobe2);
166
166
 
167
167
  print("ddd");
168
168
 
@@ -174,9 +174,9 @@
174
174
 
175
175
  foreach( $holiday_array as $key2 => $value2 ) {
176
176
 
177
- $sql = "insert IGNORE into calendartbl (holiday, create_staff_id, modify_staff_id, create_datetime, modify_datetime, is_deleted) values ('%%n%%', '%%n%%', '%%n%%', now(), now(), '%%n%%')";
177
+ $sql = "insert IGNORE into calendartbl (holiday, is_deleted) values ('%%n%%', '%%n%%')";
178
-
178
+
179
- $ret = f_db_update($sql, $value2, $staff['staff_id'], $staff['staff_id'], $tobe2);
179
+ $ret = f_db_update($sql, $value2, $tobe2);
180
180
 
181
181
  print("eee");
182
182