Database Quick Start: Example Code

The following code loads and initializes the database class based onyour configuration settings:

Once loaded the class is ready to be used as described below.

Standard Query With Multiple Results (Object Version)

$query = $db->query('SELECT name, title, email FROM my_table');
$results = $query->getResult();
foreach ($results as $row)
{
        echo $row->title;
        echo $row->name;
        echo $row->email;
}
 
echo 'Total Results: ' . count($results);

The above getResult() function returns an array of objects. Example:$row->title

The above getResultArray() function returns an array of standard arrayindexes. Example: $row[‘title’]

Standard Query With Single Result

$query = $db->query('SELECT name FROM my_table LIMIT 1');
$row   = $query->getRow();

The above getRowArray() function returns an array. Example:$row[‘name’]

Standard Insert

$sql = "INSERT INTO mytable (title, name) VALUES (".$db->escape($title).", ".$db->escape($name).")";
$db->query($sql);
echo $db->affectedRows();

The Query Builder Pattern gives you a simplifiedmeans of retrieving data:

Query Builder Insert

$data = [
        'title' => $title,
        'name'  => $name,
        'date'  => $date
];
 
$db->table('mytable')->insert($data);  // Produces: INSERT INTO mytable (title, name, date) VALUES ('{$title}', '{$name}', '{$date}')