notes

contao database

1. April 2013

uncached database query

$entries = $this->Database->query("SELECT * FROM table WHERE id=$id");
while ($entries->next()) {
 $entry = $entries->row(); 
}

cached database query with prepare statement

$entries = $this->Database->prepare("SELECT * FROM table WHERE email=?")
			  ->execute($email);
if($entries->numRows) {
	while ($entries->next()) {
                 $entry = $entries->row();
        }
}

Hinterlasse einen Kommentar

You must be logged in to post a comment.

Sonstiges