Database Quick Start: Example Code

The following page contains example code showing how the database classis used. For complete details please read the individual pagesdescribing each function.

Initializing the Database Class

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

$db = \Config\Database::connect();

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

Note: If all your pages require database access you can connectautomatically. See the connecting page for details.

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

Standard Query With Multiple Results (Array Version)

$query   = $db->query('SELECT name, title, email FROM my_table');
$results = $query->getResultArray();
 
foreach ($results as $row)
{
        echo $row['title'];
        echo $row['name'];
        echo $row['email'];
}

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();
echo $row->name;

The above getRow() function returns an object. Example: $row->name

Standard Query With Single Result (Array version)

$query = $db->query('SELECT name FROM my_table LIMIT 1');
$row   = $query->getRowArray();
echo $row['name'];

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();

Query Builder Query

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

$query = $db->table('table_name')->get();
 
foreach ($query->getResult() as $row)
{
        echo $row->title;
}

The above get() function retrieves all the results from the suppliedtable. The Query Builder class contains a fullcomplement of functions for working with 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}')