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

編集履歴

質問編集履歴

1

修正

2016/07/08 04:45

投稿

leoairen
leoairen

スコア122

title CHANGED
File without changes
body CHANGED
@@ -50,44 +50,44 @@
50
50
  if($h['is_deleted'] == "n"){
51
51
  $tobe = "y";
52
52
  foreach( $holiday_array as $key => $value ) {
53
- $sql = "update calendartbl set is_deleted = '%%n%%', modify_datetime = now() where holiday = '%%n%%'";
53
+ $sql = "update calendartbl set is_deleted = '%%n%%' where holiday = '%%n%%'";
54
- $ret2 = f_db_update($sql, $tobe, $value);
54
+ $ret2 = f_db_update($sql, $tobe, $value);
55
55
  print("aaa1");
56
56
  }
57
57
  }else if($h['is_deleted'] == "y"){
58
58
  $tobe = "n";
59
59
  foreach( $holiday_array as $key => $value ) {
60
- $sql = "update calendartbl set is_deleted = '%%n%%', modify_datetime = now() where holiday = '%%n%%'";
60
+ $sql = "update calendartbl set is_deleted = '%%n%%' where holiday = '%%n%%'";
61
- $ret2 = f_db_update($sql, $tobe, $value);
61
+ $ret2 = f_db_update($sql, $tobe, $value);
62
62
  print("aaa2");
63
63
  }
64
64
  }
65
65
  }else if($delflg == true){
66
66
  $tobe = "y";
67
67
  foreach( $holiday_array as $key => $value ) {
68
- $sql = "update calendartbl set is_deleted = '%%n%%', modify_datetime = now() where holiday = '%%n%%'";
68
+ $sql = "update calendartbl set is_deleted = '%%n%%' where holiday = '%%n%%'";
69
69
  $ret2 = f_db_update($sql, $tobe, $value);
70
70
  print("bbb");
71
71
  }
72
72
  }else if($saveflg == true){
73
73
  $tobe = "n";
74
74
  foreach( $holiday_array as $key => $value ) {
75
- $sql = "update calendartbl set is_deleted = '%%n%%', modify_datetime = now() where holiday = '%%n%%'";
75
+ $sql = "update calendartbl set is_deleted = '%%n%%' where holiday = '%%n%%'";
76
76
  $ret2 = f_db_update($sql, $tobe, $value);
77
77
  print("ccc");
78
78
  }
79
79
  }else if($newflg == true){
80
80
  $tobe2 = "n";
81
81
  foreach( $holiday_array as $key2 => $value2 ) {
82
- $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%%')";
82
+ $sql = "insert IGNORE into calendartbl (holiday, is_deleted) values ('%%n%%', '%%n%%')";
83
- $ret = f_db_update($sql, $value2, $staff['staff_id'], $staff['staff_id'], $tobe2);
83
+ $ret = f_db_update($sql, $value2, $tobe2);
84
84
  print("ddd");
85
85
  }
86
86
  }else{
87
87
  $tobe2 = "n";
88
88
  foreach( $holiday_array as $key2 => $value2 ) {
89
- $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%%')";
89
+ $sql = "insert IGNORE into calendartbl (holiday, is_deleted) values ('%%n%%', '%%n%%')";
90
- $ret = f_db_update($sql, $value2, $staff['staff_id'], $staff['staff_id'], $tobe2);
90
+ $ret = f_db_update($sql, $value2, $tobe2);
91
91
  print("eee");
92
92
  }
93
93
  }