Extra Light PHP Framework
Database
Content
Configuration
Open application/config/database.php
$database['mysql_host'] = 'localhost';
$database['mysql_user'] = 'foo';
$database['mysql_pass'] = 'bar';
$database['mysql_db'] = 'foo_baz';
$database['table_prefix'] = '';
$database['encoding'] = 'utf8';
$database['driver'] = 'mysql';
Loading library
$this->load_library('database');
Running queries
$query = '
SELECT *
FROM users
WHERE user = `john`
LIMIT 1';
$user = $this->database->query($query);
Insert
$data = array(
'foo' => 'lorem',
'bar' => 'ipsum'
);
$this->database->insert('foobar', $data);
Update
$data = array(
'foo' => 'lorem',
'bar' => 'ipsum'
);
$where = array(
'id' => 1
);
$db->update('foobar', $data, $where);
Delete
$where = array(
'id' => 1
);
$db->delete('foobar', $where);
Query results
Content
- Multiple rows as object
- Multiple rows as array
- One row as object
- One row as array
- Total rows
- Total queries
- Raw query result
Multiple rows as object
$user->result();
Multiple rows as array
$user->result_array();
One row as object
$user->row();
One row as array
$user->row_array();
Num rows
$user->num_rows();
Total queries
$db->total_queries();
Raw query result
$q = $db->raw();
$result = array();
while ($row = mysql_fetch_assoc($q))
{
$result[] = $row;
}
$user->result();
Multiple rows as array
$user->result_array();
One row as object
$user->row();
One row as array
$user->row_array();
Num rows
$user->num_rows();
Total queries
$db->total_queries();
Raw query result
$q = $db->raw();
$result = array();
while ($row = mysql_fetch_assoc($q))
{
$result[] = $row;
}