Suchergebnisse

…cCto_backups" in den tl_files abgelegt. Datenbanken finden sich im Ordner "database" und Dateien im Ordner "files". Wenn man Backups wieder einspielen möchte,

$this->import('Database'); $objDesigner = $this->Database->prepare('SELECT id,title,alias FROM tl_brand WHERE alias=? AND published=?

$objTotal = $this->Database->execute("SELECT COUNT(id) AS total FROM tl_user"); $objData = $this->Database->execute('SELECT id,username FROM tl_user' . $objHelper->getLimitForSQL());

* Database Abstraction Layer (DBAL) - Mögliche Frameworks: Doctrine DBAL

$this->import('Database'); $objProducts = $this->Database->prepare(' SELECT id,name

$this->import('Database'); $this->Database->prepare("INSERT INTO tl_log %s")->set($arrInsert)->execute();

* @var Database; protected $Database;

form fields of types select/radio/checkbox taking values from database table * Run the Contao install script and update your database

$this->import('Database'); $objComments = $this->Database->prepare("SELECT COUNT(*) AS anzahl FROM tl_comments WHERE published=1 AND

$this->Database->prepare("UPDATE tl_member SET groups = ? WHERE id = ?")->execute($group_id $this->Database->prepare("UPDATE tl_member SET groups = ? WHERE id = ?")->execute($group_id

$this->Database->prepare("UPDATE tl_member SET groups = ? WHERE id = ?")->execute($group_id $this->Database->prepare("UPDATE tl_member SET groups = ? WHERE id = ?")->execute($group_id

$this->Database->prepare("UPDATE tl_member SET groups = ? WHERE id = ?")->execute($group_id $this->Database->prepare("UPDATE tl_member SET groups = ? WHERE id = ?")->execute($group_id

…OM tl_user').fetchAllAssoc() }}</nowiki></code> (siehe auch die speziellen Database-Filter Funktionen) * '''prepare''' bereitet ein Statement vors (vgl. Database::prepare), z.B. <code>{% set stmt = 'SELECT * FROM tl_user WHERE admin=?'|p

Mit dem Feld Filter werden Parameter definiert. Diese sind ähnlich der Database-Klasse mit Fragezeichen zu markieren. Das Argument steht im zweiten Feld de

$this->Database->prepare("DELETE FROM `tl_log`")->executeUncached();

/** @var \Contao\Database\Result $rs */ $rs = Database::getInstance()

* Scroll down to Update database tables and click on Update database

echo "DATABASE Dump" mysqldump DB_NAME > /var/www/contao_1/html/database.sql

\Database::getInstance()->prepare("DELETE FROM `tl_log`")->execute();