CODE EXAMPLE FOR SQL

yii2 mysql ping

public function ping() {
    try {
        Yii::$app->db->createCommand('SELECT 1')->query();
    } catch (yiidbException $exception) {
        Yii::$app->db->close();
        Yii::$app->db->open();
    }
}