February | 2015 | iTuri Blog

First install backlight

sudo apt-get install xbacklight

1	sudo apt-get install xbacklight

Find which video card is installed in your system by typing the following command.

ls /sys/class/backlight/

1	ls /sys/class/backlight/

For me it’s intel.

Create a configuration file:

sudo nano /usr/share/X11/xorg.conf.d/20-intel.conf

1	sudo nano /usr/share/X11/xorg.conf.d/20-intel.conf

and copy the following into the the configuration file:

Section "Device"
        Identifier  "card0"
        Driver      "intel"
        Option      "Backlight"  "intel_backlight"
        BusID       "PCI:0:2:0"
EndSection

Section "Device"

Identifier "card0"

Driver "intel"

Option "Backlight" "intel_backlight"

BusID "PCI:0:2:0"

EndSection

Save the configuration file.

Now logout and then log back into the system and the brightness control would be working through the function keys.

That’s it. Simple :).

We have to add the following namespaces before using Query class:

use yii\db\Query;
$connection = \Yii::$app->db;

1 2	use yii\db\Query; $connection = \Yii::$app->db;

Following is the list of methods used in SQL Queries:

Query Class

Example 1Example 2

$query = new Query;
$query->select('id, name, email')
    ->from('customer')
    ->limit(5);
$command = $query->createCommand();
$data = $command->queryAll();

$query = new Query;

$query->select('id, name, email')

->from('customer')

->limit(5);

$command = $query->createCommand();

$data = $command->queryAll();

$query = new Query;
$columns = [];
$columns[] = 'id';
$columns[] = 'name';
$columns[] = 'email';

$query->select($columns)
    ->from('customer')
    ->limit(5);
$command = $query->createCommand();
$data = $command->queryAll();

$query = new Query;

$columns = [];

$columns[] = 'id';

$columns[] = 'name';

$columns[] = 'email';

$query->select($columns)

->from('customer')

->limit(5);

$command = $query->createCommand();

$data = $command->queryAll();

findBySql

Example 1Example 2

$sql = 'SELECT * FROM customer';
$model = Customer::findBySql($sql)->all();

1 2	$sql = 'SELECT * FROM customer'; $model = Customer::findBySql($sql)->all();

$sql = 'SELECT * FROM customer';
$model = Customer::findBySql($sql)->one();

1 2	$sql = 'SELECT * FROM customer'; $model = Customer::findBySql($sql)->one();

queryAll

Example 1

$model = $connection->createCommand('SELECT * FROM customer');
$customers = $model->queryAll();

1 2	$model = $connection->createCommand('SELECT * FROM customer'); $customers = $model->queryAll();

queryOne

Example 1

$model = $connection->createCommand("SELECT id, name, email FROM customer where id=5");
$customers = $model->queryOne();

1 2	$model = $connection->createCommand("SELECT id, name, email FROM customer where id=5"); $customers = $model->queryOne();

queryColumn

Example 1

$model = $connection->createCommand('SELECT email FROM customer');
$customer = $model->queryColumn();

1 2	$model = $connection->createCommand('SELECT email FROM customer'); $customer = $model->queryColumn();

queryScalar

Example 1

$model = $connection->createCommand('SELECT COUNT(*) FROM customer');
$customers_count = $model->queryScalar();

1 2	$model = $connection->createCommand('SELECT COUNT(*) FROM customer'); $customers_count = $model->queryScalar();

Query With Prepared Statements

Example 1

$customer = $connection
	->createCommand('SELECT * FROM customer WHERE email=:email');
$customer->bindValue(':email', $email);
$model = $customer->query();

$customer = $connection

->createCommand('SELECT * FROM customer WHERE email=:email');

$customer->bindValue(':email', $email);

$model = $customer->query();

Happy Coding!

iTuri Blog

Monthly Archives: February 2015

Ubuntu 14.04 adjust Brightness

SQL Queries: Select Query in Yii2