Welcome to Programmers Language v2

ID: 283
PlCodelang: Yii2
PlGroup: Datenbank
PlItemTitle: Verzeichnis erstellen
Code: <?php // Example as SQL: // SELECT * FROM MainTable // WHERE fieldA=5 AND fieldB IN (SELECT id FROM SubTable WHERE fieldC=551) $fieldC = 551; $SubTable_idQry = SubTable::find()->select('id')->where(['fieldC' => $fieldC]); // Static way: $fieldA = 5; // As result: $fieldA = ThirdTable::find() ->select('fieldA_Reference') ->where(['fieldC' => $fieldC]) ->one(); $MainTableResultQry = MainTable::find() ->where(['in', 'fieldB', $SubTable_idQry]) ->andWhere(['fieldA' => $fieldA]) ->all(); ?>

ID: 284
PlCodelang: Yii2
PlGroup: Datenbank
PlItemTitle: Abfrage mit Aggregration
Code: <?php /* // Example as SQL SELECT FieldA ,COUNT(FieldA) as cnt FROM MainTable WHERE FieldA = 5 GROUP BY FieldA */ $MainTableResultQry = MainTable::find() ->select(['FieldA', 'COUNT(FieldA) as cnt']) ->where(['FieldA' => 5]) ->groupBy(['FieldA']) ->createCommand() ->queryAll(); ?>

ID: 285
PlCodelang: Bash Script
PlGroup: Filehandling
PlItemTitle: Applikations-/Script-Verzeichnis ermitteln
Code: #!/bin/sh # The script is located in /tmp/abc/myscript.sh export AppPath=$(dirname $0) echo $0 # /tmp/abc/myscript.sh echo $AppPath # /tmp/abc

ID: 286
PlCodelang: Yii2
PlGroup: Yii2-ActiveQuery
PlItemTitle: Abfrage mit Subselect
Code: <?php /* SQL Example: SELECT * FROM `Cities` WHERE (`postalcode_id` IN (SELECT `id` FROM `postalcodes` WHERE `postalcode`='12345') ) OR (`region_id` IN (SELECT `id` FROM `regions` WHERE `region`='North') ) */ $active_query_postalcodes_For_Subselect = \app\models\Postalcodes::find()->select("id")->where(["postalcodes" => '12345']); // Attention! No "->all()" at the end to create a subselect! $active_query_regions_For_Subselect = \app\models\Regions::find()->select("id")->where(["region" => 'North']); // Attention! No "->all()" at the end to create a subselect! $model = new \app\models\Cities(); $all_Cities_With_IN_and_OR = $model::find() ->where(['in', "postalcode_id", $active_query_postalcodes_For_Subselect]) ->orWhere(['in', "region_id", $active_query_regions_For_Subselect]) ->all(); ?>

ID: 287
PlCodelang: MySQL
PlGroup: Strings
PlItemTitle: Anzahl an Zeichen in einem String ermitteln
Code: -- Gets only result with 4 "/" in the the field relativePath SELECT id ,albumRoot ,relativePath ,date ,caption ,collection ,icon ,LENGTH(relativePath) - LENGTH(REPLACE(relativePath,'/','')) AS `occurrences` FROM Albums WHERE LENGTH(relativePath) - LENGTH(REPLACE(relativePath,'/',''))=4 ;

ID: 288
PlCodelang: PL/pgSQL
PlGroup: Datum, Zeit
PlItemTitle: Gestriges Datum
Code: SELECT (now())::date SELECT (now() + interval '-1 day')::date

ID: 289
PlCodelang: PL/pgSQL
PlGroup: Strings
PlItemTitle: Führende Nullen vor einer Zahl
Code: WITH cte_example AS ( SELECT 5 AS int_example UNION ALL SELECT 10 AS int_example UNION ALL SELECT 50 AS int_example ) SELECT int_example, RPAD(int_example::text, 3, '0'), LPAD(int_example::text, 3, '0') FROM cte_example

ID: 290
PlCodelang: T-SQL
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: DECLARE @newDT DATETIME SET @newDT = CAST('2021-01-01 01:23:45' AS DATETIME) SELECT FORMAT(GETDATE(), 'yyyy-MM-dd', 'En') SELECT FORMAT(GETDATE(), 'yyyy-MM-dd HH:mm:ss', 'En')

ID: 291
PlCodelang: SQLite
PlGroup: Strings
PlItemTitle: Führende Nullen vor einer Zahl
Code: WITH cte_example AS ( SELECT 5 AS int_example UNION ALL SELECT 10 AS int_example UNION ALL SELECT 50 AS int_example ) SELECT int_example, substr('0000000'||ROW_NUMBER() OVER(ORDER BY int_example)||'00', -8, 8) AS example_result FROM cte_example ;

ID: 292
PlCodelang: Yii2
PlGroup: Yii2-Internal
PlItemTitle: Prüfen ob aktueller User ein Gast ist
Code: use Yii; if (! \Yii::$app->user->isGuest) { $result = "User is logged in. User is no guest" }