TYPO3.CMS 7.6 Schnipsel: Unterschied zwischen den Versionen
Aus Vosp.info
F (Diskussion | Beiträge) |
F (Diskussion | Beiträge) (→Domain) |
||
Zeile 45: | Zeile 45: | ||
== Domain == | == Domain == | ||
+ | |||
+ | === Database === | ||
* http://blog.teamgeist-medien.de/2014/09/extbase-repository-update-persistiert-nicht-nimm-den-vorschlaghammer.html | * http://blog.teamgeist-medien.de/2014/09/extbase-repository-update-persistiert-nicht-nimm-den-vorschlaghammer.html | ||
+ | |||
+ | ==== direktes sql ==== | ||
+ | |||
+ | <source lang=php> | ||
+ | // prepare_SELECTquery ($select_fields, $from_table, $where_clause, $groupBy= '', $orderBy= '', $limit= '', array $input_parameters=array()) | ||
+ | |||
+ | $statement = $GLOBALS['TYPO3_DB']->prepare_SELECTquery( | ||
+ | '*' // $select_fields | ||
+ | , 'tab1, tab1_mm as mm' // $from_table | ||
+ | , 'tt_news.uid = mm.uid_local ' // $where_clause | ||
+ | . 'AND tt_news.pid = :store_page_id ' | ||
+ | . $ncsearchwhere.$between | ||
+ | , '' // $groupBy | ||
+ | , 'crdate DESC' // $orderBy | ||
+ | , '' // $limit | ||
+ | ); | ||
+ | $statement->bindValues(array( | ||
+ | ':store_page_id' => $store_page_id | ||
+ | )); | ||
+ | |||
+ | if ($statement) { | ||
+ | $statement->execute(); | ||
+ | $return = $statement->fetchAll(); | ||
+ | $statement->free(); | ||
+ | } | ||
+ | </source> | ||
+ | |||
= fluid = | = fluid = | ||
Version vom 18. Dezember 2015, 11:11 Uhr
Inhaltsverzeichnis
extbase (php)
Generell
$objectManager = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance('TYPO3\CMS\Extbase\Object\ObjectManager');
$ncmail = $objectManager->get('Netzcoop\Extension\Services\Ncmail');
logout / login
protected function login($ncfeuserid) {
$user = $this->userRepository->findByUid($ncfeuserid);
$GLOBALS['TSFE']->fe_user->createUserSession($user->_getProperties());
$GLOBALS["TSFE"]->fe_user->user = $GLOBALS["TSFE"]->fe_user->fetchUserSession();
// es wird empfohlen jetzt zu redirect'en
}
protected function logout() {
$GLOBALS['TSFE']->fe_user->logoff();
}
Controller
Url/Link erstellen
$uriBuilder = $this->controllerContext->getUriBuilder();
$uriBuilder->reset();
$uriBuilder->setArguments(array(
strtolower($this->extensionName) => array(
'param1' => $user->getUid(),
'param2' => 'test',
)
));
$uri = $uriBuilder->build();
\TYPO3\CMS\Core\Utility\HttpUtility::redirect($uri, \TYPO3\CMS\Core\Utility\HttpUtility::HTTP_STATUS_303);
Domain
Database
direktes sql
// prepare_SELECTquery ($select_fields, $from_table, $where_clause, $groupBy= '', $orderBy= '', $limit= '', array $input_parameters=array())
$statement = $GLOBALS['TYPO3_DB']->prepare_SELECTquery(
'*' // $select_fields
, 'tab1, tab1_mm as mm' // $from_table
, 'tt_news.uid = mm.uid_local ' // $where_clause
. 'AND tt_news.pid = :store_page_id '
. $ncsearchwhere.$between
, '' // $groupBy
, 'crdate DESC' // $orderBy
, '' // $limit
);
$statement->bindValues(array(
':store_page_id' => $store_page_id
));
if ($statement) {
$statement->execute();
$return = $statement->fetchAll();
$statement->free();
}
fluid
<f:format.html parseFuncTSPath="lib.parseFunc">{ancitscttnews.bodytext}</f:format.html>