Development/Database usage

From Lanius CMS Wiki

<?php
// database usage example

// activate the Lanius CMS core
require 'core.php';

// get a resultset array (associative) with the id and title of published content items
$rsa = $conn->SelectArray('#__content', 'id,title', ' WHERE published=1');

// display the resultset array
	var_dump($rsa);

// get a resultset array with the title of published content items in a flat array
$titles = $conn->SelectColumn('#__content', 'title', ' WHERE published=1');

// display the flat array
	var_dump($titles);

?>