Differences

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

--- onny:notizen:programmierung [2026/07/24 13:52] – [php] fdc9:281f:4d7:9ee9::1
+++ onny:notizen:programmierung [2026/08/18 11:23] (current) – [mariadb / mysql] fdc9:281f:4d7:9ee9::1
@@ Line 535: / Line 535: @@
 $a = array ('a' => 'apple', 'b' => 'banana', 'c' => array ('x', 'y', 'z'));
 print_r($a);
+</code>
+filter array only unique items
+<code php>
+$userIds = array_unique($userIds);
+</code>
+append to array
+<code php>
+$fruits = ['apple', 'banana'];
+$fruits[] = 'orange';
 </code>
@@ Line 646: / Line 659: @@
 	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 ====
@@ Line 679: / 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 887: / 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>