Changeset 21372 for branches/version-2_11-dev
- Timestamp:
- 2011/12/24 14:06:56 (12 years ago)
- Location:
- branches/version-2_11-dev
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_11-dev/data/class/SC_Query.php
r21371 r21372 455 455 * @param string $table テーブル名 456 456 * @param array $sqlval array('カラム名' => '値',...)の連想配列 457 * @param array $arrSql array('カラム名' => 'SQL文',...)の連想配列 458 * @param array $arrSqlVal SQL文の中で使用するプレースホルダ配列 457 459 * @return 458 460 */ 459 function insert($table, $sqlval ) {461 function insert($table, $sqlval, $arrSql = array(), $arrSqlVal = array()) { 460 462 $strcol = ''; 461 463 $strval = ''; 462 464 $find = false; 465 $arrVal = array(); 463 466 464 467 if(count($sqlval) <= 0 ) return false; … … 471 474 } else { 472 475 $strval .= '?,'; 473 $arr val[] = $val;476 $arrVal[] = $val; 474 477 } 475 478 $find = true; 476 479 } 480 481 foreach($arrSql as $key => $val) { 482 $strcol .= $key . ','; 483 $strval .= $val . ','; 484 } 485 486 $arrVal = array_merge($arrVal, $arrSqlVal); 487 477 488 if(!$find) { 478 489 return false; … … 483 494 $sqlin = "INSERT INTO $table(" . $strcol. ") VALUES (" . $strval . ")"; 484 495 // INSERT文の実行 485 $ret = $this->query($sqlin, $arr val, false, null, MDB2_PREPARE_MANIP);496 $ret = $this->query($sqlin, $arrVal, false, null, MDB2_PREPARE_MANIP); 486 497 487 498 return $ret; -
branches/version-2_11-dev/test/createEcCubeData-v25.php
r21317 r21372 274 274 $sqlval['class_id'] = $this->objQuery->nextVal("dtb_class_class_id"); 275 275 $sqlval['name'] = $class_name; 276 $ sqlval['rank'] = "~(SELECT x.rank FROM (SELECT CASE276 $arrRaw['rank'] = "(SELECT x.rank FROM (SELECT CASE 277 277 WHEN max(rank) + 1 IS NULL THEN 1 278 278 ELSE max(rank) + 1 279 279 END as rank 280 280 FROM dtb_class 281 WHERE del_flg = 0) as x) ,";281 WHERE del_flg = 0) as x)"; 282 282 $sqlval['creator_id'] = 2; 283 283 $sqlval['create_date'] = 'CURRENT_TIMESTAMP'; 284 284 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 285 285 $sqlval['del_flg'] = (string) "0"; 286 $this->objQuery->insert("dtb_class", $sqlval );286 $this->objQuery->insert("dtb_class", $sqlval, $arrRaw); 287 287 288 288 $this->arrclass_id[] = $sqlval['class_id']; … … 300 300 $sqlval['name'] = $classcategory_name; 301 301 $sqlval['class_id'] = $class_id; 302 $ sqlval['rank'] = sprintf("~(SELECT x.rank FROM (SELECT CASE302 $arrRaw['rank'] = sprintf("~(SELECT x.rank FROM (SELECT CASE 303 303 WHEN max(rank) + 1 IS NULL THEN 1 304 304 ELSE max(rank) + 1 … … 306 306 FROM dtb_classcategory 307 307 WHERE del_flg = 0 308 AND class_id = %d) as x) ,", $class_id);308 AND class_id = %d) as x)", $class_id); 309 309 $sqlval['creator_id'] = 2; 310 310 $sqlval['create_date'] = 'CURRENT_TIMESTAMP'; … … 312 312 $sqlval['del_flg'] = (string) "0"; 313 313 314 $this->objQuery->insert("dtb_classcategory", $sqlval );314 $this->objQuery->insert("dtb_classcategory", $sqlval, $arrRaw); 315 315 316 316 switch ($class_name) {
Note: See TracChangeset
for help on using the changeset viewer.