JPDesign · February 26, 2021 05:08 · Jun 16, 2017 · Jun 15, 2017 · Jun 15, 2017 · Jun 15, 2017
diff --git a/SelectExample1.php b/SelectExample1.php
@@ -2,12 +2,12 @@
 use TYPO3\CMS\Core\Database\ConnectionPool;
 use TYPO3\CMS\Core\Utility\GeneralUtility;
 
-// select * from tt_content where hidden=0 and colPos=0 limit 3;
+// select * from tt_content where colPos=0 limit 3;
 $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
 $result = $queryBuilder
     ->select('*')
     ->from('tt_content')
-    ->where('hidden = 0 and colPos = 0')
+    ->where('colPos=0')
     ->orderBy('sorting')
     ->setMaxResults(3)
     ->execute();

diff --git a/Introduction.txt → _Introduction.txt b/Introduction.txt → _Introduction.txt
diff --git a/InsertExample.php b/InsertExample.php
@@ -2,7 +2,7 @@
 use TYPO3\CMS\Core\Database\ConnectionPool;
 use TYPO3\CMS\Core\Utility\GeneralUtility;
 
-// insert into
+// insert into tt_content (header, crdate, pid) VALUES ("New content", 123456789, 123); 
 $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
 $queryBuilder
     ->insert('tt_content')

diff --git a/InsertExample.php b/InsertExample.php
@@ -2,6 +2,7 @@
 use TYPO3\CMS\Core\Database\ConnectionPool;
 use TYPO3\CMS\Core\Utility\GeneralUtility;
 
+// insert into
 $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
 $queryBuilder
     ->insert('tt_content')
@@ -10,4 +11,4 @@
         'crdate' => time(),
         'pid' => 123,
     ])
-    ->execute();     
+    ->execute();   
diff --git a/Introduction.txt b/Introduction.txt
@@ -13,4 +13,7 @@ exec_UPDATEquery()
 exec_INSERTquery()
 
 Nevertheless there is a QueryBuilder class that can be used. I played a bit with it in TYPO3 8.7.1 and stored some examples 
-for me and of course for everybody who wants to know.
+for me and of course for everybody who wants to know.
+
+Find out more in the documentation: https://docs.typo3.org/typo3cms/CoreApiReference/ApiOverview/Database/QueryBuilder/Index.html
+or in the PHP Class \TYPO3\CMS\Core\Database\Query\QueryBuilder
diff --git a/SelectExample1.php b/SelectExample1.php
@@ -2,6 +2,7 @@
 use TYPO3\CMS\Core\Database\ConnectionPool;
 use TYPO3\CMS\Core\Utility\GeneralUtility;
 
+// select * from tt_content where hidden=0 and colPos=0 limit 3;
 $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
 $result = $queryBuilder
     ->select('*')

diff --git a/SelectExample2.php b/SelectExample2.php
@@ -2,6 +2,7 @@
 use TYPO3\CMS\Core\Database\ConnectionPool;
 use TYPO3\CMS\Core\Utility\GeneralUtility;
 
+// select header from tt_content where colPos=0;
 $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
 $result = $queryBuilder
     ->select('header')

