function Connection::queryTemporary

Same name in this branch
  1. 9 core/modules/sqlite/src/Driver/Database/sqlite/Connection.php \Drupal\sqlite\Driver\Database\sqlite\Connection::queryTemporary()
  2. 9 core/modules/mysql/src/Driver/Database/mysql/Connection.php \Drupal\mysql\Driver\Database\mysql\Connection::queryTemporary()
  3. 9 core/modules/pgsql/src/Driver/Database/pgsql/Connection.php \Drupal\pgsql\Driver\Database\pgsql\Connection::queryTemporary()
  4. 9 core/tests/fixtures/database_drivers/custom/fake/Connection.php \Drupal\Driver\Database\fake\Connection::queryTemporary()
Same name in other branches
  1. 8.9.x core/tests/fixtures/database_drivers/custom/fake/Connection.php \Drupal\Driver\Database\fake\Connection::queryTemporary()
  2. 8.9.x core/lib/Drupal/Core/Database/Driver/sqlite/Connection.php \Drupal\Core\Database\Driver\sqlite\Connection::queryTemporary()
  3. 8.9.x core/lib/Drupal/Core/Database/Driver/mysql/Connection.php \Drupal\Core\Database\Driver\mysql\Connection::queryTemporary()
  4. 8.9.x core/lib/Drupal/Core/Database/Driver/pgsql/Connection.php \Drupal\Core\Database\Driver\pgsql\Connection::queryTemporary()
  5. 8.9.x core/lib/Drupal/Core/Database/Connection.php \Drupal\Core\Database\Connection::queryTemporary()
  6. 10 core/modules/sqlite/src/Driver/Database/sqlite/Connection.php \Drupal\sqlite\Driver\Database\sqlite\Connection::queryTemporary()
  7. 10 core/modules/mysql/src/Driver/Database/mysql/Connection.php \Drupal\mysql\Driver\Database\mysql\Connection::queryTemporary()
  8. 10 core/modules/pgsql/src/Driver/Database/pgsql/Connection.php \Drupal\pgsql\Driver\Database\pgsql\Connection::queryTemporary()
  9. 11.x core/modules/sqlite/src/Driver/Database/sqlite/Connection.php \Drupal\sqlite\Driver\Database\sqlite\Connection::queryTemporary()
  10. 11.x core/modules/mysql/src/Driver/Database/mysql/Connection.php \Drupal\mysql\Driver\Database\mysql\Connection::queryTemporary()
  11. 11.x core/modules/pgsql/src/Driver/Database/pgsql/Connection.php \Drupal\pgsql\Driver\Database\pgsql\Connection::queryTemporary()

Runs a SELECT query and stores its results in a temporary table.

Use this as a substitute for ->query() when the results need to stored in a temporary table. Temporary tables exist for the duration of the page request. User-supplied arguments to the query should be passed in as separate parameters so that they can be properly escaped to avoid SQL injection attacks.

Note that if you need to know how many results were returned, you should do a SELECT COUNT(*) on the temporary table afterwards.

Parameters

string $query: A string containing a normal SELECT SQL query.

array $args: (optional) An array of values to substitute into the query at placeholder markers.

array $options: (optional) An associative array of options to control how the query is run. See the documentation for DatabaseConnection::defaultOptions() for details.

Return value

string The name of the temporary table.

5 methods override Connection::queryTemporary()
Connection::queryTemporary in core/modules/sqlite/src/Driver/Database/sqlite/Connection.php
Runs a SELECT query and stores its results in a temporary table.
Connection::queryTemporary in core/modules/mysql/src/Driver/Database/mysql/Connection.php
Runs a SELECT query and stores its results in a temporary table.
Connection::queryTemporary in core/modules/pgsql/src/Driver/Database/pgsql/Connection.php
Runs a SELECT query and stores its results in a temporary table.
Connection::queryTemporary in core/tests/fixtures/database_drivers/custom/fake/Connection.php
Runs a SELECT query and stores its results in a temporary table.
StubConnection::queryTemporary in core/tests/Drupal/Tests/Core/Database/Stub/StubConnection.php
Runs a SELECT query and stores its results in a temporary table.

File

core/lib/Drupal/Core/Database/Connection.php, line 1820

Class

Connection
Base Database API class.

Namespace

Drupal\Core\Database

Code

public abstract function queryTemporary($query, array $args = [], array $options = []);

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.