I am Ophidia, programmer.
I needed a query that returns 5 random items. My solution: //fetch 5 IDs from the mm table $idArr = $GLOBALS[‘TYPO3_DB’]->exec_SELECTgetRows( ‘uid_local’, ‘tx_something_user_userarticles_article_mm’,”, ”, ‘RAND()’, ‘5’ ); $ids = array(); //save the IDs to $ids foreach($idArr as $k => $v){ […]
If I want to look at the generated query, I have to do this: $queryParser = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance(‘TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Storage\\Typo3DbQueryParser’); \TYPO3\CMS\Extbase\Utility\DebuggerUtility::var_dump($queryParser->parseQuery($query)); That doesn’t show the query itself, but at least all parts and the information in tables, fields and where are quite helpful. […]
Today I spent hours trying to figure out why a relation wasn’t working. I have a table comments and a table fe_users, and a user can post a comment, therefore user:comment => 1:n. I had everything configured appropriately, yet $user->getComments() […]
I have a form with an iframe target. The called url is the login_check in Symfony, to which I send _username and _password, to instantly log in. The problem: the Internet Explorer loses the cookies in an iframe. So I […]
I had a superclass User, which was inherited by a few subclasses: class Admin extends User { … } class Redakteur extends User { … } class Noob extends User { … } In my Controller I already know which […]
Whenever I changed js and css files, I used to execute an assets:install, simply because I didn’t know any better. This can be avoided by using a symlink in dev mode: php ./console assets:install ../web –env=dev –symlink