diff --git a/UpdateExample.php b/UpdateExample.php
@@ -0,0 +1,13 @@
+<?php
+use TYPO3\CMS\Core\Database\ConnectionPool;
+use TYPO3\CMS\Core\Utility\GeneralUtility;
+
+// update tt_content set header = "new" where uid = 120;
+$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
+$queryBuilder
+    ->update('tt_content')
+    ->where(
+        $queryBuilder->expr()->eq('uid', 120) // if 120 would be a user parameter, use $queryBuilder->createNamedParameter($param) for security reasons
+    )
+    ->set('header', 'new')
+    ->execute();
diff --git a/InsertExample.php b/InsertExample.php
@@ -0,0 +1,13 @@
+<?php
+use TYPO3\CMS\Core\Database\ConnectionPool;
+use TYPO3\CMS\Core\Utility\GeneralUtility;
+
+$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
+$queryBuilder
+    ->insert('tt_content')
+    ->values([
+        'header' => 'New content',
+        'crdate' => time(),
+        'pid' => 123,
+    ])
+    ->execute();     
diff --git a/Introduction.txt b/Introduction.txt
@@ -1,5 +1,8 @@
-I'm inspired through the slides from the talk from Nicole (see https://de.slideshare.net/cpsitgmbh/certifuncation-2017-best-practices-extension-development-for-typo3-8-lts) and doctrine in TYPO3.
-As far as I understand the variable $GLOBALS['TYPO3_DB'] which contains the DatabaseConnection class will not be available in future versions of TYPO3. 
+I'm inspired through the slides from the talk from Nicole 
+(see https://de.slideshare.net/cpsitgmbh/certifuncation-2017-best-practices-extension-development-for-typo3-8-lts) 
+and doctrine in TYPO3.
+As far as I understand the variable $GLOBALS['TYPO3_DB'] which contains the DatabaseConnection class will not be available 
+in future versions of TYPO3. 
 
 That means that common functions are not available any more:
 exec_SELECTquery()
@@ -9,4 +12,5 @@ exec_DELETEquery()
 exec_UPDATEquery()
 exec_INSERTquery()
 
-Nevertheless there is a QueryBuilder class that can be used. I played a bit with it in TYPO3 8.7.1 and stored some examples for me and of course for everybody who wants to know.
+Nevertheless there is a QueryBuilder class that can be used. I played a bit with it in TYPO3 8.7.1 and stored some examples 
+for me and of course for everybody who wants to know.
diff --git a/Introduction.txt b/Introduction.txt
@@ -1 +1,12 @@
-My Text
+I'm inspired through the slides from the talk from Nicole (see https://de.slideshare.net/cpsitgmbh/certifuncation-2017-best-practices-extension-development-for-typo3-8-lts) and doctrine in TYPO3.
+As far as I understand the variable $GLOBALS['TYPO3_DB'] which contains the DatabaseConnection class will not be available in future versions of TYPO3. 
+
+That means that common functions are not available any more:
+exec_SELECTquery()
+exec_SELECTgetRows()
+exec_SELECTgetSingleRow()
+exec_DELETEquery()
+exec_UPDATEquery()
+exec_INSERTquery()
+
+Nevertheless there is a QueryBuilder class that can be used. I played a bit with it in TYPO3 8.7.1 and stored some examples for me and of course for everybody who wants to know.
diff --git a/SelectExample1.php b/SelectExample1.php
@@ -1,4 +1,7 @@
 <?php
+use TYPO3\CMS\Core\Database\ConnectionPool;
+use TYPO3\CMS\Core\Utility\GeneralUtility;
+
 $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
 $result = $queryBuilder
     ->select('*')

diff --git a/SelectExample2.php b/SelectExample2.php
@@ -1,4 +1,7 @@
 <?php
+use TYPO3\CMS\Core\Database\ConnectionPool;
+use TYPO3\CMS\Core\Utility\GeneralUtility;
+
 $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
 $result = $queryBuilder
     ->select('header')

diff --git a/Example.txt b/Example.txt
@@ -1 +0,0 @@
-My text

diff --git a/Introduction.txt b/Introduction.txt
@@ -0,0 +1 @@
+My Text
diff --git a/Example.php → SelectExample1.php b/Example.php → SelectExample1.php
@@ -1,3 +1,4 @@
+<?php
 $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
 $result = $queryBuilder
     ->select('*')
@@ -6,4 +7,5 @@
     ->orderBy('sorting')
     ->setMaxResults(3)
     ->execute();
-$rows = $result->fetchAll();
+$rows = $result->fetchAll();
+var_dump($rows);
diff --git a/SelectExample2.php b/SelectExample2.php
@@ -0,0 +1,10 @@
+<?php
+$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
+$result = $queryBuilder
+    ->select('header')
+    ->from('tt_content')
+    ->where('colPos=0')
+    ->execute();
+while ($row = $result->fetch()) {
+    var_dump($row);
+}
diff --git a/Example.php b/Example.php
@@ -0,0 +1,9 @@
+$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
+$result = $queryBuilder
+    ->select('*')
+    ->from('tt_content')
+    ->where('hidden = 0 and colPos = 0')
+    ->orderBy('sorting')
+    ->setMaxResults(3)
+    ->execute();
+$rows = $result->fetchAll();
diff --git a/Example.txt b/Example.txt
@@ -0,0 +1 @@
+My text
No results found