| @@ 233-248 (lines=16) @@ | ||
| 230 | * |
|
| 231 | * @return string |
|
| 232 | */ |
|
| 233 | protected static function buildValues($getClassVars) |
|
| 234 | { |
|
| 235 | $counter = 0; |
|
| 236 | $insertQuery = ""; |
|
| 237 | $columnNames = self::getColumns($getClassVars); |
|
| 238 | $arraySize = count($columnNames); |
|
| 239 | ||
| 240 | foreach ($columnNames as $key => $value) |
|
| 241 | { |
|
| 242 | $counter++; |
|
| 243 | $insertQuery .= "'".self::sanitize($value) ."'"; |
|
| 244 | if($arraySize > $counter) |
|
| 245 | $insertQuery .= ", "; |
|
| 246 | } |
|
| 247 | return $insertQuery; |
|
| 248 | } |
|
| 249 | ||
| 250 | /** |
|
| 251 | * buildClause Build the clause value |
|
| @@ 257-274 (lines=18) @@ | ||
| 254 | * |
|
| 255 | * @return string |
|
| 256 | */ |
|
| 257 | protected static function buildClause($tableName, $data) |
|
| 258 | { |
|
| 259 | $counter = 0; |
|
| 260 | $updateQuery = ""; |
|
| 261 | $arraySize = count($data); |
|
| 262 | ||
| 263 | foreach ($data as $key => $value) |
|
| 264 | { |
|
| 265 | $counter++; |
|
| 266 | $columnName = self::checkColumn($tableName, self::sanitize($key)); |
|
| 267 | $updateQuery .= $columnName ." = '".self::sanitize($value)."'"; |
|
| 268 | if ($arraySize > $counter) |
|
| 269 | { |
|
| 270 | $updateQuery .= ", "; |
|
| 271 | } |
|
| 272 | } |
|
| 273 | return $updateQuery; |
|
| 274 | } |
|
| 275 | ||
| 276 | /** |
|
| 277 | * selectAllQuery |
|