Differences

This shows you the differences between two versions of the page.

--- onny:notizen:programmierung [2023/03/24 14:48] – [javascript] 10.100.0.1
+++ onny:notizen:programmierung [2026/08/18 11:23] (current) – [mariadb / mysql] fdc9:281f:4d7:9ee9::1
@@ Line 205: / Line 205: @@
 </code>
 ===== javascript =====
+conditional properties in object
+<code javascript>
+cont my_object = {
+  ...(version >= 33 ? { iconSvgInline: MindMapSvg } : { iconClass: 'icon-mindmap' }),
+}
+</code>
 split up javascript files
@@ Line 514: / Line 521: @@
       }
 </code>
-===== css =====
-sweet font styling
+===== php =====
-<code css>
-font-family: consolas,Menlo-Regular,Menlo,Monaco,monospace;
+printf string
-    font-size: 125%;
-    line-height: 135%;
+<code php>
+printf("cleaning criteria: %s\n", $config['filterCriteria']);
 </code>
-media queries, page greater than 600px
-<code css>
+print array
-      @media (min-width: 600px) {
-        article {
+<code php>
-          min-width: 600px;
+$a = array ('a' => 'apple', 'b' => 'banana', 'c' => array ('x', 'y', 'z'));
-        }
+print_r($a);
-      }
 </code>
-popover menu
-<code css>
-.main-navigation ul li ul.sub-menu {
-	opacity: 0;
-	position: absolute;
-  box-shadow: 0 2px 5px 0 rgba(0, 0, 0, 0.26);
-	transition:opacity 250ms ease-out;
-	padding: 20px;
-	z-index: 2;
-	left: 17px;
-	background: white;
-}
-.main-navigation ul li:hover ul.sub-menu {
+filter array only unique items
-	opacity: 1;
-	transition:opacity 250ms ease-out;
+<code php>
-}
+$userIds = array_unique($userIds);
 </code>
-responsive grid layout
+append to array
-<code>
-ul {
+<code php>
-	display: grid;
+$fruits = ['apple', 'banana'];
-	grid-gap: 50px 40px;
+$fruits[] = 'orange';
-	grid-template-columns: repeat(auto-fit, minmax(290px, 1fr));
-}
 </code>
-===== php =====
+assosiative array / dictionary
+<code php>
+$myResult["ids"] = [123, 125, 127];
+</code>
+datetime object, convert to string
+<code php>
+$date = new \DateTime('1990-01-01');
+$dateString = $date->format('d.m.Y');
+</code>
 enable debugging / error log
 <file - /etc/php/conf.d/debug.ini>
 display_startup_errors = true
@@ Line 570: / Line 577: @@
 chmod a+w+r /var/log/php-errors.log
 </code>
 foreach loop
 <code php>
 foreach($this->service->findAll($this->userId) as $station) {
@@ Line 580: / Line 589: @@
 }
 </code>
 get array length
 <code php>
 var_dump(count($a));
@@ Line 586: / Line 597: @@
 get type of variable
 <code php>
 foreach($data as $episode) {
@@ Line 593: / Line 605: @@
 convert string to int
 <code php>
 intval("12345");
@@ Line 603: / Line 616: @@
 </code>
+define class, create object
+<code php>
+class Calendar {
+    private array $data;
+    public function __construct(array $data) {
+        $this->data = $data;
+    }
+    public function getUserId(): string {
+		$principalUri = $this->data['principaluri'];
+		$principalUriParts = explode('/', $principalUri);
+		$user = end($principalUriParts);
+        return $user;
+    }
+    public function getDisplayName(): string {
+        return $this->data['displayname'];
+    }
+    public function __debugInfo(): array {
+        // keeps print_r() useful
+        return $this->data;
+    }
+}
+private function fetchCalendarById(int $calendarId) {
+	$query = $this->dbConnection->getQueryBuilder();
+	$query->select('*')
+		->from('calendars')
+		->where($query->expr()->eq('id', $query->createNamedParameter($calendarId, IQueryBuilder::PARAM_INT)));
+	$result = $query->executeQuery();
+	$calendar = $result->fetch();
+	$result->closeCursor();
+	if (empty($calendar)) {
+		return false;
+	}
+	return new Calendar($calendar);
+}
+</code>
+print and debug php database queries
+<code php>
+$query->select('id', 'calendarid', 'firstoccurence')
+	->from('calendarobjects')
+	->where($filterQuery);
+printf("SQL: %s\n", $query->getSQL());
+printf("Parameters: %s\n", print_r($query->getParameters(), true));
+</code>
+check if array key exists (avoid undefined warning) via "null casting"
+<code php>
+if ($config['listCalendars'] ?? false) {
+</code>
 ==== nextcloud app dev ====
 logging, available methods: emergency, alert, critical, error, warning, notice, info, debug
@@ Line 635: / Line 709: @@
 </code>
+logging
+<code php>
+$this->logger->debug('Running actual SQL query {sql} with parameters {params}', [
+	'sql' => $query->getSQL(),
+	'params' => print_r($query->getParameters(), true),
+	'app' => 'cleanup',
+]);
+</code>
 ==== wordpress ====
 registering menus
@@ Line 787: / Line 870: @@
 </code>
 ===== sql =====
-Update field:
-<code sql>
-update forwardings set destination='alex.bloss@online.de' where 'destination=bloss@bigwood.de';
-</code>
-Insert field:
-<code sql>
-insert into forwardings (source, destination) VALUES ('markus.heim@wew-heim.de', 'heimmarkus@yahoo.de');
-insert into forwardings VALUES ('markus.heim@wew-heim.de', 'heimmarkus@yahoo.de');
-</code>
-Delete row:
-<code sql>
-delete from domains where domain='alex-vt.de';
-</code>
 <code sql>
 mysql> \P /usr/bin/less
@@ Line 819: / Line 889: @@
 </code>
-==== mysql ====
+==== mariadb / mysql ====
+select column and sort alphabetically
+<code>
+SELECT user_id
+FROM oc_user_oidc
+ORDER BY user_id ASC;
+</code>
 delete specific row
 <code>
 delete from oc_storages where numeric_id=58;
@@ Line 827: / Line 906: @@
 remove user
 <code sql>
 DROP USER 'bloguser'@'localhost';
@@ Line 832: / Line 912: @@
 adjust permissions to table
 <code sql>
 CREATE USER 'ninja'@'http.pi' IDENTIFIED BY '****';
@@ Line 845: / Line 926: @@
 </code>
+sort column by timestamp and convert to datetime
+<code sql>
+SELECT
+    `id`,
+    `calendarid`,
+    FROM_UNIXTIME(`firstoccurence`) AS firstoccurence,
+    FROM_UNIXTIME(`lastoccurence`)  AS lastoccurence
+FROM `oc_calendarobjects`
+WHERE (`lastoccurence` < 1606694400)
+  AND (`firstoccurence` > 0)
+  AND (`componenttype` = 'VEVENT')
+ORDER BY `lastoccurence` DESC;
+</code>