(Read more interesting articles on CodeIgniter 1.7 Professional Development here.)
Loading the Database library is slightly different from loading other libraries. This is because it is large and resides in a different folder, unlike the other libraries.
$this->load->database();
Let’s dive straight in by starting with the simple stuff. CodeIgniter gives us a function that we can pass a SQL Query to, and the query will be run on the database. Here’s how it works:
$this->db->query('PUT YOUR SQL HERE');
This function is incredibly simple to use; you simply use this function in place of any native PHP functions you would use to run queries. This function will return TRUE or FALSE for write queries, and will return a dataset for read queries.
There is another function that you can use for very simple queries; this will only return TRUE or FALSE. It won’t let you cache your query or run the query timer. In most cases you won’t want to use this function.
$this->db->simple_query('PUT YOUR SQL HERE');
The SQL code that you pass to these functions are database-dependent. Only Active Record queries are independent of any type of Database SQL.
You can assign the function $this->db->query() to a variable. You can then run a number of helper functions on the variable in order to return the data in different formats. Take the following example:
$query = $this->db->query('SELECT * FROM 'users'');
In this case, returning the result will return an array of objects, or an empty array if the query failed. You would usually use this function in a foreach loop.
foreach($query->result() as $row)
{
echo $row->username;
echo $row->email;
}
If your query does not return a result, the CodeIgniter User Guide encourages you to check for a failure before using this function.
if($query->num_rows > 0)
{
foreach($query->result() as $row)
{
echo $row->username;
echo $row->email;
}
}
You are also able to return the result dataset as an array. Typically, you would use this function inside a foreach loop as well.
foreach($query->result_array() as $row)
{
echo $row['username'];
echo $row['email'];
}
If your query is only expected to return a single result, you should return the row by using the following function. The row is returned as an object.
if($query->num_rows() > 0)
{
$row = $query->row();
echo $row->username;
echo $row->email;
}
You can return a specific row by passing the row number as a digit in the first parameter.
$query->row(2);
You can return a row as an array, if you prefer. The function is used in the same way as the previous example.
if($query->num_rows() > 0)
{
$row = $query->row_array();
echo $row['username'];
echo $row['email'];
}
You can return a numbered row by passing the digit to the first parameter, also.
$query->row_array(2);
Besides the helper function that helps to return the dataset in different ways, there are some other more generalized helper functions.
Used in the same way as the other helper functions, this will return the total number of rows returned from a query. Take the following example:
echo $query->num_rows();
Just like the previous function, this will return the number of fields returned by your query.
echo $query->num_fields();
This function will remove the resource ID associated with your query, and free the associated memory. PHP will usually do this by default, although when using many queries you may wish to use this to free up memory space.
$query->free_result();
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed…
Key takeaways The transformer architecture has proved to be revolutionary in outperforming the classical RNN…
Once we learn how to deploy an Ubuntu server, how to manage users, and how…
Key-takeaways: Clean code isn’t just a nice thing to have or a luxury in software projects; it's a necessity. If we…
While developing a web application, or setting dynamic pages and meta tags we need to deal with…
Software architecture is one of the most discussed topics in the software industry today, and…