Chris chris-at-github

chris-at-github / einen Datensatz

Last active September 15, 2017 05:54

Datenbankabfragen

$GLOBALS['TYPO3_DB']->exec_SELECTgetSingleRow('uid', 'pages', $where, 'GROUP', 'ORDER')

chris-at-github / OxContent

Created June 20, 2013 06:42

Oxid Smarty Snippets

[{oxcontent ident="OXCMSIDENTIFIER"}]

chris-at-github / Var Assign String Concat

Created June 20, 2013 06:52

Kleine Smarty Helfer

[{assign var="VARNAME" value="STRING-`$SMARTYVAR`"}]

chris-at-github / GetCategories

Created June 20, 2013 07:21

Kategorie laden

	$oDb = oxDb::getInstance();
	$oCategory = oxNew('oxcategory');
	$oCategory->setLanguage($this->getLanguage());

	$sWhere = $oCategory->getSqlActiveSnippet();
	$sSelect = 'SELECT * FROM
	oxcategories
	WHERE oxcategories.oxid = \'' . $oDb->escapeString($sOxid) . '\'';

	if($oCategory->assignRecord($sSelect)) {

chris-at-github / Update Join

Created June 21, 2013 11:59

	UPDATE tx_datamintstrainingmanager_domain_model_trainings a
	LEFT JOIN _aukom_kurse b ON
	a.import_org_id = b.lfdnr
	SET
	question_languages = 1
	WHERE b.de_en = 0
	AND a.uid = 1407

chris-at-github / 404 Fehler

Created June 24, 2013 09:05

ErrorDocument 404 /404/

chris-at-github / HTML mit PHP parsen

Created June 24, 2013 09:06

AddType application/x-httpd-php .html

chris-at-github / CleanFilename

Created June 25, 2013 07:43

	return preg_replace(
	array("\|Ä\|", "\|Ö\|", "\|Ü\|", "\|ä\|", "\|ö\|", "\|ü\|", "\|ß\|", "\|[^-:/.a-zA-Z0-9\.+]\|"),
	array("Ae", "Oe", "Ue", "ae", "oe", "ue", "ss", $replace),
	str_replace($arr, "", $str)
	);

chris-at-github / Doppelte Zeichen entfernen

Created June 25, 2013 07:46

preg_replace('#[/\\\\]+#', '/', $STRING);

chris-at-github / Weiterleitung auf www

Created June 27, 2013 07:58

Weiterleitungen im allgemeinen

	RewriteEngine On
	RewriteCond %{HTTP_HOST} ^deinedomain.de$ [NC]
	RewriteRule ^(.*) http://www.deinedomain.de/$1 [L,R=301]