@@ 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 |