|
@@ 248-263 (lines=16) @@
|
| 245 |
|
* @param array $fieldValueArray An associative array of all the field-value pairs |
| 246 |
|
* @return string $data A string of comma separated values for SQL statement |
| 247 |
|
*/ |
| 248 |
|
private function getDataFieldValues($fieldValueArray) |
| 249 |
|
{ |
| 250 |
|
$data = null; |
| 251 |
|
|
| 252 |
|
$arrayKeys = array_keys($fieldValueArray); |
| 253 |
|
$lastKey = end($arrayKeys); |
| 254 |
|
|
| 255 |
|
foreach (self::$data as $key => $value) { |
| 256 |
|
|
| 257 |
|
$data .= is_string($value) ? "'{$value}'" : $value; |
| 258 |
|
|
| 259 |
|
$data .= ($key !== $lastKey) ? ", " : ""; |
| 260 |
|
} |
| 261 |
|
|
| 262 |
|
return $data; |
| 263 |
|
} |
| 264 |
|
|
| 265 |
|
/** |
| 266 |
|
* getUpdateFieldValues |
|
@@ 273-287 (lines=15) @@
|
| 270 |
|
* @param array $fieldValueArray An associative array of all the field-value pairs |
| 271 |
|
* @return string comma sperarated string of field values in the SQL update format |
| 272 |
|
*/ |
| 273 |
|
private function getUpdateFieldValues($fieldValueArray) |
| 274 |
|
{ |
| 275 |
|
$data = null; |
| 276 |
|
|
| 277 |
|
$arrayKeys = array_keys($fieldValueArray); |
| 278 |
|
$lastKey = end($arrayKeys); |
| 279 |
|
|
| 280 |
|
foreach (self::$data as $key => $value) { |
| 281 |
|
|
| 282 |
|
$data .= is_string($value) ? "$key = '{$value}'" : "{$key} = $value"; |
| 283 |
|
$data .= ($key !== $lastKey) ? ", " : ""; |
| 284 |
|
} |
| 285 |
|
|
| 286 |
|
return $data; |
| 287 |
|
} |
| 288 |
|
} |
| 289 |
|
|