|
@@ 211-223 (lines=13) @@
|
| 208 |
|
* @param bool|array|string $no_quote_fields See fullQuoteArray() |
| 209 |
|
* @return bool|\mysqli_result|object MySQLi result object / DBAL object |
| 210 |
|
*/ |
| 211 |
|
public function exec_INSERTquery($table, $fields_values, $no_quote_fields = false) |
| 212 |
|
{ |
| 213 |
|
$this->logDeprecation(); |
| 214 |
|
$res = $this->query($this->INSERTquery($table, $fields_values, $no_quote_fields)); |
| 215 |
|
if ($this->debugOutput) { |
| 216 |
|
$this->debug('exec_INSERTquery'); |
| 217 |
|
} |
| 218 |
|
foreach ($this->postProcessHookObjects as $hookObject) { |
| 219 |
|
/** @var $hookObject PostProcessQueryHookInterface */ |
| 220 |
|
$hookObject->exec_INSERTquery_postProcessAction($table, $fields_values, $no_quote_fields, $this); |
| 221 |
|
} |
| 222 |
|
return $res; |
| 223 |
|
} |
| 224 |
|
|
| 225 |
|
/** |
| 226 |
|
* Creates and executes an INSERT SQL-statement for $table with multiple rows. |
|
@@ 234-246 (lines=13) @@
|
| 231 |
|
* @param bool|array|string $no_quote_fields See fullQuoteArray() |
| 232 |
|
* @return bool|\mysqli_result|object MySQLi result object / DBAL object |
| 233 |
|
*/ |
| 234 |
|
public function exec_INSERTmultipleRows($table, array $fields, array $rows, $no_quote_fields = false) |
| 235 |
|
{ |
| 236 |
|
$this->logDeprecation(); |
| 237 |
|
$res = $this->query($this->INSERTmultipleRows($table, $fields, $rows, $no_quote_fields)); |
| 238 |
|
if ($this->debugOutput) { |
| 239 |
|
$this->debug('exec_INSERTmultipleRows'); |
| 240 |
|
} |
| 241 |
|
foreach ($this->postProcessHookObjects as $hookObject) { |
| 242 |
|
/** @var $hookObject PostProcessQueryHookInterface */ |
| 243 |
|
$hookObject->exec_INSERTmultipleRows_postProcessAction($table, $fields, $rows, $no_quote_fields, $this); |
| 244 |
|
} |
| 245 |
|
return $res; |
| 246 |
|
} |
| 247 |
|
|
| 248 |
|
/** |
| 249 |
|
* Creates and executes an UPDATE SQL-statement for $table where $where-clause (typ. 'uid=...') from the array with field/value pairs $fields_values. |
|
@@ 258-270 (lines=13) @@
|
| 255 |
|
* @param bool|array|string $no_quote_fields See fullQuoteArray() |
| 256 |
|
* @return bool|\mysqli_result|object MySQLi result object / DBAL object |
| 257 |
|
*/ |
| 258 |
|
public function exec_UPDATEquery($table, $where, $fields_values, $no_quote_fields = false) |
| 259 |
|
{ |
| 260 |
|
$this->logDeprecation(); |
| 261 |
|
$res = $this->query($this->UPDATEquery($table, $where, $fields_values, $no_quote_fields)); |
| 262 |
|
if ($this->debugOutput) { |
| 263 |
|
$this->debug('exec_UPDATEquery'); |
| 264 |
|
} |
| 265 |
|
foreach ($this->postProcessHookObjects as $hookObject) { |
| 266 |
|
/** @var $hookObject PostProcessQueryHookInterface */ |
| 267 |
|
$hookObject->exec_UPDATEquery_postProcessAction($table, $where, $fields_values, $no_quote_fields, $this); |
| 268 |
|
} |
| 269 |
|
return $res; |
| 270 |
|
} |
| 271 |
|
|
| 272 |
|
/** |
| 273 |
|
* Creates and executes a DELETE SQL-statement for $table where $where-clause |