CodeIgniter User Guide Version 2.2.6 |
Table of Contents Page |
CodeIgniter Home › User Guide Home › Database Library › Database 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.
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.
$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
$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']
If you run queries that might not produce a result, you are encouraged to test for a result first using the num_rows() function:
$query = $this->db->query("YOUR QUERY");
if ($query->num_rows() > 0)
{
foreach ($query->result() as $row)
{
echo $row->title;
echo $row->name;
echo $row->body;
}
}
$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
$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']
$sql = "INSERT INTO mytable (title, name)
VALUES (".$this->db->escape($title).", ".$this->db->escape($name).")";
$this->db->query($sql);
echo $this->db->affected_rows();
The Active Record 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 Active Record class contains a full compliment of functions for working with data.
$data = array(
'title' => $title,
'name' => $name,
'date' => $date
);
$this->db->insert('mytable', $data);
// Produces: INSERT INTO mytable (title, name, date) VALUES ('{$title}', '{$name}', '{$date}')
Previous Topic: Database Class · Top of Page · User Guide Home · Next Topic: Database Configuration
CodeIgniter · Copyright © 2006 - 2014 · EllisLab, Inc. · Copyright © 2014 - 2015 · British Columbia Institute of Technology