Database Quick Start: Example Code
**********************************

The following page contains example code showing how the database
class is used. For complete details please read the individual pages
describing each function.


Initializing the Database Class
===============================

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

   $this->load->database();

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

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


Standard Query With Multiple Results (Object Version)
=====================================================

   $query = $this->db->query('SELECT name, title, email FROM my_table');

   foreach ($query->result() as $row)
   {
           echo $row->title;
           echo $row->name;
           echo $row->email;
   }

   echo 'Total Results: ' . $query->num_rows();

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


Standard Query With Multiple Results (Array Version)
====================================================

   $query = $this->db->query('SELECT name, title, email FROM my_table');

   foreach ($query->result_array() as $row)
   {
           echo $row['title'];
           echo $row['name'];
           echo $row['email'];
   }

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


Standard Query With Single Result
=================================

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

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


Standard Query With Single Result (Array version)
=================================================

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

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


Standard Insert
===============

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


Query Builder Query
===================

The Query Builder Pattern gives you a simplified means of retrieving
data:

   $query = $this->db->get('table_name');

   foreach ($query->result() as $row)
   {
           echo $row->title;
   }

The above get() function retrieves all the results from the supplied
table. The Query Builder class contains a full compliment of functions
for working with data.


Query Builder Insert
====================

   $data = array(
           'title' => $title,
           'name' => $name,
           'date' => $date
   );

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