Query

Extracts data from a database table using a custom SQL query.

$etl->extract('query', 'select * from users', $options);

Options

Connection

Name of the database connection to use.

Type

Default value

string

default

$options = ['connection' => 'app'];

Bindings

Values to bind to the query statement.

Type

Default value

array

[]

Using prepared statement with named placeholders select * from users where status = :status:

$options = ['bindings' => ['status' => 'active']];

Using prepared statement with question mark placeholders select * from users where status = ?:

$options = ['bindings' => ['active']];

Last updated