Changeset 11991 for trunk/include/dblayer/functions_sqlite.inc.php
- Timestamp:
- Aug 24, 2011, 9:50:54 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/dblayer/functions_sqlite.inc.php
r11925 r11991 328 328 329 329 /** 330 * updates on line in a table330 * updates one line in a table 331 331 * 332 332 * @param string table_name 333 * @param array dbfields334 * @param array data333 * @param array set_fields 334 * @param array where_fields 335 335 * @param int flags - if MASS_UPDATES_SKIP_EMPTY - empty values do not overwrite existing ones 336 336 * @return void 337 337 */ 338 function single_update($tablename, $dbfields, $data, $flags=0) 339 { 340 if (count($data) == 0) 338 function single_update($tablename, $set_fields, $where_fields, $flags=0) 339 { 340 if (count($set_fields) == 0) 341 { 341 342 return; 343 } 342 344 343 345 $query = ' … … 345 347 SET '; 346 348 $is_first = true; 347 foreach ($ dbfields['update'] as $key)349 foreach ($set_fields as $key => $value) 348 350 { 349 351 $separator = $is_first ? '' : ",\n "; 350 351 if (isset($ data[$key]) and $data[$key]!= '')352 { 353 $query.= $separator.$key.' = \''.$ data[$key].'\'';352 353 if (isset($value) and $value != '') 354 { 355 $query.= $separator.$key.' = \''.$value.'\''; 354 356 } 355 357 else … … 366 368 WHERE '; 367 369 $is_first = true; 368 foreach ($ dbfields['primary'] as $key)370 foreach ($where_fields as $key => $value) 369 371 { 370 372 if (!$is_first) … … 372 374 $query.= ' AND '; 373 375 } 374 if ( isset($ data[$key]) )375 { 376 $query.= $key.' = \''.$ data[$key].'\'';376 if ( isset($value) ) 377 { 378 $query.= $key.' = \''.$value.'\''; 377 379 } 378 380 else … … 385 387 } 386 388 } 387 388 389 389 390 /** … … 458 459 * @return void 459 460 */ 460 function single_insert($table_name, $d bfields, $insert)461 { 462 if (count($ insert) != 0)461 function single_insert($table_name, $data) 462 { 463 if (count($data) != 0) 463 464 { 464 465 $query = ' 465 466 INSERT INTO '.$table_name.' 466 ('.implode(',', $dbfields).')467 ('.implode(',', array_keys($data)).') 467 468 VALUES'; 468 469 469 470 $query .= '('; 470 foreach ($dbfields as $field_id => $dbfield) 471 { 472 if ($field_id > 0) 471 $is_first = true; 472 foreach ($data as $key => $value) 473 { 474 if (!$is_first) 473 475 { 474 476 $query .= ','; 475 477 } 476 if (!isset($insert[$dbfield]) or $insert[$dbfield] === '') 478 else 479 { 480 $is_first = false; 481 } 482 483 if ($value === '') 477 484 { 478 485 $query .= 'NULL'; … … 480 487 else 481 488 { 482 $query .= "'".$ insert[$dbfield]."'";489 $query .= "'".$value."'"; 483 490 } 484 491 }
Note: See TracChangeset
for help on using the changeset viewer.