DrupalAPI.de

1. drupal
   1. drupal7

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.

Übergabeparameter

$query A string containing a normal SELECT SQL query.

$args An array of values to substitute into the query at placeholder markers.

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

Rückgabewert

The name of the temporary table.

Verwandte Themen

Database abstraction layer

Allow the use of different database servers using the same code base.

Code

includes/database/database.inc, line 988

<?php
abstract function queryTemporary($query, array $args, array $options = array());
?>