xpressengine /
xe-core
| @@ 173-219 (lines=47) @@ | ||
| 170 | * @param array $params |
|
| 171 | * @return void |
|
| 172 | */ |
|
| 173 | function _prepareQueryParameters(&$types, &$params) |
|
| 174 | { |
|
| 175 | $types = ''; |
|
| 176 | $params = array(); |
|
| 177 | if(!$this->param) |
|
| 178 | { |
|
| 179 | return; |
|
| 180 | } |
|
| 181 | ||
| 182 | foreach($this->param as $k => $o) |
|
| 183 | { |
|
| 184 | $value = $o->getUnescapedValue(); |
|
| 185 | $type = $o->getType(); |
|
| 186 | ||
| 187 | // Skip column names -> this should be concatenated to query string |
|
| 188 | if($o->isColumnName()) |
|
| 189 | { |
|
| 190 | continue; |
|
| 191 | } |
|
| 192 | ||
| 193 | switch($type) |
|
| 194 | { |
|
| 195 | case 'number' : |
|
| 196 | $type = 'i'; |
|
| 197 | break; |
|
| 198 | case 'varchar' : |
|
| 199 | $type = 's'; |
|
| 200 | break; |
|
| 201 | default: |
|
| 202 | $type = 's'; |
|
| 203 | } |
|
| 204 | ||
| 205 | if(is_array($value)) |
|
| 206 | { |
|
| 207 | foreach($value as $v) |
|
| 208 | { |
|
| 209 | $params[] = $v; |
|
| 210 | $types .= $type; |
|
| 211 | } |
|
| 212 | } |
|
| 213 | else |
|
| 214 | { |
|
| 215 | $params[] = $value; |
|
| 216 | $types .= $type; |
|
| 217 | } |
|
| 218 | } |
|
| 219 | } |
|
| 220 | ||
| 221 | /** |
|
| 222 | * Fetch the result |
|
| @@ 231-277 (lines=47) @@ | ||
| 228 | * @param array $params |
|
| 229 | * @return void |
|
| 230 | */ |
|
| 231 | function _prepareQueryParameters(&$types, &$params) |
|
| 232 | { |
|
| 233 | $types = ''; |
|
| 234 | $params = array(); |
|
| 235 | if(!$this->param) |
|
| 236 | { |
|
| 237 | return; |
|
| 238 | } |
|
| 239 | ||
| 240 | foreach($this->param as $k => $o) |
|
| 241 | { |
|
| 242 | $value = $o->getUnescapedValue(); |
|
| 243 | $type = $o->getType(); |
|
| 244 | ||
| 245 | // Skip column names -> this should be concatenated to query string |
|
| 246 | if($o->isColumnName()) |
|
| 247 | { |
|
| 248 | continue; |
|
| 249 | } |
|
| 250 | ||
| 251 | switch($type) |
|
| 252 | { |
|
| 253 | case 'number' : |
|
| 254 | $type = 'i'; |
|
| 255 | break; |
|
| 256 | case 'varchar' : |
|
| 257 | $type = 's'; |
|
| 258 | break; |
|
| 259 | default: |
|
| 260 | $type = 's'; |
|
| 261 | } |
|
| 262 | ||
| 263 | if(is_array($value)) |
|
| 264 | { |
|
| 265 | foreach($value as $v) |
|
| 266 | { |
|
| 267 | $params[] = $v; |
|
| 268 | $types .= $type; |
|
| 269 | } |
|
| 270 | } |
|
| 271 | else |
|
| 272 | { |
|
| 273 | $params[] = $value; |
|
| 274 | $types .= $type; |
|
| 275 | } |
|
| 276 | } |
|
| 277 | } |
|
| 278 | ||
| 279 | /** |
|
| 280 | * Fetch the result |
|
